…followup by Dimitri Kravchuk, we have received a large number of questions on why the benchmark …on several our boxes. You can find setup/config details at the very end of this post….–percentile=99 –mysql-user=root –mysql-db=sbtest8t1M –mysql-table-engine=INNODB –mysql-socket=/tmp/mysql.sock –…
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 13 Comments
…innodb and myism tables and run on linux with 16gigs or ram. Here is our my.cnf # sammple MySQL config file for very large systems. # # # This is for a large…innodb_data_home_dir = /db innodb_data_file_path = ibdata1:10M:autoextend innodb_log_group_home_dir = /db innodb_log_arch_dir = /db…
Comment: Should MySQL update the default innodb_log_file_size?
November 22, 2011 By 37 Comments
… evaluate. An out-of-the-box config that overwhelms the user’s hardware…dedicated database servers. I do encounter db servers that share resources with PHP…the point. (c) Everyone uses the InnoDB plugin, and enjoys its 10x recovery…the plugin architecture. So a very large log file has some downside. Of…
