Remove SSL default Cert on Plesk 11.0.9

Log into mysql. mysql -uadmin -p`cat /etc/psa/.psa.shadow` mysql> select dom_id,certificate_id from hosting where dom_id=13; +——–+—————-+ | dom_id | certificate_id | +——–+—————-+ | 13 | 0 | +——–+—————-+ 1 row in set (0.00 sec) mysql> SELECT * FROM IP_Addresses; +—-+—————+————-+—————+——-+——————–+——————-+——-+——+——–+ | id | serviceNodeId | ip_address | mask | iface | ssl_certificate_id | default_domain_id | ftps…

MySQL’s wait_timeout and interactive_timeout Variables

Ever get these errors? Mysql reporting error when accessing plesk. Zend_Db_Adapter_Exception: SQLSTATE[08004] [1040] Too many connections. You can set-variable=max_connections=250 to /etc/my.cnf and restart and use mysql close statements for php code. Or, set up mysql to close sleeping processes. Mysql Config. (/etc/my.cnf) wait_timeout variable represents the amount of time that MySQL will wait before killing…

MySQL InnoDB Recovery

Mysql Recovery. Error logs shows: InnoDB: Database page corruption on disk or a failed InnoDB: file read of page 7. InnoDB: You may have to recover from a backup. 080703 23:46:16 InnoDB: Page dump in ascii and hex (16384 bytes): … A LOT OF HEX AND BINARY DATA… 080703 23:46:16 InnoDB: Page checksum 587461377, prior-to-4.0.14-form…

Optimize Mysql

Did you know that mysql comes with configuration files for better optimization? These files are located at: /usr/share/doc/mysql-server-5.1.71/my-huge.cnf /usr/share/doc/mysql-server-5.1.71/my-innodb-heavy-4G.cnf /usr/share/doc/mysql-server-5.1.71/my-large.cnf /usr/share/doc/mysql-server-5.1.71/my-medium.cnf /usr/share/doc/mysql-server-5.1.71/my-small.cnf /usr/share/man/man5/openssl.cnf.5ssl.gz Or /usr/share/mysql/my-huge.cnf /usr/share/mysql/my-innodb-heavy-4G.cnf /usr/share/mysql/my-large.cnf /usr/share/mysql/my-medium.cnf /usr/share/mysql/my-small.cnf Stop mysql # service mysqld stop Stopping mysqld: [ OK ] backup the original my.cnf file. # mv /etc/my.cnf /etc/my.cnf.original Move the new config file to…

Mytop

Install the repository CentOS 5.x rpm -Uhv http://apt.sw.be/redhat/el5/en/i386/rpmforge/RPMS/rpmforge-release-0.3.6-1.el5.rf.i386.rpm CentOS 6.x 64 bit rpm -Uhv http://apt.sw.be/redhat/el6/en/i386/rpmforge/RPMS/rpmforge-release-0.5.3-1.el6.rf.x86_64.rpm Install mytop yum -y install mytop Configuration Odds are, you will get an error initially running this program unless you configure it first. whereis mytop Example: /usr/bin/mytop or /usr/local/bin/mytop nano /usr/bin/mytop or nano /usr/local/bin/mytop Locate the following lines: my %config…