<div dir="ltr"><pre>>><i> $ mysql -umythtv -p mythconverg -e 'SHOW TABLE STATUS LIKE 'logging'\G'
</i>>><i> Enter password:
</i>>><i> ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check
</i>>><i> the manual that corresponds to your MySQL server version for the right
</i>>><i> syntax to use near 'logging' at line 1
</i>
>Oops, that should have been:
>mysql -umythtv -p mythconverg -e 'SHOW TABLE STATUS LIKE "logging"\G'
>(quote issues). I was hoping to get this output because it would
>show--in addition to repeating the storage engine information--some size
>information... Something to the effect of:
>$ mysql -umythtv -p mythconverg -e 'SHOW TABLE STATUS LIKE "logging"\G'
>*************************** 1. row ***************************
> Name: logging
> Engine: MyISAM
> Version: 10
> Row_format: Fixed
> Rows: 16952465
> Avg_row_length: 25
> Data_length: 423811625
>Max_data_length: 7036874417766399
> Index_length: 387863552
> Data_free: 0
> Auto_increment: NULL
> Create_time: 2012-03-29 18:42:37
> Update_time: 2013-02-19 17:20:03
> Check_time: 2013-02-19 04:39:12
> Collation: utf8_general_ci
> Checksum: NULL
> Create_options:
> Comment:
>1 row in set (0.00 sec)
>where the Data_length shows the size of the data file (the .MYD) on disk
>and the Index_length shows the size of the index file (the .MYI) on
>disk. Obviously, yours would show different information.
>Note, also, that my output shows a Check_time of early this morning.
>That corresponds to the time when my system runs a daily
><a href="http://optimize_mythdb.pl">optimize_mythdb.pl</a> cron job--a time I chose because of the extreme
>unlikelihood of a recording occurring at that time.<br></pre><pre><br>Thanks for the very complete and informative response!<br></pre><pre>Here is the output of the command that had the syntax error:<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: 27087<br> Avg_row_length: 174<br>
Data_length: 1730321488<br>Max_data_length: 281474976710655<br> Index_length: 650248192<br> Data_free: 1725601312<br> Auto_increment: 20519185<br> Create_time: 2012-11-19 09:05:36<br> Update_time: 2013-02-19 17:41:52<br>
Check_time: 2013-02-18 08:02:34<br> Collation: utf8_general_ci<br> Checksum: NULL<br> Create_options: <br> Comment:<br><br></pre><pre>Let me know if that changes your recommendation, otherwise I'll plan to setup a cron job as you suggested.<br>
</pre><pre>Thanks<br>Dan<br></pre></div>