VT’s Tech Blog

MySQL Activity Report

Here’s a cool utility for MySQL administrators which allows you to track the performance of your servers and also gives you performance enhancement tips. You can see a sample report from this tool over at: http://gert.sos.be/demo/mysqlar/
The MySQL Activity Report package is a tool to help MySQL database administrators to collect several database parameters and variables. These collected values can be used for server monitoring or performance tuning purposes.

Link: MySQL Activity Report

For Installation Instructions, head over to: http://www.linuxforums.org/forum/servers/72890-how-mysql-activity-report.html

Posted in Databases, Software | No Comments »

Zend Framework 0.7.0 Released

Zend had released their latest version 0.7.0 of Zend Framework, which include a lot more updates from their previous verison including Locale related, and measurement conversion functionalities. They also seem to have a new Zend_Memory class which is an API to manage large data in a limited amount of memory to overcome the memory limits imposed on PHP scripts on most servers. I’ll be test driving this functionality soon
Zend Framework Preview Release 0.7.0 includes many significant features and enhancements:

• Locale-management component
• Locale-aware Date parsing and formatting class
• New translation-management component with gettext support
• Comprehensive class for working with measurements and conversions
• New prototype class for filtering and validation parameters
• New class for managing memory usage in PHP applications
• Many other improvements in current components such as MVC, Session, Gdata, HTTP Client, Search, XmlRpc, and others
• Many other enhancements to test suites and documentation.

Link to release announcement: Zend Developer Zone | Zend Framework 0.7.0 Released

Download: http://framework.zend.com/download

Posted in PHP | No Comments »

Innodb locking and Foreign Keys

Here’s a MySQL tip from the MySQL Performance Blog which deals with possible lock situations while using InnoDB and foreign keys.

Today I was working with application which uses Innodb and foreign keys and got into locking problems possibly due to foreign keys, so I did a little investigation on that matter.

Peter Zaitsev goes on to outline an example of when this could happen and warns developers to look at locking overheads while implementing foreign keys in Innodb

Link: MySQL Performance Blog » Innodb locking and Foreign Keys

Posted in Databases | No Comments »