Hi guys,
Since the first day i started using rivendell back in 2013, i am
experiencing some strange behaviour, mostly in the scheduler part
(rdlogmanager)
I had a grayed out grid and some shedulercodes that were moving everytime i
saved the sheduler rules.
I read a post a few weeks ago, about someone having the same problem,
caused by innoDB (installed on a -back then- newer version of Mysql)
So I remember in the first week of use, that i ran some commands to convert
some tables from innoDB to MyIsam. That cured the problem with the grayed
out grid.
But since january I switched to 3.2.0, hoping the problem with the jumping
scheduler codes would be solved, but this was without success.
I also have some weird scheduling faults, where it schedules '1 record out
of 10000+' upto 3 times a day. randomly.
So now I decided to go for the root cause of this. My guess would be the
database.
I ran some checks (See Below) and it turns out some tables are still in
innoDB.
If so, would this command suit my needs :
SELECT CONCAT('ALTER TABLE ', TABLE_SCHEMA, '.', TABLE_NAME,'
ENGINE=MyISAM;')
FROM Information_schema.TABLES WHERE TABLE_SCHEMA = 'DBNAME' AND ENGINE =
'InnoDB' AND TABLE_TYPE = 'BASE TABLE'
Of course i will take a back-up of the DB before trying anything.
Regards
Peter
Checks/findings :
MariaDB [Rivendell]> SELECT TABLE_SCHEMA as DbName ,TABLE_NAME as TableName
,ENGINE as Engine
-> FROM information_schema.TABLES
-> WHERE ENGINE = 'MyISAM' -- or InnoDB or whatever
-> AND TABLE_SCHEMA NOT
IN('mysql','information_schema','performance_schema');
+-----------+---------------------+--------+
| DbName | TableName | Engine |
+-----------+---------------------+--------+
| Rivendell | AUDIO_CARDS | MyISAM |
| Rivendell | AUDIO_INPUTS | MyISAM |
| Rivendell | AUDIO_OUTPUTS | MyISAM |
| Rivendell | CARTSLOTS | MyISAM |
| Rivendell | CART_SCHED_CODES | MyISAM |
| Rivendell | CAST_DOWNLOADS | MyISAM |
| Rivendell | CLOCK_LINES | MyISAM |
| Rivendell | CUT_EVENTS | MyISAM |
| Rivendell | DECK_EVENTS | MyISAM |
| Rivendell | DROPBOX_SCHED_CODES | MyISAM |
| Rivendell | ELR_LINES | MyISAM |
| Rivendell | EVENT_LINES | MyISAM |
| Rivendell | GPIO_EVENTS | MyISAM |
| Rivendell | IMPORTER_LINES | MyISAM |
| Rivendell | JACK_CLIENTS | MyISAM |
| Rivendell | LIVEWIRE_GPIO_SLOTS | MyISAM |
| Rivendell | LOG_LINES | MyISAM |
| Rivendell | LOG_MACHINES | MyISAM |
| Rivendell | LOG_MODES | MyISAM |
| Rivendell | NEXUS_FIELDS | MyISAM |
| Rivendell | NEXUS_QUEUE | MyISAM |
| Rivendell | NEXUS_SERVER | MyISAM |
| Rivendell | NEXUS_STATIONS | MyISAM |
| Rivendell | PYPAD_INSTANCES | MyISAM |
| Rivendell | RDAIRPLAY_CHANNELS | MyISAM |
| Rivendell | RDPANEL_CHANNELS | MyISAM |
| Rivendell | RULE_LINES | MyISAM |
| Rivendell | SERVICES | MyISAM |
| Rivendell | SERVICE_CLOCKS | MyISAM |
| Rivendell | STACK_LINES | MyISAM |
| Rivendell | STACK_SCHED_CODES | MyISAM |
| Rivendell | USER_SERVICE_PERMS | MyISAM |
| Rivendell | WEBAPI_AUTHS | MyISAM |
+-----------+---------------------+--------+
33 rows in set (0.00 sec)
MariaDB [Rivendell]> SELECT TABLE_SCHEMA as DbName ,TABLE_NAME as TableName
,ENGINE as Engine
-> FROM information_schema.TABLES
-> WHERE ENGINE != 'MyISAM' -- or InnoDB or whatever
-> AND TABLE_SCHEMA NOT
IN('mysql','information_schema','performance_schema');
+-----------+----------------------+--------+
| DbName | TableName | Engine |
+-----------+----------------------+--------+
| Rivendell | AUDIO_PERMS | InnoDB |
| Rivendell | AUTOFILLS | InnoDB |
| Rivendell | AUX_METADATA | InnoDB |
| Rivendell | CART | InnoDB |
| Rivendell | CLIPBOARD | InnoDB |
| Rivendell | CLOCKS | InnoDB |
| Rivendell | CLOCK_PERMS | InnoDB |
| Rivendell | CUTS | InnoDB |
| Rivendell | DECKS | InnoDB |
| Rivendell | DROPBOXES | InnoDB |
| Rivendell | DROPBOX_PATHS | InnoDB |
| Rivendell | ENCODERS | InnoDB |
| Rivendell | ENCODER_BITRATES | InnoDB |
| Rivendell | ENCODER_CHANNELS | InnoDB |
| Rivendell | ENCODER_SAMPLERATES | InnoDB |
| Rivendell | EVENTS | InnoDB |
| Rivendell | EVENT_PERMS | InnoDB |
| Rivendell | EXTENDED_PANELS | InnoDB |
| Rivendell | EXTENDED_PANEL_NAMES | InnoDB |
| Rivendell | FEEDS | InnoDB |
| Rivendell | FEED_PERMS | InnoDB |
| Rivendell | GPIS | InnoDB |
| Rivendell | GPOS | InnoDB |
| Rivendell | GROUPS | InnoDB |
| Rivendell | HOSTVARS | InnoDB |
| Rivendell | IMPORT_TEMPLATES | InnoDB |
| Rivendell | INPUTS | InnoDB |
| Rivendell | ISCI_XREFERENCE | InnoDB |
| Rivendell | LOGS | InnoDB |
| Rivendell | MATRICES | InnoDB |
| Rivendell | OUTPUTS | InnoDB |
| Rivendell | PANELS | InnoDB |
| Rivendell | PANEL_NAMES | InnoDB |
| Rivendell | PODCASTS | InnoDB |
| Rivendell | RDAIRPLAY | InnoDB |
| Rivendell | RDCATCH | InnoDB |
| Rivendell | RDHOTKEYS | InnoDB |
| Rivendell | RDLIBRARY | InnoDB |
| Rivendell | RDLOGEDIT | InnoDB |
| Rivendell | RDPANEL | InnoDB |
| Rivendell | RECORDINGS | InnoDB |
| Rivendell | REPLICATORS | InnoDB |
| Rivendell | REPLICATOR_MAP | InnoDB |
| Rivendell | REPL_CART_STATE | InnoDB |
| Rivendell | REPL_CUT_STATE | InnoDB |
| Rivendell | REPORTS | InnoDB |
| Rivendell | REPORT_GROUPS | InnoDB |
| Rivendell | REPORT_SERVICES | InnoDB |
| Rivendell | REPORT_STATIONS | InnoDB |
| Rivendell | SCHED_CODES | InnoDB |
| Rivendell | SERVICE_PERMS | InnoDB |
| Rivendell | STATIONS | InnoDB |
| Rivendell | SWITCHER_NODES | InnoDB |
| Rivendell | SYSTEM | InnoDB |
| Rivendell | TIMJORIS_FIELDS | InnoDB |
| Rivendell | TRIGGERS | InnoDB |
| Rivendell | TTYS | InnoDB |
| Rivendell | USERS | InnoDB |
| Rivendell | USER_PERMS | InnoDB |
| Rivendell | VERSION | InnoDB |
| Rivendell | VGUEST_RESOURCES | InnoDB |
| Rivendell | WEB_CONNECTIONS | InnoDB |
+-----------+----------------------+--------+
62 rows in set (0.00 sec)
_______________________________________________
Rivendell-dev mailing list
[email protected]
http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
