June 18, 2013

Comment: Where to get recent MySQL version ?

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

Post: Percona Server 5.1.59-13.0

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

Post: Percona Server 5.5.16-22.0

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

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

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

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

… 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: MySQL 4 to MySQL 5 Upgrade performance regressions

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

Post: SHOW INNODB STATUS walk through

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

Post: Percona XtraBackup 1.5-Beta

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

Post: New SpecJAppServer results at MySQL and Sun.

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

Post: Database problems in MySQL/PHP Applications

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