Just finished migrating my website from SQLite to MySQL. What a rush. (lol) It was actually not as bad as I thought. A lot of sed, grep and other sorcery involved; especially in transforming of SQLite statements to MySQL. Some quick...
I recently revisited a project from some time ago that I found and modified the code to support PHP7 which dropped support for mysql extension in favor of mysqli....
A typical installation of Debian 8.x (Jessie) precedes this where I only select base system and ssh server options during operating system installation. After installation, this is a typical configuration to get me up and running. These are my...
Here’s a simple way to determine the date/time a database was created in MySQL: SELECT create_time FROM INFORMATION_SCHEMA.TABLES WHERE table_schema = 'DB_NAME' mysql> select create_time from information_schema.tables where table_schema='foo'; +---------------------+ | create_time | +---------------------+ | 2013-03-01 10:42:34 |...
I was working with a mail archive MySQL database today and was twiddling my thumbs waiting for simple queries to complete. The database has about 12 million rows and is on a 2x2GHz 2GB Linux Server x64. I wanted to try...
Came across a few useful websites with miscellaneous MySQL performance/configuration analysis/testing tools. http://www.day32.com/MySQL/ http://hackmysql.com/mysqlsla http://www.maatkit.org/doc/ http://blog.mysqltuner.com/...
This is my setup of LEMP with Cacti 0.8.7i. LEMP stands for Linux nginx (prounounced Engine x) MySQL and PHP. Most notably, LEMP is just replacing Apache (LAMP) with nginx. My base linux distribution is Debian 6 AMD64. Software Required: Debian...
I’m sure you’ve seen results similar to this on a standard query: Now, if you use the \G option (Send command to mysql server, display result vertically.): That makes reading the output from command line really nice. One more tidbit that...