… InnoDB Plugin: 0. InnoDB Plugin must be enabled. 1. Do steps 0 and 1 described in this post. 2. Shutdown MySQL. 3. Edit my.cnf to disable InnoDB Plugin. 4. Do steps 2, 3 and 4. 5. Start on MySQL (with built-in innodb, not plugin…
Post: Percona Server 5.1.58-12.9
August 17, 2011 By 2 Comments
…Fixed: #802825 / #61341 in MySQL (Yasufumi Kinoshita). …my.cnf have been kept for compatibility and warnings will be printed for the deprecated options (innodb_buffer_pool_shm_key and innodb_buffer_pool_shm_checksum) if used. Instructions for disabling…
Post: Percona Server 5.5.13-20.4 Stable Release
July 1, 2011 By 3 Comments
…Percona Software Repositories). Based on MySQL 5.5.13, Percona …my.cnf have been kept for compatibility and warnings will be printed for the deprecated options (innodb_buffer_pool_shm_key and innodb_buffer_pool_shm_checksum) if used. Instructions for disabling…
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
…environment. (garfield:~/work/mysql-5.0.51a) % ./configure ‘–disable-shared’ ‘–with-server-suffix=-community’ ‘–without-embedded-server’ ‘–with-ndbcluster’ ‘–with-innodb‘ ‘–with-csv…enables the logging. If you don’t specify it in my.cnf file, the remaining part of the configuration will not …
Comment: Jeremy Cole on MySQL Replication
June 14, 2006 By 12 Comments
… what I took from it was that you should disable xa-support in my.cnf if you 1. don’t need it and… between the content of InnoDB tables and the binary log. (Note: –innodb-safe-binlog is unneeded as of MySQL 5.0; it was… you’re using MySQL 5, and it’s the only transactional resource you’re using, is it safe to DISABLE innodb_xa_support…
Comment: How to estimate time it takes Innodb to Recover ?
June 25, 2008 By 7 Comments
… config (my.cnf) were all disabled from 20 servers: # Uncomment the following if you are using InnoDB tables #innodb_data_home_dir = /var/lib/mysql/ #innodb_data_file_path = ibdata1:2000M;ibdata2:10M:autoextend #innodb_log_group_home_dir = /var/lib/mysql/ #innodb…
Post: Replication of MEMORY (HEAP) Tables
October 15, 2010 By 7 Comments
…operation. So what you can do ? Use Innodb Table Instead Innodb is quite fast when it fits in…in your my.cnf; run SLAVE STOP; dump all your memory tables using MySQLDump; Restart the MySQL As planned;…replication. In this case you will need to disable binary logging while loading data from mysqldump …
