3 methods to tweak your MySQL database result pages

Most people use PHP and MySQL together and there are several reasons to do so: It’s easy, fast and powerful! If you create a MySQL database result, the data is not formatted and looks ugly. The following functions or code examples will help you to create better looking MySQL database result pages.

Continue reading 3 methods to tweak your MySQL database result pages

Optimize your MySQL Server with MySQLTuner

Login to your server’s console and download MySQLTuner (I use my user’s home directory)

wget https://raw.githubusercontent.com/major/MySQLTuner-perl/master/mysqltuner.pl

Optional
If you don’t like to enter the user details for every test it’s possible to create a .my.cnf file in the same directory and add a mysql admin user to access your database

Use this kind of settings:

[client]
user=mysqladminuser
password=dbpassword

Continue reading Optimize your MySQL Server with MySQLTuner