…looks like: if (thread->n_tickets_to_enter_innodb > 0) { thread->n_tickets_to_enter_innodb–; ENTER; } retry: if (entered_thread < innodb…of CPUs and you’re using mainly Innodb tables you might be unable to use all…innodb_log_flush_at_trx_commit=0 or 2 smaller values may make sense. If you have binary…
Post: MySQL Crash Recovery
July 30, 2006 By 30 Comments
… in MySQL and so problem potential is larger. So lets look at the problem which happen during the crash which might need…_per_table=1 your recovery speed will depend on number of Innodb tables you have, as well as many other operations, so beware. Binary log corruption – Binary log may become corrupted…
Post: Recovery beyond data restore
August 2, 2008 By 11 Comments
… for complex systems. Instead of looking just at data restore process you better look at the whole process which …as using sync-binlog innodb_flush_logs_at_trx_commit=1 and only using Innodb tables to be OK … a standby MySQL server or at least synchronously replicated master binary logs. If you can’t …
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… bad query plan. After this I’ll look at SHOW INNODB STATUS\G and see if there’s anything worth … other things I’ll look at, including checking for default users in the mysql.* tables, running mk-duplicate-key-…If it’s not possible to use a patched binary, we can use MySQL Proxy, packet sniffing, or …
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
…your platform. Also have a look at the files in the Docs … for details). Then rename the binary, which can be safely … full_scan, full_join, tmp_table, tmp_table_on_disk, filesort, filesort_on…InnoDB extensions msl patch for MySQL 5.0.51a with InnoDB extensions msl patch for MySQL 5.0.54a with InnoDB…
Post: Implications of Metadata Locking Changes in MySQL 5.5
February 1, 2013 By 9 Comments
… the binary log breaking locking semantics and contrary to serialization concepts. For example take a look at the following excerpt from the binary log of a case when an UPDATE transaction is mixed with an ALTER: # at 536… primary key) ENGINE=InnoDB; However, I feel that the CREATE TABLE should fail in such a case when the table already exists and…
Post: Troubleshooting MySQL Upgrade Performance Regressions
February 15, 2012 By Leave a Comment
…query logs but if this is not possible at least look at network traffic from tcpdump. This should help…MySQL 5.6 you can also store innodb stats in table so you have more control over them…the bug at this point. Check Binaries Make sure you’re not using debug binary or differently optimized binaries. …
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
… as efficient as a binary search can be performed. But InnoDB‘s adaptive hash indexes require …Innodb decided how many pages to flush at each checkpoint interval HT: Usually it is 128, or less. PZ: Looks…example, if ORDER and ORDERLINE tables are joined to form a single table), it might make sense …
Post: MySQL Backup tools used by Percona Remote DBA for MySQL
March 13, 2013 By 8 Comments
… In addition to local copies, store backups offsite. Look at the cost of S3 or S3+Glacier, … the conditions. Percona XtraBackup for MySQL for binary backups. Strong Points: It can restore an … backups between myisam and innodb tables. Global read lock only held until myisam tables are dumped. We …
Post: MySQL Indexing Best Practices: Webinar Questions Followup
August 16, 2012 By 4 Comments
…TABLE LINK (id1 int unsigned not null ,id2 int unsigned not null, PRIMARY KEY(id1,id2), KEY K(id2)) engine=INNODB; when table… using UUID it is at least good to convert it in binary form and store as…data in already sorted order and looks at “one group at the time”, computing aggregate functions as …
