On your new hosting place, create a new/empty WP install. That will create a database. Remember the credentials. Then create a new database, and import the data you got from the old host. Remember the credentials; assign the user/pass to that database. Then go into the new install, inside the wp-config.php file, and change the … Read more
Your problem is in the size of your site. You have huge site and now it’s not enough to have only W3 Total Cache plugin for caching. During publishing post, WordPress performs a lot of database calls, it updates some information about posts in database. So I can suppose that the weakest spot is in … Read more
Well yes but compared to what? Any query on the DB is going to add server load and thus page load so your question is not very useful without context. The PHP code WP uses to order posts randomly is found in query.php: case ‘rand’: $orderby = ‘RAND()’; Which results in the output like: SELECT … Read more
It looks like its failing to load the CSS for Max Mega Menu. Under Appearance > Max Mega Menu > Global Settings, try changing CSS Output to ‘load in head’
I don’t think there is any WordPress specific solution, but I personally use blitz.io to do the load testing for our solutions. Actually you could also use one of the usual (free) tools (like Apache bench), but then you’ll have to consider a lot of other variables to make sure that you really create real-world-numbers … Read more
It looks like your site is doing a lot of processing when displaying a page. have you tried adding a caching mechanism? you can give plugin a try: http://wordpress.org/extend/plugins/w3-total-cache/
You should search your theme files for calls to wp_enqueue_style(), I bet that is what’s adding an extra link to style.css.
The performance of WordPress does not depend on the number of posts. It depends on the server performance (how fast can PHP scripts be executed). And the performance of the MySQL Server. The server performance is normally no problem if you got enough memory. The bottleneck is in most cases the MySQL server and the … Read more
You can use a tool like loadimpact.com to generate load, include following user scripts, for a huge number of users. However, as with anything like this, it doesn’t come free. We’ve just used it, so far, for simple load testing of user views as that’s been our biggest issue with sites. We wrote an article … Read more
Too many MySQL connections on WordPress