June 19, 2013

Post: How Percona does a MySQL Performance Audit

November 24, 2008 By 17 Comments

…. For example, if I see a lot of queries in odd statuses, like “statistics”, I know something weird is going on… be changed. Queries can be broken into pieces, combined, or even eliminated entirely (we may suggest caching, or tell the customer… server, so it’s often worth another iteration, and sometimes even more after that. A really thorough audit can take up…

Filed Under: Insight for Developers Tagged With:

Post: Percona XtraDB Cluster - installation and setup webinar follow up Q&A

October 28, 2012 By 4 Comments

… recommended configuration. The number of nodes/data centers should be odd, so you can always decide which part is in majority… can achieve a high throughput despite the response time limitations. Even with parallel replication, the response time limits the number of… this process it you are using the xtrabackup SST method. Even if you are using an SST method which is blocking…

Filed Under: MySQL, XtraDB Cluster

Post: InnoDB Full-text Search in MySQL 5.6: Part 2, The Queries!

March 4, 2013 By 7 Comments

… | 925781 | Anthony James Petersen | 38.03296661376953 | +——–+————————–+——————–+ These results aren’t even close to identical. As it turns out, the full…and we were looking for queries containing the word “MySQL” – odds are that an article which has 10 instances of …

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , ,

Post: Can't Create Thread: Errno 11 (A Tale of Two Ulimits)

February 4, 2013 By 10 Comments

… you may have made to /etc/security/limits.conf! So even if you’ve properly adjusted /etc/security/limits.conf and… adjusting nproc/nofile limits in /etc/security/limits.conf or even this new 90-nproc.conf file is that these files… MySQL comes out and we need to do an upgrade. Odds are that we’re not going to reboot the whole…

Filed Under: Insight for DBAs, MySQL Tagged With: , ,

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

February 26, 2013 By 1 Comment

… = 1 in /etc/my.cnf), but I think it’s even worse that the case-sensitivity only matters some of the… one FULLTEXT index creation at a time That’s an odd limitation. Do it as two separate ALTER statements, and it… work fine. But here’s where things start to get even weirder. According to the documentation, if we specify the name…

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , ,

Post: Percona XtraDB Cluster: Failure Scenarios with only 2 nodes

July 25, 2012 By 6 Comments

… goal of having more than 2 nodes, in fact an odd number is recommended in that kind of clusters, is to… several slaves it still remains operational. Use with extreme caution even in master-slave setups, because slaves won’t automatically reconnect…. – pc.ignore_sb : Should we allow nodes to process updates even in the case of split brain? This is a dangerous…

Filed Under: MySQL, XtraDB Cluster

Post: When is MIN(DATE) != MIN(DATE) ?

September 4, 2012 By 5 Comments

… guarantee.’ It turned out that an application had submitted the odd datetime, and because the value passed the date-format check… guarantee that something will work”, just don’t risk it. Even if a piece of data matches the expected format, that… 5.5.25a, but in my case, the behavior was even stranger. I created a table with a similar structure: CREATE…

Filed Under: Insight for DBAs, Insight for Developers, MySQL

Post: Is VoltDB really as scalable as they claim?

February 28, 2011 By 3 Comments

… designed to be very fast (hundreds of thousands of TPS) even on low-end machines, by doing away with the usual… because of the lack of cross-node communication. What’s odd is that the k-factor of 0 reaches its peak… these are not high-end servers, and VoltDB should provide even higher performance on faster machines. I did not audit or…

Filed Under: Benchmarks, MySQL

Comment: Friday challange: linking with GPL code

May 10, 2009 By 20 Comments

LD_PRELOAD seems to be a bit odd, since then you distribute the launcher script which does that, … it’s not pre-load linking, at compile time, or even by that LD_PRELOAD thing, and it’s…

Filed Under: Events and Announcements Tagged With:

Post: Using Multiple Key Caches for MyISAM Scalability

November 26, 2008 By 8 Comments

… in MySQL 4.1, and indeed previously it did not even scale with one CPU as global lock was held during… multiple key caches for the same table, for example caching even/odd key blocks or something similar, or actually just keep hash…

Filed Under: Insight for DBAs Tagged With:
« Older Posts