… tool you can measure how a database upgrade, change on my.cnf or schema change can affect the overall performance of your… meassure the impact of my.cnf changes replaying a slow query log. The service starts with an empty my.cnf configuration so all parameters… to ignore that. Second try, add 2GB of InnoDB Log Files (innodb_log_file_size=1G, innodb_log_files_in_group=2): Executed 429467…
Post: Percona Server on the Raspberry Pi: Your own MySQL Database Server for Under $80
February 25, 2013 By 10 Comments
… already) A quality 2GB (or more) SDHC… Transactions | XA | Savepoints | +——————–+———+—————————————————————————-+————–+——+————+ | InnoDB | DEFAULT | Percona-XtraDB, Supports…it in /etc/mysql/my.cnf If you setup…
Comment: Choosing innodb_buffer_pool_size
February 26, 2009 By 39 Comments
My server configuration 2GB /intelquad PROBLEM : i start my sql 4.0.12 with innodb_buffer_pool_size = 128 After starting the server my.cnf becomes my_cnf.bak. but randomly the configuration is reseted and all my previous…
