…with INSERT INTO fs VALUES(0) into auto-increment field into InnoDB table. InnoDB parameters are…last N commited transactions. So now time to turn off write-cache on SSD – all transactions are… To have durability we need to disable write cache ( with following performance penalty, how much we need to …
Post: Improved InnoDB fast index creation
November 6, 2011 By 4 Comments
…how performance is affected when turning expand_fast_index_creation on. Here and in later examples I’m extending the VARCHAR column to… if expand_fast_index_creation is OFF to avoid dropping keys that are part… on AUTO_INCREMENT columns, because they must be indexed, so it is impossible to temporarily…
Post: The story of one MySQL Upgrade
October 8, 2010 By 8 Comments
…to make sure replication is in sync to begin with to avoid false positives. mk-table-checksum is a tool to do it. It turned…AUTO_INCREMENT column (and so affected by this bug). It was easy enough to change the single application not to…to the new setup. It was the time to check how…
Post: DROP TABLE and stalls: Lazy Drop Table in Percona Server and the new fixes in MySQL
June 22, 2012 By 33 Comments
…turned on innodb_file_per_table (which means that each table has its own tablespace), and you have to… the table dropping process to run during off-peak hours. But I… to mention quickly, that how drop table in MySQL < 5.5.23 used to…x(i int(11) not null auto_increment primary key) And during the …
Post: The Optimization That (Often) Isn't: Index Merge Intersection
December 14, 2012 By 6 Comments
…to use index_merge, but with disappointing results. CREATE TABLE users ( user_id INT UNSIGNED NOT NULL AUTO_INCREMENT… optimizer_switch=”index_merge_intersection=off“; This is the … or DBA, know exactly how the server should be…turns what was a 3 second query into a millisecond query. It’s hard to…
