Are you using seefusion or fusion reactor to see the longest query time per request ect? How have you determined the DB is the bottleneck?
Brook -----Original Message----- From: Jordan Michaels [mailto:[email protected]] Sent: December-03-10 12:51 PM To: cf-talk Subject: Re: OT - MySQL The MySQL workbench has load monitoring tools included with it. Here is come comprehensive documentation that covers the topic: http://www.techotopia.com/index.php/Administering_and_Monitoring_MySQL_using _the_MySQL_Workbench Hope this helps! Warm regards, Jordan Michaels Vivio Technologies http://www.viviotech.net/ Open BlueDragon Steering Committee Railo Community Distributions On 12/03/2010 12:09 PM, Alan Rother wrote: > > Hey Everyone, > > I'm helping some folks performance tune their Flex / CF Based app. I'm > pretty sure the bottleneck is happening in their DB server, but I'd like to > be able to offer some analytics beyond my best guess. > > They're using CF8 Ent and MySQL 5, the server monitor in CF8 isn't showing > me enough info about how the MySQL is performing. > > Can anyone recommend a good graphical analysis tool for MySQL similar to the > tools that come with MSSQL like SQL Server Profiler, essentially something > that can tell me how busy the DB is at any given moment. > > > =] > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339778 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
