Hi
my output of mysqltuner.pl
root@observium:~# ./mysqltuner.pl [OK] Logged in using credentials from debian maintenance account.
MySQLTuner 1.6.2 - Major Hayden major@mhtx.net 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 5.6.24-2+deb.sury.org~precise+2 [OK] Operating on 64-bit architecture
-------- Storage Engine Statistics ------------------------------------------- [--] Status: +ARCHIVE +BLACKHOLE +CSV -FEDERATED +InnoDB +MRG_MYISAM [--] Data in InnoDB tables: 1G (Tables: 94) [--] Data in MEMORY tables: 1M (Tables: 14) [!!] Total fragmented tables: 65
-------- 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: 23d 16h 42m 10s (42M q [20.852 qps], 779K conn, TX: 44B, RX: 7B) [--] Reads / Writes: 69% / 31% [--] Binary logging is disabled [--] Total buffers: 192.0M global + 1.1M per thread (500 max threads) [OK] Maximum reached memory usage: 209.0M (1.70% of installed RAM) [OK] Maximum possible memory usage: 723.2M (5.89% of installed RAM) [OK] Slow queries: 0% (989/42M) [OK] Highest usage of available connections: 3% (16/500) [OK] Aborted connections: 0.08% (611/779884) [!!] Query cache is disabled [OK] Sorts requiring temporary tables: 0% (1K temp sorts / 164K sorts) [OK] Temporary tables created on disk: 9% (10K on disk / 108K total) [OK] Thread cache hit rate: 99% (235 created / 779K connections) [OK] Table cache hit rate: 94% (252 open / 268 opened) [OK] Open file limit used: 0% (48/5K) [OK] Table locks acquired immediately: 99% (45M immediate / 45M locks)
-------- MyISAM Metrics ----------------------------------------------------- [!!] Key buffer used: 18.2% (3M used / 16M cache) [OK] Key buffer size / total MyISAM indexes: 16.0M/101.0K [OK] Read Key buffer hit rate: 100.0% (8K cached / 1 reads) [OK] Write Key buffer hit rate: 100.0% (2K cached / 0 writes)
-------- InnoDB Metrics ----------------------------------------------------- [--] InnoDB is enabled. [!!] InnoDB buffer pool / data size: 128.0M/1.1G [!!] InnoDB buffer pool <= 1G and innodb_buffer_pool_instances(!=1). [OK] InnoDB Used buffer: 87.50% (7167 used/ 8191 total) [OK] InnoDB Read buffer efficiency: 100.00% (1826749857 hits/ 1826772943 total) [!!] InnoDB Write buffer efficiency: 0.00% (0 hits/ 1 total) [OK] InnoDB log waits: 0.00% (0 waits / 6172070 writes)
-------- AriaDB Metrics ----------------------------------------------------- [--] AriaDB is disabled.
-------- Replication Metrics ------------------------------------------------- [--] No replication slave(s) for this server. [--] This is a standalone server..
-------- Recommendations ----------------------------------------------------- General recommendations: Run OPTIMIZE TABLE to defragment tables for better performance Variables to adjust: query_cache_type (=1) innodb_buffer_pool_size (>= 1G) if possible. innodb_buffer_pool_instances (=1) root@observium:~#
hope this helps
I’m guessing all the !! i need to fix or look out?
would this help speed up the mysql and apache?
Simon
On 14 Jan 2016, at 12:25 pm, MagenX admin@magenx.com wrote:
observium is php application, nginx has nothing to do with it, it only reads files... check your error log and make sure you have enough ram for database and fast hard drive.
check with mysqltuner.pl
On 14/01/2016 12:19, Simon Smith wrote:
Hi All,
I wanted a view on what people think about using nginx instead of apache for obsevium?
ive just managed to change apache to nginx (had to change htaccess to get it to work, but got there in the end)
and it seems a little bit quicker but not by much
I’m having an issue where when the server is polling and i want a graph or load up the page, it seems slow and takes forever! ( about 10 seconds )
if I load the panel when its not polling, the pages are quick, but i poll every 5mins, and it takes the full 5 mins to poll all our devices, so really no room to wiggle...
if the anyway i can speed this up? would nginx help at all?
my server is virtual based, 12gb ram, 4 virtual xeon 2.2ghz cores, 80gb virtual hard drive
regards
Simon _______________________________________________ observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium