How MySQL Uses Memory This page lists some of the ways that the mysqld server uses memory, and associated mysqld variable names Memory Use MySQL 5.0 Memory Use MySQL 4.1 MySQL Optimization which covers: – Optimization Overview – Optimizing SELECT and Other Statements – Locking Issues – Optimizing Database Structure – Optimizing the MySQL Server… Continue reading MySQL Optimization / Repair Information
Month: July 2008
Securing MySQL.
Due to differing needs and requirements this is difficult to answer except on a case by case basis. The MySQL website has a section regarding general security of a MySQL database available here: http://dev.mysql.com/doc/refman/5.0/en/security.html Additionally some good practices are: Verify your root MySQL account password is set the test account and database that were created… Continue reading Securing MySQL.
How do I backup MySQL in Linux?
1. Copying from the mysql directory By default, MySQL databases on servers that use Linux are stored in the following directory: /var/lib/mysql/ If you shut down the mysqld service first, you can copy your databases to an example /backup directory using the following command: cp –Rp /var/lib/mysql/*.* /backup The –R switch for the cp command means recursive, which you… Continue reading How do I backup MySQL in Linux?
Linux Memory Management
Scenario: Customer is concerned that only 100MB of their 2GB of memory is as unused or free when running the free command. However, no processes appear to be consuming large amounts of memory, and the server is not running slow. Cause: This is not a problem, but rather a result of the way linux manages… Continue reading Linux Memory Management
Mailbox unavailable or not local error messages – Plesk
If you receive this error when adding a domain: Unable to send notification: mail() failed: SMTP server response: 550 Requested action not taken: mailbox unavailable or not local then you need to add a valid mailbox to your Plesk admin setup. To resolve this issue log into Plesk and click on: Server Edit (under personal… Continue reading Mailbox unavailable or not local error messages – Plesk
Admin account locked out of Plesk
If the Plesk admin account becomes locked due to multiple failed logins, you have two options. The first is to wait till the lockout automatically resets (15 to 30 minutes) or use the following comands. Redhat, once connected via SSH as root: #mysql -uadmin -p`cat /etc/psa/.psa.shadow` psa -e ‘DELETE FROM lockout’ or #mysql -u admin… Continue reading Admin account locked out of Plesk
How to add GD support to PHP on a Linux server with Plesk
Adding GD graphic libraries support to php on your linux server with Plesk is relatively simple. First, log into your server using ssh to get to a command line prompt. Second, type the following command to install a version of php with GD support: up2date php-gd Third, restart your web service with this command: service… Continue reading How to add GD support to PHP on a Linux server with Plesk
How do I retrieve the Plesk control panel password?
You can always get the Plesk password if you have Administrative access to the server. If you have also lost administrative access to the server, refer to [How do I reset the password on my server] For Windows, 1. From the Start menu, select Run. 2. Enter the following command: “C:\Program Files\SWsoft\Plesk\admin\bin\plesksrvclient.exe” -get For Linux,… Continue reading How do I retrieve the Plesk control panel password?
Assigning Name server IPs manually via SSH – cPanel
Currently cPanel will start with eth0 and work through eth1 when you assign nameservers to your IPs via WHM. Unfortunately, this will automatically choose your management IP range first, which of course are non-routable. There are two work-arounds for this: 1: Create a fake nameserver record on your private IPs, and add an A record… Continue reading Assigning Name server IPs manually via SSH – cPanel
How can I compress my CPanel domlogs log files?
Before setting up compression of your logs you will want to have cpanel run the stats as often as possible. This is so you do not miss any stats that would have been included were your logs not compressed before stats run. To do this, login to WHM, and click on Tweak Settings under Server… Continue reading How can I compress my CPanel domlogs log files?