… the surface becomes challenge with MySQL because there are no clear resource usage metrics available, and …. There is no comparable variables of how many user variables are allocated (and how much … close connection. In Percona Server you can do better as you can query temporary tables too: mysql> …
Post: Too many connections? No problem!
March 23, 2010 By 28 Comments
…_5_0_87]$ ./use ERROR 1040 (00000): Too many connections Just happened to one of our …’ to clear the current input statement. mysql [localhost] {msandbox} ((none)) > select @@global.max_connections; +————————–+ | @@global.max_connections | +————————–+ | 5000 |…
Post: How Percona diagnoses MySQL server stalls
March 3, 2011 By 6 Comments
…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 the time the problem is clear upon a closer inspection, though. …of. There are many things that can cause a stall in MySQL, and …
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… Many people…, too. …mysql –user=mysql –pid-file=/var/run/mysqld/mysqld.pid –skip-external-locking –port=3306 –socket=/var/db/mysql/mysql… Value | +———————————–+———————-+ | Aborted_clients | 205174 | | Aborted_connects | 29 | | Binlog_cache_disk_…’s clear what …
Post: How Percona strives to remain neutral and independent
March 21, 2011 By Leave a Comment
Many of the prominent companies in the MySQL ecosystem are Percona customers,… on the solution. But to be clear, that is nothing more than non-…to err on the side of being too courteous to our customers if there …authorize you to mention our name in connection with the proposed architecture, unless we …
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 11 Comments
… different MySQL configurations, I didn’t try out different MySQL …3306 back_log = 50 max_connections = 2500 max_connect_errors = 10 table_cache …file sizes made no difference too. Write-back cache gave …was benchmarking, I could clearly see the difference … a [mirrored] RAID0 with many more stripes as …
Post: More on dangers of the caches
September 23, 2010 By 5 Comments
…. When software is deployed the memcache is cleared to avoid potential issues with different cache …connections to MySQL and so let application to err when it tries to put too much load on MySQL as MySQL… a way to increase traffic gradually There are many reasons beyond caching when you may want…
