Extremely slow website, MySQLTuner log, any advice?

We are running a Wordpress site and are having major problems with extremely slow response time for pages that have to miss the Nginx cache. I'm looking at our database performance as a culprit, and have a MySQLTuner log. What should I be looking at to change/tweak here? >> MySQLTuner 1.7.9 - Major Hayden >> Bug reports, feature requests, and downloads at http://mysqltuner.com/ >> Run with '--help' for additional options and output filtering [--] Skipped version check for MySQLTuner script [OK] Currently running supported MySQL version 10.1.32-MariaDB-1~jessie [OK] Operating on 64-bit architecture -------- Log file Recommendations ------------------------------------------------------------------ [--] Log file: /var/lib/mysql/shoegaze.err(0B) [!!] Log file /var/lib/mysql/shoegaze.err doesn't exist [!!] Log file /var/lib/mysql/shoegaze.err isn't readable. -------- Storage Engine Statistics ----------------------------------------------------------------- [--] Status: +Aria +CSV +InnoDB +MEMORY +MRG_MyISAM +MyISAM +PERFORMANCE_SCHEMA +SEQUENCE [--] Data in InnoDB tables: 477M (Tables: 229) [--] Data in MyISAM tables: 564M (Tables: 74) [OK] Total fragmented tables: 0 -------- Security Recommendations ------------------------------------------------------------------ [OK] There are no anonymous accounts for any database users [OK] All database users have passwords assigned [!!] There is no basic password file list! -------- CVE Security Recommendations -------------------------------------------------------------- [--] Skipped due to --cvefile option undefined -------- Performance Metrics ----------------------------------------------------------------------- [--] Up for: 2d 17h 4m 19s (8M q [38.070 qps], 143K conn, TX: 170G, RX: 8G) [--] Reads / Writes: 92% / 8% [--] Binary logging is enabled (GTID MODE: OFF) [--] Physical Memory : 1.0G [--] Max MySQL memory : 1.3G [--] Other process memory: 309.1M [--] Total buffers: 624.0M global + 7.5M per thread (100 max threads) [--] P_S Max memory usage: 0B [--] Galera GCache Max memory usage: 0B [!!] Maximum reached memory usage: 895.2M (87.42% of installed RAM) [!!] Maximum possible memory usage: 1.3G (134.49% of installed RAM) [!!] Overall possible memory usage with other process exceeded memory [OK] Slow queries: 0% (0/8M) [OK] Highest usage of available connections: 36% (36/100) [OK] Aborted connections: 0.01% (15/143505) [!!] name resolution is active : a reverse name resolution is made for each new connection and can reduce performance [!!] Query cache may be disabled by default due to mutex contention. [OK] Query cache efficiency: 37.9% (4M cached / 11M selects) [!!] Query cache prunes per day: 20139 [OK] Sorts requiring temporary tables: 0% (0 temp sorts / 96K sorts) [OK] No joins without indexes [!!] Temporary tables created on disk: 31% (131K on disk / 421K total) [OK] Thread cache hit rate: 99% (36 created / 143K connections) [OK] Table cache hit rate: 57% (400 open / 691 opened) [OK] Open file limit used: 1% (219/16K) [OK] Table locks acquired immediately: 97% (3M immediate / 3M locks) [OK] Binlog cache memory access: 99.99% (15789 Memory / 15790 Total) -------- Performance schema ------------------------------------------------------------------------ [--] Performance schema is disabled. [--] Memory used by P_S: 0B [--] Sys schema isn't installed. -------- ThreadPool Metrics ------------------------------------------------------------------------ [--] ThreadPool stat is enabled. [--] Thread Pool Size: 4 thread(s). [--] Using default value is good enough for your version (10.1.32-MariaDB-1~jessie) -------- MyISAM Metrics ---------------------------------------------------------------------------- [OK] Key buffer used: 100.0% (134M used / 134M cache) [OK] Key buffer size / total MyISAM indexes: 128.0M/226.3M [OK] Read Key buffer hit rate: 99.8% (53M cached / 134K reads) [OK] Write Key buffer hit rate: 99.3% (1M cached / 1M writes) -------- InnoDB Metrics ---------------------------------------------------------------------------- [--] InnoDB is enabled. [--] InnoDB Thread Concurrency: 0 [OK] InnoDB File per table is activated [!!] InnoDB buffer pool / data size: 256.0M/477.1M [!!] Ratio InnoDB log file size / InnoDB Buffer pool size (37.5 %): 48.0M * 2/256.0M should be equal 25% [!!] InnoDB buffer pool 64M) tmp_table_size (> 32M) max_heap_table_size (> 32M) performance_schema = ON enable PFS innodb_buffer_pool_size (>= 477M) if possible. innodb_log_file_size should be (=32M) if possible, so InnoDB total log files size equals to 25% of buffer pool size. innodb_buffer_pool_instances (=1)