June 19, 2013

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

February 6, 2011 By 2 Comments

… 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.

Filed Under: MySQL, Percona Software

Post: Announcing Percona Server 5.5.25a-27.1

July 21, 2012 By Leave a Comment

… 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…

Filed Under: MySQL

Post: MySQL on Amazon RDS part 1: insert performance

March 15, 2011 By 37 Comments

… (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…

Filed Under: Cloud and NoSQL, MySQL

Post: New patches, new builds

September 5, 2008 By 24 Comments

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

Filed Under: Percona Software Tagged With:

Post: Performance Schema tables stats

May 2, 2011 By 2 Comments

… 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…

Filed Under: MySQL

Post: The perils of InnoDB with Debian and startup scripts

January 28, 2009 By 13 Comments

… 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…

Filed Under: Insight for DBAs Tagged With: ,

Post: InnoDB: look after fragmentation

November 5, 2009 By 12 Comments

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

Filed Under: Insight for DBAs, MySQL Tagged With:

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

February 26, 2013 By 1 Comment

…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_…

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , ,

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

February 28, 2010 By 28 Comments

… 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 …

Filed Under: Insight for DBAs, MySQL Tagged With: , , ,

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

March 11, 2013 By 7 Comments

… 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…

Filed Under: MySQL Tagged With: , , , , ,
« Older Posts
Newer Posts »