Hi All,
Following query take 25 minutes time,in this table having 3 core
records,how to speed up this query,please help me.thanks advance
SELECT b.circle_name,
COUNT(a.mob),
a.pack_price,
DATE(a.req_date)
FROM user_info_table a,
circle_info_table b
WHERE a.
using Execution plan:
++++-+---++-+---+-+-
---+
| id | select_type| table | type|
possible_keys | key| key
Hello,
Starting today, my daily database backup script does not work :-( with
mysqldump typically Out of memory error.
So, I try to change max_allowed_packet option value, but I don't succeed
(mysql run on ubuntu 10.04 OS with 5.1.41-3ubuntu12.7 0 mysql version.)
On the last successfull backu
>
> AND Substring(a.mob, 1, 4) = b.mob_series
>
There's what is probably the major problem with your query: your join
condition. Indices (you *do* have them on your join fields, don't you ?)
only work on the entire field you've indexed.
Function indices are not supported in MySQL, so you'll
