…00 sec) As you can see FLUSH TABLES WITH READ LOCK is waiting for that very nasty “…you use backup solution which does FLUSH TABLES WITH READ LOCK which is very unfortunate. As the real solution I‘d love…server gridlock one way or another. If you‘re just using Innodb tables and you‘re not actively …
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…
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…
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…
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…
Comment: Time for Zero Administration effort at MySQL ?
January 9, 2012 By 4 Comments
… really not the best way of solving the problem: you‘d love to be able to change the setting dynamically, even if that is at the expense of… be affected by the configuration change. Another thing that I have come across a few times is memory management. Mysqld assumes you have enough…
Post: MySQL Limitations Part 4: One thread per connection
October 27, 2010 By 14 Comments
… the case. However, many development environments and programming languages really want a connection pool. They’re just built that way (I‘m looking at you… open, you get 5000 threads in the server. That increases the overhead from thread scheduling, and potentially memory usage as well. I feel like I‘m…, NotABug. I‘m thinking of the lack of sort-merge joins or intra-query parallelism, for example. It would be lovely to have…
Post: Can MySQL temporary tables be made safe for statement-based replication?
May 26, 2008 By 8 Comments
… love their temporary tables and will ask hopefully “are you sure this isn’t safe?” They’ll propose all sorts of ways to… the person pointed out, that isn’t true with CREATE TEMPORARY TABLE. I tested this (sometimes the manual is wrong!) and found that indeed, you can… in the binlog as I typed into the console. If you replay the binary log, you‘ll get two transactions here. This shows us something interesting that…
Comment: Big Iron for tests anyone ?
March 21, 2008 By 10 Comments
…I also hope is that I get to play with the PA RISC stuff before it gets shuffled off back to HP. That looks highly unlikely at the moment, but if I can I‘d love to test all of the…I have a feeling the servers will be shuffled back to HP way before I…
Post: BoardReader - Forum Search Engine
November 29, 2006 By 12 Comments
…application. I guess you know what LAMP is and S Stands for Sphinx – Full Text Search Engine which we love … domains still get way too many links and we’ll likely redesign it in the future to use …about in week. You can click on the bar in the graph to get search results focused on that period. Can …
