<div dir="ltr"><pre>>><i> Here is the output of the command that had the syntax error:
</i>>><i> $ mysql -umythtv -p mythconverg -e 'SHOW TABLE STATUS LIKE "logging"\G'
</i>>><i> Enter password:
</i>>><i> *************************** 1. row ***************************
</i>>><i> Name: logging
</i>>><i> Engine: MyISAM
</i>>><i> Version: 10
</i>>><i> Row_format: Dynamic
</i>>><i> Rows: 27087
</i>>><i> Avg_row_length: 174
</i>>><i> Data_length: 1730321488
</i>>><i> Max_data_length: 281474976710655
</i>>><i> Index_length: 650248192
</i>>><i> Data_free: 1725601312
</i>>><i> Auto_increment: 20519185
</i>>><i> Create_time: 2012-11-19 09:05:36
</i>>><i> Update_time: 2013-02-19 17:41:52
</i>>><i> Check_time: 2013-02-18 08:02:34
</i>>><i> Collation: utf8_general_ci
</i>>><i> Checksum: NULL
</i>>><i> Create_options:
</i>>><i> Comment:
</i>>><i>
</i>>><i> Let me know if that changes your recommendation, otherwise I'll plan
</i>>><i> to setup a cron job as you suggested.
</i>>><i>
</i>
>Still the same recommendation. Though your Check_time is recent, it's
>likely that it was just a simple check. <a href="http://optimize_mythdb.pl">optimize_mythdb.pl</a> does a
>check, an optimize, and an analyze. So, in my case, the check was
>performed at basically the same time as the optimize and analyze. In
>your case, there probably was no optimize or analyze.
>So, I'd recommend you run the script once, from the command line
>"manually", and then check the file sizes. And please report back to
>let us know how it went. Then, you can set up the cron job for future
>maintenance.
>Note that the script will need to be run in an environment that includes
>a HOME that points to a directory with a valid
>${HOME}/.mythtv/config.xml. It's likely you'll need to specify the HOME
>environment variable in your crontab (for at least this one command).
>
>Mike<br><br><br></pre><pre>I ran <a href="http://optimize_mythdb.pl">optimize_mythdb.pl</a> manually, and it made a big difference. The log files I had listed are now only a couple MB each!<br></pre><pre>Here is the current output:<br>
</pre><pre><br>$ mysql -umythtv -p mythconverg -e 'SHOW TABLE STATUS LIKE "logging"\G'<br>Enter password: <br>*************************** 1. row ***************************<br> Name: logging<br>
Engine: MyISAM<br> Version: 10<br> Row_format: Dynamic<br> Rows: 27557<br> Avg_row_length: 144<br> Data_length: 3983688<br>Max_data_length: 281474976710655<br> Index_length: 1203200<br> Data_free: 0<br>
Auto_increment: 20519655<br> Create_time: 2012-11-19 09:05:36<br> Update_time: 2013-02-19 19:50:07<br> Check_time: 2013-02-19 19:50:07<br> Collation: utf8_general_ci<br> Checksum: NULL<br> Create_options: <br>
Comment:<br><br></pre><pre>Thanks again<br>Dan<br></pre>
<hr></div>