On 8/10/08, Brian Aker <[EMAIL PROTECTED]> wrote: > > Hi! > > Is there any reason why you would ever want myisam_concurrent_insert > disabled?
Yes - http://www.mysqlperformanceblog.com/2006/06/13/myisam-concurrent-insert/ Anyone have any other favorite variables which should just go? ummm....global server variables only or also session server variables and status variables? old-passwords should die, as should the PASSWORD() function, now that auth is not done in the MySQL server itself. Even if someone writes a plugin for MySQL to use a table for auth, folks shouldn't use PASSWORD(). obviously: named pipe, socket, shared memory (and shared_memory_base_name), which may already be out but I figured they might not be yet...same with sql-mode.....log_bin_trust_function_creators deals with stored routines (sp, sfunc and triggers) The SSL_ variables should go; that should be made a plugin. "new" and "old" (I can't make this stuff up, folks....speaking of which I found a variable called "one_shot" in the 6.0 docs, but there was no description of what it did, so I filed http://bugs.mysql.com/bug.php?id=38708) last_insert_id could go -- it causes more problems than it solves IMO. This will likely be controversial... lower_case_file_system lower_case_table_names (just make 'em all case insensitive!) system_time_zone -- unless it's such a huge win caching that...but when the server changes time zones MySQL needs to restart. pain! I forget what was talked about for the character set/collation stuff, but there are tons of variables for the server/system/database/table/client/whatever charset and collation, that I'd love to see whittled down or gone away for something more sane. How often do folks set "flush" to "yes" (and flush_time)? That's a loser in my book, but kind of obscure and seems that it might be REALLY needed when needed...but... Why is there a "license" variable? I mean, seriously. I can understand the version one (though the "version-comment" drives me batty! it's either part of the version or not!) -Sheeri Cheers, > -Brian > > -- > _______________________________________________________ > Brian "Krow" Aker, brian at tangent.org > Seattle, Washington > http://krow.net/ <-- Me > http://tangent.org/ <-- Software > _______________________________________________________ > You can't grep a dead tree. > > > > > _______________________________________________ > Mailing list: > https://launchpad.net/~drizzle-discuss<https://launchpad.net/%7Edrizzle-discuss> > Post to : [email protected] > Unsubscribe : > https://launchpad.net/~drizzle-discuss<https://launchpad.net/%7Edrizzle-discuss> > More help : https://help.launchpad.net/ListHelp >
_______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
