I have an innodb table with 200 million rows and growing. It is a highly active table with tons of inserts and updates at all times. I notice a select query I test on that table is 0.01 seconds or less when all the inserts/updates are OFF. But when I throttle up the writes to the table, the select sql then takes like 1-3 full seconds or more. This is a serious bottleneck in our application. Any basic innodb wisdom for this scenario?
+-----------+---------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+---------------------+------+-----+---------+-------+ | id | bigint(20) unsigned | NO | PRI | 0 | | | clock | int(11) | NO | PRI | 0 | | | type | int(11) | NO | PRI | 3 | | | num | int(11) | NO | | 0 | | | value_min | double(20,4) | YES | | NULL | | | value_avg | double(20,4) | YES | | NULL | | | value_max | double(20,4) | YES | | NULL | | +-----------+---------------------+------+-----+---------+-------+
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=listsearcharchive@lassosoft.com
Feb 19
Walter Heck Re: Super active table optimization
Feb 19, 2011; 17:56
Walter Heck
Re: Super active table optimization
Feb 19
Reindl Harald Re: Super active table optimization
Feb 19, 2011; 18:17
Reindl Harald
Re: Super active table optimization
Search
Lasso Programming
This site manages and broadcasts several email lists pertaining to Lasso Programming and technologies related and used by Lasso developers. Sign up today!