Thanks for the idea.
I have changed the datatype to bigint, the result is not changed.
mysql> desc select * from ip_test where startNum <= 3061579775 and
endNum >= 3061579775;
++-+-+--+-+--+-+--++-+
| id | select_type
在 2010年11月9日 下午3:51，Johan De Meersman 写道：
> Indexes typically only work on the left-hand-side. Rewrite as
> select * from ip_test where startNum <= 3061579775 and endNum >= 3061579775;
>
Thanks.
But this seems the same case happened:
mysql> desc select * from ip_test where startNum <= 30615797
Hello,
I have a query below:
mysql> select * from ip_test where 3061579775 between startNum and endNum;
+++-+--+--++
| startNum | endNum | country | province | city | isp|
+++-+--+--+
2010/10/26 Philip Riebold :
>
> On 26 Oct 2010, at 11:49, MikeB wrote:
>
>> I'm finding the MySQL online manuals hard going in figuring out how to
>> construct SQL queries. Can anyone perhaps recommend a good book that can
>> shed light on the subject?
>>
>> Thanks.
>
> The book I've been using i
Hello,
Our mysql is using Innodb engines.
How can I get the read/write percent to each table?
for example, for the table_99, the read percent is 77%, write percent is 23%.
Thanks.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql
Hello,
We are a company for gaming.
Our main db is mysql 5.1 installed on Linux.
Currently the hardware for mysql is 2*4 CPU, 16G memory, Raid 10 (four disks).
Now we have the plan to replace the disks with SSD for better performance.
Do you think is it right for the SSD solution for mysql?
Thank
Hello,
what system variables of mysqld can be changed on fly?
thanks.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
