From: Minty Date: 14:42 on 25 Jun 2007 Subject: innodb_thread_concurrency I never knew Douglas Adams wrote for the mysql innodb documentation team. His legacy continues to grow.... "If you have performance issues ... try setting this variable lower or higher." "The range of this variable is 0 to 1000. A value of 20 or higher is interpreted as infinite ..." http://dev.mysql.com/doc/refman/5.1/en/innodb-parameters.html
From: seph Date: 16:00 on 25 Jun 2007 Subject: Re: innodb_thread_concurrency It's innodb_data_file_path that fills me with hate. Say, you want to keep your datafiles under 2 gigs. Maybe you're worried about the occasional filesystem bug, or maybe you just want to keep things more manageable. Conveniently, there's a max size option. Unfortunatly, there's no way to tell it to start a new file when the old one is full. Which means, you can either get one monster file, or deal with strange errors when mysql runs out of space periodicly. Such a hateful database. seph
Generated at 10:28 on 16 Apr 2008 by mariachi