… 5 instances of iiBench simultaneously to simulate 5 concurrent connections writing to the table, with each instance of iiBench writing 200 million… noticed that the insert rate drop was mainly caused by IO pressure caused by increase in flushing and checkpointing activity. This caused…
Post: Best kept MySQLDump Secret
March 23, 2012 By 11 Comments
…TABLE. When ALTER TABLE is Performed in many cases it will Create temporary table with modified structure, copy data to that table and when drop original table and…OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; …
Comment: Best kept MySQLDump Secret
March 25, 2012 By 11 Comments
… dump file (correct table contents and binary log coordinates), no other connection should use the following statements: ALTER TABLE, CREATE TABLE, DROP TABLE, RENAME TABLE, TRUNCATE TABLE. A consistent read is not isolated from those statements, so use of them on a table to…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…table_namesblogpercona.commanual master_bindblogpercona.commanual master_connect…
Post: Recovering Innodb table Corruption
July 4, 2008 By 19 Comments
… table I am getting: mysql> check table test; ERROR 2013 (HY000): Lost connection to MySQL server during query mysql> check table test; +———–+——-+———-+———-+ | Table | …all your data in MyISAM table so all you have to do is to drop old table and convert new table back to Innodb …
Post: Connecting orphaned .ibd files
May 13, 2011 By 12 Comments
… consists of several internal tables. For our topic only SYS_TABLES and SYS_INDEXES are relevant. These are usual InnoDB tables, but they’re… connect actor.ibd from sakila database taken from some MySQL server. 0. Create empty InnoDB tablespace. 1. Create the table: mysql>CREATE TABLE… used in InnoDB dictionary for table test/t2 In this case you need to drop table `test`.`t2` and create it again. InnoDB will…
Post: Beware the Innodb Table Monitor
November 29, 2011 By 2 Comments
… can see every table, every column, and every index in that table. Once you get the output, you just DROP the table and it stops. It… io-wait spike is explained by table statistics being regenerated, and the SHOW PROCESSLIST connections stuck in ‘Opening Tables‘ were waiting for the dict…
Post: Multiple purge threads in Percona Server 5.1.56 and MySQL 5.6.2
May 3, 2011 By 13 Comments
…innodb_file_format=barracuda innodb_file_per_table max_connections=2000 table_cache=2000 Percona Server 5.1 …TPS. On the other hand, TPS does slightly drop with time in the second half of the…of dedicated purge threads. The workload is single-table, and the InnoDB team advises using just one thread…
Comment: MySQL Server Memory Usage
September 1, 2006 By 18 Comments
… often hit the “max_connections” threshold (650) connections. Cpu is fine (about 100% of 400% available, MPM and dual core reports 4 processors…’ ‘Com_do’, ’0′ ‘Com_drop_db’, ’0′ ‘Com_drop_function’, ’0′ ‘Com_drop_index’, ’0′ ‘Com_drop_table‘, ’0′ ‘Com_drop_user’, ’0′ ‘Com_execute_sql…
Post: NDB API examples, the trivia to make ndbapi_scan works!
November 15, 2009 By 4 Comments
…TABLE_EXISTS_ERROR) MYSQLERROR(mysql); std::cout << "MySQL Cluster already has example table: GARAGE. ” << "Dropping it…” << std::endl; /****************** * Recreate table * ******************/ drop_table(mysql); create_table…
