June 18, 2013

Comment: Where to get recent MySQL version ?

January 3, 2007 By 86 Comments

…. 2. MySQL Enterprise Server is released more frequently than MySQL Community Server. 3. MySQL Community Server gets all bug fixes from MySQL Enterprise Server… need to improve the release frequency of source tarballs from the Community Tree. (iii) We know we need to improve the speed by which we apply community patches to our Community Tree. Kaj Arnö VP Community Relations MySQL AB

Filed Under: Insight for DBAs Tagged With:

Post: Percona Server 5.1.59-13.0

October 16, 2011 By Leave a Comment

… replication environment, the process can be speed up by having prefetch threads to warm…. #851674 (Alexey Kopytov). Backported fix for MySQL bug #53761 (Wrong estimate for RANGE … Other Changes Improvements and fixes on general distribution: #858467, #845019, (Alexey Kopytov). Improvements and fixes …

Filed Under: MySQL, Percona Software

Post: Percona Server 5.5.16-22.0

October 16, 2011 By 2 Comments

… from the Percona Software Repositories). Based on MySQL 5.5.16, including all the bug …in a replication environment, the process can be speed up by having prefetch threads to warm the…702376, #795747 (Alexey Kopytov, Ignacio Nin, Yasufumi Kinoshita). Improvements and fixes on the Percona Server Test …

Filed Under: MySQL

Post: InnoDB Full-text Search in MySQL 5.6 (part 1)

February 26, 2013 By 1 Comment

….ibd -rw-rw—-. 1 mysql mysql 98304 Feb 20 16:09 FTS_00000000000000ad_STOPWORDS.ibd -rw-rw—-. 1 mysql mysql 98304 Feb 20 15….ibd -rw-rw—-. 1 mysql mysql 98304 Feb 20 15:54 FTS_0000000000000114_STOPWORDS.ibd -rw-rw—-. 1 mysql mysql 8618 Feb 20 16… one, which discusses improving bulk insert performance. At the very bottom, the page claims that you can speed up bulk loading into…

Filed Under: Insight for DBAs, Insight for Developers, 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

… 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…

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

Post: MySQL 4 to MySQL 5 Upgrade performance regressions

June 6, 2007 By 8 Comments

… with MySQL 4 also because 100% durable transactions are not required anyway and it would allow to get some extra speed. It… should stay on MySQL 4.1 until MySQL has taken it away from you as already happened with MySQL 4.0. MySQL 5.0 can offer substantial performance improvements in…

Filed Under: Insight for DBAs Tagged With: ,

Post: SHOW INNODB STATUS walk through

July 17, 2006 By 40 Comments

… INNODB STATUS output and how to use this info to improve MySQL Performance. To start with basics SHOW INNODB STATUS is command… id 1148250464, thread declared inside InnoDB 442 mysql tables in use 1, locked 0 MySQL thread id 8079, query id 728899 localhost… index is hash index Innodb builds for some pages to speed up row lookup replacing btree search with hash search. This…

Filed Under: Insight for DBAs Tagged With:

Post: Percona XtraBackup 1.5-Beta

December 13, 2010 By 6 Comments

… (Yasufumi Kinoshita) XtraBackup can now be built from the MySQL 5.1.52, MySQL 5.5.7, or Percona Server 5.1… now compiled with the -O3 gcc option, which may improve backup speed in stream mode in some cases. It is now possible… – xtrabackup has been updated to build from the MySQL 5.1.52, MySQL 5.5.7, or Percona Server 5.1.53…

Filed Under: MySQL, Percona Software Tagged With: , , , , ,

Post: New SpecJAppServer results at MySQL and Sun.

November 12, 2008 By Leave a Comment

…better to disable them. The MySQL Settings are probably what is the most interesting: MySQL 5.0 Tuning in /etc…is rarely used so I’m curious how much speed benefit did it really provide in this case. …Tom Daly and his team in further benchmark results improvements. I guess we’ll see more of these to…

Filed Under: Benchmarks

Post: Database problems in MySQL/PHP Applications

August 11, 2006 By 13 Comments

… not expect it to beat MySQLi in speed. It is however bad idea to use mysql_ functions directly as well – I would… as much more queries per page which will make performance improvement much smaller. Notable exception being AJAX applications which may do… by people with traditional database background. Things are different with MySQL. There are many successful applications, using tens of thousands of…

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