MySQL is Consuming Lots of CPU
Introduction If MySQL is consuming a lot of your CPU resources or is maxing out your server, the best thing to do is log into MySQL on your server and watch the queries in real-time. This will clearly show what’s…
Category Working with Databases
Service Management: MySQL
Stop/Start MySQL These commands stop and start MySQL. Run them separately. gp mysql -stop gp mysql -start Restart/Reload MySQL The restart and reload commands both issue a STOP and then START from one command. They are effectively interchangeable. gp mysql…
Service Management: Redis
Stop/Start Redis These commands stop and start Redis. Run them separately. gp redis -stop gp redis -start Restart Redis The restart command issues a STOP and then START from one command. gp redis -restart Reload Redis Reload reloads the configuration…
Connect to your GridPane Site Database with PHPMyAdmin
You can connect to any site’s database easily from within your browser as the GridPane control panel has a simple to use integration of PHPMyAdmin. If you would prefer to use a desktop client to access your DB as root…
Connect to a WordPress Database Remotely With a Desktop MySQL Client
Introduction This tutorial provides a step-by-step guide to connecting the tool of your choice with your GridPane WordPress site databases. To complete this tutorial, you will need to have downloaded and installed one of the free tools listed below and…