Browse Category: MySQL

Improved ERPTC’s Server by Tuning MySQL

logo-mysqlERPTC’s server performance had been terrible because I had never spent time to tune MySQL. Well, today I had taken care of tuning MySQL. ┬áNow the site loads in just over a second. Here are the results from Pingdom Tools:

Tested Load Time Page Size Requests Page Speed
April 2 17:55:46 1.52 s 3.0 MB 157 84
April 2 14:26:11 1.18 s 3.0 MB 157 84
April 2 14:25:56 7.73 s 3.0 MB 157 79
April 2 14:04:00 1.38 s 3.0 MB 157 84
April 2 14:01:43 1.16 s 3.0 MB 157 84
April 2 14:01:26 1.29 s 3.0 MB 157 84
April 2 14:01:13 1.19 s 3.0 MB 157 84
April 2 14:00:59 7.35 s 3.0 MB 157 79
April 2 13:56:37 2.70 s 3.0 MB 163 83
April 2 13:56:19 2.63 s 3.0 MB 163 83
April 2 13:56:04 6.91 s 3.0 MB 163 79
April 2 13:32:56 2.60 s 3.0 MB 162 83
April 2 13:32:41 6.30 s 3.0 MB 163 83
April 2 13:32:23 2.66 s 3.0 MB 163 83
April 2 13:32:07 8.82 s 3.0 MB 162 79
April 2 13:20:10 2.91 s 3.0 MB 163 83
April 2 13:18:25 9.05 s 3.0 MB 162 79
April 2 13:07:21 12.97 s 3.0 MB 163 79
April 2 13:06:20 10.25 s 3.0 MB 163 79