From the course: Learning phpMyAdmin

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Using Advisor to tune performance

Using Advisor to tune performance

From the course: Learning phpMyAdmin

Start my 1-month free trial

Using Advisor to tune performance

“

- The Advisor panel in phpMyAdmin offers a quick way to identify possible performance issues with your mySQL databases. This is phpMyAdmin running on my remote server. So let's see if phpMyAdmin has got any advice on how I can improve my databases. To access the Advisor panel, you need start from the home page of phpMyAdmin. Then, click the Status tab; it's the third from the left at the top, and then the Advisor button. And below this row of buttons is a link labeled Instructions. If you click that, there's some important information about how the Advisor panel works. It says, "Do note that this system provides recommendations based on simple calculations and by rule of thumb which may not necessarily apply to your system." And a very important point down here, in the last paragraph, "The best way to tune your system would be to change only one setting at at time, observe or benchmark your database, and undo the change if there was no clearly measurable improvement. So let's close…

Contents