Percona's MySQL & InnoDB performance and scalability blog
…big fan of MyISAM; I would argue that in most situations, any possible advantages to using MyISAM are far … The other one is a set of about 790K directory records, each one containing the name, address, and …that likes lower_case_table_names = 1 in /etc/my.cnf), but I think it’s even worse that the…
… to # /etc/my.cnf to set global options, # mysql-data-dir/my.cnf to set server-specific options (in this # installation this directory is /usr/local/mysql/data) or # ~/.my.cnf to set user… = 100M read_buffer_size = 100M read_rnd_buffer_size = 100M myisam_sort_buffer_size = 100M max_length_for_sort_data=2048…
…=/etc/my.cnf –export /tmp/ Then apply the logs to get a consistent backup: # innobackupex –defaults-file=/etc/my.cnf …files from the backup to the database data directory: # cp /tmp/2012-01-22_14-13-20…you can also recover single InnoDB table as with MyISAM but knowing in advance that there are some…
… … Once that has completed, enter the sources directory: (garfield:~/work) % cd mysql-5.0.51a …InnoDB will take significantly longer to close than MyISAM), database configuration, load, etc. Configuration There are …. If you don’t specify it in my.cnf file, the remaining part of the configuration …
Copyright © Percona LLC • Contact Us • MySQL and InnoDB are trademarks of Oracle Corp.