osCommerce and osCMax shopping cart software forums

Shopping Cart Software

osCommerce with teeth!

 

Monitor performance mysql

This is a discussion on Monitor performance mysql within the New osCommerce Contributions forums, part of the osCommerce 2.2 Forums category; Some servers do not allow slow_queries to be monitored. This contribution creates a text log file in your catalog/slow_queries ...


Go Back   osCommerce and osCMax shopping cart software forums > osCommerce 2.2 Forums > New osCommerce Contributions

Register FAQ Members List Calendar Mark Forums Read


Free community membership! Fast easy FREE membership
Reply

 

LinkBack Thread Tools
  #1  
Old 10-02-2007, 08:10 AM
michael_s's Avatar
osCMax Developer

 
Join Date: Jul 2002
Location: Phoenix, AZ
Posts: 10,203
Thanks: 66
Thanked 291 Times in 277 Posts
Rep Power: 10
michael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond repute
Post Monitor performance mysql

Some servers do not allow slow_queries to be monitored. This contribution creates a text log file in your catalog/slow_queries directory that contains information about slow queries. This version does not alter the database as this interferes with OSCommerce insert queries.
The previous version of this contrib inserted orders in the database using an incorrect ID if a slow query was encountered, causing problems. This version writes the slow queries log to a file on your server instead of inserting them into the database.

- ability to check and see the bottleneck queries in the admin backend under the tools menu.
- ability to see the location of the queries.(filename in which the query run- this is cool becuase now we can easily spot the queries location)
- for everyone that does not have access to MYSQL_SLOW_QUERIES
- delete all records
This is a full package.


More...
__________________
Michael Sasek
osCMax Developer


osCMax Templates - Hundreds of premium quality templates. New designs every month!

xShop for osCMax - Windows Based osCMax administration. Improved workflow, security, speed and convenience


osCMax Hosting - From basic hosting to High Availability, Load Balanced arrays, the most experienced osCMax host.

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply



Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads

Thread Thread Starter Forum Replies Last Post
Monitor performance mysql michael_s New osCommerce Contributions 0 08-24-2007 07:22 AM
Monitor performance mysql michael_s New osCommerce Contributions 0 07-20-2007 09:11 AM
Monitor performance mysql michael_s New osCommerce Contributions 0 02-04-2007 04:16 AM
Site Monitor Question judoka osCMax v1.7 Discussion 0 07-18-2005 09:31 AM
MySQL? Please help! extremenewb osCommerce 2.2 Installation Help 3 09-22-2004 07:31 AM


All times are GMT -8. The time now is 07:03 PM.


Powered by vBulletin®
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO
Copyright 2008 osCMax