…sysbench 0.5 and the version of MySQL used was Percona Server 5.5.30-rel30.1-465… memory but still fits into the cache device, vCache shines. Compared to a deployment with no SSD cache…I think vCache can be declared the clear winner. Base MySQL & Benchmark Configuration All benchmarks were conducted …
Post: Profiling MySQL Memory Usage With Valgrind Massif
January 9, 2013 By 3 Comments
… (see here if this is not clear) Now, before you run mysqld under…memory usage/trigger the memory problem. You could also just leave the server running for some time (for example, if you have experienced memory…_cache*, st_mysql_mutex*, Format_description_log_event const*) (in /usr/local/percona/mysql…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 5 Comments
…MySQL because there are no clear resource usage metrics available, and so in most cases you do not know where exactly memory…memory allocation and will result in increased memory allocation until server is restarted. I would suspect memory leak when you see memory…
Post: Is your server's performance about to degrade?
May 18, 2010 By 13 Comments
… this in servers running 20k queries per second and higher, lots of memory, lots … caused the query cache to become an enormous bottleneck. The query cache is an… 75 microseconds. I can see it clearly when I scan the slow query…and that’s where improvements to the MySQL source code are necessary. But …
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…memory with 17g virtual size, and there’s practically nothing else running (this is a dedicated master server…mysql –user=mysql –pid-file=/var/run/mysqld/mysqld.pid –skip-external-locking –port=3306 –socket=/var/db/mysql/mysql… | 29 | | Binlog_cache_disk_use | 0 | | Binlog_cache_use | …clear…
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: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
…Cache | 128MB Memory, BBU Present BBU | 100% Charged, Temperature 34C, isSOHGood= VirtualDev Size RAID Level Disks SpnDpth Stripe Status Cache ========== …Server 5.0.92-87 with the following my.cnf configuration: [mysqld] datadir=/data/mysql…I was benchmarking, I could clearly see the difference in …
Post: State of MySQL Market and will Replication live ?
April 9, 2008 By 29 Comments
… think about it as $/visitor or $revenue/server the difference for most enterprises vs …- MySQL kept being “simple” and introduced relatively simple performance boosters – Query Cache and Replication, which were clearly…- you can see Violin Memory appliance which can be used with MySQL to get very …
Post: Filling the tmp partition with persistent connections
August 6, 2012 By 14 Comments
… the server runs out of disk space on /tmp/partition. The first step is clear, check…binary log cache. binlog_cache_size and binlog_stmt_cache_size. Before 5.5.9 binlog_cache_size… memory, you could accidentally overcommit the physical memory, most likely killing system in the end. Conclusion MySQL…
Post: ALTER TABLE: Creating Index by Sort and Buffer Pool Size
June 27, 2012 By 4 Comments
…of data and index size: mysql> show table status like “sbtest” \G *************************** …even without this additional Percona Server feature. Lets now see …. Sorting needs OS Cache It is not clearly seen from the …memory allocating 6GB to buffer pool made very little memory available for OS cache…
