…_home_dir = innodb_data_file_path = ibdata1:10M:autoextend innodb_log_group_home_dir = /usr/local/mysql/data innodb_buffer_pool_size = 2000M innodb_additional_mem_pool_size = 2M innodb_log_file_size = 65M innodb… sec) Please help to improve performance and suggest if any config changes are to be made. Thanks
Post: How to check MySQL Config files
February 12, 2008 By 7 Comments
Probably most of MySQL users sometime had a situation when they would do changes in MySQL config file without restarting server (may be matching…. Unlike Apache MySQL service control script does not have “configtest” option so there is no straight way to check MySQL config file for errors…
Post: Fixing MySQL with a comment in the config file
February 4, 2011 By 5 Comments
…/mysql_multi wouldn’t start unless it found the text “mysqld_multi” in the /etc/my.cnf file. Not a [mysqld_multi] config file… the following comment into the file. # This comment is only necessary to make /etc/init.d/mysql_multi work OK, it greps…; I just checked a recent download, and the official MySQL distribution contains a file called mysqld_multi (note the different name) that…
Post: Can we improve MySQL variable handling ?
February 18, 2012 By 8 Comments
… restart. MySQL also does not have option to re-read config file without restarting as some other software so approach to change config file and… being different from settings set in config file, and unexpected change on restart a frequent problem. pt-config-diff is the tool which… querying of variable global value Right now I can select: mysql> select @@global.sort_buffer_size; +—————————+ | @@global.sort_buffer_size | +—————————+ | 2097152…
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… 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…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… and network config, etc, and I don’t see anything wrong there. So at this point, it looks like MySQL is probably…:30 /usr/libexec/mysqld –defaults-file=/etc/my.cnf –basedir=/usr –datadir=/var/db/mysql –user=mysql –pid-file=/var/run/mysqld/mysqld.pid –skip-external-locking –port=3306 –socket=/var/db/mysql/mysql.sock consult 28852…
Post: Using Flexviews - part two, change data capture
March 25, 2011 By 11 Comments
… file to consumer.ini and edit it, making appropriate changes. The file is well commented. The example settings file should work for most MySQL… metadata table: $ mysql -e ‘select * from flexviews.binlog_consumer_status\G’ -uroot *************************** 1. row *************************** server_id: 999 master_log_file: binary_log.000001… Note that you can enable auto_changelog=true in the config file to automatically record changes for any table, starting from the…
Post: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
November 29, 2011 By 94 Comments
… \ attributes IP=”10.2.2.162″ primitive p_mysql ocf:heartbeat:mysql \ params config=”/etc/mysql/my.cnf” pid=”/var/run/mysqld/mysqld.pid… defines the mysql resource on each node and has many parameters, here’s the ones I had to define: config: The path of the my.cnf file. Remember that Pacemaker will start MySQL, not the regular init.d script pid: The pid file…
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… = /usr/local/mysql/data/ #innodb_data_file_path = ibdata1:2000M;ibdata2:10M:autoextend #innodb_log_group_home_dir = /usr/local/mysql/data/ #innodb…
Post: Backing up binary log files with mysqlbinlog
January 18, 2012 By 2 Comments
… binary log files which could still lead to data loss depending on the interval you back them up. Recently in MySQL 5… got a new feature addition that supports connecting to remote MySQL instances and dumping binary log data to local disks ( http… the config and ensure mysqlbinlog utility is up and running. By default if you do not supply the binary log file, mysqlbinlog…
