…in it was only recently found and fixed: http://bugs.mysql.com/bug.php?id=29560 Concerning a switch to Oracle’s main database…of table online. Q38: Seems that adaptive hash indexes are not used for primary key lookups or not showed up in…
Post: Shard-Query adds parallelism to queries
November 15, 2010 By 18 Comments
…number of concurrent queries which each examine large amounts of data. Since a single query is single threaded in MySQL…in this blog post. Many database servers can add this parallelism natively, but most of those are not open source. In…
Post: Commodity Hardware, Commodity Software and Commodity People
June 15, 2007 By 9 Comments
…Number of vendors would claim they are in…table while server is running and it would typically work. Even if table is corrupted MySQL…database” interfaces which run on top of MySQL or other databases…
Post: Handling big result sets
June 26, 2006 By 13 Comments
…table: < ?php $link = mysql_connect(‘localhost’, ‘root’, ”) or die(‘Could not connect: ‘ . mysql_error()); mysql_select_db(‘test’) or die(‘Could not select database…mysql_unbuffered_query instead of mysql_query. execution time: 54.34 s Good improvement. The identical results we can get…Number of…
