…example, MySQL 5.6 DBA and Developer Guide has a number of graphs starting with 32 connections… baseline that offers the best response times (MySQL server does not use multiple threads to execute… — many batch jobs are written to be single-threaded. MySQL replication is single-thread too, and MySQL 5…
Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released
March 25, 2013 By 2 Comments
…Server, MariaDB, Percona XtraDB Cluster, and MariaDB Galera Cluster), upgrades are fashionable, so to speak. Problem is: “original” pt-upgrade was too…connection over the web, else it will use a standard (http) connection. pt-stalk and pt-mysql-summary have built-in MySQL…
Post: Too many connections? No problem!
March 23, 2010 By 28 Comments
…? [percona@sandbox msb_5_0_87]$ ./use ERROR 1040 (00000): Too many connections Just happened to one of our customers. Want to know… the server is flooded. So, when this happens in production, the problem is – how do you quickly regain access to mysql server to… to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 8 Server version: 5.0.87-percona-highperf-log MySQL Percona…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 11 Comments
… will alert when a snapshot is failed or overly full. Too many deadlocks. Deadlocks (and lock wait timeouts, covered in another plugin…-check-mysql-status plugin to alert when the server‘s Uptime variable is too small. The server is approaching max_connections. Overflowing the max_connections setting…
Post: What to tune in MySQL Server after installation
September 29, 2006 By 118 Comments
…MySQL Server straight after installation, assuming it was installed with default settings. I’m surprised how many… one does not really affect performance too much, at least on OS with decent…tables (remember each connection needs its own entry) if you have many connections or many tables increase it…
Post: MySQL Server Memory Usage
May 17, 2006 By 21 Comments
…MySQL Server so it uses too small amount of memory it will likey perform suboptimally. If you however configure it so it consumes too…MySQL Server. The rest of memory is available for connections. For exampe with 8GB server… and Cursors. Single connection may have many prepared statements and cursors…
Post: How Percona diagnoses MySQL server stalls
March 3, 2011 By 6 Comments
…many requests for help with server stalls. They come under various … thing to check for. VARIABLE=${VARIABLE:-Threads_connected} You need to change the threshold…and sometimes the problem is doing too much work without blocking. Likewise, …of. There are many things that can cause a stall in MySQL, and …
Post: Auditing login attempts in MySQL
December 28, 2012 By 4 Comments
…too many audit capabilities in MySQL Community so the first option to audit MySQL…mysql> select * from user_statistics where user=’root’\G *************************** 1. row *************************** USER: root TOTAL_CONNECTIONS: 25 CONCURRENT_CONNECTIONS: 0 CONNECTED… using Percona Server you can…
Post: MySQL Connection Timeouts
April 19, 2011 By 4 Comments
… very busy MySQL server you will see sporadic connection timeouts, such as Can’t connect to MySQL server on ‘mydb’ (110). If you have connects timed in… too low for many conditions. Now lets look more into the problem and do some Math. First lets look into how MySQL accepts connection…
Post: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
…1000 | 224 | | SOCKET | /tmp/mysql_sandbox5530.sock | /tmp/mysql_sandbox5610.sock | | INNODB_FILE_PER_TABLE | …concurrency workloads. Makes sense as servers have a lot more cores …as value of 1M is too small to be practical … change to help workloads with many connects/disconnects sync_relay_log_info…
