…database related forums, mailing lists or blogs you probably heard complains about MySQL being unable to handle more than 1.000.000 (or…better than others. For example if you have star join with dimention tables being small…
Post: Recovery beyond data restore
August 2, 2008 By 11 Comments
…have many trashed copies to deal with. If you have just one or several small tables corrupted you can reload them. One option is to…large portion of data trashed you may need to recover full database on all slaves which is best done in binary mode for large…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
…better-ness in the meantime, you might have to do some awkward backpedaling with customers, who now expect realtime data. The database…One reason denormalization is important is that nested-loop joins on large data sets are very expensive. If MySQL supported sort-merge or…
Post: Database problems in MySQL/PHP Applications
August 11, 2006 By 12 Comments
…to have very simple logic besides database – in most cases you would have… ALTER TABLE or OPTIMIZE TABLE now locks small table…have all these problems with loosing data etc. Read more in my Why MySQL Could be slow with Large…MySQL you might be better of using several queries than doing complicated ones…
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
…database ? Or does it mean MySQL did not scale well to…have queries which only do small sorts it is indeed better to have…one. So the it was better to restrict amount of dirty pages Innodb can have to get better performance. It probably was done to…
Post: MySQL Query Cache
July 27, 2006 By 69 Comments
…to implement. Might not work with transactions – Different transactions may see different states of the database, depending on the updates they have…have change their result set but MySQL has no way to identify which one…or timeout based invalidation which can offer much better…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…mysql.com/bug.php?id=29560 Concerning a switch to Oracle’s main database, I believe different applications work best on different database…to get large data manageable. MySQL Master Master Manager can help you to automate it a bit. I also like to keep tables small enough, “sharding” to…
Comment: Database problems in MySQL/PHP Applications
August 11, 2006 By 12 Comments
…to have very simple logic > besides database – in most cases you would have…or OPTIMIZE TABLE > now locks small…MySQL you might be > better of using several queries than doing complicated ones…
Post: Cache Performance Comparison
August 9, 2006 By 73 Comments
…to access same data read from database multiple times. Examining MySQL full query logs from many applications seeing several…to performance of all in memory caches and so you might be better…have just one web server or your data set is small…
Post: FaceBook Search, Search for social networks
August 12, 2007 By 4 Comments
…to be indexed available for index process. With Sphinx which talks directly to the MySQL database…to know exact number if it is large – small numbers are however need to be exact to be able to…or something else which gives me best profiles) I would likely get much better…
