Compare VPS Hosting and Dedicated Server

ComfortVPS is here to help you find the right hosting, Save Time and Save Money!
Focus on cheap Windows VPS Hosting and Linux VPS Hosting Since 2012, and Dedicated Server NOW

mysql

  • How to enable InnoDB for MySql?
    For low memeory VPS (Free memeory less than 512MB ), our script use MyISAM instead of InnoDB by default If you want enable InnoDB, please make sure your VPS memeory is enough to get mysql work.  Then, vi /etc/my.cnf, delete below 2 lines and restart mysql: innodb=OFFdefault-storage-engine=MyISAM   If you see below error when restart mysql, “InnoDB: Fatal error: cannot allocate the memory for the buffer pool” You will need change some parameter eg. innodb_buffer_pool_size to use less memeory, restarted the MySQL and it was done , error gone .
  • Tutorials of ComfortVPS Nginx+PHP+MySql Installation Service
    Here are some useful tutorials of ComfortVPS Nginx+PHP+MySql Installation Service How to find your password of SFTP and MySql root? How to connect to SFTP? How to upload files? How to create a Nginx website(how to add domain)? How to access phpMyAdmin(how to control MySql database)? How to stop Nginx server? How to start and restart Nginx via command line? How to custom config a Nginx domain? Nginx configuration file location How to stop/restart PHP-fpm? How to custom config and optimize PHP-fpm? How to enable InnoDB for MySql? Note, We wrote these tutorials to save your time, but we do not...
  • Auto installer of Nginx PHP(php-fpm) MySql phpMyAdmin in CentOS
    If you are not good at SSH command and you want install Nginx PHP(php-fpm) MySql phpMyAdmin for your small website, you can use our Automatically install script of Nginx PHP(php-fpm) MySql in CentOS. What's you need to do is: Copy and post/run below single command line via SSH root login. wait 5-15 minutes(depending on the software download speed from your server), Everything is Done!  wget --no-check-certificat -O /tmp/install-nginx-php-mysql.sh https://raw.github.com/ComfortVPS/Nginx-PHP-MySql-phpMyAdmin/master/install-nginx-php-mysql.sh; sh /tmp/install-nginx-php-mysql.sh; The Auto installer of Nginx PHP(php-fpm) MySql only works on CentOS 5.x/6.x 32bit or 64bit now, work perfectly for Xen VPS ram >= 128MB. Recommand RAM(memory) is >= 256MB for CentOS 32bit and...