Percona is glad to announce the release of Percona Server 5.5.22-25.2 on April 25, 2012 (Downloads … Software Repositories). Based on MySQL 5.5.22, including all the bug fixes in it, Percona Server 5.5.22-25.2… MEMORY engine may return rows in non-deterministic order for equal keys. Bug fixed #892951 (Laurynas Biveinis). Release notes for Percona Server…
Post: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
… with highest memory available, and memory is what really really matters. High-Memory Quadruple Extra Large Instance 68.4 GB of memory 26 EC2… 10. Now let’s come to the MySQL configuration. MySQL Configuration I used Percona Server 5.5.22-55 for the tests. Following… I am using “estimate” flushing method available only on Percona Server. The “estimate” method reduces the impact of traditional InnoDB log…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 3 Comments
…memory is being used by current MEMORY tables: mysql> select sum(data_length+index_length) from information_schema.tables where engine=’memory‘; …memory allocation and will result in increased memory allocation until server is restarted. I would suspect memory leak when you see memory…
Post: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
March 12, 2012 By 12 Comments
… in preparation for the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. We are taking a… optimizer enhancement Index Condition Pushdown (ICP). Its available in both MySQL 5.6 and MariaDB 5.5 Now let’s take…
Post: Percona Server 5.5.21-25.1 released!
March 29, 2012 By 8 Comments
Percona is glad to announce the release of Percona Server 5.5.21-25.1 on March 30, 2012 (Downloads … Software Repositories). Based on MySQL 5.5.21, including all the bug fixes in it, Percona Server 5.5.21-25.1… that we wish to make available. Bugs Fixed: Fixed a memory corruption regression introduced in 5.5.18-23.0. Bug…
Comment: Alternatives of PHP ?
April 11, 2012 By 28 Comments
… WebDNA: it is lighter than php and mysql and is also much faster (resilient in-memory database). It is 100% compatible with… virtually anything the server send to the browser. I run it with heavy in-memory databases but you can use MySQL if you…
Post: MySQL Server Memory Usage
May 17, 2006 By 18 Comments
… MySQL Server code and various small static buffers. This is memory which you can consider used when you just start MySQL Server. The rest of memory… to be impractical. Here is why: List of rarely considered MySQL Server Memory Requirements Thread buffers can be allocated more than once for…
Post: Getting MySQL Core file on Linux
August 26, 2011 By 1 Comment
… be dumped by setuid processes (and MySQL Server is most commonly ran changing user from “root” to “mysql“). Before you embark on enabling… space and restart time. The core file will dump all MySQL Server memory content including buffer pool which can be tens on even…, you may be looking at many times the amount of memory MySQL consumes worth of disk space. You have to do couple…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 8 Comments
… disk. The database server will continue to function, however, because the file isn’t really deleted. The MySQL server keeps an open filehandle…. The server is allocating too much memory. A runaway server process, or poorly optimized queries, can consume too much memory and cause the server to…
Post: What to tune in MySQL Server after installation
September 29, 2006 By 116 Comments
… as MySQL DBAs or be involved with MySQL Performance in some way is to ask them what should be tuned in MySQL Server straight… less secure as you can lose transactions even in case MySQL Server crashes. Value 2 only cause data loss with full OS… increase sort_buffer_size even if you have 64GB of memory to waste. Furthermore doing so may decrease performance. I normally…
