Re: [Maria-discuss] Suggested sample my.cnf for MariaDB package

2011-03-25 Thread Haidong Ji
I've been busy preparing for a SQL Server presentation I will do this weekend, therefore the lack of activity. Arjen, > > The Debian/Ubuntu packages already contain a "baseline config" that Open > Query created earlier for the OurDelta packages. > I believe all of the options suggested by you are

Re: [Maria-discuss] Suggested sample my.cnf for MariaDB package

2011-03-20 Thread Arjen Lentz
Hi Haidong, all On 19/03/2011, at 3:16 AM, Haidong Ji wrote: I proposed updating the packaged my.cnf sample files before. The Debian/Ubuntu packages already contain a "baseline config" that Open Query created earlier for the OurDelta packages. I believe all of the options suggested by you a

Re: [Maria-discuss] Suggested sample my.cnf for MariaDB package

2011-03-20 Thread Haidong Ji
> I request setting max_allowed_packet 16M (at least - actually I'd prefer > 64M) in both [mysqld] and [mysqldump] sections for all templates. For the > background for this request see > http://www.webyog.com/blog/2009/08/10/mysql-server-has-gone-away-part-1-max_allowed_packet/ Excellent! Thanks

Re: [Maria-discuss] Suggested sample my.cnf for MariaDB package

2011-03-20 Thread Haidong Ji
Hi Walter, I think a sample file with ALL options will drown out the important ones and causes confusion. Like I mentioned in the reply to Monty, personally I think the target of sample my.cnf is for lower end users (no disrespect intended whatsoever). My 0.02c Haidong On Fri, Mar 18, 2011 at 3

Re: [Maria-discuss] Suggested sample my.cnf for MariaDB package

2011-03-20 Thread Haidong Ji
Hi Monty, > The problem is that a too simple my.cnf will please very few (mainly > desktop users) and leave the a bit more advanced user to search on > the net and get 'anything' that looks remotely right. > I respectfully disagree. I think the sample my.cnf is targeted for desktop users, medium-

Re: [Maria-discuss] Suggested sample my.cnf for MariaDB package

2011-03-18 Thread Peter Laursen
I request setting max_allowed_packet 16M (at least - actually I'd prefer 64M) in both [mysqld] and [mysqldump] sections for all templates. For the background for this request see http://www.webyog.com/blog/2009/08/10/mysql-server-has-gone-away-part-1-max_allowed_packet/ We have reports every mont

Re: [Maria-discuss] Suggested sample my.cnf for MariaDB package

2011-03-18 Thread Walter Heck
I personally would be more in favor of a version that has _all_ options in it, with explanatory comments. Many options should not be set, but they could be commented out. That would make it much easier for users to get a grasp of available options and recommended settings. For instance, zabbix' con

[Maria-discuss] Suggested sample my.cnf for MariaDB package

2011-03-18 Thread Haidong Ji
All, I proposed updating the packaged my.cnf sample files before. After some thinking and deliberation, here are my thoughts on the sample my.cnf: 1. There are so many factors that affect settings in my.cnf so it is impossible to please everybody. There is a lot of debates on this. 2. There are v