… version 5.0 straight to 5.5. This means 6 years since GA release date – quite respected. The cases when you see old MySQL versions… adequate for MySQL ? Oracle seems to have extended support for MySQL versions rather significantly with Extended support going 8 years after release date. This does not seems to apply to MySQL 5.0 though…
Post: MySQL 5.1 went to GA. Was it a good move ?
December 10, 2008 By 4 Comments
MySQL 5.1 release as “GA” seems to be the most controversial to date. It had very negative response from Monty, original MySQL Founder… has anything to do with MySQL 5.1 stability. I know people who are happy with MySQL 6.0 and Falcon stability for months now – it works for their workload. So what is Quality Guidelines for Release (GA…
Post: Shard-Query turbo charges Infobright community edition (ICE)
May 6, 2011 By 22 Comments
… of a single commodity database server with 6 cores (+6ht) and 24GB of memory was selected…[default] user=mysql db=ontime password= port=5029 column=date_id mapper=hash gearman=127.0.0.1:7000 inlist=* … You can get Shard-Query (currently in development release form as a checkout from SVN) here: …
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…off with these commands: date uname -a cat /etc/*release The first command is…mysql –user=mysql –pid-file=/var/run/mysqld/mysqld.pid –skip-external-locking –port=3306 –socket=/var/db/mysql/mysql.sock consult 28852 26909 0… the connection properly). This is happening 6 times every ten seconds. We …
Post: Faster Point In Time Recovery with LVM2 Snaphots and Binary Logs
February 23, 2012 By Leave a Comment
… and CentOS 5.7 includes packages with this feature, previous releases might also include them via supplemental repositories i.e. … 0 Warnings: 0 mysql> update employees set age = ((YEAR(CURDATE())-YEAR(birth_date)) – (RIGHT(CURDATE(),5)
Post: Backing up binary log files with mysqlbinlog
January 18, 2012 By 2 Comments
… them up. Recently in MySQL 5.6, mysqlbinlog got a new feature addition that supports connecting to remote MySQL instances and dumping binary… -v orig|tail -n 1` TIMESTAMP=`date +%s` FILESIZE=$(stat -c%s “$LASTFILE”) if [ $FILESIZE -gt 0 ]; then echo “Backing up last…” mode. Please note MySQL 5.6 is not yet released as GA but you can use mysqlbinlog to backup MySQL 5.1 and 5…
Comment: Full text search for all MySQL Storage Engines
June 29, 2006 By 37 Comments
…: Darn, what are the odds that mysql will use sphinx as its native fulltext index … release info on the site) was released just 2-3 days ago. My previous observations are based on 0…. 6.60 read_hits: 2.16 ————— 10 most common words along with only -l 200 –sort=date (sorting by date …
Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 8, 2007 By 117 Comments
…(64) NOT NULL default ”, `dob` date default NULL, `address` varchar(128)…5) unsigned NOT NULL default ‘0‘, PRIMARY KEY (`id`), UNIQUE KEY …MySQL 5.1.14-falcon bitkeeper tree bk://mysql.bkbits.net/mysql-5.1-falcon for Falcon (Please note this is a first release… than MyISAM by 6-9%. Falcon shows …
Post: Statistics of InnoDB tables and indexes available in xtrabackup
September 14, 2009 By 6 Comments
…date NOT NULL, `mod_is` tinyint(3) unsigned NOT NULL default ‘0‘, `is_adult` tinyint(3) unsigned NOT NULL default ‘0…_domain, space id: 12, root page 6 estimated statistics in dictionary: key vals:…released quite soon. And the last point of the post – if you are badly missing some features in MySQL…
Post: Great work Innodb Team
November 30, 2009 By 8 Comments
…of great performance improvements and 1.0.5/1.0.6 gets even further with long … documentation now seems to be merged with MySQL Documentation which makes it much more usable…0.5 is named Release Candidate which hopefully means it will be considered ready for general use – almost 2 years from the date…
