[mythtv] innodb vs myism preformance

[Daniel Manjarres]

Yan-Fa Li wrote:

>Daniel Manjarres wrote:
>  
>
>>Thanks for the quick response.
>>
>>Ok, well I decided to switch the database back to test it, and it is 
>>slow as hell again. This time I did:
>>
>>for a in $(ls *frm | cut -f1 -d. ); do echo "use mythconverg; ALTER 
>>TABLE $a TYPE=MYISAM;"|mysql ; done
>>
>>
>>    
>>
>
>Do you have query cache turned on ?
>

Well, deleting a recording isn't going to be sped up by cache, now is it?

mysql> show variables like '%cache%';
+-----------------------+------------+
| Variable_name         | Value      |
+-----------------------+------------+
| bdb_cache_size        | 8388600    |
| binlog_cache_size     | 32768      |
| have_query_cache      | YES        |
| max_binlog_cache_size | 4294967295 |
| query_cache_limit     | 1048576    |
| query_cache_size      | 26214400   |
| query_cache_type      | ON         |
| table_cache           | 64         |
| thread_cache_size     | 0          |
+-----------------------+------------+
9 rows in set (0.00 sec)