Many in the MySQL community are snobbish about using MyISAM (not using it that is) … get the benefits of MyISAM which includes consistently faster query speeds, tables which are easily maintained, is more easily tuned and…
Post: Testing MySQL column stores
August 16, 2010 By 15 Comments
… first focused on core functionality and compatibility of ICE (Infobright Community Edition) compared with MyISAM on a small data set. The… with InfiniDB Community Edition on a 950GB data set. The first first part of my analysis focused on testing specific MySQL functionally… the two databases, including: Ease of installation Loading capability and speed of loading Accuracy of results of queries over the large…
Comment: Where to get recent MySQL version ?
January 3, 2007 By 86 Comments
… than MySQL Community Server. 3. MySQL Community Server gets all bug fixes from MySQL Enterprise Server. 4. The higher release frequency of MySQL Enterprise …We know we need to improve the speed by which we apply community patches to our Community Tree. Kaj Arnö VP Community Relations MySQL AB
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…are, both in terms of size and spindle speed. I need to know how many physical …mysql –user=mysql –pid-file=/var/run/mysqld/mysqld.pid –skip-external-locking –port=3306 –socket=/var/db/mysql/mysql…small adjustments to the direction we’re going, communicate to the client how much time we’re …
Post: Report from OSCON 2008
July 27, 2008 By 7 Comments
… sacrificing speed or flexibility. The MySQL presence on this conference was also very interesting. There was a SUN booth with quite limited MySQL… came somewhat outside – the Drizzle – MySQL “community fork” was surely the biggest splash on the conference around MySQL. Monty’s Maria storage engine…
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
… to be much larger than table itself) The index build speed is however not only reason I can’t wait for… in MySQL 5.2 or even MySQL 5.1. I surely would like to see it sooner at least in more flexible community… because they target at least MySQL 5.1 with row level replication readily available. Speaking about community items the following were most…
Post: Making the impossible: 3 nodes intercontinental replication
January 11, 2012 By 25 Comments
…. Well, you theoretically could create 3 node traditional MySQL ring replication, but this is not what you…need to open ports in the firewall. For the communication the nodes need, by default, 4444, 4567, 4568 …the physic law, you cannot go faster than speed of light, and the round trip between Europe…
Comment: MySQL Quality of old and new features
October 5, 2007 By 24 Comments
… my opinion people who pay money for mySQL should be given piece of mind that mySQL itself will not cause data-corruption…! To feel confident that mySQL will not cause corruption is to release the fixes and use the community as the testing ground… Community (like fix the Optimizer, Grammer Parser, etc). People will pay for Enterprise if they want the speed and support, while the community…
Post: How much overhead DRDB could cause ?
June 2, 2008 By 4 Comments
…file system and configuration) more synchronous IO operations – MySQL binary logs are not preallocated as Innodb…overhead can vary a lot depending on the speed of the disk subsystem and network. If… you should be looking at low latency network communications. It would be actually rather interesting to…
Comment: New MySQL Community Release Policies published
August 9, 2007 By 9 Comments
… the above article. Here are my criticisms. First of all, Community version will continue, but with some changes. Second, microsecond resolution… do agree partially with what you wrote on the speed with which MySQL accepts patches. But, believe it or not, new procedures…. In that way a paying customer gets more then community user. But community still gets a free software, which is also VERY…
