Dear Nitin,
I have newly installed mysql on this server.
mysql> Select version();
+-+
| version() |
+-+
| 5.1.22-rc-Debian_2~ppa5-log |
+-+
Earlier I use to run the same command on Fedora-wi
At 04:44 AM 9/3/2010, Alexandre Vieira wrote:
Hi Johnny,
mysql> EXPLAIN SELECT * FROM clientinfo WHERE userid='911930694';
++-++---+---+-+-+---+--+---+
| id | select_type | table | type | possible_keys | key | key_
On 9/3/2010 3:15 PM, Johnny Withers wrote:
It seems that when your index is PRIMARY on InnoDB tables, it's magic and is
part of the data thereby it is not included in the index_length field.
I have never noticed this. I don't think adding a new index will make a
difference.
You could try moving
Thansk,
Will try to turn on log_warnings.
-Mon
From: Nitin Mehta
To: monloi perez ; Ananda Kumar
Cc: mysql mailing list
Sent: Sun, September 5, 2010 12:03:45 PM
Subject: Re: Logs not working
I believe that will not be logged unless you have enabled log_war
