~Replication errors~

Hi, Iam getting the following error on my Mysql Slave server. This happened when my disk space got full and there was no space left on the device. I managed to free up some space and then ran mysql STOP SLAVE mysql CHANGE MASTER TO MASTER_LOG_FILE='mysql-bin.000110', MASTER_LOG_POS=850202232;

Re: ~Mysql performance~

Hi, The Server2 is not a slave. Seperate inserts were done on two different mysql servers. Thanks, Abdul. On Fri, 2006-04-28 at 12:01 -0400, Kishore Jalleda wrote: On 4/28/06, Mohammed Abdul Azeem [EMAIL PROTECTED] wrote: Hi, I have 2 mysql servers with version

Re: ~Mysql performance~

Hi, The insert queries are run from the localhost on both the machines. -Abdul On Fri, 2006-04-28 at 10:28 -0700, Atle Veka wrote: On Fri, 28 Apr 2006, Mohammed Abdul Azeem wrote: Hi, I have 2 mysql servers with version 5.0.15-standard-log running on redhat es4 installed on 2

~Mysql performance~

Hi, I have 2 mysql servers with version 5.0.15-standard-log running on redhat es4 installed on 2 different geographic locations. The default storage engine used is innodb on both the servers. I run an insert query on both the servers that inserts 25,00,000 records. first server takes 7.5 hrs,

Re: ~Mysql performance~

Hi, The following is the hard disk specs for both the servers: server one: ( whose performance is good ) --- class: HD bus: IDE detached: 0 device: hda driver: ignore desc: ST3200822A physical: 16383/16/63 logical: 24321/255/63 - class: HD bus: IDE detached: 0 device: hdb driver: ignore

Re: ~Mysql performance~

