Re: Locking a Database (not tables) x

2014-03-23 Thread Peter Brawley
On 2014-03-23 8:02 PM, David Lerer wrote: Thanks Shawn, This may work for us with some script changes. We'll take a look. By the way, too bad we cannot rename a database, or can we? See http://dev.mysql.com/doc/refman/5.1/en/rename-database.html about removal of a "dangerous RENMAE DATABASE" st

RE: Locking a Database (not tables) x

2014-03-23 Thread David Lerer
Thanks Shawn, This may work for us with some script changes. We'll take a look. By the way, too bad we cannot rename a database, or can we? See http://dev.mysql.com/doc/refman/5.1/en/rename-database.html about removal of a "dangerous RENMAE DATABASE" statement... David. David Lerer | Director,

Re: Precedence in WHERE clauses.

2014-03-23 Thread Christophe
mentioned, my goal is also to get a general > discussion about theorical behaviour of MySQL while handling WHERE clauses. > > I don't have access to the application for now, but will try EXPLAIN as > soon as I can . Here is the Result of Explain : http://perso.stux6.net/mysql/201

Re: Database migration from default configuration to innodb_file_per_table

2014-03-23 Thread Christophe
Hi Shawn, and thanks for this concise anwser ;) . Le 22/03/2014 05:35, shawn l.green a écrit : > > The system is operating exactly as designed. The ibdata* file(s) contain > more than just your data and indexes. This is the common tablespace and > it contains all the metadata necessary to identify