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-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…
Mysql Innodb: InnoDB: ERROR: the age of the last checkpoint is InnoDB: which exceeds the log group capacity
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
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…
Find And List All Hidden Files Recursively
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…
Upgrade Drupal from command line (drush)
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!
How To Install Linux, Apache, MySQL, PHP (LAMP) stack on Ubuntu
https://www.digitalocean.com/community/tutorials/how-to-install-linux-apache-mysql-php-lamp-stack-on-ubuntu
How to Grow the Storage (ec2 volumes)
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
Add EBS to Ubuntu EC2 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:…
Add EBS VOLUME to Ubuntu EC2 Instance
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:…
Ubuntu 12.04 on Amazon EC2: /dev/xvda1 will be checked for errors at next reboot
*** /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…
How to backup mysql database (command line)
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
W: GPG error
- 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
tar – archive utility
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
Install PECL uploadprogress
https://drupal.org/node/793264 https://drupal.org/node/1332446