10-12-2008
Depending on the web application, most have databases in the backend, so you will need a good database performance tuning tool.
I posted a few a few months back, mysqltuner.pl and tuning-primer.sh for MySQL.
7 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Could someone point me in the correct direction or web link containing instructions for installing the System Performance Tool (aka STP) software on an IBM-AIX version 4.? machine. My client has the software (that came from their original server) on a 3" floppy. Thanks! (1 Reply)
Discussion started by: Pam
1 Replies
2. Programming
So, I've been told and heard a million times that malloc and free are expensive calls to be avoided. So many times I avoid malloc by reusing already allocated memory blocks. Store them on free lists somewhere myself and don't call free when I know malloc will be called very shortly thereafter.
... (6 Replies)
Discussion started by: DreamWarrior
6 Replies
3. AIX
I'm doing performance testing for one application which works on AIX.
But I don't know which performance parameters of memory need to be collected. Now, I just know very few:
1. page in
2. page out
3. fre
They are all collected by "vmstat" command.
I want to know, except for above... (2 Replies)
Discussion started by: adasong
2 Replies
4. Linux
Hello friends,
I'm working on a Thesis and right now I'm in a phase of comparing a Linux vs Windows performance in similar situations on the same machine.
I'm asking here because I would like help on this, since I've always worked in Linux as an Administrator and a user, never as a... (6 Replies)
Discussion started by: lzcool
6 Replies
5. AIX
Dear experts ,
Pls advice for any good Tool to monitor the CPU and performance of AIX the system ..
to keep monitoring to show me the utilization of that system .. (12 Replies)
Discussion started by: Mr.AIX
12 Replies
6. Red Hat
Hi All,
I'm looking for good reference books or white papers about Linux Redhat Performance tuning / system tuning.
Thanks for any advice. (0 Replies)
Discussion started by: linuxqwer
0 Replies
7. Infrastructure Monitoring
Hi,
We have HP OpenView tool to extract utilization report and extract them in csv. Every month I pull 30 days CPU and Memory utilization, every 5 minutes via GUI and export it in csv (excel) format. It is always a time consuming process to run it on a set of servers and then pick next set because... (0 Replies)
Discussion started by: solaris_1977
0 Replies
LEARN ABOUT DEBIAN
mysql::diff::database
MySQL::Diff::Database(3pm) User Contributed Perl Documentation MySQL::Diff::Database(3pm)
NAME
MySQL::Diff::Database - Database Definition Class
SYNOPSIS
use MySQL::Diff::Database;
my $db = MySQL::Diff::Database->new(%options);
my $source = $db->source_type();
my $summary = $db->summary();
my $name = $db->name();
my @tables = $db->tables();
my $table_def = $db->table_by_name($table);
my @dbs = MySQL::Diff::Database::available_dbs();
DESCRIPTION
Parses a database definition into component parts.
METHODS
Constructor
new( %options )
Instantiate the objects, providing the command line options for database access and process requirements.
Public Methods
o source_type()
Returns 'file' if the data source is a text file, and 'db' if connected directly to a database.
o summary()
Provides a summary of the database.
o name()
Returns the name of the database.
o tables()
Returns a list of tables for the current database.
o table_by_name( $name )
Returns the table definition (see MySQL::Diff::Table) for the given table.
FUNCTIONS
Public Functions
o available_dbs()
Returns a list of the available databases.
Note that is used as a function call, not a method call.
COPYRIGHT AND LICENSE
Copyright (c) 2000-2011 Adam Spiers. All rights reserved. This program is free software; you can redistribute it and/or modify it under the
same terms as Perl itself.
SEE ALSO
mysqldiff, MySQL::Diff, MySQL::Diff::Table, MySQL::Diff::Utils
AUTHOR
Adam Spiers <mysqldiff@adamspiers.org>
perl v5.14.2 2012-04-06 MySQL::Diff::Database(3pm)