June 19, 2013

Post: Percona Server and XtraBackup weekly news, February 5th

… about making innodb_file_per_table a session variable. There was discussion on a bug that makes the INDEX_STATISTICS and TABLE_STATISTICS tables… at all. Mark Callaghan found a bug in INFORMATION_SCHEMA.INNODB_SYS_TABLES in the 5.1 server code. Percona XtraBackup… discussed for innobackupex. There was discussion about making tar4ibd support InnoDB‘s compressed tables.

Post: Announcing Percona Server 5.5.25a-27.1

… regression introduced with ssl connections count in statistics tables in Percona Server 5.5.24-… Server started with skip-innodb crashes on SELECT * FROM INNODB_TABLE_STATS or INNODB_INDEX_STATS. Bug fixed… Bug fixed #988383 (Stewart Smith). Fixed upstream mysql bug #60743, typo in cmake/dtrace.cmake…

Post: MySQL on Amazon RDS part 1: insert performance

… (RDS) is a cloud-hosted MySQL solution. I’ve had some clients…,000 rows. This creates a table+index data size approximately twice as big … happens in B-Tree inserts (see InnoDB vs TokuDB for example). This doesn… slowdowns. I should have gathered more statistics and finer-grained samples, say, every…

Post: New patches, new builds

STATISTICS, INDEX_STATISTICS, TABLE_STATISTICS to INFORMATION_SCHEMA mysql> select * from information_schema.table_statistics; +————————-+———–+————–+———————-+ | TABLE_NAME | ROWS_READ | ROWS_CHANGED | ROWS_CHANGED_INDEXES

Post: Performance Schema tables stats

… post some statistics we are able to get from performance schema tables. 1. table_io_waits_summary_by_table mysql> select * from… sec) 2. There is table with statistic per index: mysql> select * from table_io_waits_summary_by_index_usage where OBJECT_NAME=’sbtest55′G…_NAME: /data/tachion/sb/ibdata1 EVENT_NAME: wait/io/file/innodb/innodb_data_file COUNT_READ: 118218 COUNT_WRITE: 849692 SUM_NUMBER…

Post: The perils of InnoDB with Debian and startup scripts

… all those processes in ‘statistics‘ status. Why is that happening? Look at SHOW INNODB STATUS: ===================================== 090128 8:29:03 INNODB MONITOR OUTPUT ===================================== Per…, OS thread id 1159956816 starting index read, thread declared inside InnoDB 500 mysql tables in use 7, locked 0 MySQL thread id 6424, query id 1579718 10.255.106.47 user statistics And…

Post: InnoDB: look after fragmentation

mysql> SHOW STATUS LIKE ‘Innodb_scan_pages%’; +——————————+——-+ | Variable_name | Value | +——————————+——-+ | Innodb_scan_pages_contiguous | 45 | | Innodb…/ InnoDB-plugin with FAST INDEXInnodb_scan_pages_contiguous ; Innodb_scan_pages_jumpy statistics

Post: InnoDB Full-text Search in MySQL 5.6 (part 1)

…get some statistics about the FT indexes on that table by querying the various I_S.INNODB_FT_* tables. In particular, the INNODB_FT…happens: mysql> set global innodb_ft_aux_table=’test/dir_test_innodb‘; mysql> set global innodb_optimize_fulltext_only=1; mysql> select * from information_schema.innodb_…

Post: Why you should ignore MySQL's key cache hit ratio

… very limited use for the statistics from which the ratio is …hold your working set — the index blocks that are frequently used….InnoDB tuning? You might be wondering, what about InnoDB tuning? What is the best way to choose an innodb…your IO system’s capabilities. MySQL doesn’t have good …

Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark

… and the other secondary indexes have been pushed out of the buffer pool. mysql> select * from information_schema.innodb_buffer_pool_stats\G *************************** 1….000000 | 0.000000 | 0 | 0 | 0 | 0 | 29 | 29 | | 9 | statistics | 0.000130 | 0.000097 | 0.000000 | 0.000000 | 0 | 0…