System administrators constantly worry about optimization with code compilation. This is no different for MySQL. Most systems are fine with the binaries distributed by their flavor of Linux or directly from Oracle. But there are many who need to maximize their hardware usage by pushing their software. I intend to show how to tweak your MySQL compilation to achieve these results.
Read More ...Posts Tagged ‘mysql’
Will Fitch
Jul 9
|22:55
Moving from a procedural system to object-oriented can be a daunting task. One feature to assist you is the MySQLi class, which allows for an object-oriented approach to database manipulation. This tutorial gives insight into the structure and basic usage of the MySQLi class. If PDO isn’t an option for you, then try MySQLi!
Read More ...
Will Fitch
Jul 5
|18:48
Navicat MySQL is a tool produced by PremiumSoft CyberTech Ltd that allows both developers and DBAs to access, design, manipulate, report and manage data and the MySQL server. Although it’s not free, it is certainly worth taking the time to play around with. Navicate MySQL is certainly the tool of choice for my DBA needs. [...]
Read More ...
Will Fitch
Mar 28
|19:55
This tutorial will cover using the mysqldump executable for backing up databases. If you are an average user of MySQL, and are not interested in administering a MySQL server, then this tutorial might be useless to you. The mysqldump tool is a backup program that is distributed with every MySQL download. If you aren’t familiar [...]
Read More ...