Disable bin-log without restart

2010-06-11 Thread George Chelidze
Hello, I have a quite loaded server with bin-log enabled. I'd like to disable binary logging globally not for a single session without restarting mysql. Is it possible? Any input is appreciated. Best Regards, George -- MySQL General Mailing List For list archives:

RE: Disable bin-log without restart

2010-06-11 Thread andrew.2.moore
No George you will need to restart MySQL. From: ext George Chelidze [wr...@geo.net.ge] Sent: 11 June 2010 12:15 To: mysql@lists.mysql.com Subject: Disable bin-log without restart Hello, I have a quite loaded server with bin-log enabled. I'd like to

Re: MySQL For Huge Collections

2010-06-11 Thread Andy
Hello all, Thanks much for your replies. OK, so I realized that I may not have explained the problem clearly enough. I will try to do it now. I am a researcher in computational linguistics, and I am trying to research language usage and writing styles across different genres of books over the

RE: WHERE clause from AS result

2010-06-11 Thread Steven Staples
Putting the 'HAVING' in there, works perfectly :) THANKS! Steven Staples -Original Message- From: SHAWN L.GREEN [mailto:shawn.l.gr...@oracle.com] Sent: June 10, 2010 8:03 PM To: Steven Staples Cc: 'MySql' Subject: Re: WHERE clause from AS result On 6/10/2010 4:38 PM, Steven

RE: MySQL For Huge Collections

2010-06-11 Thread Jerry Schwartz
-Original Message- From: Andy [mailto:listan...@gmail.com] Sent: Friday, June 11, 2010 8:09 AM To: mysql@lists.mysql.com Subject: Re: MySQL For Huge Collections Hello all, Thanks much for your replies. OK, so I realized that I may not have explained the problem clearly enough. I will

RE: MySQL For Huge Collections

2010-06-11 Thread Gavin Towey
Agreed. Consider keeping meta data about the book in your mysql database, but storing and serving the actual files from somewhere else. If I were you, I'd use an external full text search engine like Sphinx or Lucene to handle something like searching for content inside the book. Also, in

Re: No Need to Create Constraints?

2010-06-11 Thread jayabharath
I got the below information from a website, when I encountered this error. Hope this would be helpful for you. In every case this is due to something about the relationship that MySQL doesn’t like. Unfortunately it doesn’t specify what the exact issue is. Here is a running list of causes that