… table these rare corruptions did not cause too much problems to us – as it was not clustered index we always could repair table by running ALTER TABLE with limited impact to production system (as only one table of about a hundred… recovery settings. Happily I was able to restart MySQL with innodb_force_recovery=4 (SRV_FORCE_NO_IBUF_MERGE). So in my…
Post: 10+ Ways to Crash or Overload MySQL
November 13, 2007 By 20 Comments
…tables would be repaired at the same time. What if user uses all 100 of his allowed connections to ALTER 100 different tables…tables in MySQL 5.1 Disk Space For MyISAM tables hosting providers used to use disk quotas for MyISAM tables…
Post: Paul McCullagh answers your questions about PBXT
November 20, 2009 By 2 Comments
… MySQL Backup API which was originally implemented in MySQL 6.0. This feature is now scheduled for an upcoming version of MySQL 5.4. The Backup API makes it possible to pull a consistent snapshot of an entire database even when tables use… done by REPAIR TABLE. The table data page size does not require a rebuild because a page of records in the table is…
Comment: Why MySQL could be slow with large tables ?
June 20, 2007 By 141 Comments
…REPAIR TABLE table1 QUICK” at about 4pm, the above query would execute in 0.00 seconds. The problem was: why would this table…tables and we needed referential integrity and such, MySQL…
Post: MySQL 5.6.7-RC in tpcc-mysql benchmark
October 8, 2012 By 22 Comments
… requires big log files. MySQL configuration: [mysqld] gdb innodb_file_per_table = true innodb_data_file_path … = 0 ft_min_word_len = 4 thread_stack = 192K tmp_table_size = 64M server-id = 10 #*** … myisam_max_sort_file_size = 10G myisam_repair_threads = 1 myisam_recover user=root skip-grant-tables…
Post: Percona Server 5.1.60-13.1
December 16, 2011 By Leave a Comment
…MySQL at the time of this Percona Server release. Bug Fixed: #860910 (Alexey Kopytov) MyISAM repair…improvement in |myisamchk|, CREATE INDEX and ALTER TABLE performance. Bug Fixed: #878404 (Alexey Kopytov) …. Bug Fixed:#878022 (Laurynas Biveinis) GCC 4.6 has expanded diagnostics and compiler warnings…
Post: Small things are better
October 8, 2006 By 15 Comments
… 4.4 distribution but still it did. We had “journal failed” message in kernel log and filesystem needed to be checked and repaired… of MySQL bugs, OS Bugs or hardware bugs, misconfiguration or failures. Sometimes corruption kind be mild, so ALTER TABLE to rebuild the table… tables allow per table backup and recovery to happen faster. With MySQL and blocking ALTER TABLE there is yet another reason to keep tables small…
Comment: MySQL Installation and upgrade scripts.
May 21, 2007 By 3 Comments
… tried to upgrade from 4.1.19 to: 5.0.24a – fast, “check for upgrade” did not trigger table repairs (bad, varchar string….0.37 – slow, with “check for upgrade” repairs, problems with merge tables, performance problems while table is updated by PK = empty string (actially… present time I decided to upgrade to 5.0.36sp1 (MySQL Enperprise) it seems to be the most stable release, it…
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
…’, ’0′ ‘Com_rename_table‘, ’0′ ‘Com_repair‘, ’0′ ‘Com_replace’, ’20801587′ ‘Com_replace_select’, ’0′ ‘Com_reset’, ’0′ ‘Com_restore_table‘, ’0′ ‘Com… innodb_log_group_home_dir=/var/log/mysql innodb_log_arch_dir=/var/log/mysql innodb_table_locks=0 innodb_buffer_pool_size… # Lowered from 32M according to MySQL innodb_additional_mem_pool_size=20M innodb_file_io_threads=4 innodb_lock_wait_timeout=15…
Post: Rendundant Array of Inexpensive Servers
August 21, 2008 By 15 Comments
… extremely unlikely to fail, because you have 4 hour onsite repair agreement and because it is just freaking expensive… time (in particular if you’re using MyISAM tables) which can cause the error to propagate further …ie 8 core server can be slower than 4 core with MySQL). It is best if you just put …
