…WHERE a.parent=” . $parent); echo “”; while ($row = mysql_fetch_assoc($result)) { if ($row['Count'] > 0) { echo “” . $row['label'] . “”; display_menu($row['id'], $level + 1); echo “”; } elseif ($row['Count']==0) { echo “” . $row['label'] . “”; } else…
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
… about MySQL buffer pools or anything else that’s on your mind! There are numerous solutions for MySQL high availability. Many rely on MySQL’s asynchronous replication to maintain a warm standby server which is flipped into service if… the same chunk again. We expected everything to be cached if we warmed the cache with the exact same data. All…
Post: Understanding the maximum number of columns in a MySQL table
April 8, 2013 By 5 Comments
… do I discuss the FRM file? If we look at the MAX_FIELDS define in MySQL, we’ll see that it’s… bugs with small static rows in MySQL */ reclength=max(file->min_record_length(table_options),reclength); if (info_length+(ulong) create_fields…. Unless you have many columns, and then it’s something else (as in that case you don’t get your 80×24…
Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released
March 25, 2013 By 2 Comments
… there are certain versions of MySQL that have critical bugs. Version check will warn you about these if your system is running… the web, else it will use a standard (http) connection. pt-stalk and pt-mysql-summary have built-in MySQL options No more… make their run-related options (–run-time, –interval, –iterations) standard. If you hadn’t noticed, one tool would run forever by…
Comment: Open Source, the MySQL market (and TokuDB in particular)
May 10, 2013 By 13 Comments
…. I choose MySQL, then I go write my app to use MySQL. Later I may want to move to something else, Postgres perhaps… suppliers of MySQL but it’s still MySQL, even if it’s some fork like Maria DB (???) that’s still basically MySQL. You have the constraints of that platform and if…
Comment: Repair MySQL 5.6 GTID replication by injecting empty transactions
March 27, 2013 By 1 Comment
…) What is going on with the mysql 5.5 / 5.6 changelogs on MySQL.com. Anyone else noticed how extremely quiet they have… released what they believe to be an almost bug-free MySQL release… or they are taking bug fixing / development behind closed… on Percona asking what’s going on, or answering it [if anyone at Percona knows someone at Oracle who knows]
Post: CVE-2012-4414 strikes back in MySQL 5.5.29 (and what we're doing in Percona Server 5.5.29)
January 13, 2013 By 4 Comments
… bug is very important, it means that anyone can verify if their MySQL server is vulnerable, after all, many people run their… a waste of Oracle time and money rather than anybody else‘s. However, in this instance, even though they didn’t… your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘`) SET…
Post: Which Linux distribution for a MySQL database server? A specific point of view.
December 8, 2011 By 38 Comments
… Linux distribution I would use for a MySQL database server. Bearing the responsibility for someone else‘s success means I should advise… performance improvements, however these days it is rarely important to MySQL users. If it is to you, then you probably did your… installing or uninstalling anything else. Imagine that someone left system in such shape, you prepared for downtime, stopped MySQL and… error – text…
Post: MySQL Indexing Best Practices: Webinar Questions Followup
August 16, 2012 By 4 Comments
…? A: The question in this case is how MySQL will execute the join. If it will fist lookup Table2 using some other… primary key. You should pick something else if you have a good reason to do it – if you would benefit from data clustering… more details. Q: how mysql use index for group by? A: If you have Index on the column MySQL can avoid temporary table…
Post: Announcing Percona Live MySQL Conference and Expo 2012
August 9, 2011 By 11 Comments
… all know that the entire MySQL community has been waiting to see if there will be a MySQL conference next year in the traditional date and location. To the best of our knowledge, no one else was…” is crucial here — the O’Reilly MySQL conference has occupied the crossroads of open-source, MySQL, community, and business. Emphasis on business…
