MySQL Forums
Forum List  »  Performance

MySQL Perfomace with two DB must be so slow?
Posted by: diSmiSS Ilyin
Date: March 24, 2005 09:19AM

Sorry if i posted in wrong place (it seems to me this post must be in MySQL Usage - Newbie) but.... the folowing situation...
Computer: P4-3.0G/1Gb/150SATA
OS: FreeBSD 5.3/PHP 4.3.10/MySQL 4.0.23a
The perfomance of server is too slow.....
When i taped "top" command i see something like that:
CPU states: 67.8% ..........
and never be less then 50%. The most rated process is:
--------------------------------------------------------------------------------
PID USERNAME PRI NICE SIZE RES STATE TIME WCPU CPU COMMAND
19231 mysql 20 0 317M 294M kserel 496:35 14.75% 14.75% mysqld
.......
.......
--------------------------------------------------------------------------------
I have two DB (first about 5Mb, second (forum) - (180Mb)), and about 200-300 visitors whithin 15 minutes.

There is one thing that i couldn't explain.
When i typed in MySQL shell promt SHOW BINLOG EVENTS
-----------------------------------------------------------------------------
Log name Position Event type Server ID Original position Information
log-bin.001 79 Query 1 79 use `forum`; DELETE FROM `forum`....
log-bin.001 144 Query 1 144 use `forum`; INSERT INTO session ....
log-bin.001 618 Query 1 618 use `site`; UPDATE user SET....
log-bin.001 724 Query 1 724 use `forum`; UPDATE thread ......
log-bin.001 819 Query 1 819 use `forum`; INSERT INTO s.......
log-bin.001 957 Query 1 957 use `site`; update pm_weblog ......
.........
-----------------------------------------------------------------------------

That's all.....
And now question's:
Is MySQL realy need more process time with 200-300 visitors?
Why in each line of logfile is USE command?

PS Sorry for my bad English :(.

thank's for help....

Options: ReplyQuote


Subject
Views
Written By
Posted
MySQL Perfomace with two DB must be so slow?
2366
March 24, 2005 09:19AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.