How to Optimize MySQL

CentOS There is a default my.cnf that comes with mysql (4+5) that will make mysql run a bit quicker if you have 2+ gig of ram cp -f /usr/share/mysql/my-large.cnf /etc/my.cnfThere is also my-huge.cnf, or my-medium.cnf depending on your hardware setup.   Check the contents of these my*.cnf files for the one that’s right for you.… Continue reading How to Optimize MySQL

Multiple vulnerabilities mysql – Mandriva

  Problem Description:   Multiple vulnerabilities has been discovered and corrected in mysql:   Unspecified vulnerability in MySQL 5.5.x before 5.5.23 has unknown   impact and attack vectors related to a Security Fix, aka Bug   #59533. NOTE: this might be a duplicate of CVE-2012-1689, but as of   20120816, Oracle has not commented on… Continue reading Multiple vulnerabilities mysql – Mandriva

How To: Install memcached on CentOS 6

Memcached is a distributed, high-performance, in-memory caching system that is primarily used to speed up sites that make heavy use of databases. It can however be used to store objects of any kind. Nearly every popular CMS has a plugin or module to take advantage of memcached, and many programming languages have a memcached library,… Continue reading How To: Install memcached on CentOS 6

How to upgrade mysql with custombuild

To upgrade mysql using the custombuild script, do the following: cd /usr/local/directadmin/custombuild ./build set mysql 5.1 ./build set mysql_inst yes ./build set mysql_backup yes ./build update ./build mysql Where mysql can be 5.0, 5.1 or 5.5. A full raw sql backup will be run prior to the upgrade if you have mysql_backup=yes set.  It goes without… Continue reading How to upgrade mysql with custombuild

How to change the max file upload size for phpMyAdmin in Plesk

You need to edit the correct php.ini file and increase the value of the following variables to the desired size: memory_limit, upload_max_filesize and post_max_size The  php.ini file is located at: On Linux server: /usr/local/psa/admin/conf/php.ini On Windows server: C:\Program Files (x86)\Parallels\Plesk\admin\php.ini   Then you will need to restart your webserver & PSA.    

MySQL Socket errors

This is an error that many people who run PHP and MySQL are familiar with: ERROR 2002: Can’t connect to local MySQL sever through socket ‘/var/lib/mysql/mysql.sock’ (2) Luckily, this is relatively easy to solve in most cases. Here’s what to do. ·First of all, we need to decide where the MySQL socket file should be. For… Continue reading MySQL Socket errors