(Baron Schwartz) How smart is the MySQL optimizer? If it sees an expression repeated many times, does it realize they’re all the same and not calculate the result for each of them?
Tag: Open Source
Encrypting Replicated Data
(Robert Hodges) Open source projects have a great way of pulling in original ideas. Take encrypting replicated SQL: it’s a big deal when you are are not sure about network security. This problem comes up very quickly when you transmit data over WAN links or in shared/cloud environments.
Some partition movement tricks with MySQL 5.1
(Alex Tomic) I have been using partitioning in MySQL 5.1 since it has been in late beta, and with the odd bump I’ve been quite satisfied with its stability and ease of use. Perhaps the days of maintaining nasty application logic to maintain tables like table_yyyymm manually are finally over!
MySQL security: data integrity issues
(Shlomi Noach) MySQL’s security model is not as elaborate as other popular databases. It’s missing quite a lot.
InnoDB Table and Tablespace Monitors
(Mark Leith) InnoDB allows you to dump information on its internal data dictionary out to stderr, by creating specific InnoDB monitor tables. Specifically the innodb_table_monitor and innodb_tablespace_monitor tables. This is covered to a limited extent in the MySQL Reference Manual at http://dev.my
Profiling MySQL stored routines
(Aurimas Mikalauskas) These days I’m working with a customer who has an application based entirely on stored routines on MySQL side. Even though I haven’t worked much with stored procedures, I though it’s going to be a piece of cake. In the end – it was, but there’s a catch.
MySQL’s TO_DAYS function
(Peter Gulutzan) I’ll try to clear up possible confusion about dates and MySQL’s TO_DAYS() function. TO_DAYS() works, correctly. TO_DAYS() assumes a year 0, correctly. There are indeed bugs, but only if you use MySQL extensions with partitions.
MySQL Back to Basics: Lesser-known MySQL client scripts
(Nicklas Westerlund) So there’s a whole bunch of MySQL scripts included with any release, who can say they know them all? In this blog post, we will take a look at some of these and show usage examples that may help you in your environment.
Setting, Changing And Resetting MySQL Root Passwords
(SamTzu) This tutorial explains how you can set, change and reset (if you’ve forgotten the password) MySQL root passwords. Time and again I see problems like mysqladmin: connect to server at ‘localhost’ failed error: ‘Access denied for user ‘root’@’localhost’ (using password: YES)’. So I thought it
MySQL Proxy is back
(Giuseppe Maxia) MySQL Proxy is back. After a long hiatus due to many deadlines in the Proxy team, the GPL version of MySQL Proxy has been updated.