June 19, 2013

Post: Percona Monitoring Plugins 1.0.3 for MySQL now available

April 23, 2013 By 4 Comments

…, plugins, and scripts. Changelog: * MySQL 5.6 compatibility for InnoDB graphs (bug 1124292) * Added performance data to Nagios plugins (…granularity to pmp-check-mysql-deadlocks (bug 1154774) * Added package install/update instructions and other documentation updates (bugs 1139652, 1124200, …

Filed Under: Events and Announcements, Percona Software Tagged With:

Post: MySQL alternative Percona Server 5.1.68 -14.6 now available

April 19, 2013 By 3 Comments

… in CentOS 6.3 during installation. Bugs fixed #1031427 and #1051874. When mysqldump was used with –innodb-optimize-keys option it produced… creation optimization. Bug fixed #1081016. When mysqldump was used with –innodb-optimize-keys and –no-data options, all secondary key definitions… innotop and its InnoDBParser Perl package from source and Debian installation. Bug fixed #1032139. Percona Server was missing help texts in…

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

Comment: Implications of Metadata Locking Changes in MySQL 5.5

March 27, 2013 By 9 Comments

…. If you can enable the InnoDB plugin on your 5.1 installation instead of using the built-in InnoDB, then you can further… ALTER in your test case is waiting on InnoDB row locks by setting innodb_lock_wait_timeout to 1 and then issuing…=3 for update; — session 2 set innodb_lock_wait_timeout=1; alter table t1 engine=innodb; And the alter will timeout after…

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

Comment: Open Source, the MySQL market (and TokuDB in particular)

May 10, 2013 By 13 Comments

… viral nature of open source. If you can get 10million installations and just 1 out of the thousand pays you, you… all. If the total market for software is 10.000 installations you will unlikely get viral effect to the same extent… might have not been enough as the advantages compared to Innodb are relatively subtle – you need specific workloads to see the…

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

Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released

March 25, 2013 By 2 Comments

… are configurable. Also, we removed –lock-wait-timeout which set innodb_lock_wait_timeout because that now conflicts, or is at… by default. If the IO::Socket::SSL Perl module is installed (easily available through your package manager), it will use a…

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

Post: Updated msl (microslow) patch, installation walk-through!

April 20, 2008 By 17 Comments

… let me walk you through the installation and configuration because things changed along the way. Installation In order to use the patch… with InnoDB extensions msl patch for MySQL 5.0.51a with InnoDB extensions msl patch for MySQL 5.0.54a with InnoDB extensions msl patch for MySQL 5.0.56 with InnoDB extensions…

Filed Under: Percona Software Tagged With:

Post: What to tune in MySQL Server after installation

September 29, 2006 By 118 Comments

… is very important variable to tune if you’re using Innodb tables. Innodb tables are much more sensitive to buffer size compared… up to 70-80% of memory often make sense for Innodb only installations. Same rules as for key_buffer apply – if you… are typically enough. Smaller installations should use smaller values. innodb_flush_log_at_trx_commit Crying about Innodb being 100 times slower than…

Filed Under: Insight for DBAs Tagged With:

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

February 26, 2013 By 1 Comment

… between MyISAM FTS and InnoDB FTS over the same data sets, and then finally in the third installment, we’ll look at… to performance in the third installment. For now, the important number here is to note that the InnoDB buffer pool for my… global innodb_ft_aux_table=’test/dir_test_innodb‘; mysql> set global innodb_optimize_fulltext_only=1; mysql> select * from information_schema.innodb_ft…

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

Post: Percona XtraDB Cluster - installation and setup webinar follow up Q&A

October 28, 2012 By 4 Comments

… local virtualbox instance, and I tried to show the minimal installation required for XtraDB cluster. Unfortunately enough, I didn’t include… independent from each other. Q: I installed Percona as cluster database working with Zabbix (innodb), do you have a recommended configuration? A… don’t have any specific recommandations for Zabbix, but general InnoDB tuning recommendations apply here, in large zabbix deployments, you may…

Filed Under: MySQL, XtraDB Cluster

Post: InnoDB in self-compiled MySQL 5.1

September 13, 2007 By 9 Comments

… –prefix=/dir/to/mysql make make install and then, for example, load the dump of InnoDB from previous version: mysql testdatabase < dump... | NO | +------------+---------+-----------------------------------------------------------+--------------+----+------------+ 4 rows in set (0.00 sec) By default InnoDB is not compiled as storage engines. Perhaps it is related… –with-plugins=innodb make make install But what I would want to see is BIG Warning or even Error that InnoDB table can…

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