… available in mysql-5.0.92 src.rpm file will fail at two hunks against mysql-5.0.77. On vanilla mysql-5.0.92 it applies…
Comment: How to calculate a good InnoDB log file size
June 1, 2010 By 38 Comments
… be created InnoDB: Setting log file ./ib_logfile0 size to 5 MB InnoDB: Database physically writes the file full: wait… 100601… be created InnoDB: Setting log file ./ib_logfile1 size to 5 MB InnoDB: Database physically writes the file full: wait… InnoDB…: Started; log sequence number 0 0 100601 9:08:30 [Note] /usr/libexec/mysqld: ready for connections. Version: ‘5.0.77‘ socket: ‘/var/lib/mysql…
Comment: Multi-Column IN clause - Unexpected MySQL Issue
October 7, 2009 By 21 Comments
I have a similar issue with the in clause (5.0.77). It seems that if there are more than 2 items …_id | 4 | NULL | 137 | Using where | +—-+————-+———-+——-+—————+—————+———+——+——+————-+ 1 row in set (0.00 sec) mysql> explain select * from projects where project_phase…
Comment: Which Linux distribution for a MySQL database server? A specific point of view.
December 10, 2011 By 38 Comments
… to install. CentOS 5 ships with MySQL 5.0.77 which is really old. The 6.x releases ship with MySQL 5.1 which is… old if you want to start something new. The MySQL 5.5 packages from Oracle are good, but a YUM repository is… to be any puppet packages available. On Debian/Ubuntu: MySQL 5.5 landed in Debian expirimental, and the default MySQL version has…
Comment: Percona XtraBackup 1.4
January 21, 2011 By 10 Comments
…: innobackupex-1.5.1: Using mysql Ver 14.12 Distrib 5.0.77, for redhat-linux-gnu (i686) using readline 5.1 innobackupex-1.5.1…: /usr/bin/xtrabackup_51: cannot execute binary file innobackupex-1.5.1: fatal error: no ‘mysqld’ group in MySQL options innobackupex-1.5.1: fatal error: OR no ‘datadir’ option in group ‘mysqld…
Comment: Slow Query Log analyzes tools
January 5, 2012 By 84 Comments
Which version of MySQL-Server is best and more efficient for Master-Master and Master-Slave Replication. Present I’m using 5.0.77-log.
Comment: Optimizing slow web pages with mk-query-digest
April 12, 2011 By 14 Comments
…. We would need it separately, yes — we are running MySQL 5.0.77, not Percona Server. Our server hosts won’t support Percona…
Comment: Optimizing slow web pages with mk-query-digest
April 11, 2011 By 14 Comments
You mention the sow log query patch which allows for logging in microseconds, but I can only find a version of that from 2006. We are running MySQL 5.0.77 — do you have a version of the patch that’s compatible with that, and can you link me to it if so?
Comment: Optimizing slow web pages with mk-query-digest
April 7, 2011 By 14 Comments
…. We would need it separately, yes — we are running MySQL 5.0.77, not Percona Server. Our server hosts won’t support Percona…
Comment: Optimizing slow web pages with mk-query-digest
April 7, 2011 By 14 Comments
You mention the sow log query patch which allows for logging in microseconds, but I can only find a version of that from 2006. We are running MySQL 5.0.77 — do you have a version of the patch that’s compatible with that, and can you link me to it if so?
