Benchmarking

[mixo]

How can I benchmark the perfomance of Mysql with the following setup:
Perl 5.8.0 (perl-DBI, perl-DBI-Mysql)
mysql-3.23.54a-11
apache-2.0.40-21
mod_perl-1.99_07-5

I want to compare the perfomance of Mysql against that of Pg using my
own data.


And, how can I resolve :
"DBD::mysql ::st execute failed: The table 'Attachments' is full at
/usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm"

My configuration is as follows:

+++++++++++/etc/my.cnf+++++++++ ++++++++++++=
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
#InnoDB
innodb_data_fil e_path = rt3ibdata/ibdata1:2000M;
innodb_data_hom e_dir = /var/lib/mysql

[mysql.server]
user=mysql
basedir=/var/lib

[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
+++++++++++/etc/my.cnf+++++++++ ++++++++++++=

I have an additional 11Gig partition which is not is use.


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=m...ie.nctu.edu.tw