In a previous post I explained how to repair MySQL 5.6 GTID replication using two different methods. I … up with data inconsistencies between Master and Slave servers. pt-table-checksum can help you here, which is found in Percona…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… workload (which actually is closer to what I need). Tables looks like: CREATE TABLE `sbtest1` ( `hid` int(10) unsigned NOT NULL DEFAULT… –test=insert_roll.lua –oltp-table-size=10000 –mysql-user=root –oltp-tables-count=32 –mysql_table_engine=tokudb –oltp_auto_inc=on…_size = 10G myisam_repair_threads = 1 myisam_recover socket=/var/lib/mysql/mysql.sock user=root skip-grant-tables TokuDB-related options…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… –num-threads=32 –test=tests/db/oltp.lua –oltp_tables_count=32 \ –oltp-table-size=10000000 –rand-init=on –report-interval=1…=95 \ –mysql-user=root –mysql-socket=/tmp/mysql.sock –mysql-table-engine=innodb \ –oltp-read-only=off run The base MySQL…_buffer_size = 8M myisam_max_sort_file_size = 10G myisam_repair_threads = 1 myisam_recover
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… NOT the typical form of Eventual Consistency, known as asynchronous repair, that most people think of). Callaghan’s Law But what…. When a player makes an achievement, your application updates this table with a statement like this: UPDATE achievements SET count = count… application. These are maintained in separate tables and there also exists a users_groups table to define the relationship between them. When…
Post: Recovering CREATE TABLE statement from .frm file
December 17, 2008 By 5 Comments
… chown mysql:mysql * mysql> repair table test_myisam USE_FRM; +——————+——–+———-+———-+ | Table | Op | Msg_type | Msg_text | +——————+——–+———-+———-+ | test.test_myisam | repair | status | OK | +——————+——–+———-+———-+ 1…
Post: mysql_upgrade and Innodb Tables
May 14, 2010 By 8 Comments
… some tables to be upgraded and will attempt to run REPAIR TABLE for them. This will fail with “The storage engine for the table doesn’t support repair” error message. This… should not be that complicated to at least map REPAIR TABLE to null ALTER TABLE which will help with most issues. There is…
Post: Can you Trust CHECK TABLE ?
September 11, 2008 By 6 Comments
Take a look at this: mysql> repair table a3; +———+——–+———-+———-+ | Table | Op | Msg_type | Msg_text | +———+——–+———-+———-+ | test.a3 | repair | status | OK | +———+——–+———-+———-+ 1 row in set… you can see you get quite funny table which is considered OK by CHECK TABLE, which does store values larger than max…
Comment: Upgrading MySQL
January 5, 2010 By 24 Comments
… the MyISAM table index format in MySQL 5.0. Upgrade from MySQL 4.1 to 5.0 and repair all MyISAM tables (see Section 2.4.4, “Rebuilding or Repairing Tables or Indexesâ€). Then upgrade from MySQL 5.0 to 5.1 and check and repair your tables.” http://dev…
Comment: mysql_upgrade and Innodb Tables
May 15, 2010 By 8 Comments
I filed a bug report about the ‘repair table‘ getting mapped to ‘recreate + analyze’: http://bugs.mysql.com/bug.php?id=47205 (map ‘repair table‘ to recreate +analyze for engines not supporting native repair)
Comment: MySQL Upgrade Webinar Questions Followup
June 28, 2012 By 7 Comments
…: error : Table upgrade required. Please do “REPAIR TABLE `account`” or dump/reload to fix it! this error happens to all my innodb tables, I understand that “repair table” statement does not work with innodb, thus, I had to do a “alter table table_name engine…
