June 19, 2013

Post: Percona XtraBackup 2.1.0 'release candidate' for MySQL available for download

May 7, 2013 By Leave a Comment

… crash when preparing the 5.6 backup with partitioned tables. Bug fixed #1169169. Tables that were dropped between taking a full backup… backups has been merged. Fixed by removing files corresponding to tables that are missing in the incremental backup directory. Bug fixed… are thousands of tables and slow IO then XtraBackup can spend a lot of time opening all the tablespaces. Optimization has been…

Filed Under: MySQL, Percona Software Tagged With: , , ,

Post: Percona XtraBackup 2.0.7 for MySQL available for download

May 6, 2013 By 1 Comment

… crash when preparing the 5.6 backup with partitioned tables. Bug fixed #1169169. Tables that were dropped between taking a full backup… backups has been merged. Fixed by removing files corresponding to tables that are missing in the incremental backup directory. Bug fixed… are thousands of tables and slow IO then XtraBackup can spend a lot of time opening all the tablespaces. Optimization has been…

Filed Under: MySQL Tagged With: , , ,

Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released

March 25, 2013 By 2 Comments

… it and how. There’s still one noticeable omission: pt-table-sync. It’s still unclear if or how one would…). This feature is still in development while we determine the optimal JSON structure. Version check is on by default In 2…

Filed Under: Percona Software, Percona Toolkit Tagged With: , , , , ,

Post: Thinking about running OPTIMIZE on your Innodb Table ? Stop!

December 9, 2010 By 18 Comments

…> optimize table a; +——–+———-+———-+——————————————————————-+ | Table | Op | Msg_type | Msg_text | +——–+———-+———-+——————————————————————-+ | test.a | optimize | note | Table does…

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

Post: Recovering Innodb table Corruption

July 4, 2008 By 22 Comments

… you can create or drop Innodb tables): mysql> optimize table test; +———–+———-+———-+———————————-+ | Table | Op | Msg_type | Msg_text | +———–+———-+———-+———————————-+ | test.test | optimize | error | Got error -1 from…

Filed Under: Insight for DBAs Tagged With:

Post: Slow DROP TABLE

June 16, 2009 By 21 Comments

… DROP TABLE to minimize the effect, such as: TRUNCATE TABLE large_table; ALTER TABLE large_table ENGINE=…; DROP TABLE large_table; TRUNCATE TABLE large_table; OPTIMIZE TABLE large_table; DROP TABLE large_table; Unfortunately as it turned out each of the administrative commands like ALTER TABLE or OPTIMIZE TABLE one…

Filed Under: Insight for DBAs Tagged With:

Post: How well does your table fits in innodb buffer pool ?

December 9, 2010 By 12 Comments

… innodb_sys_tables ON table_id = innodb_sys_tables.id JOIN innodb_index_stats ON innodb_index_stats.table_name = innodb_sys_tables.name AND…_name AND innodb_index_stats.table_schema = innodb_sys_tables.SCHEMA ORDER BY cnt DESC LIMIT 20; +————–+————–+————–+——+——-+——–+———+ | table_schema | table_name | index_name | cnt… as how buffer pool is affected by batch jobs, alter tables, optimize table etc – the lasting impact these may have on system performance…

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

Post: ALTER TABLE: Creating Index by Sort and Buffer Pool Size

June 27, 2012 By 4 Comments

… are pretty interesting. I used modified Sysbench table for these tests because original table as initially created only has index on column… following in terms of data and index size: mysql> show table status like “sbtest” \G *************************** 1. row *************************** Name: sbtest Engine: InnoDB…: If you’re having large tables and need to run ALTER TABLE which rebuilds the table or OPTIMIZE TABLE do not forget to enable expand…

Filed Under: Insight for DBAs, MySQL

Post: Learning about MySQL Table Fragmentation

May 1, 2008 By 20 Comments

… this particular form of query because it will do full table scan – running count(*) without where clause may pick to scan… notice you can see poor sequential scan performance even if table is not logically fragmented and Innodb is reading data in… same – OPTIMIZE TABLE tbl – this command recreates the table by writing the new .ibd file (if you’re using innodb_file_per_table=1…

Filed Under: Insight for DBAs Tagged With: ,

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

February 26, 2013 By 1 Comment

… | | | optimize_end_time | | | stopword_table_name | | | use_stopword | 1 | | table_state | 0 | +—————————+———+ 10 rows in set (0.02 sec) mysql> optimize table dir_test_innodb; +———————-+———-+———-+———-+ | Table… | | total_word_count | | | optimize_start_time | | | optimize_end_time | | | stopword_table_name | | | use_stopword | 1 | | table_state | 0 | +—————————+———+ I ran OPTIMIZE TABLE several more times, and…

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , ,
« Older Posts
Newer Posts »