List:Database Benchmarks« Previous MessageNext Message »
From:mixo Date:July 8 2003 8:21am
Subject:Benchmarking
View as plain text  
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_file_path = rt3ibdata/ibdata1:2000M;
innodb_data_home_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.

Thread
Benchmarkingmixo8 Jul