… the lvconvert binary. Base installs of Ubuntu 11.04 (Natty) and CentOS 5.7 includes packages …on CentOS. If you are using InnoDB, it is also important that your transaction logs (ib_logfile*) are on…(0.49 sec) mysql> alter table employees add column age smallint unsigned not null default 0; Query OK…
Post: Faster Point In Time Recovery with LVM2 Snaphots and Binary Logs
February 23, 2012 By Leave a Comment
Post: Percona welcomes Drizzle 7.1
April 10, 2012 By Leave a Comment
… to syslog is enabled by default Updated DEB and RPM packages …protocol plugin, authentication from a file, MySQL UNIX socket protocol, javascript plugin, …install from the PPA are in the Drizzle manual. CentOS 6 packages are available from download.drizzle.org. Instructions on how to install…
Post: Which Linux distribution for a MySQL database server? A specific point of view.
December 8, 2011 By 37 Comments
…MYSQL, upgrade MySQL, 10x start/stop MySQL, upgrade MySQL, downgrade MySQL, upgrade MySQL, install a security fix for something, 20x start/stop MySQL, upgrade MySQL, … . Restarting and changing MySQL…MySQL. By default…
Comment: Which Linux distribution for a MySQL database server? A specific point of view.
December 10, 2011 By 37 Comments
…’ve used MySQL on Debian/Ubuntu, CentOS/RHEL/OEL, Solaris and on Windows. On Windows: There is no OS version of MySQL. And the MySQL Installer makes installing and… be any puppet packages available. On Debian/Ubuntu: MySQL 5.5 landed in Debian expirimental, and the default MySQL version has been 5.1…
Comment: Which Linux distribution for a MySQL database server? A specific point of view.
December 9, 2011 By 37 Comments
… considerably worse. Distrowatch suggests many are deserting CentOS in favour of Mint. Current deploys of …contain sensible defaults, so you generally can’t rely on anything actually working once it’s installed. You … cited on this very blog as the FS of choice for MySQL), and it’s a pain to install…
Post: FlashCache: tpcc workload
May 25, 2010 By 18 Comments
…CentOS team reads this post – please change default IO scheduler from CFQ to Deadline. Seriously, it makes so much damage on performance on servers with IO intensive workloads, so it should be the first action after CentOS installation…
Comment: Why MySQL could be slow with large tables ?
November 14, 2008 By 139 Comments
…/lib/mysql socket = /var/lib/mysql/mysql.sock user=mysql # Default to using old password format for compatibility with mysql 3.x… installed, but when I change mysql vars and restart server, my configs are not applied, defautl mysql…with Apache 2.2. Mysql ver. 5.0.45 via socket on x86_64 centos 5.2, …
