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: http://lists.mysql.com/mys

Re: How to log some queries and not others

2005-02-10 Thread George Chelidze
Dear Paul, Paul DuBois wrote: At 19:52 +0300 2/9/05, George Chelidze wrote: Hello, I have the following problem: I have a table with a blob field and turned on query logging. I'd like to log every query except inserts into table with a blob field because my log files grow very fast and I

How to log some queries and not others

2005-02-09 Thread George Chelidze
s are very informative and important. How can I do that? Best Regards, -- George Chelidze -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: CREATE FUNCTION problem

2003-10-28 Thread George Chelidze
Matt - Original Message - From: "George Chelidze" Sent: Monday, October 27, 2003 9:18 AM Subject: CREATE FUNCTION problem Hello, I have created new udf function which converts time from NTP format to timestamp. I compile it with the following command: gcc -Wall -shared -o n

CREATE FUNCTION problem

2003-10-27 Thread George Chelidze
ry to configure it with --with-mysqld-ldflags=-rdynamic? I'd like it to be installed from RPM rather source code, is there another workaround? Thanks in advance. Best Regards, -- George Chelidze -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscrib

Re: Replacing server online

2003-06-17 Thread George Chelidze
'', MASTER_PASSWORD='', MASTER_LOG_FILE='', MASTER_LOG_POS=; filling in box 2's name, and the log name and position recorded in step 3. 6. Start slave on box 1. 7. Start slave on box 2. 8. Verify box 1 looks ok 9. Direct requests to both boxes again. -- George Chelidze

Replacing server online

2003-06-17 Thread George Chelidze
them online without stopping them. I know I can tar the tables (MyISAM) and move to a new box but I have to make sure the data won't change, so I have to offline the boxes. Is there any way to do this replace transparetely? Any recommendations would be great. Thanks in advance. Regards,

Re: birthday calculation problem

2002-12-27 Thread George Chelidze
- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-ma

mysql_install_db hangs

2002-11-12 Thread George Chelidze
e tried to install mysql from source and installation finished successfully but problem still exsist when I run mysql_install_db Any ideas? -- George Chelidze - Before posting, please check: http://www.mysql.com/manual.php

bin log correction

2002-08-16 Thread George Chelidze
say there are 2 servers A and B. I have configures replication so that server A is a master and server B is a slave. so sometimes after incorrect query replication stops and the error log indicates that I should correct bin log. I dont know how. any help would be great. Regards, -- George

Re: Newbie: Help with count

2002-04-27 Thread George Chelidze
ne point me in the right direction to do it > please? I know how to get a count for all the pending messages for a > particular user ID (SELECT count(MessageID) WHERE UserID='1' AND > MessageState='PENDING