Re: Slow Insert on simple query
Posted by:
Rick James
Date: March 01, 2011 10:19PM
`ip` varchar(15) NOT NULL DEFAULT '',
-- IPv6 is coming very soon! Suggest VARBINARY(39)
> 8gb of RAM, and mysqld is optimized to use up to 7gb of it.
If you set innodb_buffer_pool_size = 7G, then you were probably swapping. This is a big performance killer. 5G would be better.
How big is query_cache_size? Anything over 100M can cause unexplained sluggishness in random queries.
SHOW VARIABLES LIKE 'innodb%';
Subject
Written By
Posted
February 24, 2011 03:29AM
February 24, 2011 03:40AM
Re: Slow Insert on simple query
March 01, 2011 10:19PM
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.