(Mark Schoonover) I read Baron’s blog about this challenge on how to limit rows accessed, not rows returned with a query. He had another requirement, no subqueries, so it would work on pre MySQL 4.x. At first, I started down the same path he did, looking for a way to limit the number of rows accesse

(Arjen Lentz) I’ll say beforehand that the following is not very clean – for a number of reasons. I’ll discuss some issues after the query. The query returns all indexes in a db where the cardinality is lower than 30% of the rows, thus making it unlikely that the server will ever use that index.

(Johan Andersson) With ndb_restore it is actually possible (talking MySQL Cluster 6.2 and 6.3 here, haven’t looked at 5.0 for a long time) to restore a single table into a CSV file that can be loaded using LOAD DATA INFILE.

(Julie C. Meloni) In this chapter, youll learn the design process behind a simple discussion forum. This includes developing the database tables and user input forms, and displaying the results. When broken into pieces like this, such a task seems simpleand it is! The ultimate goal is to understand

(Baron Schwartz) How many of you use the mysql command-line client? And did you know about the pager command you can give it? It’s pretty useful. It tells mysql to pipe the output of your commands through the specified program before displaying it to you.

(Daniel Fischer) Since you’re reading this, you probably know that Sun is switching to the Bazaar version control system for all development work on the MySQL server. Unlike the version control system that we’ve been using previously, Bazaar is an open source project and freely available to anyone.

(Sheeri Cabral) I was asked today about the ANSI_QUOTES SQL mode. According to http://dev.mysql.com/doc/refman/5.0/en/server-sql-mode.html, ANSI_QUOTES mode changes the functionality of double quotes () to be like the backtick (`). Normally the functionality of double quotes is more like that of

(Alex Tomic) I stumbled upon an interesting article discussing the different Linux I/O schedulers that are available in the 2.6 kernel, and also discussing some of the deficiencies of the 2.4 Linus elevator I/O scheduler.

(Keith Murphy) Recently, a customer wondered if they should start using the innodb_file_per_table option, or if they should continue to use the large InnoDB tablespace files created by the innodb_data_file_path option in the my.cnf option file.

(Johan Andersson) I got a few questions about how to configure the cluster for disk data.