Re: A question about load / queries pr second
Hello Terje, Friday, September 07, 2001, 12:11:30 PM, you wrote: TK> I have a HP-UX server with Perl 5.005_03, MySQL 3.23.39 for hp-hpux11.00 TK> (hppa2.0w), TK> Apache/1.3.20. TK> The load are rather high, and "Queries per second avg: 94.859" TK> This is an local B2B installation som we are really not getting any traffic TK> between 4PM and 7AM TK> We have peeks where there is more than 1000 Queries per second. TK> Does anyone have any experience with a higher number of queries pr second TK> than this ? There can be lot of queries such as 'SELECT 1' which won't actually make high CPU load on server and there can be few queries with several joins without using keys which can almost kill the server. It depends. I have server which handles about 300-400 queries per second and serves for ~30 websites. TK> Regards TK> Terje K TK> - TK> Before posting, please check: TK>http://www.mysql.com/manual.php (the manual) TK>http://lists.mysql.com/ (the list archive) TK> To request this thread, e-mail <[EMAIL PROTECTED]> TK> To unsubscribe, e-mail <[EMAIL PROTECTED]> TK> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Best regards, Vinchemailto:[EMAIL PROTECTED] - 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
LOAD table from master failure
Hello mysql, I just tried to build replica on the fly and encountered strange problem. When I do "LOAD table stopword from master" it hangs forever and in logs I'm getting this 010529 14:04:13 Duplicate key 1 for record at 315 against new record at 0 010529 14:04:13 fetch_nx_table: failed on create table I don't think 315 is a row number because mysql> select count(*) from stopword; +--+ | count(*) | +--+ | 99 | +--+ 1 row in set (0.00 sec) On the replica server I have mysql> select count(*) from stopword; +--+ | count(*) | +--+ |0 | +--+ 1 row in set (0.00 sec) Neither CHECK nor REPAIR table stopword on master give me an error. I don't know what to now. Maybe someone help me? Table definition: CREATE TABLE stopword ( word char(32) NOT NULL default '', lang char(2) NOT NULL default '', PRIMARY KEY (word,lang) ) TYPE=MyISAM; -- Best regards, Vinche mailto:[EMAIL PROTECTED] - 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
Is MySQL BeoWulf compatible?
Subj. Can I set it up on a cluster? I have so heavy load on my MySQL server that I need to increase the power of my server. I consider different ways of doing it and want to know if somebody installed it successfully on a cluster. Best regards, Vinche mailto:[EMAIL PROTECTED] - 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
Occasional hang of mysql
Hi there! I encounterd with a problem recently. Mysql occasionally hangs so that it can't be killed with -SIGKILL, that is there is one thread persist after killall -9 mysqld and it can't be killed in any way. The only way to get mysql back to work is server reboot. I'm using mysql-3.23.37 on RedHat 6.2 linux kernel 2.4.3. It happens both on binary distribution and on myself compiled one. It can't be predicted and mysql can work the whole day without hang or it can hang in 5 minutes after reboot. Is there somebody that have the same troubles or maybe someone can help me. Thanks. Victor. - 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