…Now let’s come to the MySQL configuration. MySQL Configuration I used Percona Server 5…threads = 8 innodb_write_io_threads = 4 innodb_file_per_table = 1 ## Disabling query cache query_cache_size = 0 query_cache…am using “estimate” flushing method available only on Percona Server. The “estimate” method…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 3 Comments
…MySQL 3.23 when there would only…_length+index_length) | +——————————-+ | 126984 | +——————————-+ 1 row in set…cache 512619219 (509995888 + 2623331) File system 294352 (82672 + 211680) Lock system 318875832 (318747272 + 128560) Recovery system 0 (0 + 0) Threads…
Post: Announcing Percona XtraBackup 1.9.1
February 27, 2012 By 9 Comments
… latest stable release (which was 1.6.5 at the time … previous versions where it was only possible to stream full backups….threads=2′ will create 4 IO threads that will read the data and pipe it to 2 compression threads… with parallel compression to (without caching) stream several compressed files at …
Post: MariaDB 5.3 is released as GA!
March 5, 2012 By 17 Comments
…, and elimination of useless tables in joins Thread pooling and a segmented key cache for improved scalability That’s really just a sampling. A good starting point for learning more is the MySQL versus… the only exciting thing, however. MariaDB 5.3 is based on MySQL 5.1, but MariaDB 5.5 will be based on MySQL 5…
Post: Return of the Query Cache, win a Percona Live ticket
August 26, 2011 By 4 Comments
…1 branch and replaced our fix. There are some other query cache improvements in MySQL…thread‘s status in SHOW PROCESSLIST to “Waiting on query cache mutex” when the query cache…
Post: MySQL Limitations Part 4: One thread per connection
October 27, 2010 By 14 Comments
…create a connection to MySQL, because it just requires creating a thread (or taking one from a cache). This is … or otherwise horizontally scaled application, it’s not only easy to get into this pickle, it’s …, and two followup blog posts from Tim Cook (1, 2). Thanks for the great comments on the …
Post: Evaluating IO subsystem performance for MySQL Needs
March 5, 2008 By 23 Comments
… the system. What I usually look for MySQL is performance in random reads and random …cache configuration: We get 4735.27 Requests/sec from 1 thread and single file; 4740.19 Requests/sec from 64 threads and 1… they are performed from single thread – so it does not only help database log writes but…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 11 Comments
…alignment, not different MySQL configurations, I didn’t try out different MySQL versions or settings… 1 thread, 4 or 8 threads. Different file sizes made no difference too. Write-back cache…only have two graphs to show you. First one is with RAID controller set to WT cache: The second is with WB cache…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
… compression there is only 2.5GB of data, so ICE gets over 16:1 compression ratio(compared to Innodb, 8:1 compared to…-cache skip-name-resolve sort-buffer-size=512K sql-mode=STRICT_TRANS_TABLES symbolic-links table-definition-cache=16384 table-open-cache=128 thread-cache-size=32 thread-stack=256K tmp-table-size=64M transaction-isolation=READ-COMMITTED user=mysql wait…
Post: MySQL Server Memory Usage
May 17, 2006 By 18 Comments
…to 10% of theoretical memory consumptions others only to 1%. So what could you do instead …threads. Each thread connecting to MySQL server will needs its own buffers. About 256K is allocated at once even if thread…. There can be mutiple key caches. Multiple key caches can be created to accomodate …
