(BarrySolomon) Currently, MySQL only provides very basic read functionality, ExtractValue(). This only returns a concatenated string of node values without a delimiter and has no capability to return the actual child node tree of the target node; Therefore, I created several UDFs for reading Xml f

(tsmonaghan) This comes up in discussions almost every new project I work on, because it’s a very important thing to consider when designing a database.

(kedar.nitty-witty) The LOAD DATA INFILE statement reads rows from a text file into a table at a very high speed. The file name must be given as a literal string.

(Rob Gravelle) When generating a result set where the query contains an unknown number of column and/or row values we can use a combination of Prepared Statements, which allows us to tailor the output based on the number of data values. We can also add input parameters to a procedure to assign the f

(Johan Andersson) At the UC 2010 I will have a session on MySQL Cluster Performance Tuning. This session will address a lot of the most common performance problems I see in my day to day job with Cluster. A small excerpt of the talk is below here and many other things will be addressed in the sessio

(Ronald Bradford) Using ROLLBACK with MyISAM is useless. A ROLLBACK command is used to undo any DML that occurs during a transaction (i.e. START TRANSACTION and COMMIT). The MySQL default storage engine MyISAM does not support transactions.

(Mark Callaghan) Using the configuration described elsewhere I ran a modified version of sysbench to compare PBXT, InnoDB and MyISAM using two update intensive workloads on a CPU-bound server. The workloads are simple but reproduce a bottleneck that is intermittent on some of our MySQL servers. Each

(Anders Karlsson) The Audit API has more uses that you may think! When a statement is executed in the server, the notification function in this API will be called, and we can use that do some interesting things!

(Peter Zaitsev) In XtraDB we have the table INNODB_BUFFER_POOL_PAGES_INDEX which shows which pages belong to which indexes in which tables. Using thing information and standard TABLES table we can see how well different tables fit in buffer pool.

(Rob Gravelle) MySQL Reporting requirements sometimes require both unknown column and row values, necessitating a more powerful means of generating crosstabs. Today’s article presents Prepared Statements, which dynamically generate the SQL and assign it to a variable so that we can tailor the output