Dear All,
we have developed a web-based application for a client
and now in its testing phase by next week...
It uses Linux/PHP 4/MySQL 3.23
As the volume of user will be more, we are very much
concerned about the server efficiency and our
application efficiency/performance...
Following are the one we need to database server...
1. server performance
2. the database load
3. efficiency query
4. execution time
5. how many inserts/updates taking place
6. volume of data involved
and so on...
Is there any tools available for this?
Any idea about testing the mysql server?
Thanks a lot.
Shankar
Server Load Testing
Moderator: General Moderators
-
psmshankar
- Forum Commoner
- Posts: 96
- Joined: Tue Aug 06, 2002 4:25 am
- Location: India
the documentation at mysql.com offers some hints

- i.e.
- http://www.mysql.com/doc/en/MySQL_Optimisation.html
- http://www.mysql.com/doc/en/SHOW_STATUS.html
- http://www.mysql.com/doc/en/Slow_query_log.html
- http://www.mysql.com/doc/en/ANALYZE_TABLE.html
- http://www.mysql.com/doc/en/EXPLAIN.html
- http://www.linux-mag.com/2001-06/mysql_01.html
- http://www.linux-mag.com/2001-12/mysql_01.html
-
psmshankar
- Forum Commoner
- Posts: 96
- Joined: Tue Aug 06, 2002 4:25 am
- Location: India