… in MySQL 5.1.7 but was found to be dangerous and was removed in MySQL 5.1.23.” For me term ‘dangerous‘ is interesting there , as I’d expect really dangerous is… the RENAME DATABASE db1 TO db2 statement. So it seems MySQL took an interesting practice to get GA released as soon…
Comment: Why you don't want to shard.
August 6, 2009 By 33 Comments
… not necessarily a bad thing. Mysql is complex. that doesnt make it bad. The real danger of implementing sharding is bad design… a problem. If your entire development team is on the mysql command line making live schema changes, yes, you’re going to… terms of sharding solutions that you could implement at the mysql or storage engine level, but they’re a bit to…
Post: PHP Large result sets and summary tables.
July 6, 2007 By 8 Comments
… on table with 1000 rows may well give you very dangerous false sense of security. One of the process web site… of swap space) like crazy. Why ? Because by default mysql_query uses mysql_store_result C library call and buffers all result… others purely SQL commands and it can be much more efficient. Another alternative is of course to use MySQL Stored Procedures which…
