….cnf to set global options, # mysql-data-dir/my.cnf to set server-specific options (in this # installation this directory is /usr/local/mysql/data… [mysqldump] quick max_allowed_packet = 16M [mysql] no-auto-rehash # Remove the next comment character if you are not familiar with SQL…
Comment: What to tune in MySQL Server after installation
October 8, 2012 By 118 Comments
… server is installing MySql 5.5.21 and the sorftware has the following settings: [mysqld] log-error=/var/log/mysqld.log init_connect=SET CHARACTER SET utf8 datadir=/data/mysql socket=/data/mysql/mysql.sock [General] skip…
Post: Infinite Replication Loop
October 10, 2011 By 2 Comments
… !! There was a hidden character in my.cnf that was unvalidating the value and then it was set to 1. How to… with the wrong server-id are performed on the two slaves (mysql 3 and mysql 4) and the new events (with server-id 1) are also replicated. Step 4: the event with server-id…
Comment: New Forum Categories: Help Wanted, For Hire
March 5, 2013 By 1 Comment
…=/tmp/mysqld_mdmp.sock character-sets-dir=/home/mysqld/sys/5.5.8/share/mysql/charsets [mysqld] port=3323 server-id=1 socket=/tmp…-ignore-table=mysql.gsd_runs replicate-ignore-table=mysql.gsd_monitor boonton: [client] port=3323 socket=/tmp/mysqld_mdmp.sock character-sets-dir=/home/mysqld/sys/5.5.8/share/mysql/charsets [mysqld] port=3323 server-id=2 socket=/tmp…
Comment: When is it a time to upgrade memory ?
December 9, 2009 By 11 Comments
… some performance issue sine at least 10 months on a MySQL server. I am not an expert, I am doing some tuning… user=mysql max_connections=600 connect_timeout=30 wait_timeout=15 max_allowed_packet=64M default-collation=utf8_unicode_ci default-character-set…/log_mysql innodb_log_file_size=1G innodb_log_buffer_size=64M innodb_flush_log_at_trx_commit=2 [mysql.server] user=mysql basedir…
Post: Using MMM to ALTER huge tables
March 27, 2008 By 11 Comments
… columns or indexes, changing data type, converting data to different character set – MySQL master-master replication especially accompanied by MMM can be very… reach this point. 5. on monitor: switch masters Once standby servers (only db2 in our case) have caught-up, we are… application to use different IP for MySQL or ensure some load balancer/proxy does this, set read-only manually on standby master…
Post: Are PHP persistent connections evil ?
November 12, 2006 By 32 Comments
… MySQL server connections. Some people simply do not realize you can increase max_connections variable and get over 100 concurrent connections with MySQL… into trouble. If you happen to recycle connections with custom character set settings you’re in trouble back again, not to mention about…
Comment: Fixing column encoding mess in MySQL
January 26, 2011 By 32 Comments
…, the tables were MyISAM – it came out of Sql Server into MySQL, and may have been converted to utf-8 during that…. Searching everywhere, I have found nothing that tells me what character set encoding that is, and I’ve tried many. When it… upside-down exclamation marks and “section” glyphs, etc. And some characters look like „« (double-comma, double-left-angle-brackets…
Post: Percona XtraBackup 1.6
April 12, 2011 By 15 Comments
…to MySQL 5.1.55, MySQL 5.5.9, Percona Server 5.1.55-12.6, and Percona Server …an error message was requesting that datadir be set, even though it’s not a required option….the –password option with innobackupex to specify MySQL passwords containing special shell characters (such as “&”) did not work, …
Comment: Fixing column encoding mess in MySQL
March 14, 2012 By 32 Comments
… CONVERT TO CHARACTER SET utf8; Does nothing except changes table/column encodings, but no actual content changes. So.. After this mysql thinks my table is utf8, I try the nr2 way mentioned in this blog: UPDATE table SET column=CONVERT…; And it.. Does nothing. £ sign stays the same, nothing changes. Server version: 5.1.61-0ubuntu0.11.10.1
