… mention this contest Tweet “My favorite #MySQL conference session” with a link to your favorite “Like” your favorite conference session with Facebook +1 your favorite conference session via Google Plus To Tweet, “like…
Post: Announcing Percona XtraBackup 1.9.1
February 27, 2012 By 9 Comments
… release. We do not recommend using Beta releases in production. Link to BETA version and Release notes. If you are looking…. The xbstream utility is added This utility has a tar like interface to the xbstream format.
Post: MySQL Configuration Wizard Updated
January 26, 2012 By 5 Comments
… logged in. It’s kind of like sending someone a link to a pastebin or something like that. Screenshot: Another new feature is… sanity/safety options to prevent common problems MySQL users run into because of too-permissive MySQL behaviors. These are the kinds of… that Drizzle fixes — and should be fixed by default in MySQL — but never will be because they might break applications that…
Post: MySQL Limitations Part 4: One thread per connection
October 27, 2010 By 14 Comments
…’s seriously limiting MySQL in core use cases (links: part 1, 2, 3). This post is about the way MySQL handles connections, allocating one thread per connection to the server. MySQL… thread scheduling, and potentially memory usage as well. I feel like I’m forgetting some reasons that this matters — please fill…
Post: What's the recommended MySQL version?
August 15, 2011 By 24 Comments
… as “Which version of MySQL is currently recommended?” I’ll respond here and then post a link in the forum as a… isn’t in production yet. The reason is that I like to keep the upgrade cycle as long as possible, and…, and now I’d even say use MySQL 5.6. For older applications running MySQL 5.0, I’d say upgrade to…
Post: Multiple purge threads in Percona Server 5.1.56 and MySQL 5.6.2
May 3, 2011 By 13 Comments
…to not to penalize further TPS. MySQL 5.6.2 Results Now let’s test MySQL 5.6.2. It is …2 multiple purge thread support is very experimental and is likely to receive a lot of tuning in the future. …here has been found by Dimitri Kravtchuk before, and the linked post suggests a fix: in 5.6.2 the …
Post: Actively monitoring replication connectivity with MySQL's heartbeat
December 29, 2011 By 1 Comment
… a value you can define. If the network link goes down or the latency goes up for … time and the number of beats received. mysql_slave > SHOW STATUS LIKE ‘%heartbeat%’; +—————————+——-+ | Variable_name | Value | +—————————+——-+ | Slave_heartbeat_period …
Post: Sphinx: Going Beyond full text search
July 23, 2007 By 18 Comments
….mysql.com/download/” and “dev.mysql.com/download/mysql-5.1.html” we could not use link=const where clause but had to use link like “prefix%” which means index could not be used to get 20 last links and filesort over millions of links we… to use index past link_date part, it is true so we had to use link_date in () and link like “prefix%” which allows…
Post: Pretty-formatted index fragmentation with xtrabackup
March 15, 2011 By 4 Comments
… useful to examine whether you’d benefit from “defragmenting” your MySQL database with OPTIMIZE TABLE, although I have not determined firm… output looks like this: TABLE INDEX TOT_PAGES FREE_PAGES PCT_FULL art.link_out104 832383 38561 86.8% art.link_out104 PRIMARY 498304 49 91.9% art.link_out104 domain_id…
Post: Talking MySQL to Sphinx
April 19, 2009 By 4 Comments
….9.9-rc2 there is a support for MySQL wire protocol and SphinxQL – SQL-like language to query Sphinx indexes. This support… | 2735703 | 139448919 | 2735703 | +————+——–+———-+———–+———+ 10 rows in set (32.47 sec) MySQL mysql> select max(forum_id) as m,author_id as a…_links=1; Empty set (2.70 sec) MySQL mysql> select max(author_id) as a ,forum_id as f from sptest where num_links…
