June 19, 2013

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 not solve all scalability problems even for read only … CPUs giving 24 real cores. The workload was completely in memory in this test. I have compared Percona Server 5.1.56-12… Percona Server 5.1 and around 6 for Percona Server 5.5 which is way too little for what you would expect from 24 core…

Filed Under: MySQL

Post: Announcing Percona Server 5.5.19-24.0

January 13, 2012 By 4 Comments

… Server 5.5.19-24.0 on January 13th, 2012 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.5.19, including all the bug fixes in it, Percona Server 5.5.19-24.0 is now the current stable release in the 5.5… new value cont. The previously-available option values 0 and 1 now have more descriptive names none and area. The value…

Filed Under: MySQL

Post: MySQL and plugin binaries

April 20, 2008 By 5 Comments

… MySQL. I suppose it should be changed, otherwise there will be total madness with versions – InnoDB 1.0.0 binary for MySQL 5.1.23, 5.1.24, …, InnoDB 1.0.1 binary for MySQL 5.1.23, 5.1.24, 5.1.25… etc. Even when that…

Filed Under: Insight for DBAs Tagged With: ,

Post: InnoDB Full-text Search in MySQL 5.6: Part 2, The Queries!

March 4, 2013 By 7 Comments

…MySQL 5.6: Part 2, The Queries![/caption] This is part 2 in a 3 part series. In part 1…California Free Public Records, Criminal Records And Background Checks | 24.224336624145508 | +—–+————————————————————————–+——————–+ OK, now I’m …

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , ,

Post: MySQL 6.0 vs 5.1 in TPC-H queries

March 25, 2008 By 17 Comments

…TPC-H benchmarks, particularly comparing MySQL 6.0.4-alpha with 5.1. MySQL 6.0 is interesting…+ 0.01 AND l_quantity < 24; with execution plain (in 5.1) +—-+————-+———-+——-+—————+—————+———+——+———+————-+ | id | select_type | table | type | …

Filed Under: Benchmarks Tagged With:

Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark

March 11, 2013 By 7 Comments

… tested three configurations: Config 1: Default config for MySQL 5.5 and MySQL 5.6, no tuning at all Config 2: MySQL 5.6 with all default settings… – Scale Factor 1 – Mysql 5.5 vs 5.6 response times are in seconds (lower is better) Version Buffer Cold Run1 Run2 Run3 5.5.30 128M… (innodb_old_blocks_time=0) 128M 349.24 178.80 178.55 179.07 5.5.30 4G 200.87 20.53 20…

Filed Under: MySQL Tagged With: , , , , ,

Post: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact

March 12, 2012 By 12 Comments

… preparation for the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. We are taking a look at and benchmarking… Index Condition Pushdown (ICP). Its available in both MySQL 5.6 and MariaDB 5.5 Now let’s take a look briefly at what… WHERE condition defined as: l_partkey = x and l_quantity >= 1 and l_quantity = 1 and l_quantity

Filed Under: Benchmarks, Insight for DBAs, MySQL Tagged With: , , , , , , ,

Post: Announcing Percona Server 5.5.25a-27.1

July 21, 2012 By Leave a Comment

… Server 5.5.25a-27.1 on July 21st, 2012 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.5.25a, including all the bug fixes in it, Percona Server 5.5.25a-27.1 is now the current stable release in the 5.5… with ssl connections count in statistics tables in Percona Server 5.5.24-26.0. Bug fixed #1008278 (Vladislav Lesin). PAM authentication plugin…

Filed Under: MySQL

Post: Is there room for more MySQL IO Optimization?

January 3, 2013 By 11 Comments

… cached — system files, binary log, FRM files, MySQL MyISAM system tables etc. Starting MySQL 5.5 MySQL uses asynchronous IO which should allow it to…-31 16:24:54 Update_time: NULL Check_time: NULL Collation: utf8_general_ci Checksum: NULL Create_options: Comment: 1 row in… Read_Ahead which is not available in MySQL 5.5 (different version is added back in MySQL 5.6) so I tried that as well…

Filed Under: Insight for DBAs, MySQL Tagged With: , ,

Comment: MySQL and plugin binaries

April 21, 2008 By 5 Comments

… have SE Interface version which is same for Major MySQL version – say 5.1 6.0 etc. But with the way things are… process. Innodb should have working with MySQL to ensure their plugin at least builts with MySQL 5.1.24 (I’m not speaking about binary… be established – Community is to provide their storage engine to MySQL so it can be built ant minimally tested with new…

Filed Under: Insight for DBAs Tagged With: ,
« Older Posts
Newer Posts »