[thelist] tuning MySQL

Pedro Arana pedro.arana.matus at gmail.com
Thu Nov 30 12:03:26 CST 2006

On 11/30/06, Matt McKeon <matt at camadro.com> wrote:
> >>>> On 11/28/06, Matt McKeon <matt at camadro.com> wrote:
> >>>>
> >>>>> Hershel Robinson wrote:
> >>>>> Right sorry, forgot the details in my cloud of confusion.
> >>>>> MySQL v.4.1.21
> >>>>> PHP v.4.4.4
> >>>>>
> >>>>> The two tables I'm working with are both less then 1MB, the DB size is
> >>>>> only about 5MB. This PHP script/MySQL DB was working seemingly fine in
> >>>>> our previous setup..
> >>>>>
> >
> Yes the table is small and the queries are simple and both tables have
> the id field as the primary key. So I'm not sure why the query to
> tbl_one has to go through all rows.. They are still fast to execute here
> the results:
> The select query takes 0.0001 sec.
> The update query takes 0.0004 sec.
> thanks,
>  -matt
> --

mmmmm ,  then the problems isnt here, the queries are fast , i dont
see how improve that.

by the way

> I would think it would hold up pretty well as just a DB server,

there is a diferent server for PHP ?
can be a problem with the connection with the DB server?


    Pedro Arana Matus
"La forma más rápida de lograr que un ingeniero solucione un problema
es declarar que el problema es insoluble."

More information about the thelist mailing list