Server Fault is a question and answer site for system and network administrators. It only takes a minute to sign up. Connect and share knowledge within a single location that is structured and easy to search. Now from my web server on a different server , when I make queries it takes 10x longer than it used to take to make the queries when the database server was on the same server. I think mysql server on the dedicated VPS is just configured wrong, especially with the cache sizes.
A database is a structured collection of data. It may be anything from a simple shopping list to a picture gallery or the vast amounts of information in a corporate network. To add, access, and process data stored in a computer database, you need a database management system such as MySQL Server.
Managing your database
One of the most common sources of site performance degradation is poor database optimization. While it is possible to optimize databases by manual inspection, this process may be prohibitively time consuming. Please note that you will need to log into the command line interface as the root user to continue on with this tutorial. MySQL Tuner is a script that checks for fragmented database tables that need to be repaired, provides uptime statistics, and reviews the database for security issues. By tuning MySQL databases, you can reduce site load times and increase the overall performance of the site itself. If your site relies heavily on database queries, proper optimization is key. The good news is that tools such as MySQL Tuner exist as easy-to-use database optimization resources.
Running a WordPress on a Virtual private Server or dedicated server is not an easy as running a WordPress on shared hosting server. There are a few things need to install and configure. Installation of the MySQL is very easy, but most of the webmaster will facing difficulties on the configuration part. MySQL database is actually the brain of your website or blog. It will store all the configuration information, the posts, comments, login information, user information and etc. This article assumed that you already installed the MySQL server on your VPS or dedicated server and then you may proceed to configure and harden it as below :. Disallow root login remotely if you want. However i prefer to disallow it later.