filter: sql, mysql, query *bites filter :-]*
Hi gang.
I have the following problem facing me: Currently, we are utilizing
mysql to handle our business data needs. To this end, we have lots of
customers who access their data through a web-based interface. That
accounts for probably around 2-5% of the usage. We are also utilizing
data from customer logins via radius to permit mail sending via a heap
table that stores their login name, their IP address, and when they
logged in (for pruning the table down later). This table is also is
queried by our mail servers for mail access -- If they're listed, they
can relay, if they're not, they can't. This traffic (the radius servers
placing the accounting info into the table, and the mail servers
searching it) account for about, I would say, 65-70% of the traffic to
the database. I have optimized the queries, and they do execute
reasonably fast. Generally, the number of queries is in the range of
40-70 per second, but I have seen it has high as 1918 queries per second
(Wow!). We also have other things that query the database, but by in
large, the rest each account for only a small portion of the data
utilization.
I guess the utilization goes in this order:
Radius transactions
Mail Server transactions
Other (billing, customer modification, etc etc.)
MySQL Info:
Version:
3.23.51-log
Status:
Uptime: 1105153 Threads: 160 Questions: 50002315
Slow queries: 15428 Opens: 19239 Flush tables: 1
Open tables: 255 Queries per second avg: 45.245
(or about 4 million queries per day.)
Hardware:
This machine is an Athlon at ~1350MHz, with 768MB of ram.
It has ~220GB of disk space (3*70GB Seagate 10k RPM SCSI-3
160MB/s disks).
The cpu utilization by mysql on this machine is generally in the range
of 8 to 20 percent. Maybe 3% of the time the cpu utilization exceeds
40%.
Should I be looking to my applications for the performance issues?
(radius - written in perl, postfix) What do you all suggest I do next?
Many thanks in advance,
Gabriel.
--
Gabriel Cain
Unix Systems Administrator [EMAIL PROTECTED]
Dialup USA, Inc. 888-460-2286 ext 208
Faster, Better, Cheaper: Pick any two.
---------------------------------------------------------------------
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
