June 17, 2013

Post: Open Source, the MySQL market (and TokuDB in particular)

May 10, 2013 By 13 Comments

…, and the Open Source model is something different. Now let me state that I am not an Open Source fanatic and I totally accept different models. Open Source should be considered as a way of… above. I expect that some vendors tend to love “vendor lock-in,” and it also helps your bottom line if you are the one and…

Filed Under: MySQL Tagged With: , , , , , , ,

Comment: Is Synchronous Replication right for your app?

May 14, 2013 By 18 Comments

… of love on Semi-sync in general, though if you guys come up with a patch I‘m sure it could make its way into Percona Server. :) @Peter: Yes, you are right, I am talking about commits. I‘m not sure how useful it is to update the… there is an assumption that Locks are held on the source node before global ordering is established. Certainly if you were single node…

Filed Under: MySQL, Percona Software, XtraDB Cluster Tagged With: , , , , , ,

Comment: SimCity outages, traffic control and Thread Pool for MySQL

March 21, 2013 By 16 Comments

…Ronald, thanks for the detail. I read the posts you linked but would love to know more about how/why the thread pool is only now being integrated as it is. I… the DB server. This was effectively a SQL proxy but it offered an easy way to handle connection pooling and throttling so that…

Filed Under: MySQL Tagged With: , , , ,

Post: How Percona does a MySQL Performance Audit

November 24, 2008 By 17 Comments

… talk about that. That‘s not because I want to keep secrets from you. To the contrary, I‘d love to share it all with you. But that‘s… this way, I work through the status and the variables, and explain to the client what I can deduce about the server from them. I would point out that I…

Filed Under: Insight for Developers Tagged With:

Post: Here's a quick way to Foresee if Replication Slave is ever going to catch up and When!

August 29, 2012 By 11 Comments

… slave that is severely behind, you probably noticed that it’s not catching up with a busy master at a steady pace. Instead, the… are few reasons catching up is so unstable: If you have restarted the server, or started a new one, caches are cold…. I didn’t like my own answer to The question, so I decided to do something about it. And because I love awk, I did that something…

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

Post: What attendees are saying about Percona Live NYC ?

September 19, 2012 By Leave a Comment

…the fifth Percona Live event that I have attended, with each one being better than the last. Next month in New York, I…you there!” Sean Hull, Senior MySQL EC2 & Scalability Lead have written while essay on the topic: “What I loved…. I promise you this, these talks won’t be salesy or in any way a …

Filed Under: Events and Announcements, MySQL

Post: Should you have your swap file enabled while running MySQL ?

April 6, 2008 By 31 Comments

… the question of you must do it this or that way but rather understanding advantages of both approaches. I also would like to hear what you do yourself, and why :) The rationale… both of the configurations – if you keep swap enabled you may have hard time keeping MySQL in memory because Kernel would love to swap…

Filed Under: Insight for DBAs Tagged With: ,

Post: MySQL-Memcached or NOSQL Tokyo Tyrant - part 1

October 15, 2009 By 16 Comments

… ) outside the DB.  Think memcached. Almost everyone loves memcached,…way to get more scalability out of your database? Is the database even the best place for this data? I…you‘re thinking my simple key lookup should really benefit from memcached. So let’s try it! I took the simple app I created that…

Filed Under: Benchmarks, Cloud and NoSQL, MySQL Tagged With: , ,

Post: InnoDB Flushing: a lot of memory and slow disk

March 31, 2011 By 57 Comments

…you can see, after the initial warmup, throughput drops constantly, all the way to zero, and may stay in that…But I call that tuning by shooting yourself in the left foot. (You…that hard disks love sequential operations, and your throughput in this case may turn out significantly worse. So what is the…

Filed Under: Benchmarks, Hardware and Storage, Insight for DBAs, MySQL

Post: Sphinx search performance optimization: multi-threaded search

January 16, 2013 By 10 Comments

… here. Sphinx has the ability to do distributed search out of the box – it was designed to scale out that way very early on. If your sphinx index does not fit to one machine, you… line I always loved how Sphinx scales out easily with as many machines you need and have been running it this way for many…

Filed Under: MySQL Tagged With: , , ,
« Older Posts