RE: slave is running slow in another data center

IO thread is way ahead then SQL 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 cent

slave is running slow in another data center

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 slaves.

FW: Row level security in MySQL

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

Row level security in MySQL

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 fine

FW: MySQL install problem on RH 3.0 IA64

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: /usr

MySQL install problem on RH 3.0 IA64

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 pinhpe02

Space allocation info for MyISAM tables

I have a requirement where I have to accept only two parameters in script for space and other calculation i.e. -i -o 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 allocated Total space u

Udf_Example.so compilation error with gcc

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/sql>gcc -shared -I/usr/local/mysql-4.0.14/include -o myfunc.so myfunc.cc In file included from myfunc.cc:122: /usr/loca

RE: MySQL to syslog

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, -O

RE: Error while using Mysqldump

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

Error while using Mysqldump

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 '

Mysqlhotcopy usage problem

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: /opt/pe

RE: mysql query output get wrapped

Try -E option or put "\g" in end of your sql statement like below Mysql -u -p -E -e "show innodb status" OR Mysql -u -p -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: Tuesda

RE: copying

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 scr

RE: copying

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 PROTE