RE: slave is running slow in another data center

2008-06-18 Thread Sagar, Sanjeev
thread. It's a SQL thread, which is not able to keep up. On 6/18/08, Sagar, Sanjeev [EMAIL PROTECTED] wrote: Hello All, I've 4 slaves of a master. Out of 4, 3 are in same data center and have no issues. The fourth one is in another data center and some time that slave sql_thread lag

slave is running slow in another data center

2008-06-17 Thread Sagar, Sanjeev
Hello All, I've 4 slaves of a master. Out of 4, 3 are in same data center and have no issues. The fourth one is in another data center and some time that slave sql_thread lag behind more then 5000 sec. It's only sql_thread, which slow down. All H/W, S/W and my.cnf files are same for all

Row level security in MySQL

2004-05-11 Thread Sagar, Sanjeev
Hello All, I have a requirement where I have to implement the Oracle fine grain access control functionality in MySQL 4.0.19 Any ideas will be highly appreciable that how can I implement this in MySQL. I know how to do it in Oracle but not sure if MySQL can do this. For details about Oracle

FW: Row level security in MySQL

2004-05-11 Thread Sagar, Sanjeev
Thanks ! -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 11, 2004 10:28 AM To: Sagar, Sanjeev; [EMAIL PROTECTED] Subject: Re: Row level security in MySQL At 10:16 -0500 5/11/04, Sagar, Sanjeev wrote: Hello All, I have a requirement where I have

Space allocation info for MyISAM tables

2004-04-22 Thread Sagar, Sanjeev
I have a requirement where I have to accept only two parameters in script for space and other calculation i.e. -i instance_name -o outfile My instance can have multiple databases and can have MyISAM and Innodb table type both. I am looking for following info for MyISAM tabel type Total space

MySQL install problem on RH 3.0 IA64

2004-04-22 Thread Sagar, Sanjeev
Hello Everyone, We are already working with MySQL support on this issue but just wondering if there are anyone using MySQL database on RH 3.0. Following is our O/S and DB version info O/S : Red Hat Enterprise Linux AS release 3 (Taroon Update 1) Kernel 2.4.21-9.ELsmp on an x86_64 Linux

FW: MySQL install problem on RH 3.0 IA64

2004-04-22 Thread Sagar, Sanjeev
Small correction : Kernel 2.4.21-9.ELsmp on an x86_64 is not valid in this case. It came form another machine. Real kernel version is Linux pinhpe02 2.4.21-9.EL #1 SMP Thu Jan 8 16:54:40 EST 2004 ia64 ia64 ia64 GNU/Linux MySQL: mysql-pro-4.0.18-unknown-linux-ia64 Problem Description:

Udf_Example.so compilation error with gcc

2003-09-25 Thread Sagar, Sanjeev
Hello All, I am trying to compile udf_example.cc or myfunc.cc (copy of udf_example) with gcc on Solaris 2.8 but facing following errors [EMAIL PROTECTED]:/usr/local/mysql-4.0.14/sqlgcc -shared -I/usr/local/mysql-4.0.14/include -o myfunc.so myfunc.cc In file included from myfunc.cc:122:

RE: MySQL to syslog

2003-08-15 Thread Sagar, Sanjeev
I am not sure that MySQL can directly log to syslog but Unix provide this logger - make entries in the system log logger [-t tag] [-p pri] [-i] [-f file] [message...] So you use MysQL to put messages in a file and then use logger to send it to syslogs. This is how we do it too. Regards,

Error while using Mysqldump

2003-07-16 Thread Sagar, Sanjeev
Hello All, I am using Mysql 4.0.13-max-log on Solaris 2.8 If I run mysqldump like below /usr/local/mysql/bin/mysqldump -u root -pabc -d -r /usr/local/mysql/testbackup/schemadump.sql --all-databases It abort with following error /usr/local/mysql/bin/mysqldump: Can't get CREATE TABLE for table

RE: Error while using Mysqldump

2003-07-16 Thread Sagar, Sanjeev
This issue is closed. THANKS ! -Original Message- From: Sagar, Sanjeev Sent: Wednesday, July 16, 2003 3:28 PM To: [EMAIL PROTECTED] Cc: Sagar, Sanjeev Subject: Error while using Mysqldump Hello All, I am using Mysql 4.0.13-max-log on Solaris 2.8 If I

Mysqlhotcopy usage problem

2003-06-05 Thread Sagar, Sanjeev
Hello All, I am facing following error while I am trying to use mysqlhotcopy utility for hot backups. I am not sure that how can I check the perl correct installation. Please see below [EMAIL PROTECTED]:/usr/local/mysql/bin mysqlhotcopy --help Can't locate DBI.pm in @INC (@INC contains:

RE: copying

2003-06-04 Thread Sagar, Sanjeev
I tried mysqldump in past but it do come INSERT statement (with DATA). Is there any option if you just need schema. I might have missed it. Appreciate it, -Original Message- From: Cal Evans [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 03, 2003 9:51 AM To: [EMAIL PROTECTED]; [EMAIL

RE: copying

2003-06-04 Thread Sagar, Sanjeev
Please ignore my first mail. I got the answer in next email. Regards, -Original Message- From: Cal Evans [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 03, 2003 9:51 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: copying use mysqldump to just dump the schema. Then edit the

RE: mysql query output get wrapped

2003-06-04 Thread Sagar, Sanjeev
Try -E option or put \g in end of your sql statement like below Mysql -u id -ppasswd -E -e show innodb status OR Mysql -u id -ppasswd -e show innodb status \g I am not sure it is little g or capital G. Try both way. -Original Message- From: Asif Iqbal [mailto:[EMAIL PROTECTED] Sent: