…the slave_compressed_protocol option in /etc/my.cnf if bandwidth is a concern. If you’…to prevent a problem before it occurs. For example, if you see a large number of long… in file: ‘./mysql/servers.frm’ ERROR: 1033 Incorrect information in file: ‘./mysql/servers.frm’ Running mysql_install_db under …
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
… Benchmark. In my previous blog post I compared MySQL 5.5.30 to MySQL 5.6.10, both with default settings using… OLAP analysis. Each query in each flight (Q1.1 for example) is tested with a cold buffer pool. Then the query… TABLE ENABLE KEYS. my.cnf [mysqld] datadir=/mnt/mysql56/data basedir=/usr/local/mysql socket=/var/lib/mysql/mysql.sock user=justin innodb_buffer…
Post: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 2, 2013 By 5 Comments
… replication feedback mechanism, unlike anything you find in standard async MySQL replication. It is my belief that the lack of understanding… as soon as possible. An example configuration tuning flow control in a master/slave cluster might be: mysql> set global wsrep_provider… Cluster Node Queue Ops Bytes Flow Conflct time name P cnf # name cmt sta Up Dn Up Dn Up Dn pau…
Post: Profiling MySQL Memory Usage With Valgrind Massif
January 9, 2013 By 3 Comments
…see less issues then with earlier versions. For example, earlier versions may have too-small Valgrind-internal…include –default-file=/etc/my.cnf (if this is where your my.cnf file is located) in …Log_event::read_log_event(st_io_cache*, st_mysql_mutex*, Format_description_log_event const*) (in /usr…
Post: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
November 29, 2011 By 102 Comments
… IP=”10.2.2.162″ primitive p_mysql ocf:heartbeat:mysql \ params config=”/etc/mysql/my.cnf” pid=”/var/run/mysqld/mysqld.pid” \ socket… Pacemaker to know if MySQL is already running. It should match the my.cnf pid_file setting. socket: The MySQL unix socket file…, you should set the quorum policy to ignore. Also, this example configuration has no stonith devices defined so stonith is disable…
Post: What's required to tune MySQL?
July 27, 2011 By 4 Comments
… vast majority of MySQL installations don’t suffer from the variety and severity of problems we write about here. Examples include what… consultant will need more than simply looking at your my.cnf file. It’s sometimes possible to look at the my… to other areas as a deliverable of the process. For example, you may receive suggestions about reindexing, or changing queries, or…
Post: Auditing login attempts in MySQL
December 28, 2012 By 4 Comments
… Query Log. Let’s see an example: Enable the log: general_log_file = /var/log/mysql/mysql.log general_log = 1 User correctly… MySQL is running on a multi-tenant environment or we need to control how resources are used. Let’s seen an example, first we enable User Statistics in my.cnf: 5.5 userstat = 1 5.1…
Post: Percona Server on the Raspberry Pi: Your own MySQL Database Server for Under $80
February 25, 2013 By 10 Comments
… needing to view the console of your Raspberry Pi (for example to configure an IP address in Arch Linux if you… mysqld Connect using the mysql client: [root@alarmpi ~]# /usr/bin/mysql Welcome to the MySQL monitor. Commands end with ; or \g. [...] mysql> SHOW ENGINES… the configuration file, you can find it in /etc/mysql/my.cnf If you setup Percona Server to startup at boot time…
Post: Distro Packages, Pre-built Binaries or Compile Your Own MySQL
September 4, 2012 By 7 Comments
… the other components of your operating system. Take for example Ubuntu, the MySQL packaging team does not always include with every release… can be as easy as stopping MySQL, updating symlinks or your my.cnf basedir, starting MySQL and running mysql_upgrade. Unlike package managers, you…
Post: Getting MySQL Core file on Linux
August 26, 2011 By 1 Comment
…. First you need “core-file” option to my.cnf which will instruct MySQL to dump core on crash. This alone will unlikely… configured dumping core I suggest you to test it for example on the test box, which has same operating system. This…/sbin/mysqld[0x516a61] The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains information that should help you…
