#Apache httpd.conf tweak: prefork.c module #Add this to httpd.conf ===================== <IfModule prefork.c> StartServers 15 MinSpareServers 10 MaxSpareServers 40 ServerLimit 256Max Clients 256 MaxRequestsPerChild 1000 </IfModule> ===================== #mysql tweak: #add [ … ]
Category: MySQL
Show Grants for a MySQL User
To show the granted permissions for a MySQL username, first you will need to know the username that you need to check on. In this article, the username will be [ … ]
Check the storage engines for MySQL
If you need to find out the available storage engines for MySQL, such as InnoDB, you can run the following command. mysql -Bse 'show engines' That will output the engines [ … ]
Change WordPress password from the command line
If you forget the login to the WordPress dashboard and the “forgot your password” link isn’t working for you, it is possible to change it from the command line. First, [ … ]
Delete and recreate a MySQL database
You can delete a mysql database by going into the mysql command prompt and using the drop database command. Therefore, if you have a database named data_base that you would [ … ]
Restore a MySQL database from a .sql file
You are able to use the command line to restore a database using the mysql command. To restore a file named backup.sql to the database data_base, first make sure that [ … ]