May 25, 2012

Post: Shard-Query EC2 images available

accessed. Since both InnoDBmysql> use ontime1; Database changed mysql> show table status like ‘ontime_fact’G *************************** 1. row *************************** Name: ontime_fact Engine: InnoDB

Post: Helgrinding MySQL with InnoDB for Synchronisation Errors, Fun and Profit

show_status_array(THD*, char const*, st_mysql_show_var*, enum_var_type, system_status_var*, char const*, st_table*, bool, Item*) (sql_showshow the same issues, show similar issues (other InnoDB stat counters), show non-issues or my analysis errors (like the log…use atomic access primitives in InnoDB

Post: Can MySQL temporary tables be made safe for statement-based replication?

InnoDB, and the InnoDB transaction ID does not change in SHOW INNODB STATUS

Post: Heikki Tuuri Innodb answers - Part I

…merged in Innodb mainline yet. Q11: If read-ahead is happening and Innodb needs to access …’ (lots of threads waiting for semaphores in SHOW INNODB STATUS), you can try to disable thread …MySQL‘s binlog and InnoDB‘s log must have the transactions in the same order, for a recovery based on MySQL

Post: INSERT INTO ... SELECT Performance with Innodb tables.

…rows before INSERT … SELECT had chance to access it it will also be modified in… so use innodb_locks_unsafe_for_binlog option with caution. Note disabling binary logs is …SHOW INNODB STATUS: —TRANSACTION 0 42304626, ACTIVE 14 sec, process no 29895, OS thread id 2894768 updating or deleting mysql

Post: SHOW INNODB STATUS walk through

SHOW INNODB STATUS output, showing what you can learn from SHOW INNODB STATUS output and how to use this info to improve MySQL Performance. To start with basics SHOW INNODB STATUSlog files to find truly conflicting statements. For most simple cases information from SHOW INNODB STATUS

Post: What MySQL buffer cache hit rate should you target

… data access, so you’re a bit in trouble) or “OS file reads”, “OS file writes” from SHOW INNODB STATUS for Innodb tables. In MySQL 5.0+ you can also use Innodb_data_reads, and Innodb_data_writes counters from SHOW STATUS So again… and writes are done and where do they come from (log writes, data/index reads etc) but you would probably have…

Post: Identifying the load with the help of pt-query-digest and Percona Server

…enable logging atomically, not just for new connections as in MySQL. …InnoDB pages (meaning 616.48K of data), however, 95% of the times InnoDB r ops is 0, which means it accessesSHOW TABLE STATUS FROM `wp_blog_one ` LIKE ‘wp_terms’\G # SHOW CREATE TABLE `wp_blog_one `.`wp_terms`\G # SHOW TABLE STATUS

Post: A quest for the full InnoDB status

InnoDB table called innodb_monitor: CREATE TABLE innodb_monitor (a INT) ENGINE=InnoDB Creating it causes the full status to be periodically printed into MySQL error logMySQL keeps the file deleted, so it is not possible access…run SHOW ENGINE InnoDB STATUS at least once. Then see what MySQL process …

Post: Heikki Tuuri answers to Innodb questions, Part II

… 6 tables, what version of Innodb/MySQL would you recommend? I’ve …or “does not fit”. Depending on data access distribution gains will be different … to increase size of your Innodb log files to be able to …not showed up in “show innodb status”. select * from table where id=5 show innodb status