jobrieniii/yourTwapperKeeper — Issue #2: MySQL Caching Best Practices
Author: audvin
Created: 2012-02-19 18:52:49+00:00
State: open

With close to 30M tweets in the database and perhaps around 1000-2000 keywords active in the stream, how should one configure MySQL for optimal performance.

I've got a server, 1GB memory, the MySQL process consumes about 75% CPU, the stream process gets the rest.

Looking at phpMySQL Status, there are many "red numbers" from the last 30 days...
- Handler_read_rnd: 16M
- Handler_read_rnd_next: 8,169M
- Created_tmp_disk_tables: 47
- Key_reads: 491M
- Opened_tables: 7,420M
- Table_locks_waited: 589k

How should MySQL be configured for best results with yourTwapperKeeper?