June 20, 2013

Comment: MySQL alternative Percona Server 5.1.68 -14.6 now available

May 28, 2013 By 3 Comments

Hi, I can’t find any 5.1 files in the yum repos. Have they been moved to a new location (for example, I’m checking repo.percona.com/centos/5/os/x86_64/ )? The apt repo seems to be okay though. Thanks!

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

Comment: ZFS on Linux and MySQL

May 27, 2013 By 17 Comments

… checksums. d) What compression algo does ZfsOnLinux use? Is gzip-1 by default? btrfs supports LZO etc. too I believe. e…

Filed Under: Hardware and Storage, Insight for DBAs, MySQL Tagged With: , , , ,

Comment: Percona Server for MySQL 5.5.30-30.2 now available

May 24, 2013 By 10 Comments

after upgrade ssl replication doesn’t work anymore: ERROR 2026 (HY000): SSL connection error: error:00000001:lib(0):func(0):reason(1) same certificates worked fine with 5.5.30, OpenSSL 1.0.0

Filed Under: MySQL

Comment: Sphinx search performance optimization: multi-threaded search

May 24, 2013 By 10 Comments

How would you merge the indexes after this? I assume you would want to get 1 index. So, I can run the indexer for idx1p0, idx1p1, idx1p2 but how would I then get the idx1 index? If I try to run indexer for idx1, I get “skipping non-plain index ‘idx1′… ” Thanks, Rob

Filed Under: MySQL Tagged With: , , ,

Post: ZFS on Linux and MySQL

May 24, 2013 By 17 Comments

… raid controller write cache use.  Even the fairly slow gzip-1 mode works well.  The tpcc database, which contains a lot… doesn’t compress well showed a compression ration of 1.70 with gzip-1.  Real data will compress much more.  That gives…, the storage will still be working.  Also, instead of having 1 or 2 spare drives per controller, I have 2 for…

Filed Under: Hardware and Storage, Insight for DBAs, MySQL Tagged With: , , , ,

Post: Experiences with the McAfee MySQL Audit Plugin

May 23, 2013 By 4 Comments

… on a previous post in our blog. Starting with 5.1, the new plugin API gives us more flexibility by allowing… I was using for the test (5.5.28-29.1). This is needed as the plugin needs the offset to…_offsets=6464, 6512, 4072, 4512, 104, 2584 audit_json_file=1 audit_json_socket_name=/tmp/audit.sock #audit_json_socket…

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

Comment: How to calculate a good InnoDB log file size

May 22, 2013 By 38 Comments

… sequence && ls -l /var/lib/mysql/ib_logfile* -rw-rw—- 1 mysql mysql 536870912 May 22 13:33 /var/lib/mysql/ib_logfile0 -rw-rw—- 1 mysql mysql 536870912 May 22 12:55 /var/lib/mysql…:35:00 CDT 2013 Log sequence number 18343465682 -rw-rw—- 1 mysql mysql 536870912 May 22 13:35 /var/lib/mysql…

Filed Under: Insight for DBAs Tagged With: ,

Comment: Percona XtraBackup 2.1.2 for MySQL available for download

May 22, 2013 By 4 Comments

…/1182698 Percona seems to be working on another release 2.1.3, for the moment it’s strongly advised IMO to…

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

Comment: Percona XtraBackup 2.1.2 for MySQL available for download

May 22, 2013 By 4 Comments

…, Sorry but there is a bug in the 2.1.1 and 2.1.2 version (see http://www.percona.com/forums/questions…

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

Comment: How to calculate a good InnoDB log file size

May 21, 2013 By 38 Comments

… sequence && ls -l /var/lib/mysql/ib_logfile* -rw-rw—- 1 mysql mysql 536870912 May 21 22:23 /var/lib/mysql/ib_logfile0 -rw-rw—- 1 mysql mysql 536870912 May 21 22:23 /var/lib/mysql…:24:15 CDT 2013 Log sequence number 17750981011 -rw-rw—- 1 mysql mysql 536870912 May 21 22:24 /var/lib/mysql…

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