Re: Accesses
Just wondering how many accesses can MYSQL handle... let's say per hour. I have about 500 accesses per hour, 8 clicks per second... does anyone know about this issue? thanks I just did picard:/usr/local/mysql/bin# mysqladmin version -upferdezeitung -p Enter password: mysqladmin Ver 8.15 Distrib 3.23.33, for pc-linux-gnu on i686 Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 3.23.33 Protocol version10 Connection Localhost via UNIX socket UNIX socket /tmp/mysql.sock Uptime: 5 days 8 hours 31 min 23 sec Threads: 23 Questions: 14877669 Slow queries: 793 Opens: 17632 Flush tables: 1 Open tables: 64 Queries per second avg: 32.155 -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 ยท Fax 0(049) 5224-997 409 http://pferdezeitung.de - 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: Accesses
Just wondering how many accesses can MYSQL handle... let's say per hour. I have about 500 accesses per hour, 8 clicks per second... does anyone know about this issue? thanks It really depends on what kind of queries you're running, your hardware, your configuration, your operating system, etc. The most I've seen so far is Jeremy's box which is doing 87 queries per second, and my busiest box is currently at 60 queries per second with a system load of 0.69 (and I can't see any queries in a processlist so they're all running quickly). - 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: Accesses
On 10-Jul-01 Chris K wrote: Just wondering how many accesses can MYSQL handle... let's say per hour. I have about 500 accesses per hour, 8 clicks per second... does anyone know about this issue? thanks One of my advert sites runs about 12,000 hits in 10 minutes, each hit is 4 queries (2 select, + 2 insert). 12,000 x 4 x 6 = 288000/hour or 80/sec. MySQL 3.22.32, Linux 2.2.7 SMP 2x PII-750Mhz Dual SCSI-Wide Regards, -- Don Read [EMAIL PROTECTED] -- It's always darkest before the dawn. So if you are going to steal the neighbor's newspaper, that's the time to do it. - 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