ZoneMinder Forums

Here is the exit of Mysqltuner in my server:

>> MySQLTuner 1.6.4 - Major Hayden <major@mhtx.net>
>> Bug reports, feature requests, and downloads at http://mysqltuner.com/
>> Run with '--help' for additional options and output filtering
[OK] Logged in using credentials from debian maintenance account.

[--] Skipped version check for MySQLTuner script
[OK] Currently running supported MySQL version 5.5.47-0ubuntu0.14.04.1
[OK] Operating on 64-bit architecture

-------- Storage Engine Statistics -------------------------------------------
[--] Status: +ARCHIVE +BLACKHOLE +CSV -FEDERATED +InnoDB +MRG_MYISAM
[--] Data in InnoDB tables: 5M (Tables: 18)
[!!] Total fragmented tables: 18

-------- Security Recommendations -------------------------------------------
[OK] There are no anonymous accounts for any database users
[!!] User 'root@127.0.0.1' has no password set.
[!!] User 'root@::1' has no password set.
[!!] User 'root@camserver' has no password set.
[!!] User 'root@localhost' has no password set.
[!!] There is no basic password file list!

-------- CVE Security Recommendations ---------------------------------------
[--] Skipped due to --cvefile option undefined

-------- Performance Metrics -------------------------------------------------
[--] Up for: 4m 1s (803 q [3.332 qps], 89 conn, TX: 1M, RX: 132K)
[--] Reads / Writes: 12% / 88%
[--] Binary logging is disabled
[--] Total buffers: 192.0M global + 2.7M per thread (151 max threads)
[OK] Maximum reached memory usage: 229.6M (9.17% of installed RAM)
[OK] Maximum possible memory usage: 597.8M (23.87% of installed RAM)
[OK] Slow queries: 0% (0/803)
[OK] Highest usage of available connections: 9% (14/151)
[OK] Aborted connections: 0.00% (0/89)
[OK] Query cache efficiency: 32.8% (40 cached / 122 selects)
[OK] Query cache prunes per day: 0
[OK] Sorts requiring temporary tables: 0% (0 temp sorts / 2 sorts)
[OK] Temporary tables created on disk: 25% (54 on disk / 213 total)
[OK] Thread cache hit rate: 84% (14 created / 89 connections)
[OK] Table cache hit rate: 89% (62 open / 69 opened)
[OK] Open file limit used: 4% (48/1K)
[OK] Table locks acquired immediately: 100% (676 immediate / 676 locks)

-------- MyISAM Metrics ------------------------------------------------------
[!!] Key buffer used: 18.2% (3M used / 16M cache)
[OK] Key buffer size / total MyISAM indexes: 16.0M/103.0K

-------- InnoDB Metrics ------------------------------------------------------
[--] InnoDB is enabled.
[OK] InnoDB buffer pool / data size: 128.0M/5.1M
[OK] InnoDB buffer pool instances: 1
[!!] InnoDB Used buffer: 6.35% (520 used/ 8192 total)
[OK] InnoDB Read buffer efficiency: 96.00% (12248 hits/ 12758 total)
[!!] InnoDB Write Log efficiency: -92.65% (-290 hits/ 313 total)
[OK] InnoDB log waits: 0.00% (0 waits / 603 writes)

-------- ThreadPool Metrics --------------------------------------------------
[--] ThreadPool stat is disabled.

-------- AriaDB Metrics ------------------------------------------------------
[--] AriaDB is disabled.

-------- TokuDB Metrics ------------------------------------------------------
[--] TokuDB is disabled.

-------- Galera Metrics ------------------------------------------------------
[--] Galera 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
Set up a Password for user with the following SQL statement ( SET PASSWORD FOR 'user'@'SpecificDNSorIp' = PASSWORD('secure_password'); )
MySQL started within last 24 hours - recommendations may be inaccurate
Enable the slow query log to troubleshoot bad queries

is there something wrong? besides the password that is not set.

I had the same issue.

I ultimately found that setting the timezone to UTC in my /etc/php5/apache2/php.ini file was the cause of my issue. Setting it to America/Los/Angeles (where I am) fixed it after restarting (just) apache2 service. I should have tried this earlier, as I've seen reference to this before... A bit more testing found that indeed, it has to match the timezone on your Ubuntu machine. I can change either Ubuntu or php.ini and break streaming.

You can get what ubuntu is using by doing "cat /etc/timezone"

Hopefully that helps.