[thelist] tuning MySQL
Matt McKeon
matt at camadro.com
Thu Nov 30 11:06:21 CST 2006
Matt McKeon wrote:
> Pedro Arana 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..
>>>
>>> The SQL being used is:
>>> SELECT tbl_one.id, tbl_one.rating_current, tbl_one.rating_count,
>>> tbl_two.name_internal
>>> FROM tbl_one, tbl_two
>>> WHERE tbl_one.id = tbl_two.id AND tbl_two.name_internal = $name
>>>
>>> UPDATE tbl_one
>>> SET rating_current = $rate, rating_count = $cnt
>>> WHERE id = $id
>>>
>>> Hope that makes it a little easier, o and its in a RHE 4 environment.
>>>
>>> -matt
>>> --
>>>
>>>
>> hi!
>>
>> Wich information shows desc?
>>
>> DESC SELECT tbl_one.id, tbl_one.rating_current, tbl_one.rating_count,
>> tbl_two.name_internal
>> FROM tbl_one, tbl_two
>> WHERE tbl_one.id = tbl_two.id AND tbl_two.name_internal = $name
>>
>>
>>
>>
>>
> Sorry for the delay, we've been working on debugging this mess.. Anyway
> here's a DESC on the SELECT
>
> id select_type table type possible_keys key
> key_len ref rows Extra
> 1 SIMPLE tbl_one ALL PRIMARY NULL NULL NULL
> 270
> 1 SIMPLE tbl_two eq_ref PRIMARY PRIMARY 3
> db_daddy.tbl_one.id 1 Using where
>
> thanks a bunch,
> matt
>
>
wow, sorry about that mess.. hopefully this looks better. All fields are
separated by a -
id - select_type - table - type - possible_keys - key - key_len - ref - rows - Extra
1 - SIMPLE - tbl_one - ALL - PRIMARY - NULL - NULL - NULL - 270
1 - SIMPLE - tbl_two - eq_ref - PRIMARY - PRIMARY - 3 - db_daddy.tbl_one.id - 1 - Using where
More information about the thelist
mailing list