Re: [Maria-discuss] How many open files by daemon is still sane?

2015-04-21 Thread Rohan M C
Hi, We had similar issues and we went through a couple of exercises to determine how file descriptors work with both mysql and mariadb. Please correct me if I'm wrong...this is what I've seen based on a number of repeated tests. For innodb, regardless of how many queries you have or any other par

Re: [Maria-discuss] R: question regarding innodb compression

2014-10-29 Thread Rohan M C
thout any problem of that. > > Regards, > > 2014-10-29 17:35 GMT+09:00 Federico Razzoli : > >> I had a mix of Antelope/Barracuda for years. As far as I can tell, this >> never caused problems. >> >> Regards >> Federico >> >> >> -

[Maria-discuss] question regarding innodb compression

2014-10-29 Thread Rohan M C
Hi all, Due to space constraints we are considering the innodb compression option for some of our larger tables. We're not compressing all the tables, but only a select few to begin with. Our current planned process for this is to SET GLOBAL innodb_file_format=Barracuda; create compressed table, t

[Maria-discuss] question about mariadb threadpools and file descriptors

2013-12-30 Thread Rohan M C
Hi All, We're considering a switch to mariadb (5.5.33a) from mysql (5.5.31) for our production servers. First, some background info about our system 1) ~2000 tables. 3/4th of them are innodb, the rest are myisam 2) All tables are partitioned with ~100 partitions each 3) our largest tables are par