Page 1 of 1
Enable and convert MySQL to innodb file per table for Zoneminder
Posted: Wed Nov 30, 2016 8:38 am
by Camera_Doc
https://wiki.zoneminder.com/Enable_and_ ... Zoneminder
I have tried to follow this wiki but get an error on the following command
Code: Select all
Verify all InnoDB tables gone
SELECT table_name, table_schema, engine FROM information_schema.tables WHERE engine = 'InnoDB';
What am I doing wrong?
Re: Enable and convert MySQL to innodb file per table for Zoneminder
Posted: Wed Nov 30, 2016 5:13 pm
by bbunge
What flavor and version of Linux are you running?
Which version of MySQL? If you are running MySQL 5.6 or beyond you do not need to do this as innodb_file_per_table is the default.
Re: Enable and convert MySQL to innodb file per table for Zoneminder
Posted: Wed Nov 30, 2016 8:48 pm
by bbunge
It has been a while since I ran that procedure so I did it again. The message you got is not an error but what should be returned if you did things right.
Re: Enable and convert MySQL to innodb file per table for Zoneminder
Posted: Sun Dec 11, 2016 8:57 am
by m3lab
Nothing ...
SELECT is a MySql command so the correct line should be
My best,
m.
Re: Enable and convert MySQL to innodb file per table for Zoneminder
Posted: Mon Dec 12, 2016 7:35 am
by Camera_Doc
I run zoneminder on a Raspberry Pi 2
Uninstalled Zoneminder changed to innodb in my.cnf.
Installed zonminder again.
Zoneminder has not stopped after the change.
Perhaps adding to
https://wiki.zoneminder.com/Raspbian
This is what my my.cnf looks like
- [mysqld]
innodb_file_per_table
innodb_buffer_pool_size = 512m
query_cache_type = 1
innodb_buffer_pool_instances = 1
query_cache_limit = 2M