Messages in this thread | | | From | "Heikki Tuuri" <> | Subject | Re: 2.6.0-test2-mm3 and mysql | Date | Sun, 3 Aug 2003 13:43:12 +0300 |
| |
Andrew,
----- Original Message ----- From: "Andrew Morton" <akpm@osdl.org> To: "Heikki Tuuri" <Heikki.Tuuri@innodb.com> Cc: <linux-kernel@vger.kernel.org> Sent: Sunday, August 03, 2003 12:27 PM Subject: Re: 2.6.0-test2-mm3 and mysql
> "Heikki Tuuri" <Heikki.Tuuri@innodb.com> wrote: > > > > What to do? People who write drivers should run heavy, multithreaded file > > i/o tests on their computer using some SQL database which calls fsync(). For > > example, run the Perl '/sql-bench/innotest's all concurrently on MySQL. If > > the problems are in drivers, that could help. > > Well there's a problem. We're kernel people, not database people. I, for > one, would not have a clue how to set such a thing up. > > If someone could prepare a simple-enough-for-kernel-people description of > how to get such a test up and running, then we might make some progress.
ok :).
1. Download
from http://www.mysql.com/downloads/mysql-4.0.html:
MySQL-server-VERSION.i386.rpm The MySQL server. You will need this unless you only want to connect to a MySQL server running on another machine. Please note that this package was called MySQL-VERSION.i386.rpm before MySQL 4.0.10.
MySQL-client-VERSION.i386.rpm The standard MySQL client programs. You probably always want to install this package.
MySQL-bench-VERSION.i386.rpm Tests and benchmarks. Requires Perl and the DBD-mysql module.
MySQL-shared-compat-VERSION.i386.rpm This package includes the shared libraries for both MySQL 3.23 and MySQL 4.0. Install this package instead of MySQL-shared, if you have applications installed that are dynamically linked against MySQL 3.23 but you want to upgrade to MySQL 4.0 without breaking the library dependencies. This package is available since MySQL 4.0.13. (these are named 'Dynamic client libraries (including 3.23.x libraries)' on the download page).
Do NOT use the MySQL distro which comes with Red Hat distros. It is old and may not be properly built. Only use binaries downloaded from www.mysql.com.
2. Install with
shell> rpm -i MySQL-server-VERSION.i386.rpm MySQL-client-VERSION.i386.rpm
etc.
3. I am assuming that you have Perl which comes in most Linux distros. You probably also have the MySQL DBI/DBD module in your Linux distro. It will use those MySQL-shared-compat client libraries.
http://search.cpan.org/author/JWIED/DBD-mysql-2.1026/lib/DBD/mysql/INSTALL.pod: " Red Hat Linux
As of version 7.1, Red Hat Linux comes with MySQL and DBD::mysql. You need to ensure that the following RPM's are installed: mysql perl-DBI perl-DBD-MySQL "
If you do not have DBI/DBD, you have to resort to http://www.mysql.com/downloads/api-dbi.html.
4. The rpm installation should now have the mysqld daemon running and mysqld etc. placed in a bin dir (probably /usr/bin). You can shut it down with
mysqladmin shutdown
You can start it again with
mysqld
it should print something like:
" 030803 13:13:48 InnoDB: Started mysqld: ready for connections. Version: '4.0.14-debug-log' socket: '/home/heikki/MySQLheikki' port: 3307 "
(If something went wrong in the grants table creation, it will complain it cannot find the 'host.frm' file. In that case refer to http://www.mysql.com/doc/en/Post-installation.html about the script mysql_install_db.)
The 'datadir' of MySQL is typically /var/lib/mysql. Under it is the actual database data.
To connect to the database from a console, type
mysql test
mysql> show databases; ... mysql> exit
5. To run Perl tests, go to the sql-bench directory (typically under /usr/local/mysql) and:
perl innotest1
perl innotest1a
perl run-all-tests --create-options=type=innodb
etc.
You should run all innotests concurrently.
mysqld should not crash or print anything. The Perl tests themselves print quite a lot as they test deadlocks etc.
We are testing a Pogo Linux server with a Red Hat 2.4.20 kernel, http://www.mysql.com/press/release_2003_20.html, and so far that combination seems to work ok.
Greetings to Linus! I hope you are having a good time at OSDL!
Heikki
- To unsubscribe from this list: send the line "unsubscribe linux-kernel" in the body of a message to majordomo@vger.kernel.org More majordomo info at http://vger.kernel.org/majordomo-info.html Please read the FAQ at http://www.tux.org/lkml/
| |