June 19, 2013

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: Percona XtraDB Cluster reference architecture with HaProxy

log too. After the SSTs are done, you should check if you have a 3 node cluster. mysql> show global status…. The statistics page is accessible on the client node with…mysqlmysql-engine-trx=yes –mysql-table-engine=innodbmysql-host=127.0.0.1 –mysql-port=3307 –mysql-user=sbtest –mysql

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: Is there room for more MySQL IO Optimization?

… binary log, FRM files, MySQL MyISAM system tables etc. Starting MySQL 5.5 MySQL uses… mysql> show table status like “post_channel” \G *************************** 1. row *************************** Name: post_channel Engine: InnoDB…more information MySQL has about data which will be accessed next – in…