Hi everybody,
I noticed (after checking the files in utils/kamctl/mysql) that kamailio uses the MyISAM storage engine for its database tables in mysql, is there some particular reason for this? Isn't the read/write concurency that InnoDB provides desirable?
And on a side note, enabling 'low_priority_updates' ( http://dev.mysql.com/doc/refman/5.0/en/server-options.html#option_mysqld_low...) that prioritizes reads over writes in my mysql config can lead to any potential issues with kamailio? Anybody tested this before?
Regards,
Lefteris Zafiris
Hello,
On 5/28/13 3:53 PM, Lefteris Zafiris wrote:
Hi everybody,
I noticed (after checking the files in utils/kamctl/mysql) that kamailio uses the MyISAM storage engine for its database tables in mysql, is there some particular reason for this? Isn't the read/write concurency that InnoDB provides desirable?
you can change that if you prefer innodb, nothing has to be changed in kamailio. Probably the MyISAM is still the safest for old installations. The best would be to make it configurable, but now is generated from the xml file specifying table structures.
Is there an option to set default storage engine per database (or mysql server)? Maybe we should skip it in table definition and let it be the default one in the database server.
And on a side note, enabling 'low_priority_updates' (http://dev.mysql.com/doc/refman/5.0/en/server-options.html#option_mysqld_low...) that prioritizes reads over writes in my mysql config can lead to any potential issues with kamailio? Anybody tested this before?
I haven't played with this myself, but it should not really affect kamailio, each own process uses its connection and does serial queries.
Cheers, Daniel
Regards,
Lefteris Zafiris
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list sr-users@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
On Tue, 28 May 2013 16:30:42 +0200 Daniel-Constantin Mierla miconda@gmail.com wrote:
Is there an option to set default storage engine per database (or mysql server)? Maybe we should skip it in table definition and let it be the default one in the database server.
Since Mysql 5.5 InnoDB is the default engine. It can also be configured by the default-storage-engine setting in my.cfg
I haven't played with this myself, but it should not really affect kamailio, each own process uses its connection and does serial queries.
It only affects MyISAM tables. It makes things a bit faster because actually runs the read operations before some write locks the table. If its safe to use InnoDB it's not worth bothering with this specific option.
Regards,
Lefteris Zafiris
On 5/28/13 4:43 PM, Lefteris Zafiris wrote:
On Tue, 28 May 2013 16:30:42 +0200 Daniel-Constantin Mierla miconda@gmail.com wrote:
Is there an option to set default storage engine per database (or mysql server)? Maybe we should skip it in table definition and let it be the default one in the database server.
Since Mysql 5.5 InnoDB is the default engine. It can also be configured by the default-storage-engine setting in my.cfg
OK. Perhaps worth opening an issue on our tracker not to forget this one.
I think Henning did most of xml-to-sql tools work in the past, if he cannot jump on it, someone else will do it.
I haven't played with this myself, but it should not really affect kamailio, each own process uses its connection and does serial queries.
It only affects MyISAM tables. It makes things a bit faster because actually runs the read operations before some write locks the table. If its safe to use InnoDB it's not worth bothering with this specific option.
OK.
Cheers, Daniel
Is there an option to set default storage engine per database (or mysql server)? Maybe we should skip it in table definition and let it be the default one in the database server.
Since Mysql 5.5 InnoDB is the default engine. It can also be configured by the default-storage-engine setting in my.cfg
OK. Perhaps worth opening an issue on our tracker not to forget this one.
I think Henning did most of xml-to-sql tools work in the past, if he cannot jump on it, someone else will do it.
Hello Daniel,
I'll have a look today and change it in the xslt.
Best regards,
Henning
-
Daniel-Constantin Mierla -
Henning Westerholt -
Lefteris Zafiris