…/mysql_multi wouldn’t start unless it found the text “mysqld_multi” in the /etc/my.cnf file. Not a [mysqld_multi] config file… was to place the following comment into the file. # This comment is only necessary to make /etc/init.d/mysql_multi work OK, it… time I can recall fixing software by putting a comment into its configuration file. Unfortunately I don’t recall what Linux distribution…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…config, etc, and I don’t see anything wrong there. So at this point, it looks like MySQL…mysql –user=mysql –pid-file=/var/run/mysqld/mysqld.pid –skip-external-locking –port=3306 –socket=/var/db/mysql/mysql… and see if there’s anything worth commenting on there. Depending on the workload, there …
Post: MySQL 5.5.8 and Percona Server: being adaptive
December 20, 2010 By 25 Comments
…_checkpoint (estimate) were the default values. The raw results, full config files, and scripts are in our Benchmarks Wiki. The graphical result… way. UPDATE By request from commenter I put also results with different innodb_io_capacity for MySQL 5.5.8. It is… config file used for benchmarks on FusionIO: [client] socket=/var/lib/mysql/mysql.sock [mysqld] core basedir=/usr/local/mysql user=root socket=/var/lib/mysql/mysql…
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 12 Comments
… MySQL config file for very large systems. # # # This is for a large system with memory of 1G-2G where the system runs mainly # MySQL. # # You can copy this file to # /etc/my.cnf to set global options, # mysql-data-dir/my.cnf… = 50 [mysqldump] quick max_allowed_packet = 16M [mysql] no-auto-rehash # Remove the next comment character if you are not familiar with…
Post: Using Flexviews - part two, change data capture
March 25, 2011 By 11 Comments
….example file to consumer.ini and edit it, making appropriate changes. The file is well commented. The example settings file should work for most MySQL… Note that you can enable auto_changelog=true in the config file to automatically record changes for any table, starting from the…
Post: Testing the Group Commit Fix
July 13, 2011 By 13 Comments
… and oltp read-write workload. All scripts, raw results and config files are available on our launchpad results page. The hardware used… in the future. UPDATE 14-Jul-2011 By requests from comments there is also result to compare binary logs enabled and…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…=InnoDB DEFAULT CHARSET=latin1 COMMENT=’Contains all avaialble data from 1988 to 2010′; mysql> use ontime1; Database changed mysql> show table status like… the shards.ini file for testing an cluster of 1 to 20 nodes. cd shard-query #generate a config for 20 shards…/mysql-inno.sock default-storage-engine=INNODB innodb-buffer-pool-instances=2 innodb-buffer-pool-size=5600M innodb-file-format=barracuda innodb-file…
Comment: MySQL versions shootout
October 12, 2011 By 6 Comments
… question is configuration – I see configuration file is large with a lot of stuff commented out. Do I understand correctly and you… as multiple buffer pools on MySQL 5.5 and above ? Also I’m not sure the config file posted (my.cnf) is correct at all. It contains: innodb_log_file_size = 4000M #innodb_log_file_size = 1024M #innodb_log_file…
Comment: Which Linux distribution for a MySQL database server? A specific point of view.
December 8, 2011 By 37 Comments
…make things work with flavors of RPM (individual file dependencies for parts of libc and friends …wrong libs combined with getting upset about the mysql config directory (due to multiple packages maintaining it) – … (perhaps garbled – I’ve been reading the mysql-master-ha wiki all afternoon) comments…
Post: Percona testing: Quick test clusters with kewpie!
January 13, 2012 By Leave a Comment
… x86_64 20120113-125552 INFO server_comment: (Source distribution wsrep_22.3.r3683)…| 13 | +—-+ 5 rows in set (0.00 sec) mysql> exit; Bye $ mysql -uroot –protocol=tcp –port=9320… the percona_tests/cluster_basic/suite_config.py file: server_requirements = [[],[],[]] server_requests = {‘join_cluster…
