10 MySQL settings to tune after installation
https://www.percona.com/blog/2014/01/28/10-mysql-settings-to-tune-after-installation/
https://www.percona.com/blog/2014/01/28/10-mysql-settings-to-tune-after-installation/
MySQLTuner-perl MySQLTuner is a script written in Perl that allows you to review a MySQL installation quickly and make adjustments to increase performance and stability. The current configuration variables and status data is retrieved and presented in a brief format…
STEP 01) Change the following in /etc/my.cnf [mysqld] innodb_log_buffer_size = 32M innodb_buffer_pool_size = 2G innodb_log_file_size = 768M STEP 02) SET GLOBAL innodb_fast_shutdown = 0; to force InnoDB to completely purge transactional changes from all of InnoDB moving parts, including the transactional logs (ib_logfile0,…
How to find the proper MTU size for my network - Welcome to TP-LINK How to find the proper MTU size for my network Helpful hint: One way to verify whether if it is an MTU problem is to try…
Recursively list all hidden files and directories on Linux/Unix The basic syntax is as follows: find /dir/to/search/ -name ".*" -print OR find /dir/to/search/ -name ".*" -ls OR search only hidden files: find /dir/to/search/ -type f -iname ".*" -ls OR search…
First refresh the list of available updates so Drush knows there is a new release for Drupal. drush rf # pm-refresh and then drush up drupal Done!
https://www.digitalocean.com/community/tutorials/how-to-install-linux-apache-mysql-php-lamp-stack-on-ubuntu
Sources: http://edoceo.com/blog/2009/02/amazon-ebs-how-to-grow-storage http://stackoverflow.com/questions/9604337/how-do-i-increase-the-ebs-volume-size-of-a-running-instance
source: http://stackoverflow.com/questions/11535617/add-ebs-to-ubuntu-ec2-instance additional info: http://docs.aws.amazon.com/AWSEC2/latest/UserGuide/ebs-creating-volume.html Since this is a new volume, you need to format the EBS volume (block device) with a file system between step 1 and step 2. So the entire process with your sample mount point is:…
Lets say we want to mount /var into new partition: 1. create new volume (leave snapshot id empty) 2. name new volume [var-vol] 3. attach volume to instance: right-click on volume/attach and choose the ec2 instance 4. format the instance:…
*** /dev/xvda1 will be checked for errors at next reboot *** It is a bug on Ubuntu 11.04 and 12.04 ... which causes a file to be created with a future time stamp that contains that message. The simplest solution…
To backup: mysqldump -u username -p database_to_backup > backup_name.sql To restore: mysql -u username -p CREATE DATABASE database_name; exit mysql -u username -p database_name < backup_name.sql
- problem: W: GPG error: http://ppa.launchpad.net precise Release: The following signatures couldn't be verified because the public key is not available: NO_PUBKEY 8AB767895ADC2037 - to fix: sudo apt-key adv --keyserver keyserver.ubuntu.com --recv-keys 8AB767895ADC2037
To view the contents of tar file without extracting tar -tf filename.tar.gz To extract specific file from tarball tar --extract --file={tarball.tar} {file} tar --extract --file=cbz.tar css
https://drupal.org/node/793264 https://drupal.org/node/1332446