I have a database, say abc, in mysql server. It has only one table named test. test uses innodb engine and I've set innodb_file_per_table to true.
After I run the query delete from abc.test, I want ...
I have a busy InnoDB table that expands and contracts regularly in size on a daily basis based on it's load. Typically, we'd see the table grow to 80GB in size (50/50 data and indexes) and then shrink ...
Hardware specs for an OLTP DB
dual quad core xeon with hyperthreading
Hardware RAID10 BBU
Standard install of Ubuntu 10.04LTS with default LVM partitioning
Installed Percona ...