Siteground hosting are now upgrading the mysql database from the older version 4 to the latest version 5. And after this mysql database upgrade, those customer can setup php scripts that utilised mysql 5 feature. Mysql version 5 made some improvement, and offering new features that included stored procedure, views and database triggers.
“The MySQL service will be upgraded from version 4 to version 5. This will alllow you to take advantage of the new features that come with MySQL 5, most important of which are stored procedures, triggers, data dictionary and views.“
Read More...
In recent siteground review articles, i wrote about siteground for forum web hosting purposes, and mentioned that a fast mysql database is crucial for a success of a forum site. Vbulletin forum for example have over 100 tables at the backend, and there are lots of mysql quesries being perform to complete a single user request. If there are ten or hundreds of forum user online, that will definately load the mysql database server, and result in slow website or even downtime to your website.
Its important to research on the hosting mysql database specification, version, total connection limit per account, and so on. Once your shared hosting can’t support the traffic that you are having, its time to upgrade to vps hosting or even a dedicated server hosting.
Go to Siteground.com
Read More...
