(Sergey Petrunia) A customer issue has drawn my attention to this this pecularity: if partitioning is done by the value of some function, then partition pruning module will make use of comparisons of the partitioning column(s), but not of comparisons of the value of the partitioning function.
Tag: Open Source
MySQL – to use or not to use
(Peter Zaitsev) Reading this slashdot article today and two CIO magazine articles linked from it.
MySQL Logon trigger
(Oli Sennhauser) With MySQL 5.0 the database provides trigger functionality on INSERT, REPLACE, UPDATE and DELETE. (pdf)
Working with PHP and MySQL
(Michele Davis and Jon Phillips) Last week, you began learning how to use PHP to display and modify data from a MySQL database. This week, you’ll learn how to select the database, fetch and display data, and more.
How to write MySQL conditional comments
(Xaprb) MySQL’s version-specific conditional comment syntax confused me for the longest time. Then I learned about printf formatting rules, and it all became clear. Read on if you don’t already know what I mean.
Magic Innodb Recovery self healing
(Peter Zaitsev) We have certain type of the table corrupting with Innodb, as it is limited to only one particular index on one particular table type it is likely to be Innodb bug but Heikki currently could not find what could be causing it.
Debunking GROUP BY myths
(Roland Bouman) There is a popular myth about the SQL GROUP BY clause. The myth holds that ‘standard SQL’ requires columns referenced in the SELECT list of a query to also appear in the GROUP BY clause, unless these columns appear exclusively in an aggregated expression. MySQL is often accused of vi
MySQL System Architecture
(Mike Kruckenberg and Jay Pipes) In this article, we’re going to take a look at MySQL internals. It will be a fun, informative examination of how all the different pieces and parts of the MySQL server operate together. MySQL’s implementation is a fascinating mix of technology that is truly a remarka
Aggregating SHOW STATUS Output
(Mark Leith) When I first joined MySQL one of the things that was evident was the Support Engineers spent quite some time with customers issues that were focused on performance tuning. Performance tuning issues generally start with a engineer requesting a bunch of information from the customer such
Getting PHP to Talk to MySQL
(Michele Davis and Jon Phillips) In this first part of a three-part series. you will begin learning how to use PHP to display and modify data from a MySQL database.