RE: Replication with HEAP tables slave insert error
Hi Egor, Thanks for the reply. My responses below - Vinod Panicker [EMAIL PROTECTED] wrote: Hi, Had a query regarding replication with HEAP tables. It seems like I cannot use LOAD DATA FROM MASTER to update the stopped slave with data from the master since it apparently works only for MyISAM tables. Any other way of updating the slave with a snapshot of the data? Since a HEAP table doesn't create a disk file, I cant get a snapshot using tar. You can use mysqldump utility on your master and then run SQL script on the slave. --- Now why didn't I think of this! Also, the slave stopped due to an error of a duplicate key! Why should it have a problem with inserting data that went through fine on the master? Could you describe your problem more detailed? What is the table type? Did it happen with HEAP table? What is the failed query? --- The slave got an error running an insert into a 4 field table with a primary key set on a column 'userid'. The slave SQL thread apparently stopped and the slave IO thread continued running, but the table stopped getting updated. The table type again was HEAP. Tx, Vinod. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Replication with HEAP tables slave insert error
Hi, Had a query regarding replication with HEAP tables. It seems like I cannot use LOAD DATA FROM MASTER to update the stopped slave with data from the master since it apparently works only for MyISAM tables. Any other way of updating the slave with a snapshot of the data? Since a HEAP table doesn't create a disk file, I cant get a snapshot using tar. Also, the slave stopped due to an error of a duplicate key! Why should it have a problem with inserting data that went through fine on the master? All help is welcome. Tx, Vinod. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Re: max connections
hey, thanks for replying so soon. the max limit of files and inodes have been increased on the system. So that is not a problem. But what i really meant to ask was if mysql scales well over 1000 connections (assuming that i'm not having any external problems like the OS for instance). Tx. Vinod - Original Message -- "Jorge del Conde" [EMAIL PROTECTED] wrote: To:[EMAIL PROTECTED], "vinod panicker" [EMAIL PROTECTED] From:"Jorge del Conde" [EMAIL PROTECTED] Date:Sat, 3 Mar 2001 01:17:41 -0600 Subject: Re: max connections Hi, The maximum number of connections that mysql can accept is restricted by both: the OS and ulimit. In other words, you can set max_connections as high as you want without bypassing the limits specified in ulimit. If you do ulimit -n you should get the number of connections allowed (1024 by default I think) .. Read section 21.3 in the manual for having several servers running on different ports on the same machine. Regards, Jorge MySQL Development Team __ ___ __ __ / |/ /_ __/ __/ __ \/ / Jorge del Conde [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\/ Mexico City, Mexico ___/ - Original Message - From: "vinod panicker" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, March 02, 2001 1:09 PM Subject: max connections hey, i'm developing a product that heavily utilizes mysql databases through PHP. The max number of connections that any server can handle is needed as i have to think of scaleability issues. The servers are pretty powerful - it maxes out at 4G's 2x850 P-III. I need max performance out of this box. It will be accessed by multiple web servers. I also wanted to know if I can have 2 mysql servers on the same machine accessing and serving data from the *same* database... also, at what number of connections does mysql go for a toss? Tx. Vinod _ Chat with your friends as soon as they come online. Get Rediff Bol at http://bol.rediff.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Re: Re: max connections
thanks a million... i've got another problem that i've been struggling with for a long time now. It needs to be fixed fast.. running out of time... the problem is this - i'm using PHP to connect to mysql using mysql_connect(). The script runs fine till a certain number of users. This 'certain number' keeps changing. When the machine is rebooted, the server supports around 150 clients... but soon restarts and i get mysql connection failed in the script. I ran the servers with logging enabled, but the restart is not caused by any specific query as such. In the .cnf file, i've just increased the max_connections variable. The server runs smoothly for some time and then it just restarts without any warning... nothing in the .err file too! weird... any hope, suggestions? Tx. Vinod - Original Message -- "Jorge del Conde" [EMAIL PROTECTED] wrote: To:"vinod panicker" [EMAIL PROTECTED] From:"Jorge del Conde" [EMAIL PROTECTED] Date:Sat, 3 Mar 2001 03:51:30 -0600 CC:[EMAIL PROTECTED] Subject: Re: Re: max connections Hi, If you want to have 1000+ connections, you will need to modify and recompile LinuxThreads. Afterwards, you'll need to recompile MySQL while linking with the new libpthread.a library. Check the following section from the manual: http://www.mysql.com/doc/L/i/Linux.html Regards, Jorge MySQL Development Team __ ___ __ __ / |/ /_ __/ __/ __ \/ / Jorge del Conde [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\/ Mexico City, Mexico ___/ - Original Message - From: "vinod panicker" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Saturday, March 03, 2001 2:52 AM Subject: Re: Re: max connections hey, thanks for replying so soon. the max limit of files and inodes have been increased on the system. So that is not a problem. But what i really meant to ask was if mysql scales well over 1000 connections (assuming that i'm not having any external problems like the OS for instance). Tx. Vinod - Original Message -- "Jorge del Conde" [EMAIL PROTECTED] wrote: To:[EMAIL PROTECTED], "vinod panicker" [EMAIL PROTECTED] From:"Jorge del Conde" [EMAIL PROTECTED] Date:Sat, 3 Mar 2001 01:17:41 -0600 Subject: Re: max connections Hi, The maximum number of connections that mysql can accept is restricted by both: the OS and ulimit. In other words, you can set max_connections as high as you want without bypassing the limits specified in ulimit. If you do ulimit -n you should get the number of connections allowed (1024 by default I think) .. Read section 21.3 in the manual for having several servers running on different ports on the same machine. Regards, Jorge MySQL Development Team __ ___ __ __ / |/ /_ __/ __/ __ \/ / Jorge del Conde [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\/ Mexico City, Mexico ___/ - Original Message - From: "vinod panicker" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, March 02, 2001 1:09 PM Subject: max connections hey, i'm developing a product that heavily utilizes mysql databases through PHP. The max number of connections that any server can handle is needed as i have to think of scaleability issues. The servers are pretty powerful - it maxes out at 4G's 2x850 P-III. I need max performance out of this box. It will be accessed by multiple web servers. I also wanted to know if I can have 2 mysql servers on the same machine accessing and serving data from the *same* database... also, at what number of connections does mysql go for a toss? Tx. Vinod _ Chat with your friends as soon as they come online. Get Rediff Bol at http://bol.rediff.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Re: Scaling mysql
hey, replication was ruled out coz the writes are very very frequent. and consistency of data is a very important issue. tx. vinod - Original Message -- "Jason Landry" [EMAIL PROTECTED] wrote: To:[EMAIL PROTECTED], "vinod panicker" [EMAIL PROTECTED] From:"Jason Landry" [EMAIL PROTECTED] Date:Sat, 3 Mar 2001 03:38:10 -0600 CC:[EMAIL PROTECTED] Subject: Re: Scaling mysql Have you considered replication? There's a pretty good chapter in the MySQL manual on how to objectively determine the benefit to a master/slave setup with n slaves (it depends on how often writes happen to the database). - Original Message - From: "vinod panicker" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Friday, March 02, 2001 1:24 PM Subject: Scaling mysql hey, i'm having a problem with scaling a mysql server. This is the situation... i have a database with 5 tables containing user data. Except one, all the other tables have only 2 fields. This data is queried often and needs to be accessed by multiple web servers. Each table would contain something like 500,000 to 1,000,000 records. I'm using PHP to access the mysql database. The system would be experiencing loads of 5000 concurrent users. Tips on how to scale this database to handle such a load would be very helpful. The H/W is pretty good - 2 gigs of RAM and a dual CPU. Tx. Vinod. _ Chat with your friends as soon as they come online. Get Rediff Bol at http://bol.rediff.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ Chat with your friends as soon as they come online. Get Rediff Bol at http://bol.rediff.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
max connections
hey, i'm developing a product that heavily utilizes mysql databases through PHP. The max number of connections that any server can handle is needed as i have to think of scaleability issues. The servers are pretty powerful - it maxes out at 4G's 2x850 P-III. I need max performance out of this box. It will be accessed by multiple web servers. I also wanted to know if I can have 2 mysql servers on the same machine accessing and serving data from the *same* database... also, at what number of connections does mysql go for a toss? Tx. Vinod _ Chat with your friends as soon as they come online. Get Rediff Bol at http://bol.rediff.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php