European Experts Exchange (EEE.org) :: Free Experts PHP MySql Oracle Microsoft Web SQL Delphi


Databases :: MySql :: MYSQL PErformance
By: Squibi	Date: 10/09/2004 20:00:00	Points: 25	Status: Answered Quality : Excellent
Hi All How can i check the mysql performance menas i want to check that how much quires generated per sec in this mysql can handle any good site for that. Thanks
By: VGR	Date: 10/09/2004 22:13:00		Type : Answer
status mysql> status -------------- mysql Ver 11.15 Distrib 3.23.46, for Win95/Win98 (i32) Connection id: 148843 Current database: Current user: root@localhost Server version: 3.23.46-nt Protocol version: 10 Connection: . via named pipe Client characterset: latin1 Server characterset: latin1 UNIX socket: MySQL Uptime: 5 days 20 hours 32 min 58 sec Threads: 102 Questions: 5584636 Slow queries: 5 Opens: 9145 Flush tables: 1 Open tables: 9 Queries per second avg: 11.037 you can also have this in the GUI "winmysqladmin", tab "server status" I think (the default one)

By: Squibi	Date: 10/09/2004 22:29:00		Type : Comment
thanks for this info but i need is there any fact and figures that tell me that how much quires handel this mysql per sec. thanks

By: VGR	Date: 10/09/2004 22:52:00		Type : Comment
Queries per second avg: 11.037 it was written...

Do register to be able to answer

©2010 These pages are served without commercial sponsorship. (No popup ads, etc...). Bandwidth abuse increases hosting cost forcing sponsorship or shutdown. This server aggressively defends against automated copying for any reason including offline viewing, duplication, etc... Please respect this requirement and DO NOT RIP THIS SITE.
Please DO link to this page! Post to Plurk Post to Yahoo Buzz Post to Delicious Post to Digg Post to MySpace Post to Ping.fm Post to Reddit Post to StumbleUpon

Contact

page generated in 298.912050 milliseconds

Why Google AdSense ads ?

New Improved Search!