MySQL Forums
Forum List  »  Performance

Re: Keys ignored for larger tables!?
Posted by: Thomas Wiedmann
Date: April 06, 2011 05:10AM

most of your Index columns can be "NULL". For example:
..
`ip_start` int(10) unsigned DEFAULT NULL, 
`ip_end` int(10) unsigned DEFAULT NULL, 
..

Is this true or can you switch to NOT NULL? Please do it if you can.


I think we need some more informations:
Please provide:
* SHOW VARIABLES LIKE '%buffer%'; -- cache size
* SHOW VARIABLES LIKE 'query_cache%'; -- is it on?
* SHOW STATUS LIKE 'Qc%';
and surround them with [ code ] and [ / code ]

with kind regards,
Thomas

Options: ReplyQuote


Subject
Views
Written By
Posted
2506
April 06, 2011 04:00AM
Re: Keys ignored for larger tables!?
853
April 06, 2011 05:10AM
1594
April 08, 2011 08:20PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.