October 21, 2006
MySQLprovides some tools to monitor and troubleshoot a MySQL server, but they don’t always suit a MySQL developer or administrator’s common needs, or may not work in some scenarios, such as remote or over-the-web monitoring. Fortunately, the MySQL community has created a variety of free tools to fill the gaps. On the other hand, many [...]
October 12, 2006
“MySQL is a rock solid, lighting fast database server which has been designed for two factors speed and performance. It is the Ferrari of databases: Light weight, fast and Built for the high speed tracks!I still hear an awful lot of stories from owners whose databases are running two slow.”
This article goes over some basic [...]
August 23, 2006
So you might notice “abstraction layer” in quotes, well, simply put, it’s the big term for using a middle-man with MySQL data. Any form of data for that matter. It just makes your life easier. After using MySQL with PHP the procedural way I decided to try it the PHP object oriented [...]
June 23, 2006
MySQL doesn’t allow referring to a table that’s targeted for update in a FROM clause, which can be frustrating. There’s a better way than creating endless temporary tables, though. This article explains how to update a table while selecting from it in a subquery.