Hi, I would like to make one correction. The server one has 2 IDE hard disks and not SATA hard disks. Thanks, Abdul. On Fri, 2006-04-28 at 16:33 +0530, Mohammed Abdul Azeem wrote: Hi, The following is the hard disk specs for both the servers: server one: ( whose performance is good

Re: MySQLDump and Restore

Hello Jim, mysql -u root -p ROOTPASSWD dump.sql Thanks, Abdul. On Fri, 2006-04-21 at 17:02 +1000, Jim wrote: Hi All, Am using mySQLDump to backup db as follows mysqldump --databases OURDB -uroot -pROOTPASSWRD dump.sql How can I restore OURDB from dump.sql? Thanks

~Master Slave setup on the same machine~

Hi, Is it possible to configure a master and slave server on the same machine ? I have 3 instances of mysql running on the same server. I need to replicate a database from one server to other 2 servers. Any links or suggestions required regarding the same. Thanks in advance, Abdul.

~mytop output~

Hi, Iam using mytop script to monitor the processes on mysql server. This is output from mytop: MySQL on localhost (5.0.15-standard-log) up 0+02:24:46 [13:08:20] Queries: 22.6M qps: 2733 Slow: 0.0 Se/In/Up/De(%): 00/00/00/00 qps now: 2801 Slow qps: 0.0 Threads:8 (

RE: ~ How to install 3 instances of mysql~

'; use mysql; update user set password=password('password') where user='root'; flush privileges Regards, Rich -Original Message- From: Mohammed Abdul Azeem [mailto:[EMAIL PROTECTED] Sent: Saturday, April 15, 2006 12:53 AM To: mysql@lists.mysql.com Subject: ~ How to install 3

RE: ~ How to install 3 instances of mysql~

: ~ How to install 3 instances of mysql~ On Sat, 15 Apr 2006, Mohammed Abdul Azeem wrote: To: [EMAIL PROTECTED] From: Mohammed Abdul Azeem [EMAIL PROTECTED] Subject: Re: ~ How to install 3 instances of mysql~ Hello Keith, Thank you very much for your guidence. This is my

~ How to install 3 instances of mysql~

Hi, I need to install 3 instances of mysqld server on a single machine. Can anyone let me know how this can be acheived ? It would be helpful if someone can send me some links and suggestions regarding the same. Also pls lemme know what kind of a configuration file i need to have in order to

Re: ~ How to install 3 instances of mysql~

Apr 2006, Mohammed Abdul Azeem wrote: To: mysql@lists.mysql.com From: Mohammed Abdul Azeem [EMAIL PROTECTED] Subject: ~ How to install 3 instances of mysql~ Hi, I need to install 3 instances of mysqld server on a single machine. Can anyone let me know how this can be acheived

~problem with select into outfile~

Hi Iam having a problem using select into outfile command, iam getting the following error. can anyone help me trace the problem. mysql SELECT * INTO OUTFILE'/home/public1/data.txt' FROM temp_table WHERE last_time_update = 2006-04-01; ERROR 1 (HY000): Can't create/write to file

~Mysql db crashing again and again~

Hi, Iam having a mysql version 5.0.15-standard-log installed on redhat es4. It is configured as slave server. It was running fine till yesterday. Then it hit a mysql bug with signal 6. The mysql db was throwing the following errors on the shell prompt ie the OS shell prompt. *** glibc detected

Re: ~performance issues~

Thanks Ravi On Tue, 2006-04-11 at 11:41 +0530, Ravi Prasad LR wrote: yes, that is the reason for slowness . Thanks, Ravi On Tuesday 11 April 2006 10:51, Mohammed Abdul Azeem wrote: Hi Ravi, Since the sync'ing is done to disk with sync_binlog=1, the update queries to server

~performance issues~

Hi, I have a master/slave setup ( replication enabled ) for mysql in two different geographic locations ( one master/slave set up in each location). In one location i have configured the sync_binlog=1 . And the other location does not have the same. My problem is, when i run similar update

Re: ~performance issues~

the binary log; but it is also the slowest choice (unless the disk has a battery-backed cache, which makes sync'ing very fast). This variable was added in MySQL 4.1.3. /snip --Ravi On Tuesday 11 April 2006 10:22, Mohammed Abdul Azeem wrote: Hi, I have a master/slave

~How to load a mysql data file into sybase~

Hello, I have a mysql data bcp file ( using select into outfile ) from a table in mysql database. I have a similar table existing in a sybase database. I need to bcp in the mysql data file into sybase. Can anyone help me on how to go about the same ? Thanks in advance, Abdul.

~how to add a new innodb data file~

Hi, Iam running a mysql server 5.0.15 over Redhat linux es4. My disk space has exhausted. so i need to add a new ibdata file to my /etc/my.cnf configuration. I followed the following procedure to do so. 1. I checked the ibdata1 file size. when i do a du -sh ibdata1 , i get the size to be 443M

RE: ~Mysql cluster info~

is def. on the large size for a MySQL Cluster configuration. Jimmy Guerrero, Senior Product Manager MySQL Inc, www.mysql.com -Original Message- From: Mohammed Abdul Azeem [mailto:[EMAIL PROTECTED] Sent: Monday, March 20, 2006 9:33 PM To: mysql@lists.mysql.com

~BCP for mysql~

Hi, Can we any use bcp to perform bulk copy for MYSQL as in SYBASE ? If not, is there any other tool which can do the same operation. I need to perform a bcp out from Mysql and then bcp in to Sybase. Please help me out regarding the same. Thanks in advance, Abdul.

~Mysql cluster info~

Hi, Iam new to clustering in mysql. I went through the reference manual 5.0 and found that the RAM memory requirements for implementing a cluster is almost twice the size of the database. My problem is i have a database which is 55GB. So does it mean that i need to have 110 GB RAM memory ? Can

Re: ~~Info needed~~

Hi Green Eugene, Thanks a lot. On Fri, 2006-03-10 at 09:57 -0500, [EMAIL PROTECTED] wrote: Косов Евгений [EMAIL PROTECTED] wrote on 03/10/2006 07:53:37 AM: Hm... It seems to me In MySQL there's no such thing as database owner. Or am I missing something? Mohammed Abdul Azeem

~~Info needed~~

Hi, How to check for the database owner for a particular database ? The way show procedure status command lists the definer column, Is there a command that shows the database owner. Similarly, what is the command to see the owner of a table in a database ? Thanks in advance, Abdul.