PHP & MySQL Performance Tweaks

PHP

MySQL

Grab your total memory
```
grep MemTotal /proc/meminfo
```
Take that number and convert it to GB: https://www.google.com/search?q=kb+to+mb&oq=kb+to+mb
Take 80% of that, use this in the innodb_buffer_pool_size below
Edit the MySQL config
```
sudo nano /etc/mysql/my.cnf
```

Put these settings at the bottom

open_files_limit = 6144
innodb_autoinc_lock_mode = 2
innodb_read_io_threads = 16
innodb_spin_wait_delay = 24
innodb_sync_spin_loops = 200
innodb_write_io_threads = 16
innodb_buffer_pool_size = 0.8G // OR WHATEVER YOU CAME UP WITH IN #3
innodb_lock_wait_timeout = 20
query_cache_type = 0
table_definition_cache = 600
thread_cache_size = 19
tx_isolation='READ-COMMITTED'
wait_timeout = 600
join_buffer_size = 8388608
read_rnd_buffer_size = 8388608