Load Testing MySQL
I know this is quite a bit off topic, but i was wondering if anyone else out there had any experience with Segue's Silk Performer load testing tools. More specifically, i am trying to compile a test script to allow me to perform some transactional database testing to load test a MySQL 4.0.13 database server running behind some apache webservers. I have obtained an ODBC driver from MySQL and have some specific queries i would like to use in the test. I am have used SP to load test the webservers specifically, but i am not 100% sure how to run this against a database server now. If anyone has any experience they can share, please feel free to email me off list. Thank you in advance -- Michael B. Weiner, Linux+, Linux+ SME Systems Administrator/Partner The UserFriendly Network (UFN) -- Linux Registered User #94900Have you been counted? http://counter.li.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Help required on testing MySQL with Open SSL
Hi, I'm looking for information on testing MySQL server with Open SSL using any client(JDBC/ODBC). Please let me know how to test using a MySQL client for SSL. I was able to compile mysql with using open SSL Thanks Ram -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
testing mysql
Hello and good morning all! I'm running into a problem when trying to test mysql on Red Hat Linux. I have the server up and running just fine with no problems, but when I go to run ./mysql-test-run it spits back the following. TEST USER SYSTEM ELAPSEDRESULT alias [ fail ] /home/nstuart/mysql-3.23.49/bin/mysqltest: Failed in mysql_real_connect(): Can't connect to local MySQL server through socket '/home/nstuart/mysql-3.23.49/mysql-test/var/tmp/mysql-master.sock' (2) Command exited with non-zero status 1 real 0.01 user 0.01 sys 0.01 Aborting. To continue, re-run with '--force'. Ending Tests Shutting-down MySQL daemon /home/nstuart/mysql-3.23.49/bin/mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/home/nstuart/mysql-3.23.49/mysql-test/var/tmp/mysql-master.sock' (2)' Check that mysqld is running and that the socket: '/home/nstuart/mysql-3.23.49/mysql-test/var/tmp/mysql-master.sock' exists! Master shutdown finished I would like to simply run the test on the server that is running but apparently it doesn't want to do that. I thought I changed the correct settings in the mysql-test-run but apparently not. Also tried the mysql-test-run --local but that do anything different. Also, I dont want to run the slave test either but again the --skip-rpl seems to do nothing. Thanks for all the help! -Nick - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Testing MySQL 4.0 ; detaching queries
You could just exec() the page again, with a parameter telling it to use the test server, like so: I like this general idea, though the above method would take a little more work since I would have to pass the environment variables and apache variables (GET and POST, etc) to exec and I don't know how. However, I can try and setup a test web server on the test SQL server and have a auto_postpend file that sets up all these variables (cookies, post vars, etc) and sends them off using fsockopen, etc., as a HTTP request to the other server. If I setup the other server to ignore hangups, then I can send the request and quit. Thanks for the idea! Sincerely, Steven Roussey http://Network54.com/?pp=e - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Testing MySQL 4.0
Hello On Tue, 19 Jun 2001, Sasha Pachev wrote: If you have a spare development system, plug in 4.0 binary and try to run your applications on it to see if it will crash. I just tried it on Debian GNU/Linux for i386 with up-to-date testing distro and up-to-date bk clone. The compile process fails on client/insert_test: , [ excerpt from make's output ] | /bin/sh ../libtool --mode=link gcc -O3 -DDBUG_OFF -rdynamic -o insert_test |insert_test.o ../libmysql/libmysqlclient.la -lz -lcrypt -lnsl -lm | gcc -O3 -DDBUG_OFF -rdynamic -o .libs/insert_test insert_test.o |../libmysql/.libs/libmysqlclient.so -lz -lcrypt -lnsl -lm -lz -lcrypt -lnsl -lm |-Wl,--rpath -Wl,/usr/local/mysql4/lib/mysql | insert_test.o: In function `main': | insert_test.o(.text+0x40): undefined reference to `mysql_connect' | collect2: ld returned 1 exit status ` Indeed, mysql_connect does not seem to exist in libmysqlclient: , [ nm ../libmysql/.libs/libmysqlclient.so | grep connect ] | 5e40 t connect2 | U connect@@GLIBC_2.0 | 7758 T mysql_real_connect | 8404 t mysql_reconnect ` Anyhow, if I go on with make in spite of this, the resulting mysqld, mysql and friends seem to be running just fine. :-) cheers -- TS - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Testing MySQL 4.0
On Monday 09 July 2001 10:51, Tibor Simko wrote: Hello On Tue, 19 Jun 2001, Sasha Pachev wrote: If you have a spare development system, plug in 4.0 binary and try to run your applications on it to see if it will crash. I just tried it on Debian GNU/Linux for i386 with up-to-date testing distro and up-to-date bk clone. The compile process fails on client/insert_test: , [ excerpt from make's output ] | /bin/sh ../libtool --mode=link gcc -O3 -DDBUG_OFF -rdynamic -o insert_test insert_test.o ../libmysql/libmysqlclient.la -lz -lcrypt -lnsl -lm | gcc -O3 -DDBUG_OFF -rdynamic -o .libs/insert_test insert_test.o ../libmysql/.libs/libmysqlclient.so -lz -lcrypt -lnsl -lm -lz -lcrypt -lnsl -lm -Wl,--rpath -Wl,/usr/local/mysql4/lib/mysql | insert_test.o: In function `main': | insert_test.o(.text+0x40): undefined reference to `mysql_connect' | collect2: ld returned 1 exit status ` Indeed, mysql_connect does not seem to exist in libmysqlclient: , [ nm ../libmysql/.libs/libmysqlclient.so | grep connect ] | 5e40 t connect2 | U connect@@GLIBC_2.0 | 7758 T mysql_real_connect | 8404 t mysql_reconnect ` Anyhow, if I go on with make in spite of this, the resulting mysqld, mysql and friends seem to be running just fine. :-) We will have this fixed shortly... It should be using mysql_real_connect() instead. -- MySQL Development Team For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sasha Pachev [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA ___/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Testing MySQL 4.0
Hi! Sasha == Sasha Pachev [EMAIL PROTECTED] writes: Sasha On Tuesday 19 June 2001 17:43, Russell E Glaue wrote: . After you've pulled, run BUILD/compile-pentium (for a lean fast binary) or BUILD/compile-pentium-debug - it will build a binary for you. We run all our MySQLs on the fast SPARCs and PPCs is pentium the only supported hardware right now? Sasha No, but we do not have a nifty compile-solaris-sparc-debug in the BUILD Sasha directory yet, largely because none of our developers uses a Sparc for their Sasha primary development machine. We do have compile-solaris-sparc, though, and Sasha even compile-solaris-sparc-purify. Feel free to copy one of those, hack it Sasha and send it to us. Sasha On most platforms, BUILD/compile-pentium should build a good binary even if Sasha the architecture is not a pentium. This is not really true, as BUILD/compile-pentium will include compiler options that only works on Intel (and not sparc) Another thing is that you should normally never use scripts in the BUILD options if you are not working on developing MySQL, as these scripts require that you have a lot of extra tools installed. To do a correct build on Solaris sparc you should use the following configure line: CFLAGS=-O3 CXX=gcc CXXFLAGS=-felide-constructors -fno-exceptions -fno-rtti -O3 -fno-omit-frame-pointer ./configure --prefix=/usr/local/mysql --enable-assembler --with-mysqld-ldflags=-all-static You can find more information about this in the MySQL manual in the Solaris section. Regards, Monty - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Testing MySQL 4.0
On Wed, 20 Jun 2001, Michael Widenius wrote: Hi! Sasha == Sasha Pachev [EMAIL PROTECTED] writes: Sasha On Tuesday 19 June 2001 17:43, Russell E Glaue wrote: . After you've pulled, run BUILD/compile-pentium (for a lean fast binary) or BUILD/compile-pentium-debug - it will build a binary for you. We run all our MySQLs on the fast SPARCs and PPCs is pentium the only supported hardware right now? Sasha No, but we do not have a nifty compile-solaris-sparc-debug in the BUILD Sasha directory yet, largely because none of our developers uses a Sparc for their Sasha primary development machine. We do have compile-solaris-sparc, though, and Sasha even compile-solaris-sparc-purify. Feel free to copy one of those, hack it Sasha and send it to us. Sasha On most platforms, BUILD/compile-pentium should build a good binary even if Sasha the architecture is not a pentium. This is not really true, as BUILD/compile-pentium will include compiler options that only works on Intel (and not sparc) Another thing is that you should normally never use scripts in the BUILD options if you are not working on developing MySQL, as these scripts require that you have a lot of extra tools installed. To do a correct build on Solaris sparc you should use the following configure line: CFLAGS=-O3 CXX=gcc CXXFLAGS=-felide-constructors -fno-exceptions -fno-rtti -O3 -fno-omit-frame-pointer ./configure --prefix=/usr/local/mysql --enable-assembler --with-mysqld-ldflags=-all-static You can find more information about this in the MySQL manual in the Solaris section. Regards, Monty Thanks Monty. I am interested in testing the 4.0 development tree for PPC Darwin and Solaris 8, both which are my primary development/production archs. -RG +--+ Russell E Glaue, Technologies Engineer Integrator [EMAIL PROTECTED] Center for the Application of Information Technologies WIU, 101 Horrabin Hall, 1 University Circle, Macomb, IL 61455 http://www.cait.org - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Testing MySQL 4.0
On Wednesday 20 June 2001 07:30, Michael Widenius wrote: Hi! Sasha == Sasha Pachev [EMAIL PROTECTED] writes: Sasha On Tuesday 19 June 2001 17:43, Russell E Glaue wrote: . After you've pulled, run BUILD/compile-pentium (for a lean fast binary) or BUILD/compile-pentium-debug - it will build a binary for you. We run all our MySQLs on the fast SPARCs and PPCs is pentium the only supported hardware right now? Sasha No, but we do not have a nifty compile-solaris-sparc-debug in the BUILD Sasha directory yet, largely because none of our developers uses a Sparc for their Sasha primary development machine. We do have compile-solaris-sparc, though, and Sasha even compile-solaris-sparc-purify. Feel free to copy one of those, hack it Sasha and send it to us. Sasha On most platforms, BUILD/compile-pentium should build a good binary even if Sasha the architecture is not a pentium. This is not really true, as BUILD/compile-pentium will include compiler options that only works on Intel (and not sparc) Yes, just checked - there is only one Pentium specific option ( -mpentiumpro ), and I have verified that gcc on Solaris gives an error instead of ignoring it. However, all BUILD/compile-pentium* scripts should work if you comment out pentium_cflags=-mpentiumpro in BUILD/SETUP.sh Another thing is that you should normally never use scripts in the BUILD options if you are not working on developing MySQL, as these scripts require that you have a lot of extra tools installed. To do a correct build on Solaris sparc you should use the following configure line: CFLAGS=-O3 CXX=gcc CXXFLAGS=-felide-constructors -fno-exceptions -fno-rtti -O3 -fno-omit-frame-pointer ./configure --prefix=/usr/local/mysql --enable-assembler --with-mysqld-ldflags=-all-static You can find more information about this in the MySQL manual in the Solaris section. This works fine if you get a source tarball. However, if you pull from the tree, configure script is not checked it ( because it is auto-generated), so you have to use BUILD/compile-* or do aclocal; autoheader; autoconf; automake before you can execute configure. -- MySQL Development Team For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sasha Pachev [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA ___/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Testing MySQL 4.0
Hello, MySQL users/hackers: As some of you know, we are currently actively working on MySQL 4.0, and are making some progress. Those who are subscribed to the internals lists get notified of all of our commits and can monitor the progress. If you would like to do a pull from our repository and play with it, follow the instructions at http://www.mysql.com/doc/I/n/Installing_source_tree.html . After you've pulled, run BUILD/compile-pentium (for a lean fast binary) or BUILD/compile-pentium-debug - it will build a binary for you. If you have a spare development system, plug in 4.0 binary and try to run your applications on it to see if it will crash. If it does, although 4.0 is pre-alpha, it is a concern to us - our rule is not to have anything in the central repository that we know crashed - each developers has to run make test before he can push the change, and it has to pass, maybe with the exception of when one developer commits a test case for a bug for some other developer to fix it. So if you can get our tree to crash ( again, we recommend you do not try it on a production system yet :-) ), please report it. The sooner you report it, the sooner we fix it, and the sooner we get 4.0 into production quality release. Some cool things already coded in the current 4.0 tree: REPLICATION: * LOAD DATA FROM MASTER auto-magically sets up a slave ( master tables will be locked in the current code, but this will be fixed in the future once we get hot backup to work) * master is aware of slaves if they register * client has built-in master/slave awareness that get turned on with special client options or through new API calls GENERAL SQL: * count(distinct) is about 30% faster * records can be read on raw MyISAM level with HANDLER command * multi-delete works, but there is a bug we are aware of that we have not fixed yet FULL TEXT: * All I know is that it works much better - Sergei could fill in the details The above list is not comlete - I just typed it from memory. Of course, the new API, SQL syntax, log formats, etc is subject to change since we are still pre-alpha, so do not build applications that depend on it until we have officially blessed them. Also, now is the best time to throw in suggestions, feature requests, etc. Once we've stablized the branch, it would be a lot harder to get us to change things. So, in short, have fun... -- MySQL Development Team For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sasha Pachev [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA ___/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Testing MySQL 4.0
. After you've pulled, run BUILD/compile-pentium (for a lean fast binary) or BUILD/compile-pentium-debug - it will build a binary for you. We run all our MySQLs on the fast SPARCs and PPCs is pentium the only supported hardware right now? -RG On Tue, 19 Jun 2001, Sasha Pachev wrote: Hello, MySQL users/hackers: As some of you know, we are currently actively working on MySQL 4.0, and are making some progress. Those who are subscribed to the internals lists get notified of all of our commits and can monitor the progress. If you would like to do a pull from our repository and play with it, follow the instructions at http://www.mysql.com/doc/I/n/Installing_source_tree.html . After you've pulled, run BUILD/compile-pentium (for a lean fast binary) or BUILD/compile-pentium-debug - it will build a binary for you. If you have a spare development system, plug in 4.0 binary and try to run your applications on it to see if it will crash. If it does, although 4.0 is pre-alpha, it is a concern to us - our rule is not to have anything in the central repository that we know crashed - each developers has to run make test before he can push the change, and it has to pass, maybe with the exception of when one developer commits a test case for a bug for some other developer to fix it. So if you can get our tree to crash ( again, we recommend you do not try it on a production system yet :-) ), please report it. The sooner you report it, the sooner we fix it, and the sooner we get 4.0 into production quality release. Some cool things already coded in the current 4.0 tree: REPLICATION: * LOAD DATA FROM MASTER auto-magically sets up a slave ( master tables will be locked in the current code, but this will be fixed in the future once we get hot backup to work) * master is aware of slaves if they register * client has built-in master/slave awareness that get turned on with special client options or through new API calls GENERAL SQL: * count(distinct) is about 30% faster * records can be read on raw MyISAM level with HANDLER command * multi-delete works, but there is a bug we are aware of that we have not fixed yet FULL TEXT: * All I know is that it works much better - Sergei could fill in the details The above list is not comlete - I just typed it from memory. Of course, the new API, SQL syntax, log formats, etc is subject to change since we are still pre-alpha, so do not build applications that depend on it until we have officially blessed them. Also, now is the best time to throw in suggestions, feature requests, etc. Once we've stablized the branch, it would be a lot harder to get us to change things. So, in short, have fun... -- MySQL Development Team For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sasha Pachev [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA ___/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Testing MySQL 4.0
On Tuesday 19 June 2001 17:43, Russell E Glaue wrote: . After you've pulled, run BUILD/compile-pentium (for a lean fast binary) or BUILD/compile-pentium-debug - it will build a binary for you. We run all our MySQLs on the fast SPARCs and PPCs is pentium the only supported hardware right now? No, but we do not have a nifty compile-solaris-sparc-debug in the BUILD directory yet, largely because none of our developers uses a Sparc for their primary development machine. We do have compile-solaris-sparc, though, and even compile-solaris-sparc-purify. Feel free to copy one of those, hack it and send it to us. On most platforms, BUILD/compile-pentium should build a good binary even if the architecture is not a pentium. -- MySQL Development Team For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sasha Pachev [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA ___/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php