June 20, 2013

Post: Is your MySQL buffer pool warm? Make it sweat!

April 16, 2013 By 6 Comments

…, our standard MySQL database configuration follows this active/passive …set long_query_time to 0 in order to log every…plugin thread-pool –thread-pool-threads-count 100 –session-init-query \”set innodb_fake_changes=1\” > /var/log/playback.log 2>&1…warmed up with chunk 3. The result is similar …

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

Post: 5.0.87-build20 Percona binaries

November 18, 2009 By 3 Comments

… build is based on MySQL-5.0.87 innodb_rw_lock.patch is ported from InnoDB Plugin 1.0.3 To be compatible with RedHat RPM repository….com/mysql/5.0.87-b20/ There is Debian packages repository is also available. See release page for configuration and usage guideance…-dev group. For support, commercial and sponsorship inquiries contact Percona. innodb_rw_lock.patch

Filed Under: MySQL, Percona Software Tagged With:

Comment: Great work Innodb Team

December 1, 2009 By 8 Comments

… configuration default value changes in early 5.4.x releases, so skip directly to the most recent of these, 5.4.3: http://dev.mysql.com/doc/refman/5.4/en/news-5-4-3.html Upcoming MySQL 5.5.0 also has InnoDB Plugin as the built-in InnoDB, and it will have InnoDB Plugin 1.0.5. (5.4.x has 1.0…

Filed Under: Events and Announcements Tagged With:

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

March 4, 2013 By 7 Comments

…a 3 part series. In part 1, we took a quick look at some initial configuration of InnoDB…1 | | 1 | Harold Wesley Abbott Iii | 0 | | 3 | William Doyle Abbott Jr | 0 | | 5 | Robert Jack Abraham | 0 | | 7 | Mark Allen Abrell | 0 …code, convert it to a plugin, and use it for InnoDB FT indexes where you’re…

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

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

March 11, 2013 By 7 Comments

…innodb_old_blocks_time immediately came to mind.  The InnoDB plugin introduced innodb…

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

Post: Percona XtraDB Cluster reference architecture with HaProxy

June 20, 2012 By 63 Comments

…Plugin ‘FEDERATED’ is disabled. 120619 13:21:17 InnoDB: The InnoDB memory heap is disabled 120619 13:21:17 InnoDB…| wsrep_cluster_size | 3 | +——————–+——-+ 1 row in set (0…configured in the /etc/haproxy/haproxy.cfg and it should look like this. global log 127.0.0.1 local0 log 127.0.0.1…

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

Post: Paul McCullagh answers your questions about PBXT

November 20, 2009 By 2 Comments

…1.5. Morgan notes: As well as Adaptive Checkpointing, Oracle has also been working on Adaptive Flushing for the InnoDB Plugin…A recent version of PBXT (1.0.09) supports the MySQL… to this list are 3 things that make developing … performance problems in particular configurations. This is not necessarily…

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

Post: InnoDB in self-compiled MySQL 5.1

September 13, 2007 By 9 Comments

…plugins=innodb (or max, or max-no-ndb, which includes set of more engines) ./configure —prefix=/dir/to/mysql –with-plugins=innodb…

Filed Under: Insight for DBAs Tagged With: ,

Post: Percona Server 5.1.52-12.3

December 13, 2010 By 2 Comments

…Server 5.1.52-12.3 is now based on MySQL 5.1.52. New Features Added: HandlerSocket plugin …innodb_extra_undoslots option is disabled but it was enabled before” was sometimes reported after upgrading from MySQL 5.0…_gettime() is present in librt at the configure stage. If yes, -lrt is added to LIBS….

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

Post: MySQL 5.6.7-RC in tpcc-mysql benchmark

October 8, 2012 By 22 Comments

…configuration: [mysqld] gdb innodb_file_per_table = true innodb_data_file_path = ibdata1:100M:autoextend innodb_flush_method = O_DIRECT innodb_log_buffer_size = 256M innodb…

Filed Under: Benchmarks, MySQL