… quite late). I am using MySQL (5.6.4) on that now. Being bleeding edge, building MySQL it could use latest components like… filesystem utilities etc. So I would recommend anything but debian (Sorry debianers: many packages are from time of dinosaurs unless you mean…
Comment: Which Linux distribution for a MySQL database server? A specific point of view.
December 13, 2011 By 38 Comments
Post: xtrabackup-0.9.5rc
October 24, 2009 By 13 Comments
… of backup XtraBackup is ported for InnoDB Plugin 1.0.4. Barracuda file format as well as compressed tables are supported…,5, Debian, FreeBSD, MacOS as well as source code of the XtraBackup is available on http://www.percona.com/mysql/xtrabackup/0.9.5rc/. The Debian package is also available via APT. Just…
Comment: MySQL Query Cache WhiteSpace and comments
June 5, 2009 By 9 Comments
… ~400k rows. After restarting Mysql, to delete the cache, this is the result. Mysql : 5.0.51a-24 (Debian) PHP : 5.2.6…(*) FROM `mytable` WHERE `myfield` LIKE “%c%” 0.84706401825 seconds /* comment 4 */ SELECT count(*) FROM `mytable` WHERE `myfield` LIKE “%c%” 0.83235502243…(*) FROM `mytable` WHERE `myfield` LIKE “%c%” 0.000951051712036 seconds /* comment 4 */ SELECT count(*) FROM `mytable` WHERE `myfield` LIKE “%c%” 0.000913858413696…
Comment: How much memory can MySQL use in the worst case?
February 13, 2009 By 17 Comments
… when we were running under 4.0. I reported this issue around 5.0.27 to mysql, and they indeed find one… 20926208 Buffer pool size 458752 … Which mean per your formula: mysql> select 8751883484 – (458752*16384) – 20926208; +—————————————-+ | 8751883484 – (458752*16384) – 20926208 | +—————————————-+ | 1214764508…’d say, I’m in the process of building a debian package out of the latest release). I tried everything I…
Comment: How to change innodb_log_file_size safely
May 2, 2012 By 17 Comments
… works on my site on a Debian Squeeze system where I have to edit: /etc/mysql/my.cnf Also make sure that…, which does not 100% accurately reflect log file size x 4 factor. But I can change that options at any time… 64M or more (but e.g instead of 32M x 4 = 128M innodb_buffer_pool_size). According to my previous posts…
Comment: Percona Toolkit 2.1 with New Online Schema Change Tool
April 22, 2012 By 10 Comments
…) with a Percona type version of MySQL – ie one of Percona’s “improved” versions of MySQL (that is what Percona does, isn… help and information. I just made the MySQL, apache2 and php updates available to Debian Squeeze avalable on DotDeb.org, and I… updates made to INNOdb tables really slowed down mySQL as measured by qps, in the last 4-6 months? Best regards, Eddie
Post: XtraDB storage engine release 1.0.6-9
January 13, 2010 By 9 Comments
…://bugs.mysql.com/47621 more reasonable The builds for RedHat 4, 5 , Debian and Ubuntu are located on http://www.percona.com/mysql/xtradb… repo the upgrade becomes as easy as yum update MySQL-server-percona MySQL-client-percona The latest source code of XtraDB, including… bugs found on Bugs in Percona XtraDB Storage Engine for MySQL. For general questions use our Pecona-discussions group, and for…
Post: XtraDB storage engine release 1.0.3-7
August 17, 2009 By 6 Comments
… might know Innobase has released 1.0.4. The release includes following new features: MySQL 5.1.37 as a base release…://bugs.mysql.com/bug.php?id=45749 and http://bugs.mysql.com/bug.php?id=42101 The builds for RedHat4,5 and Debian are located on http://www.percona.com/mysql/xtradb…
Post: New patches, new builds
September 5, 2008 By 24 Comments
…| Percona | GPL | Ported from Debian | | microslow_innodb.patch | … microseconds granularity. mysql> SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST; +—-+——+———–+——+———+——+———–+———————————————-+———+ | ID … for RedHat 4/5, binary tar….
Post: Percona Playback 0.3 development release
July 10, 2012 By 15 Comments
…captured either in a MySQL slow query log or a tcpdump capture of the MySQL protocol exchange … gettext libpcap-dev libcloog-ppl (if using gcc 4.6) libmysqlclient-dev libdrizzle-dev pkg-config … 10.04LTS (lucid), Ubuntu 12.04 (precise) and Debian 6. You can build using the standard: ./configure && …
