First Byte Time - MediaTemple

Web Site Optimization Help Needed
1

Hi I have a (dv) Dedicated Virtual Self Managed server with Media Temple. I’m hosting a site with the URL: www.mermaidecoresort.com - This website is not even using a MySQL Database yet. It will soon, but the First Time Byte is a whopping 42s. I contacted media temple and they told me that I need to log on to my Linux Apache Server via SSH and optimize the apache conf file and optimize it to fix this issue. Does anyone have any experience with this. I was not able to do it. I would really really appreciate it if someone could shed some light.

[size=large]A conversation between me and Media Temple[/size]

Thank you for your inquiry.

I have reviewed your (dv) Dedicated-Virtual Server and ran a MySQL performance report. The results show a need to modify the settings in the ‘etc/my.cnf’ file to better handle requests and memory allocation. Also, notice the need to use phpMyAdmin and run the repair tables tool. I am including a screen shot of the report below:

I am including some (mt) KnowledgeBase articles in regards to this for reference below:

Using MySQL Report on a (dv) Dedicated-Virtual Server
http://kb.mediatemple.net/questions/1558

Using MySQLTuner
http://kb.mediatemple.net/questions/70

Basic MySQL performance tuning (MySQLd)
http://kb.mediatemple.net/questions/258

b Increasing Max MySQL Connections[/b]
http://kb.mediatemple.net/questions/711

Managing a MySQL database with phpMyAdmin
http://kb.mediatemple.net/questions/426/Managing+a+MySQL+database+with+phpMyAdm in#dv_40

Optimizing your (dv) server
http://kb.mediatemple.net/questions/771

b HOWTO: Basic Apache performance tuning (httpd)[/b]
http://kb.mediatemple.net/questions/246

http://wiki.mediatemple.net/w/(dv)_4.0_-_Making_It_Better

b 4.0 - Making It Better :: Installing Plesk Health Monitor[/b]
http://wiki.mediatemple.net/w/(dv)_4.0_-_Making_It_Better_::_Installing_Ple sk_Health_Monitor

[size=large]MY REPLY:[/size]

Thanks for the prompt reply. I have one last question, this specific website is not relying on the MySQL server we are just hosting html pages for the time being yet it’s slow. Can you please give me a link to any tutorial so I can specifically fix my errors with the First Byte Time.

[size=large]Their Final REPLY [/size]

Thank you for your reply.

I understand where you are coming from in regards to, mermaidecoresort.com, being a static site. However, the MySQL resources are directly tied into the Apache resources. So your static HTML site is suffering do to the overall performance of your (dv) Dedicated-Virtual Server. I would focus on the ‘etc/my.cnf’ file, repairing the tables in phpMyAdmin, and adjusting the prefork settings in Apache. This should resolve the issue.

Please keep in mind that the (dv) Dedicated-Virtual Server is a self-managed server, and assistance with its configuration and maintenance is outside of the (mt) Media Temple scope of support. All suggestions in this message were provided as a courtesy.

2

Are you running any other sites on the same (dv)? Sorry, I can’t do the configuration directly but it sounds like they are saying that your mermaidecoresort.com site is really slow because of other activity on the server (possibly related to another of your sites), particularly a database that is consuming a lot of resources.

If you aren’t using mysql at all and that really is the case then you should completely uninstall MySQL from the server.

From the sound of things, you might want to re-consider using a self-managed server though. Even with lower performance you might be better off with a fully managed shared hosting plan of some kind because maintaining the system operation is an ongoing effort.