May 25, 2012

Comment: Why MySQL could be slow with large tables ?

…_concurrency=4 myisam_sort_buffer_size=950M character-set-server=utf8 default-collation=utf8_unicode_ci set-variable=max_connections=1500 log_slow… the backup and all of that is so very cumbersome (mysqlhotcopy is not available, for instance) and eking performance out of…

Comment: Database problems in MySQL/PHP Applications

…, # MASTER_USER=’joe’, MASTER_PASSWORD=’secret’; # # OR # # 2) Set the variables below. However, in case you choose… 16M [mysql] no-auto-rehash # Remove the next comment character if you are not familiar with SQL #safe-updates…_size = 256M read_buffer = 2M write_buffer = 2M #[mysqlhotcopy] interactive…