June 19, 2013

Post: More on MySQL transaction descriptors optimization

… the third one features even higher QPI speed (and thus, faster inter-process/node communication). Results: First of all, we used a… –max-requests=0 –percentile=99 –mysql-user=root –mysql-db=sbtest8t1M –mysql-table-engine=INNODB –mysql-socket=/tmp/mysql.sock –oltp-point-selects=1 –oltp…

Post: Testing MySQL column stores

… 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 ?

… 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

…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

… 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 – MySQLcommunity fork” was surely the biggest splash on the conference around MySQL. Monty’s Maria storage engine…

Post: MySQL Users Conference - Innodb

… 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

…. 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…

Post: InnoDB Full-text Search in MySQL 5.6 (part 1)

…, keep in mind that I used the community editions of MySQL 5.5.30 and MySQL 5.6.10 with no tuning whatsoever….ibd -rw-rw—-. 1 mysql mysql 98304 Feb 20 16:09 FTS_00000000000000ad_STOPWORDS.ibd -rw-rw—-. 1 mysql mysql 98304 Feb 20 15…. At the very bottom, the page claims that you can speed up bulk loading into an InnoDB FT index by declaring…

Post: The Optimization That (Often) Isn't: Index Merge Intersection

… with columns that had single-column indexes on them, MySQL could sometimes make use of the multiple indexes. For…might not see right away. Disabling this setting might speed up this query (it did), but it might also…, to be sure). As they say in the Perl community, there’s more than one way to do it….

Comment: Should you move from MyISAM to Innodb ?

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…