[mythtv-users] Off Topic. Can't execute: MySQL server has gone away

[Kevin Johnson]

Hi All:

I know some of you are Mysql experts so I thought I would ask here.

Description: Ubuntu 14.04.4 LTS
Release: 14.04

mysql Ver 14.14 Distrib 5.5.49, for debian-linux-gnu (x86_64) using
readline 6.3


I am also running zoneminder on my mythbuntu backend.
Both Myth and Zoneminder are running and working just fine.

Issue is, when I go to look at the log files for zoneminder I get the
following error.

Can't execute: MySQL server has gone away.

Now I dont think this is a mysql error as everything is working good. and I
ran the following with what I think are good results.

mysqlcheck -uroot -p --optimize --databases zm

Gor a bunch of the following. All checked okay.

zm.Config
note : Table does not support optimize, doing recreate + analyze instead
status : OK
zm.ControlPresets
note : Table does not support optimize, doing recreate + analyze instead
status : OK


I then ran this.

sudo mysqltuner

Got this.

-------- Storage Engine Statistics
-------------------------------------------
[--] Status: +Archive -BDB -Federated +InnoDB -ISAM -NDBCluster
[--] Data in PERFORMANCE_SCHEMA tables: 0B (Tables: 17)
[--] Data in MyISAM tables: 93M (Tables: 106)
[--] Data in InnoDB tables: 109M (Tables: 556)
[!!] Total fragmented tables: 42

-------- Security Recommendations
-------------------------------------------
[!!] User '@kapok' has no password set.
[!!] User '@localhost' has no password set.

-------- Performance Metrics
-------------------------------------------------
[--] Up for: 3m 35s (1K q [7.149 qps], 397 conn, TX: 7M, RX: 264K)
[--] Reads / Writes: 61% / 39%
[--] Total buffers: 280.0M global + 48.8M per thread (151 max threads)
[OK] Maximum possible memory usage: 7.5G (48% of installed RAM)
[OK] Slow queries: 2% (44/1K)
[OK] Highest usage of available connections: 35% (54/151)
[OK] Key buffer size / total MyISAM indexes: 64.0M/94.0M
[OK] Key buffer hit rate: 99.5% (7K cached / 43 reads)
[OK] Query cache efficiency: 32.9% (252 cached / 767 selects)
[OK] Query cache prunes per day: 0
[OK] Sorts requiring temporary tables: 0% (0 temp sorts / 46 sorts)
[!!] Temporary tables created on disk: 35% (204 on disk / 581 total)
[OK] Thread cache hit rate: 85% (57 created / 397 connections)
[OK] Table cache hit rate: 25% (256 open / 998 opened)
[OK] Open file limit used: 25% (262/1K)
[OK] Table locks acquired immediately: 100% (742 immediate / 742 locks)
[OK] InnoDB data size / buffer pool: 109.2M/128.0M

-------- Recommendations
-----------------------------------------------------
General recommendations:
Run OPTIMIZE TABLE to defragment tables for better performance
MySQL started within last 24 hours - recommendations may be inaccurate
When making adjustments, make tmp_table_size/max_heap_table_size equal
Reduce your SELECT DISTINCT queries without LIMIT clauses
Variables to adjust:
tmp_table_size (> 32M)
max_heap_table_size (> 1G)


So with my limited knowledge, I believe the mysql database is okay.
But if someone on this list sees or knows something that may help, I would
appreciate it.
I asked over at the zoneminder forums and not getting a whole lot of
answers.

Thanks to all
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20160503/1ad508b3/attachment.html>