[thelist] tuning MySQL

[Pedro Arana]

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?

Greetings!

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