…in software RAID 10. Now let’s come to the MySQL configuration. MySQL Configuration I used Percona Server 5.5… ## Disabling query cache query_cache_size = 0 query_cache_type = 0 You can see that the buffer… when you are concerned with write performance is using partitioning to reduce the size of the B…
Post: Scaling problems still exist in MySQL 5.5 and Percona Server 5.5
May 20, 2011 By 11 Comments
MySQL 5.5 and Percona Server 5.5 do…SELECT * FROM table WHERE deleted = 0 AND group_id IN (62715996, 62716592, 62717660, 62717716, … workload in Percona Server 5.5 showing up to 2.5 times better performance or 150… in this workload and innodb_adaptive_hash_index_partitions=16 available for partitioning…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
…can change the lifecycle of your application in advance. What about partitioning in MySQL 5.1? I know there … work by either using MySQL 5.1′s row-based replication, or in MySQL 5.0 and earlier, doing the…schemas. The problem is that MySQL doesn’t tend to perform well on a data warehousing …
Post: MySQL 5.5.8 and Percona Server on Fast Flash card (Virident tachIOn)
December 21, 2010 By 11 Comments
…in_group=2) innodb_flush_neighbor_pages=0 innodb_adaptive_checkpoint=keep_average innodb_read_ahead=none For MySQL 5.5…partitions, InnoDB datafiles on the Virident tachIOn 400G card The raw results, config, and script are in…if you are looking for high MySQL performance, and we tune Percona Server to…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 11 Comments
… extents were placed in this case). When I have mounted the partition with inode64 option however, the effect disappeared and performance without LVM… running on a Percona Server 5.0.92-87 with the following my.cnf configuration: [mysqld] datadir=/data/mysql socket=/var/run/mysqld…
Post: Using any general purpose computer as a special purpose SIMD computer
May 16, 2011 By 6 Comments
… because in a set, you can perform operations on…the frequency of words 5) order by the …0 Warnings: 0 Here is the serial version as run by the native database interface (MySQL): mysql…partition elimination expression. Here is the output from the parallel version: — SQL TO SEND TO SHARDS: Array ( [0…
Post: MariaDB 5.3.4 benchmarks
February 18, 2012 By 22 Comments
… 1 to 256 Versions: MariaDB 5.3.4, MySQL 5.5.20 Data is stored on RAID10 HDD partition Like in all my recent benchmarks, I… MariaDB 5.3.4 MySQL 5.5.20 Ratio 1 252 271 0.9298893 2 412 588 0.7006803 4 801 1097 0.7301732 8 1709 2205 0… 0.8980876 I was surprised to see that MariaDB shows 20-30% worse throughput. It seems many changes resulted to performance hit in…
Post: Percona Server 5.5.8 Beta Release
February 16, 2011 By 16 Comments
…MySQL 5.5.8 server. Here are some highlights: Performance…partitioning, stored procedures More diagnostics and tunability More pluggability, including pluggable authentication In addition to building on MySQL 5.5…
Post: Hijacking Innodb Foreign Keys
January 2, 2012 By 2 Comments
…them not working for partitioned tables as well as making foreign keys performed row by …MySQL 5.1 (Innodb Plugin) dropping foreign keys which should only require meta data change needs a table rebuild. In…=InnoDB DEFAULT CHARSET=latin1 1 row in set (0.00 sec) mysql> create table parentx(i int) engine…
Post: Is disk Everything for MySQL Performance ?
April 25, 2008 By 7 Comments
…in. Many Web 2.0 sites in particular design for having everything they need in…can comfortably put in MySQL Instance without getting in too much …5% of total data set in memory while over may require full 100%. Performance gains graphs in relation to fit in… files on the same partition as well because …
