test - ignore
ignore
Re: Simple test
On 6/18/2015 1:25 PM, AZ 9901 wrote: Hello, I only get SPAM answers when I try to post to this list so here is a simple message… Sorry… Marc. your message came through on gmane.comp.db.mysql.general just fine. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Simple test
Hello, I only get SPAM answers when I try to post to this list so here is a simple message… Sorry… Marc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: Which test suites are valid for --extern option in mysql-test-run?
Thanks a lot, Eric! Yes, unfortunately, I'm trying to use them to do some specific testing. One thing bugged me is that even testing on a clean mysqld with the default configuration, some --extern test fails. I guess it is because these test cases are not supported. By the way, could you explain a little bit about the difference between the test cases in the r directory and the ones in the suite directory? It seems they are quite different. When running mysql_test_run without argument, it uses the ones in the suite directory. Best, Tianyin On Mon, Nov 26, 2012 at 6:57 PM, Eric Bergen eric.ber...@gmail.com wrote: Those tests are typically used by people developing the mysqld server. The packages distributed have already had the tests ran on them. I'm not sure how much value it will provide unless you're modifying mysqld. I don't have a great answer but my best guess is that extern can't be used with tests that start or stop mysqld servers like the replication tests. On Sat, Nov 24, 2012 at 12:16 AM, Tianyin Xu t...@cs.ucsd.edu wrote: Hi, all, I wanna test my running MySQL server. According to the README in the mysql-test directory, If you want to use an already running MySQL server for specific tests, use the --extern option to mysql-test-run. For example, mysql-test-run --extern alias But the README also pointed out that some tests cannot run with an external server. My question is how to know which test suites in t directory are valid for --extern option? Without knowing this, I cannot judge whether a test fails is because it's not supported or real problems. Thanks a lot! Tianyin -- Tianyin XU, http://cseweb.ucsd.edu/~tixu/ -- Eric Bergen eric.ber...@gmail.com http://www.ebergen.net -- Tianyin XU, http://cseweb.ucsd.edu/~tixu/
Re: Which test suites are valid for --extern option in mysql-test-run?
Those tests are typically used by people developing the mysqld server. The packages distributed have already had the tests ran on them. I'm not sure how much value it will provide unless you're modifying mysqld. I don't have a great answer but my best guess is that extern can't be used with tests that start or stop mysqld servers like the replication tests. On Sat, Nov 24, 2012 at 12:16 AM, Tianyin Xu t...@cs.ucsd.edu wrote: Hi, all, I wanna test my running MySQL server. According to the README in the mysql-test directory, If you want to use an already running MySQL server for specific tests, use the --extern option to mysql-test-run. For example, mysql-test-run --extern alias But the README also pointed out that some tests cannot run with an external server. My question is how to know which test suites in t directory are valid for --extern option? Without knowing this, I cannot judge whether a test fails is because it's not supported or real problems. Thanks a lot! Tianyin -- Tianyin XU, http://cseweb.ucsd.edu/~tixu/ -- Eric Bergen eric.ber...@gmail.com http://www.ebergen.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Which test suites are valid for --extern option in mysql-test-run?
Hi, all, I wanna test my running MySQL server. According to the README in the mysql-test directory, If you want to use an already running MySQL server for specific tests, use the --extern option to mysql-test-run. For example, mysql-test-run --extern alias But the README also pointed out that some tests cannot run with an external server. My question is how to know which test suites in t directory are valid for --extern option? Without knowing this, I cannot judge whether a test fails is because it's not supported or real problems. Thanks a lot! Tianyin -- Tianyin XU, http://cseweb.ucsd.edu/~tixu/
Test mail
Hi all, Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Test mail
Looks like your test succeeded and you win!!! On Thu, May 19, 2011 at 9:41 AM, Adarsh Sharma adarsh.sha...@orkash.comwrote: Hi all, Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=sureshkumar...@gmail.com -- Thanks Suresh Kuna MySQL DBA
Re: [Failed on test 761, perl mysql-test-run.pl]
Courtney, this happens because you acted against a sacred Unix commandment: Thou shalt not work as 'root' user unless absolutely necessary. In particular, you should not run a database system as the root user. Courtney Waller wrote: [[...]] From: root [[...]] main.information_schema_chmod [ fail ] Test ended at 2010-09-11 14:14:46 CURRENT_TEST: main.information_schema_chmod --- /usr/local/mysql-5.1.50-linux-i686-glibc23/mysql-test/r/information_schema_$ +++ /usr/local/mysql-5.1.50-linux-i686-glibc23/mysql-test/r/information_schema_$ @@ -2,4 +2,5 @@ create table mysqltest.t1(a int); select table_schema from information_schema.tables where table_schema='mysqlte$ table_schema +mysqltest drop database mysqltest; mysqltest: Result length mismatch - saving '/usr/local/mysql-5.1.50-linux-i686-glibc23/mysql-test/var/log/main.i$ Only 761 of 1552 completed. mysql-test-run: *** ERROR: Not all tests completed r...@ewokums-laptop:/usr/local/mysql-test# See bug#49985 and bug#51271 for similar reports. Regards, Jörg -- Joerg Bruehe, MySQL Build Team, joerg.bru...@oracle.com ORACLE Deutschland B.V. Co. KG, Komturstrasse 18a, D-12099 Berlin Geschaeftsfuehrer: Juergen Kunz, Marcel v.d. Molen, Alexander v.d. Ven Amtsgericht Muenchen: HRA 95603 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
[Failed on test 761, perl mysql-test-run.pl]
SEND-PR: -*- send-pr -*- SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as SEND-PR: will all comments (text enclosed in `' and `'). SEND-PR: From: root To: mysql@lists.mysql.com Subject: [Failed on test 761, perl mysql-test-run.pl] Description: main.greedy_optimizer [ pass ] 150 main.group_by [ pass ] 538 main.group_min_max [ pass ] 633 main.handler_myisam [ pass ] 2645 main.having [ pass ] 225 main.heap [ pass ] 367 main.heap_auto_increment [ pass ] 24 main.heap_btree [ pass ] 175 main.heap_hash [ pass ] 175 main.help [ pass ] 166 main.index_merge_myisam [ pass ] 6497 main.information_schema [ pass ] 9771 main.information_schema_chmod [ fail ] Test ended at 2010-09-11 14:14:46 CURRENT_TEST: main.information_schema_chmod --- /usr/local/mysql-5.1.50-linux-i686-glibc23/mysql-test/r/information_schema_$ +++ /usr/local/mysql-5.1.50-linux-i686-glibc23/mysql-test/r/information_schema_$ @@ -2,4 +2,5 @@ create table mysqltest.t1(a int); select table_schema from information_schema.tables where table_schema='mysqlte$ table_schema +mysqltest drop database mysqltest; mysqltest: Result length mismatch - saving '/usr/local/mysql-5.1.50-linux-i686-glibc23/mysql-test/var/log/main.i$ Only 761 of 1552 completed. mysql-test-run: *** ERROR: Not all tests completed r...@ewokums-laptop:/usr/local/mysql-test# How-To-Repeat: perl mysql-test-run.pl Fix: how to correct or work around the problem, if known (multiple lines) Submitter-Id: ewok...@yahoo.com Originator: root Organization: Raytheon MySQL support: [none] Synopsis: synopsis of the problem (one line) Severity: critical Priority: high Category: mysql Class: sw-bug Release: mysql-5.1.50 (MySQL Community Server (GPL)) C compiler: gcc (GCC) 4.3.2 C++ compiler: gcc (GCC) 4.3.2 Environment: machine, os, target, libraries (multiple lines) System: Linux ewokums-laptop 2.6.24-24-generic #1 SMP Thu Sep 10 19:00:20 UTC 2$ Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc GCC: Using built-in specs. Target: i486-linux-gnu Configured with: ../src/configure -v --enable-languages=c,c++,fortran,objc,obj-$ Thread model: posix gcc version 4.2.4 (Ubuntu 4.2.4-1ubuntu3) Compilation info (call): CC='ccache /usr/local/gcc-4.3.2/bin/gcc -static-libgcc$ Compilation info (used): CC='ccache /usr/local/gcc-4.3.2/bin/gcc -static-libgcc$ LIBC: lrwxrwxrwx 1 root root 11 2010-09-06 18:06 /lib/libc.so.6 - libc-2.7.so -rwxr-xr-x 1 root root 1274092 2008-04-04 19:38 /lib/libc-2.7.so -rw-r--r-- 1 root root 2906282 2008-04-04 19:38 /usr/lib/libc.a -rw-r--r-- 1 root root 238 2008-04-04 19:26 /usr/lib/libc.so Configure command: ./configure '--prefix=/usr/local/mysql' '--localstatedir=/u$
Re: test - please ignore
i said: ignore! But did it work? ;-) With regards, Martijn Tonies Upscene Productions http://www.upscene.com Download Database Workbench for Oracle, MS SQL Server, Sybase SQL Anywhere, MySQL, InterBase, NexusDB and Firebird! Database questions? Check the forum: http://www.databasedevelopmentforum.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
test - please ignore
i said: ignore! -- hartmut -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
how can i bzr the mysql-test-extra branch?
Hi all, I'm new to mysql and I'm looking into some bug cases of mysql. I tried to reproduce some bugs and the reports referred to the mysql-test-extra-6.0 branch. I also found that this branch is renamed to mysql-test-extra. The problem is, when I try to use bazaar to get this branch, using: bzr branch http://bazaar.launchpad.net/~mysql/mysql-server/mysql-test-extra , it shows that this address is not a branch. Is there any update of this branch or where else can I get this branch? Thanks. --Wenbin
Re: high performance test data/test query generator
I usually simulate the load of the whole stack, by benchmarking the application directly using a tool such as jMeter. Loading MySQL specifically with read/write patterns similar to those of the real application can be useful, but quite hard to accomplish. One easy way of doing that is to enable logging in your server and capture the statements executed over a day or so, then extract the SQL statements into a separate file. You can use then use a tool such as mysqlslap (available since 5.1) to execute those statements in a number of iterations with a given concurrency on your benchmarking box. On Thu, Jun 4, 2009 at 2:05 PM, petya pe...@petya.org.hu wrote: Anyone else? You guys don't simulate realistic workload in benchmark just do sysbench or something like that? If there were a tool for that (which can handle data generation, initial database generation, and query generation, maybe it's output will be a jmeter test case) would you do so? Peter petya wrote: I use jmeter too, but it can't generate the test dataset (if I have to write this, I plan that it will create a jmeter test case with the generated test data). Usually my ad-hoc script generates csv files (to load initial data) and jmeter test cases. Michael Dykman wrote: On Wed, Jun 3, 2009 at 9:41 AM, petya pe...@petya.org.hu wrote: Hi, We have lots of mysql servers, master-slave and sharded databases. A recurring task when a new feature/application comes in to test the database with real workload. This needs test data and test query generation. Until now I did this with ad-hoc scripts, I looked for tools to do this, so far I found nothing. The closest thing to this was benerator, but it doesn't generate test queries. I need to measure write performance too (or concurrent read/write performance), so it would be good if I can tell the tool to generate bulk inserts with n records or generate a csv file or generate single insert... statements, so I can simulate the application's workload (of course I can do this with the application itself, but in development stage it is important to see how the database itself performs). Does such a tool exists? No problem if it is mysql only. If not, I think I will write one. Peter Boros It is by no means the only such tool, but I have often use JMeter as an all-purpose load-generation tool. It has good support for database testing among other things.. http://jakarta.apache.org/jmeter/usermanual/build-db-test-plan.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=amr.most...@gmail.com -- Amr Mostafa PHP Team Leader, Egypt Development Center amr.most...@egyptdc.comhttp://egyptdc.com +(2012)1700502 +(202)24052355/6
Re: high performance test data/test query generator
That only works if the application is already in production and gets a certain load. For a new application (for example the database is designed but the application is not ready yet) this doesn't work. Amr Mostafa wrote: I usually simulate the load of the whole stack, by benchmarking the application directly using a tool such as jMeter. Loading MySQL specifically with read/write patterns similar to those of the real application can be useful, but quite hard to accomplish. One easy way of doing that is to enable logging in your server and capture the statements executed over a day or so, then extract the SQL statements into a separate file. You can use then use a tool such as mysqlslap (available since 5.1) to execute those statements in a number of iterations with a given concurrency on your benchmarking box. On Thu, Jun 4, 2009 at 2:05 PM, petya pe...@petya.org.hu wrote: Anyone else? You guys don't simulate realistic workload in benchmark just do sysbench or something like that? If there were a tool for that (which can handle data generation, initial database generation, and query generation, maybe it's output will be a jmeter test case) would you do so? Peter petya wrote: I use jmeter too, but it can't generate the test dataset (if I have to write this, I plan that it will create a jmeter test case with the generated test data). Usually my ad-hoc script generates csv files (to load initial data) and jmeter test cases. Michael Dykman wrote: On Wed, Jun 3, 2009 at 9:41 AM, petya pe...@petya.org.hu wrote: Hi, We have lots of mysql servers, master-slave and sharded databases. A recurring task when a new feature/application comes in to test the database with real workload. This needs test data and test query generation. Until now I did this with ad-hoc scripts, I looked for tools to do this, so far I found nothing. The closest thing to this was benerator, but it doesn't generate test queries. I need to measure write performance too (or concurrent read/write performance), so it would be good if I can tell the tool to generate bulk inserts with n records or generate a csv file or generate single insert... statements, so I can simulate the application's workload (of course I can do this with the application itself, but in development stage it is important to see how the database itself performs). Does such a tool exists? No problem if it is mysql only. If not, I think I will write one. Peter Boros It is by no means the only such tool, but I have often use JMeter as an all-purpose load-generation tool. It has good support for database testing among other things.. http://jakarta.apache.org/jmeter/usermanual/build-db-test-plan.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=amr.most...@gmail.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: high performance test data/test query generator
Anyone else? You guys don't simulate realistic workload in benchmark just do sysbench or something like that? If there were a tool for that (which can handle data generation, initial database generation, and query generation, maybe it's output will be a jmeter test case) would you do so? Peter petya wrote: I use jmeter too, but it can't generate the test dataset (if I have to write this, I plan that it will create a jmeter test case with the generated test data). Usually my ad-hoc script generates csv files (to load initial data) and jmeter test cases. Michael Dykman wrote: On Wed, Jun 3, 2009 at 9:41 AM, petya pe...@petya.org.hu wrote: Hi, We have lots of mysql servers, master-slave and sharded databases. A recurring task when a new feature/application comes in to test the database with real workload. This needs test data and test query generation. Until now I did this with ad-hoc scripts, I looked for tools to do this, so far I found nothing. The closest thing to this was benerator, but it doesn't generate test queries. I need to measure write performance too (or concurrent read/write performance), so it would be good if I can tell the tool to generate bulk inserts with n records or generate a csv file or generate single insert... statements, so I can simulate the application's workload (of course I can do this with the application itself, but in development stage it is important to see how the database itself performs). Does such a tool exists? No problem if it is mysql only. If not, I think I will write one. Peter Boros It is by no means the only such tool, but I have often use JMeter as an all-purpose load-generation tool. It has good support for database testing among other things.. http://jakarta.apache.org/jmeter/usermanual/build-db-test-plan.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: high performance test data/test query generator
I find it difficult to use a general tool to generate a lot of data specifi to my application. There are many tools out there to execute queries against a MySQL server it seems and log/report the performance. However, finding a tool that is able to generate a lot of data that fits into your schema seems to be the problem. I would use a tool that does this. On Thu, Jun 4, 2009 at 6:05 AM, petya pe...@petya.org.hu wrote: Anyone else? You guys don't simulate realistic workload in benchmark just do sysbench or something like that? If there were a tool for that (which can handle data generation, initial database generation, and query generation, maybe it's output will be a jmeter test case) would you do so? Peter petya wrote: I use jmeter too, but it can't generate the test dataset (if I have to write this, I plan that it will create a jmeter test case with the generated test data). Usually my ad-hoc script generates csv files (to load initial data) and jmeter test cases. Michael Dykman wrote: On Wed, Jun 3, 2009 at 9:41 AM, petya pe...@petya.org.hu wrote: Hi, We have lots of mysql servers, master-slave and sharded databases. A recurring task when a new feature/application comes in to test the database with real workload. This needs test data and test query generation. Until now I did this with ad-hoc scripts, I looked for tools to do this, so far I found nothing. The closest thing to this was benerator, but it doesn't generate test queries. I need to measure write performance too (or concurrent read/write performance), so it would be good if I can tell the tool to generate bulk inserts with n records or generate a csv file or generate single insert... statements, so I can simulate the application's workload (of course I can do this with the application itself, but in development stage it is important to see how the database itself performs). Does such a tool exists? No problem if it is mysql only. If not, I think I will write one. Peter Boros It is by no means the only such tool, but I have often use JMeter as an all-purpose load-generation tool. It has good support for database testing among other things.. http://jakarta.apache.org/jmeter/usermanual/build-db-test-plan.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=joh...@pixelated.net -- - Johnny Withers 601.209.4985 joh...@pixelated.net
high performance test data/test query generator
Hi, We have lots of mysql servers, master-slave and sharded databases. A recurring task when a new feature/application comes in to test the database with real workload. This needs test data and test query generation. Until now I did this with ad-hoc scripts, I looked for tools to do this, so far I found nothing. The closest thing to this was benerator, but it doesn't generate test queries. I need to measure write performance too (or concurrent read/write performance), so it would be good if I can tell the tool to generate bulk inserts with n records or generate a csv file or generate single insert... statements, so I can simulate the application's workload (of course I can do this with the application itself, but in development stage it is important to see how the database itself performs). Does such a tool exists? No problem if it is mysql only. If not, I think I will write one. Peter Boros -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: high performance test data/test query generator
I use jmeter too, but it can't generate the test dataset (if I have to write this, I plan that it will create a jmeter test case with the generated test data). Usually my ad-hoc script generates csv files (to load initial data) and jmeter test cases. Michael Dykman wrote: On Wed, Jun 3, 2009 at 9:41 AM, petya pe...@petya.org.hu wrote: Hi, We have lots of mysql servers, master-slave and sharded databases. A recurring task when a new feature/application comes in to test the database with real workload. This needs test data and test query generation. Until now I did this with ad-hoc scripts, I looked for tools to do this, so far I found nothing. The closest thing to this was benerator, but it doesn't generate test queries. I need to measure write performance too (or concurrent read/write performance), so it would be good if I can tell the tool to generate bulk inserts with n records or generate a csv file or generate single insert... statements, so I can simulate the application's workload (of course I can do this with the application itself, but in development stage it is important to see how the database itself performs). Does such a tool exists? No problem if it is mysql only. If not, I think I will write one. Peter Boros It is by no means the only such tool, but I have often use JMeter as an all-purpose load-generation tool. It has good support for database testing among other things.. http://jakarta.apache.org/jmeter/usermanual/build-db-test-plan.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
MySQL University session on April 2: How to Create a Test Case
How to Create a Test Case http://forge.mysql.com/wiki/How_to_Create_a_Test_Case This Thursday (April 2nd, 14:00 UTC), Patrick Crews will give a MySQL University session on How to Create a Test Case. This is an updated session of a talk we had in 2007, but this time it will be recorded (slides and audio). Patrick is a database engineer who works in the server QA department, so test cases are his daily bread. For MySQL University sessions, point your browser to this page: http://webmeeting.dimdim.com/portal/JoinForm.action?confKey=mysqluniversity You need a browser with a working Flash plugin. You may register for a Dimdim account, but you don't have to. (Dimdim is the conferencing system we're using for MySQL University sessions. It provides integrated voice streaming, chat, whiteboard, session recording, and more.) MySQL University is a free educational online program for engineers/developers. MySQL University sessions are open to anyone, not just Sun employees. Sessions are recorded (slides and audio), so if you can't attend the live session you can look at the recording anytime after the session. Here's the schedule for the upcoming weeks: * April 2, 2009: How to Create a Test Case (updated session from 2007) (Patrick Crews) * April 9, 2009: No MySQL University session scheduled (due to upcoming Easter vacation in Europe) * April 16, 2009 (tentative): Going Nuts - How to write MySQL test cases in Perl (Luis Soares, Alfranio Correia, Serge Kozlov, Lars Thalmann) * April 23, 2009: No MySQL University session during MySQL Conference Expo 2009 * April 30, 2009: Testing Multiple Servers With MySQL Sandbox (Giuseppe Maxia) * May 7, 2009: MySQL Replication: Walk-through of the new 5.1 and 6.0 features (Lars Thalmann) * May 14, 2009: Programming Towards Multi-Core CPUs (Mikael Ronström) * May 21, 2009: No session scheduled * May 28, 2009: No session scheduled * May 28, 2009: Architecture of MySQL Backup (Lars Thalmann) * June 4, 2009: Boosting Performance With MySQL 5.1 Partitioning (Giuseppe Maxia) * June 11, 2009: Building MySQL Releases on Unix (Jörg Brühe) * June 18, 2009: Architecture of MySQL Backup (Lars Thalmann) * July 2 (tentative): Starring Sakila - a data warehouse mini-tutorial (Roland Bouman) The schedule is not engraved in stone at this point. Please visit http://forge.mysql.com/wiki/MySQL_University#Upcoming_Sessions for the up-to-date list. On that page, you can also find the starting time for many time zones. Cheers, Stefan -- *** Sun Microsystems GmbHStefan Hinz Sonnenallee 1Manager Documentation, Database Group 85551 Kirchheim-Heimstetten Phone: +49-30-82702940 Germany Fax: +49-30-82702941 http://www.sun.de/mysql mailto: stefan.h...@sun.com Amtsgericht Muenchen: HRB161028 Geschaeftsfuehrer: Thomas Schroeder, Wolfgang Engels, Dr. Roland Boemer Vorsitzender des Aufsichtsrates: Martin Haering *** -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Need help executing mysql stress test suite
Hi, For mysql stress test suite (mysql-stress-test.pl) to execute, it requires --stress-tests-file to be provided which contains the list of tests to be executed. As per the documentation the default name of the file is stress-test.txt and it will be located under ./mysql-test directory. But I could not find this file under the default directory. How to create this file? What is the format? Does this file come by default with test suite installation? or do I have to create this with the list of tests ? Can I have a sample copy of this file (stress-test.txt) ? I did try creating the file in the following format and tests stress-test.txt 1st alias alter_table analyse analyze ansi -- Note: Above tests are part of test suite stress test suite executes well with single thread. But it fails with multiple threads as these threads cannot be executed simultaneously. Regards, Durga.
Re: embedded client test scripts
Hi Alex, all! Alex Katebi wrote: Any information on how to run the test scripts for the embedded client. Call the test script, mysql-test-run.pl, and pass it the option --embedded-server It does not support replication or cluster, so you should add --skip-rpl --skip-ndbcluster Regards, Jörg -- Joerg Bruehe, MySQL Build Team, [EMAIL PROTECTED] Sun Microsystems GmbH, Sonnenallee 1, D-85551 Kirchheim-Heimstetten Geschaeftsfuehrer: Thomas Schroeder, Wolfgang Engels, Dr. Roland Boemer Vorsitzender des Aufsichtsrates: Martin Haering Muenchen: HRB161028 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
embedded client test scripts
Any information on how to run the test scripts for the embedded client. Thanks, -Alex
Test E-mail
Test E-mail Mikhail Berman
test - please ignore
a Linux -csh script to refresh test with production
Hello all. Does anyone out there (in mysql world) have a Linux -csh script to refresh test with production data. My developers would like their test database to be refreshed nightly with production data. The production and test mysql servers do not run in the same box. They run on different boxes. Therefore there is some ftp or scp required Thanks This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: a Linux -csh script to refresh test with production
If test and production are supposed to be identical, then use this:
mysqldump -hIP for Prod -u... -p... --triggers --routines db-name on Prod |
mysql -hIP for Test -u... -p... -A -Ddb-name on Test
If you havn't noticed, you do not dump the data to a file and ftp or scp
anything anywhere !!!
This will actually pipe all mysqldump commands striaght to the test database.
Make sure Linux can withstand the long connect time required.
If you want mysqldump all tables one at a time,
here is a Windows Batch File That I Use Every Week:
1) drop a target database,
2) recreate a target database,
3) Copy all stored procedures from Source to Target
4) Dynamically Create a Windows Batch File to mysqldump every table
(and its triggers, if applicable) starting with the largest table
Using this method, you need not worry about connection time because each table
will be shipped over from Source to Target using a Fresh Connection each time.
@echo off
set TABLESBAT=DynamicBatchFile.bat
echo SysData Full Copy Initiated DataLoadFull.txt
date /t DataLoadFull.txt
time /t DataLoadFull.txt
rem
rem
rem Drop SysData_Test from Target
rem Create SysData_Test for Target
rem Load Stored Procedures from Host PROD_IP Database SysData_Prod into Host
TEST_IP Database SysData_Test
rem
rem
set SOURCE_HOST=PROD_IP
set SOURCE_USER=...
set SOURCE_PASS=...
set TARGET_HOST=TEST_IP
set TARGET_USER=...
set TARGET_PASS=...
rem
rem
echo DROP DATABASE IF EXISTS SysData_Test; ResetTarget.sql
echo CREATE DATABASE SysData_Test; ResetTarget.sql
echo USE SysData_Test ResetTarget.sql
mysqldump -h%SOURCE_HOST% -u%SOURCE_USER% -p%SOURCE_PASS% --no-data
--no-create-info --routines NDW ResetTarget.sql
rem
rem
rem mysqldump all MyISAM tables from Source to Target in Size Order starting
from the Largest Table
rem
rem
mysql -h%SOURCE_HOST% -u%SOURCE_USER% -p%SOURCE_PASS% -A --skip-column-names
-DNDW -eSELECT CONCAT('mysqldump -h%SOURCE_HOST% -u%SOURCE_USER%
-p%SOURCE_PASS% --triggers SysData_Prod ',A.table_name,' | mysql
-h%TARGET_HOST% -u%TARGET_USER% -p%TARGET_PASS% -A -DSysData_Test') FROM
(SELECT table_name,(data_length+index_length) table_length FROM
information_schema.tables WHERE table_schema='SysData_Prod' AND
engine='MyISAM') A ORDER BY A.table_length DESC,A.table_name; %TABLESBAT%
echo exit %TABLESBAT%
mysql -h%TARGET_HOST% -u%TARGET_USER% -p%TARGET_PASS% -A ResetTarget.sql
start mysqldumps from PROD to TEST, DO NOT CLOSE !!! /w %TABLESBAT%
del ResetTarget.sql
del %TABLESBAT%
echo SysData Full Completed DataLoadFull.txt
date /t DataLoadFull.txt
time /t DataLoadFull.txt
PLEASE BE CAREFUL WITH THIS !!!
- Original Message -
From: Charles Brown [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Tuesday, March 27, 2007 3:17:46 PM (GMT-0500) Auto-Detected
Subject: a Linux -csh script to refresh test with production
Hello all.
Does anyone out there (in mysql world) have a Linux -csh script to
refresh test with production data.
My developers would like their test database to be refreshed nightly
with production data. The production and test mysql servers do not run
in the same box. They run on different boxes. Therefore there is some
ftp or scp required
Thanks
This message is intended only for the use of the Addressee and
may contain information that is PRIVILEGED and CONFIDENTIAL.
If you are not the intended recipient, you are hereby notified
that any dissemination of this communication is strictly prohibited.
If you have received this communication in error, please erase
all copies of the message and its attachments and notify us
immediately.
Thank you.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: a Linux -csh script to refresh test with production
well, you'd want to come up with your specifics but it's pretty simple using ssh... put this is your shell... $ mysqldump db-name | mysql -h remote.box.com db-name $ mysqldump db-name | ssh [EMAIL PROTECTED] mysql db-name $ mysqldump db-name foo | ssh [EMAIL PROTECTED] mysql bar hope this helps bb -Original Message- From: Brown, Charles [mailto:[EMAIL PROTECTED] Sent: Tue 3/27/2007 12:17 PM To: mysql@lists.mysql.com Subject: a Linux -csh script to refresh test with production Hello all. Does anyone out there (in mysql world) have a Linux -csh script to refresh test with production data. My developers would like their test database to be refreshed nightly with production data. The production and test mysql servers do not run in the same box. They run on different boxes. Therefore there is some ftp or scp required Thanks This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
copy data from prod to test - when database name is not the same name
Hello All, We have two mysql environment PROD and TEST. I would like to copy data from PROD to TEST. The PROD database name is Mysql_prod and the TEST database name is mysql_TEST. Using mysqldump or any applicable utility can someone show me how to migrate my production data from prod to test. The only thing that is different is the database name. The tables are all the same. Thanks in advance This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: copy data from prod to test - when database name is not the same name
mysql -h... -u... -p... -eCREATE DATABASE IF NOT EXISTS mysql_TEST; mysqldump -h... -u... -p... --routines --triggers Mysql_prod | mysql -h... -u... -p... -Dmysql_TEST - Original Message - From: Charles Brown [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Friday, February 23, 2007 10:48:27 AM (GMT-0500) Auto-Detected Subject: copy data from prod to test - when database name is not the same name Hello All, We have two mysql environment PROD and TEST. I would like to copy data from PROD to TEST. The PROD database name is Mysql_prod and the TEST database name is mysql_TEST. Using mysqldump or any applicable utility can someone show me how to migrate my production data from prod to test. The only thing that is different is the database name. The tables are all the same. Thanks in advance This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
test email
Sorry, but I haven't gotten any emails from the list and I'm trying to determine if there is a blockages. Sorry to disturb the list. --- William R. Mussatto, Senior Systems Engineer http://www.csz.com Ph. 909-920-9154 ext. 27 FAX. 909-608-7061 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
test msg don't care
test -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
checking return type of sprintf... configure: error: cannot run test program while cross compiling
Hi ! Any clue will be appriciated. I have following problem while cross compiling for powerpc. (Configure) checking return type of sprintf... configure: error: cannot run test program while cross compiling This occurs when makefile is generated with the following configure option. CC=powerpc-linux-gcc LD=powerpc-linux-ld ./configure --host=powerpc-linux --build=i686-pc-linux-gnu I also try many other options but this problem has not been resolved. Kindly help Thanks Arvind
Mysql: checking return type of sprintf... configure: error: cannot run test program while cross compiling
Hi ! Any clue will be appriciated. I have following problem while cross compiling for powerpc. (Configure) checking return type of sprintf... configure: error: cannot run test program while cross compiling This occurs when makefile is generated with the following configure option. CC=powerpc-linux-gcc LD=powerpc-linux-ld ./configure --host=powerpc-linux --build=i686-pc-linux-gnu Kindly help Thanks Arvind
Re: Looking For How test database performans on different hardware
Vahric, There are so many variations between different hardware platforms that can affect performance on your specific application that it's better to run benchmarks on the actual hardware if you have it. If not then Peter Zaitsev's performance blog is the next best resource. http://www.mysqlperformanceblog.com/category/hardware/ On 7/27/06, Vahric MUHTARYAN [EMAIL PROTECTED] wrote: Hello , I want to test Mysql , on Dual Intel Xeon 2MB Cache CPU and Dual AMD Opteron platforms for looking differents which one is better then other ! I found something but I want to asl to list , is there anybody have an experiance about this type tests ! Regards Vahric MUHTARYAN Sistem Mühendisi/System Engineer DorukNet Tel / Phone : +90 212 326 92 00 Fax : +90 212 227 28 11 E-mail : [EMAIL PROTECTED] http://www.doruk.net.tr http://www.doruk.net.tr/english.html Bu e-posta mesajı kişiye özel olup, gizli bilgiler içeriyor olabilir. Eğer bu e-posta mesajı size yanlışlıkla ulaşmışsa, e-posta mesajını kullanıcıya hemen geri gönderiniz ve mesaj kutunuzdan siliniz. Bu e-posta mesajı, hiç bir şekilde, herhangi bir amaç için çoğaltılamaz, yayınlanamaz ve para karşılığı satılamaz. Yollayıcı, bu e-posta mesajının - virüs koruma sistemleri ile kontrol ediliyor olsa bile - virüs içermediğini garanti etmez ve meydana gelebilecek zararlardan doğacak hiçbir sorumluluğu kabul etmez. The information contained in this message is confidential, intended solely for the use of the individual or entity to whom it is addressed and may be protected by professional secrecy. You should not copy, disclose or distribute this information for any purpose. If you are not the intended recipient of this message or you receive this mail in error, you should refrain from making any use of the contents and from opening any attachment. In that case, please notify the sender immediately and return the message to the sender, then, delete and destroy all copies. This e-mail message has been swept by anti-virus systems for the presence of computer viruses. In doing so, however, we cannot warrant that virus or other forms of data corruption may not be present and we do not take any responsibility in any occurrence. -- Eric Bergen [EMAIL PROTECTED] http://www.provenscaling.com
Looking For How test database performans on different hardware
Hello , I want to test Mysql , on Dual Intel Xeon 2MB Cache CPU and Dual AMD Opteron platforms for looking differents which one is better then other ! I found something but I want to asl to list , is there anybody have an experiance about this type tests ! Regards Vahric MUHTARYAN Sistem Mühendisi/System Engineer DorukNet Tel / Phone : +90 212 326 92 00 Fax : +90 212 227 28 11 E-mail : [EMAIL PROTECTED] http://www.doruk.net.tr http://www.doruk.net.tr/english.html Bu e-posta mesajı kişiye özel olup, gizli bilgiler içeriyor olabilir. Eğer bu e-posta mesajı size yanlışlıkla ulaşmışsa, e-posta mesajını kullanıcıya hemen geri gönderiniz ve mesaj kutunuzdan siliniz. Bu e-posta mesajı, hiç bir şekilde, herhangi bir amaç için çoğaltılamaz, yayınlanamaz ve para karşılığı satılamaz. Yollayıcı, bu e-posta mesajının - virüs koruma sistemleri ile kontrol ediliyor olsa bile - virüs içermediğini garanti etmez ve meydana gelebilecek zararlardan doğacak hiçbir sorumluluğu kabul etmez. The information contained in this message is confidential, intended solely for the use of the individual or entity to whom it is addressed and may be protected by professional secrecy. You should not copy, disclose or distribute this information for any purpose. If you are not the intended recipient of this message or you receive this mail in error, you should refrain from making any use of the contents and from opening any attachment. In that case, please notify the sender immediately and return the message to the sender, then, delete and destroy all copies. This e-mail message has been swept by anti-virus systems for the presence of computer viruses. In doing so, however, we cannot warrant that virus or other forms of data corruption may not be present and we do not take any responsibility in any occurrence.
Re: Segmentation fault error accrued when gcc -o test -L/usr/lib/mysql -lmysqlclient test.c
On Sunday 23 July 2006 10:26 pm, ali asghar torabi parizy wrote:
while ((row = mysql_fetch_row(res_set)) != NULL) {
while (row = mysql_fetch_row(res_set))
would do the same thing, NULL check shouldn't be necessary.
for (i=0; iltmysql_num_fields(res_set); i++) {
I hope your client is inserting that lt in there, that may be what's causing
your problem (not to mention it's lt;...)
printf(%s\n,row[i] != NULL ? row[i] : NULL);
}
}
--
Chris White
PHP Programmer/DBanned!
Interfuel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
gcc -o test -L/usr/lib/mysql -lmysqlclient test.c
hi to all.
thanks luiz and mike for response.
my code is compiled when i use -lmysqlclient option and executable file is now
exist but when i try to execute this file it prompts segmentation error
.what's the meaning of it and what i have to do?
The code is as fillows:
***
#include stdio.h
#include mysql.h
#define host localhost
#define username mysql
#define password
#define database test
MYSQL *conn;
int main() {
conn = mysql_init(NULL);
mysql_real_connect(conn,host,username,password,database,0,NULL,0);
MYSQL_RES *res_set;
MYSQL_ROW row;
unsigned int i;
mysql_query(conn,SELECT * FROM users WHERE userid=1);
res_set = mysql_store_result(conn);
unsigned int numrows = mysql_num_rows(res_set);
while ((row = mysql_fetch_row(res_set)) != NULL) {
for (i=0; iltmysql_num_fields(res_set); i++) {
printf(%s\n,row[i] != NULL ? row[i] : NULL);
}
}
mysql_close(conn);
return 0; }
*
Please help me
-
Do you Yahoo!?
Everyone is raving about the all-new Yahoo! Mail Beta.
Segmentation fault error accrued when gcc -o test -L/usr/lib/mysql -lmysqlclient test.c
hi to all.
thanks luiz and mike for response.
my code is compiled when i use -lmysqlclient option and executable file is now
exist but when i try to execute this file it prompts Segmentation fault
.what's the meaning of it and what i have to do?
##
gcc -o test -L/usr/lib/mysql -lmysqlclient test.c
##
The code is as fillows:
***
#include
#include
#define host localhost
#define username mysql
#define password
#define database test
MYSQL *conn;
int main() {
conn = mysql_init(NULL);
mysql_real_connect(conn,host,username,password,database,0,NULL,0);
MYSQL_RES *res_set;
MYSQL_ROW row;
unsigned int i;
mysql_query(conn,SELECT * FROM users WHERE userid=1);
res_set = mysql_store_result(conn);
unsigned int numrows = mysql_num_rows(res_set);
while ((row = mysql_fetch_row(res_set)) != NULL) {
for (i=0; iltmysql_num_fields(res_set); i++) {
printf(%s\n,row[i] != NULL ? row[i] : NULL);
}
}
mysql_close(conn);
return 0; }
*
Please help me
-
Do you Yahoo!?
Everyone is raving about the all-new Yahoo! Mail Beta.
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
I can not find the mysql database, but information_schema and test
Hi there, I am trying to install/configure the Mysql Ver. 5.0.22-standard on a SUN-Solaris 2.10 (SPARC) machine. After having installed the SUN-package, I run the script mysql_install_db using the following command (beeng connected as user 'mysql'): NMS:mysql@ /opt/mysql/mysql/scripts/mysql_install_db --user=mysql After that I started the mysql server: /opt/mysql/mysql/bin/mysqld -u mysql At this point I run the command mysqlshow in order the check the granted databases: I can see both the information_schema and test databases, but I am missing the mysql database. What am I doing wrong? Thanks in advance and Kind Regards Fabrizio _ Fabrizio Calselli Referent Netzwerk-Management Systemtechnik - IT/Org SCHUFA Holding AG Kormoranweg 5 D-65201 Wiesbaden Tel. : +49 (0) 6 11 - 92 78 - 235 Handy: +49 (0) 173 - 34 83 858 Fax: +49 (0) 6 11 - 92 78 - 209 E-Mail: [EMAIL PROTECTED] www.schufa.de _
Question on mysql-test-run sp failed
Hi, Recently, I built mysql5.0 on Solaris 10 amd64, but when running make test, the bundled sp test failed with the following error: mysqltest: At line 1527: query 'call fib(20)' failed: 1436: Thread stack overrun: 186944 bytes used of a 262144 byte stack, and 81920 bytes needed. Use 'mysqld -O thread_stack=#' to specify a bigger stack. (the last lines may be the most important ones) Looking at the test source code, I saw the following lines: # Enable recursion set @@max_sp_recursion_depth= 20| # Minimum test: recursion of 3 levels insert into fib values (0), (1)| call fib(3)| select * from fib order by f asc| delete from fib| # Original test: 20 levels (may run into memory limits!) insert into fib values (0), (1)| call fib(20)| When calling a recursive procedure many times with a limited stack, it's quite possible to overrun the stack, and looks like that authors of the test wanted to note exactly this - could you please let me know if my understanding is correct, and let me know how to increase the stack limit for the mysqld process? Thanks much for your information in advance. Regards, Jenny
Re: Question on mysql-test-run sp failed
Hi Jenny Jenny Chen wrote: Hi, Recently, I built mysql5.0 on Solaris 10 amd64, but when running make test, the bundled sp test failed with the following error: mysqltest: At line 1527: query 'call fib(20)' failed: 1436: Thread stack overrun: 186944 bytes used of a 262144 byte stack, and 81920 bytes needed. Use 'mysqld -O thread_stack=#' to specify a bigger stack. (the last lines may be the most important ones) From what I understand (I am also building MySQL from the source), there are memory constraints with the number of threads and the stack size for each thread. See the following (it's not for 5.0/Solaris, but might help anyway) : http://dev.mysql.com/doc/refman/5.1/en/source-notes-linux.html Marc Alff. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL Test Framework documented
MySQL is shipped with a set of test cases and programs for running them. These tools constitute the MySQL test framework that provides a means for verifying that MySQL Server and its client programs operate according to expectations. That's handy for anybody developing MySQL or contributing code to MySQL. In case the preconfigured test cases (there are hundreds) don't suffice the MySQL test framework can be extended by writing test cases using the mysqltest language. The MySQL test framework has been around for a long time, but making use of the mysqltest language was something for the inaugurated only because there was no documentation, except for this: You can use the mysqltest language to write your own test cases. Unfortunately, we have not yet written full documentation for it. You can, however, look at our current test cases and use them as an example. Well, tables have turned, and the MySQL test framework is documented on more than 60 pages now. For anyone contributing code to MySQL it's a must-read. But don't be afraid, it's also fun to read, because it was written by Paul DuBois. See for yourself: http://dev.mysql.com/doc/index.html#mysqltest Regards, Stefan -- Stefan Hinz [EMAIL PROTECTED] MySQL AB Documentation Team Lead. Berlin, Germany (UTC +2:00) Skype:stefanhinz Cell:+491777841069 Desk:+493082702940 Fax:+493082702941 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: DBD::mysql will make but won't test on Solaris10...
Well I tried removing -lmtmalloc from the LIBS line. Like before, I was able to make but not make test. This time I just get a different error after test. I could look into solving this error, but is this just treating the symptoms though? Ideas welcome, TIA, F # /usr/local/bin/make test PERL_DL_NONLAZY=1 /usr/bin/perl -MExtUtils::Command::MM -e test_harness(0, 'blib/lib', 'blib/arch') t/*.t t/00base.install_driver(mysql) failed: Can't load '/export/home/root/.cpan/build/DBD-mysql-3.0002/blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: ld.so.1: perl: fatal: relocation error: file /export/home/root/.cpan/build/DBD-mysql-3.0002/blib/arch/auto/DBD/mysql/mysql.so: symbol mysql_real_escape_string: referenced symbol not found at /usr/perl5/5.8.4/lib/sun4-solaris-64int/DynaLoader.pm line 230. at (eval 1) line 3 Compilation failed in require at (eval 1) line 3. Perhaps a required shared library or dll isn't installed where expected at t/00base.t line 38 t/00base.dubious Test returned status 255 (wstat 65280, 0xff00) DIED. FAILED tests 4-5 Failed 2/5 tests, 60.00% okay On 12/7/05, Gleb Paharenko [EMAIL PROTECTED] wrote: Hello. I'm not a Solaris or DBD guru, so I could be wrong, but ldd output doesn't show that mysql.so loads libmysqlclient (however, it can be statically linked). There could be some problems with compiling MySQL clients which described more in detail at: http://dev.mysql.com/doc/refman/5.0/en/solaris.html http://dev.mysql.com/doc/refman/5.0/en/perl-support-problems.html I've found a bit similar issue related to building php-mysql extension on MySQL forums. The person declares that he has solve the problem. May be it will help you: http://forums.mysql.com/read.php?52,9,9,quote=1` Jake Peavy [EMAIL PROTECTED] wrote: Yep, the objects appear to be ok including the offending libmtmalloc.so.1... # ldd /export/home/root/.cpan/build/DBD-mysql-3.0002 /blib/arch/auto/DBD/mysql/mysql.so librt.so.1 =/lib/librt.so.1 libcrypt_i.so.1 = /usr/lib/libcrypt_i.so.1 libgen.so.1 = /lib/libgen.so.1 libsocket.so.1 =/lib/libsocket.so.1 libnsl.so.1 = /lib/libnsl.so.1 libm.so.2 = /lib/libm.so.2 libmtmalloc.so.1 = /usr/lib/libmtmalloc.so.1 libc.so.1 = /lib/libc.so.1 libaio.so.1 = /lib/libaio.so.1 libmd5.so.1 = /lib/libmd5.so.1 libmp.so.2 =/lib/libmp.so.2 libscf.so.1 = /lib/libscf.so.1 libdoor.so.1 = /lib/libdoor.so.1 libuutil.so.1 = /lib/libuutil.so.1 /platform/SUNW,Ultra-80/lib/libc_psr.so.1 /platform/SUNW,Ultra-80/lib/libmd5_psr.so.1 On 12/7/05, Mir Islam [EMAIL PROTECTED] wrote: hmm it appears that the module got compiled fine. Try doing: ldd /export/home/root/.cpan/build/DBD-mysql-3.0002 /blib/arch/auto/DBD/mysql/mysql.so and see if all of the referenced objects are loading fine On 12/7/05, Jake Peavy [EMAIL PROTECTED] wrote: Since I didn't get a response from the perl list, and since Daryn received some responses to his similar question I thought I might see if you guys had any ideas on why I can't make test for DBD::mysql on Solaris. TIA, F -- Forwarded message -- From: Jake Peavy [EMAIL PROTECTED] Date: Nov 29, 2005 11:37 PM Subject: DBD::mysql will make but won't test on Solaris10... To: [EMAIL PROTECTED] Hey yall, I'm having all kinds of problems trying to install DBD::mysql on my newly built Solaris 10 box. I have installed the Sun CC compiler, and DBI installed fine along with a number of other CPAN modules. I have installed mysql via the pkgadd package. Here's the output (this is only the results from the first test. none of the tests passed 100% - there were TONS of failures.) note that there are some warnings thrown by make - duplicate functions? xarch=v9 not recognized? also, libmtmalloc.so.1 is located in /usr/lib. Thanks in advance, -jp CPAN.pm: Going to build C/CA/CAPTTOFU/DBD- mysql-3.0002.tar.gz I will use the following settings for compiling and testing: cflags(mysql_config) = -I/opt/mysql/mysql/include -xO3 -mt -D_FORTEC_ -xarch=v9 -xc99=none embedded (mysql_config) = libs (mysql_config) = -xarch=v9 -L/opt/mysql/mysql/lib -lmysqlclient -lz -lposix4 -lcrypt -lgen -lsocket -lnsl -lm -lmtmalloc mysql_config (guessed ) = mysql_config nocatchstderr (default ) = 0 nofoundrows (default ) = 0 ssl (guessed ) = 0 testdb(default ) = test testhost (default ) = testpassword (default ) = testsocket(default
Fwd: DBD::mysql will make but won't test on Solaris10...
Since I didn't get a response from the perl list, and since Daryn received some responses to his similar question I thought I might see if you guys had any ideas on why I can't make test for DBD::mysql on Solaris. TIA, F -- Forwarded message -- From: Jake Peavy [EMAIL PROTECTED] Date: Nov 29, 2005 11:37 PM Subject: DBD::mysql will make but won't test on Solaris10... To: [EMAIL PROTECTED] Hey yall, I'm having all kinds of problems trying to install DBD::mysql on my newly built Solaris 10 box. I have installed the Sun CC compiler, and DBI installed fine along with a number of other CPAN modules. I have installed mysql via the pkgadd package. Here's the output (this is only the results from the first test. none of the tests passed 100% - there were TONS of failures.) note that there are some warnings thrown by make - duplicate functions? xarch=v9 not recognized? also, libmtmalloc.so.1 is located in /usr/lib. Thanks in advance, -jp CPAN.pm: Going to build C/CA/CAPTTOFU/DBD-mysql-3.0002.tar.gz I will use the following settings for compiling and testing: cflags(mysql_config) = -I/opt/mysql/mysql/include -xO3 -mt -D_FORTEC_ -xarch=v9 -xc99=none embedded (mysql_config) = libs (mysql_config) = -xarch=v9 -L/opt/mysql/mysql/lib -lmysqlclient -lz -lposix4 -lcrypt -lgen -lsocket -lnsl -lm -lmtmalloc mysql_config (guessed ) = mysql_config nocatchstderr (default ) = 0 nofoundrows (default ) = 0 ssl (guessed ) = 0 testdb(default ) = test testhost (default ) = testpassword (default ) = testsocket(default ) = testuser (default ) = To change these settings, see 'perl Makefile.PL --help' and 'perldoc INSTALL'. Checking if your kit is complete... Looks good Unrecognized argument in LIBS ignored: '-xarch=v9' Using DBI 1.48 (for perl 5.008004 on sun4-solaris-64int) installed in /usr/perl5/site_perl/5.8.4/sun4-solaris-64int/auto/DBI/ Writing Makefile for DBD::mysql cp lib/DBD/mysql.pm blib/lib/DBD/mysql.pm cp lib/DBD/mysql/GetInfo.pm blib/lib/DBD/mysql/GetInfo.pm cp lib/Mysql.pm blib/lib/Mysql.pm cp lib/DBD/mysql/INSTALL.pod blib/lib/DBD/mysql/INSTALL.pod cp lib/Mysql/Statement.pm blib/lib/Mysql/Statement.pm cp lib/Bundle/DBD/mysql.pm blib/lib/Bundle/DBD/mysql.pm cc -c -I/usr/perl5/site_perl/5.8.4/sun4-solaris-64int/auto/DBI/ -I/opt/mysql/mysql/include -xO3 -mt -D_FORTEC_ -xarch=v9 -xc99=none -DDBD_MYSQL_INSERT_ID_IS_G OOD -g -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -xarch=v8 -D_TS_ERRNO -xO3 -xspace -xildoff -DVERSION=\ 3.0002\ -DXS_VERSION=\3.0002\ -KPIC -I/usr/per l5/5.8.4/lib/sun4-solaris-64int/CORE dbdimp.c /usr/bin/perl -p -e s/~DRIVER~/mysql/g /usr/perl5/site_perl/5.8.4/sun4-solaris-64int/auto/DBI//Driver.xst mysql.xsi /usr/bin/perl /usr/perl5/5.8.4/lib/ExtUtils/xsubpp -typemap /usr/perl5/5.8.4/lib/ExtUtils/typemap mysql.xs mysql.xsc mv mysql.xsc mysql.c Warning: duplicate function definition 'do' detected in mysql.xs, line 224 Warning: duplicate function definition 'rows' detected in mysql.xs, line 559 cc -c -I/usr/perl5/site_perl/5.8.4/sun4-solaris-64int/auto/DBI/ -I/opt/mysql/mysql/include -xO3 -mt -D_FORTEC_ -xarch=v9 -xc99=none -DDBD_MYSQL_INSERT_ID_IS_G OOD -g -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -xarch=v8 -D_TS_ERRNO -xO3 -xspace -xildoff -DVERSION=\ 3.0002\ -DXS_VERSION=\3.0002\ -KPIC -I/usr/per l5/5.8.4/lib/sun4-solaris-64int/CORE mysql.c Running Mkbootstrap for DBD::mysql () chmod 644 mysql.bs rm -f blib/arch/auto/DBD/mysql/mysql.so LD_RUN_PATH=/opt/mysql/mysql/lib:/lib:/usr/lib /usr/bin/perl myld cc -G dbdimp.o mysql.o -o blib/arch/auto/DBD/mysql/mysql.so -L/opt/mysql/mysql/lib -lmy sqlclient -lz -lposix4 -lcrypt -lgen -lsocket -lnsl -lm -lmtmalloc chmod 755 blib/arch/auto/DBD/mysql/mysql.so cp mysql.bs blib/arch/auto/DBD/mysql/mysql.bs chmod 644 blib/arch/auto/DBD/mysql/mysql.bs Manifying blib/man3/DBD::mysql.3 Manifying blib/man3/DBD::mysql::INSTALL.3 Manifying blib/man3/Mysql.3 Manifying blib/man3/Bundle::DBD::mysql.3 /usr/local/bin/make -- OK Running make test PERL_DL_NONLAZY=1 /usr/bin/perl -MExtUtils::Command::MM -e test_harness(0, 'blib/lib', 'blib/arch') t/*.t t/00base.install_driver(mysql) failed: Can't load '/export/home/root/.cpan/build/DBD- mysql-3.0002/blib/arch/auto/DBD/mysql/mysql.so' for module DBD ::mysql: ld.so.1: perl: fatal: libmtmalloc.so.1 : DF_1_NOOPEN tagged object may not be dlopen()'ed at /usr/perl5/5.8.4/lib/sun4-solaris-64int/DynaLoader.pm line 230. at (eval 1) line 3 Compilation failed in require at (eval 1) line 3. Perhaps a required shared library or dll isn't installed where expected at t/00base.t line 38 dubious Test returned status 255 (wstat 65280, 0xff00) DIED. FAILED tests 4-5 Failed 2/5 tests, 60.00% okay
Re: DBD::mysql will make but won't test on Solaris10...
Yep, the objects appear to be ok including the offending libmtmalloc.so.1... # ldd /export/home/root/.cpan/build/DBD-mysql-3.0002 /blib/arch/auto/DBD/mysql/mysql.so librt.so.1 =/lib/librt.so.1 libcrypt_i.so.1 = /usr/lib/libcrypt_i.so.1 libgen.so.1 = /lib/libgen.so.1 libsocket.so.1 =/lib/libsocket.so.1 libnsl.so.1 = /lib/libnsl.so.1 libm.so.2 = /lib/libm.so.2 libmtmalloc.so.1 = /usr/lib/libmtmalloc.so.1 libc.so.1 = /lib/libc.so.1 libaio.so.1 = /lib/libaio.so.1 libmd5.so.1 = /lib/libmd5.so.1 libmp.so.2 =/lib/libmp.so.2 libscf.so.1 = /lib/libscf.so.1 libdoor.so.1 = /lib/libdoor.so.1 libuutil.so.1 = /lib/libuutil.so.1 /platform/SUNW,Ultra-80/lib/libc_psr.so.1 /platform/SUNW,Ultra-80/lib/libmd5_psr.so.1 On 12/7/05, Mir Islam [EMAIL PROTECTED] wrote: hmm it appears that the module got compiled fine. Try doing: ldd /export/home/root/.cpan/build/DBD-mysql-3.0002 /blib/arch/auto/DBD/mysql/mysql.so and see if all of the referenced objects are loading fine On 12/7/05, Jake Peavy [EMAIL PROTECTED] wrote: Since I didn't get a response from the perl list, and since Daryn received some responses to his similar question I thought I might see if you guys had any ideas on why I can't make test for DBD::mysql on Solaris. TIA, F -- Forwarded message -- From: Jake Peavy [EMAIL PROTECTED] Date: Nov 29, 2005 11:37 PM Subject: DBD::mysql will make but won't test on Solaris10... To: [EMAIL PROTECTED] Hey yall, I'm having all kinds of problems trying to install DBD::mysql on my newly built Solaris 10 box. I have installed the Sun CC compiler, and DBI installed fine along with a number of other CPAN modules. I have installed mysql via the pkgadd package. Here's the output (this is only the results from the first test. none of the tests passed 100% - there were TONS of failures.) note that there are some warnings thrown by make - duplicate functions? xarch=v9 not recognized? also, libmtmalloc.so.1 is located in /usr/lib. Thanks in advance, -jp CPAN.pm: Going to build C/CA/CAPTTOFU/DBD- mysql-3.0002.tar.gz I will use the following settings for compiling and testing: cflags(mysql_config) = -I/opt/mysql/mysql/include -xO3 -mt -D_FORTEC_ -xarch=v9 -xc99=none embedded (mysql_config) = libs (mysql_config) = -xarch=v9 -L/opt/mysql/mysql/lib -lmysqlclient -lz -lposix4 -lcrypt -lgen -lsocket -lnsl -lm -lmtmalloc mysql_config (guessed ) = mysql_config nocatchstderr (default ) = 0 nofoundrows (default ) = 0 ssl (guessed ) = 0 testdb(default ) = test testhost (default ) = testpassword (default ) = testsocket(default ) = testuser (default ) = To change these settings, see 'perl Makefile.PL --help' and 'perldoc INSTALL'. Checking if your kit is complete... Looks good Unrecognized argument in LIBS ignored: '-xarch=v9' Using DBI 1.48 (for perl 5.008004 on sun4-solaris-64int) installed in /usr/perl5/site_perl/5.8.4/sun4-solaris-64int/auto/DBI/ Writing Makefile for DBD::mysql cp lib/DBD/mysql.pm blib/lib/DBD/mysql.pm cp lib/DBD/mysql/GetInfo.pm blib/lib/DBD/mysql/GetInfo.pm cp lib/Mysql.pm blib/lib/Mysql.pm cp lib/DBD/mysql/INSTALL.pod blib/lib/DBD/mysql/INSTALL.pod cp lib/Mysql/Statement.pm blib/lib/Mysql/Statement.pm cp lib/Bundle/DBD/mysql.pm blib/lib/Bundle/DBD/mysql.pm cc -c -I/usr/perl5/site_perl/5.8.4/sun4-solaris-64int/auto/DBI/ -I/opt/mysql/mysql/include -xO3 -mt -D_FORTEC_ -xarch=v9 -xc99=none -DDBD_MYSQL_INSERT_ID_IS_G OOD -g -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -xarch=v8 -D_TS_ERRNO -xO3 -xspace -xildoff -DVERSION=\ 3.0002\ -DXS_VERSION=\3.0002\ -KPIC -I/usr/per l5/5.8.4/lib/sun4-solaris-64int/CORE dbdimp.c /usr/bin/perl -p -e s/~DRIVER~/mysql/g /usr/perl5/site_perl/5.8.4/sun4-solaris-64int/auto/DBI//Driver.xst mysql.xsi /usr/bin/perl /usr/perl5/5.8.4/lib/ExtUtils/xsubpp -typemap /usr/perl5/5.8.4/lib/ExtUtils/typemap mysql.xs mysql.xsc mv mysql.xsc mysql.c Warning: duplicate function definition 'do' detected in mysql.xs, line 224 Warning: duplicate function definition 'rows' detected in mysql.xs, line 559 cc -c -I/usr/perl5/site_perl/5.8.4/sun4-solaris-64int/auto/DBI/ -I/opt/mysql/mysql/include -xO3 -mt -D_FORTEC_ -xarch=v9 -xc99=none -DDBD_MYSQL_INSERT_ID_IS_G OOD -g -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -xarch=v8 -D_TS_ERRNO -xO3 -xspace -xildoff -DVERSION=\ 3.0002\ -DXS_VERSION=\3.0002\ -KPIC -I/usr/per l5/5.8.4/lib/sun4-solaris-64int/CORE mysql.c Running Mkbootstrap for DBD::mysql () chmod 644 mysql.bs rm -f blib/arch/auto/DBD/mysql/mysql.so LD_RUN_PATH=/opt/mysql/mysql/lib:/lib
Re: DBD::mysql will make but won't test on Solaris10...
Hello. I'm not a Solaris or DBD guru, so I could be wrong, but ldd output doesn't show that mysql.so loads libmysqlclient (however, it can be statically linked). There could be some problems with compiling MySQL clients which described more in detail at: http://dev.mysql.com/doc/refman/5.0/en/solaris.html http://dev.mysql.com/doc/refman/5.0/en/perl-support-problems.html I've found a bit similar issue related to building php-mysql extension on MySQL forums. The person declares that he has solve the problem. May be it will help you: http://forums.mysql.com/read.php?52,9,9,quote=1` Jake Peavy [EMAIL PROTECTED] wrote: Yep, the objects appear to be ok including the offending libmtmalloc.so.1... # ldd /export/home/root/.cpan/build/DBD-mysql-3.0002 /blib/arch/auto/DBD/mysql/mysql.so librt.so.1 =/lib/librt.so.1 libcrypt_i.so.1 = /usr/lib/libcrypt_i.so.1 libgen.so.1 = /lib/libgen.so.1 libsocket.so.1 =/lib/libsocket.so.1 libnsl.so.1 = /lib/libnsl.so.1 libm.so.2 = /lib/libm.so.2 libmtmalloc.so.1 = /usr/lib/libmtmalloc.so.1 libc.so.1 = /lib/libc.so.1 libaio.so.1 = /lib/libaio.so.1 libmd5.so.1 = /lib/libmd5.so.1 libmp.so.2 =/lib/libmp.so.2 libscf.so.1 = /lib/libscf.so.1 libdoor.so.1 = /lib/libdoor.so.1 libuutil.so.1 = /lib/libuutil.so.1 /platform/SUNW,Ultra-80/lib/libc_psr.so.1 /platform/SUNW,Ultra-80/lib/libmd5_psr.so.1 On 12/7/05, Mir Islam [EMAIL PROTECTED] wrote: hmm it appears that the module got compiled fine. Try doing: ldd /export/home/root/.cpan/build/DBD-mysql-3.0002 /blib/arch/auto/DBD/mysql/mysql.so and see if all of the referenced objects are loading fine On 12/7/05, Jake Peavy [EMAIL PROTECTED] wrote: Since I didn't get a response from the perl list, and since Daryn received some responses to his similar question I thought I might see if you guys had any ideas on why I can't make test for DBD::mysql on Solaris. TIA, F -- Forwarded message -- From: Jake Peavy [EMAIL PROTECTED] Date: Nov 29, 2005 11:37 PM Subject: DBD::mysql will make but won't test on Solaris10... To: [EMAIL PROTECTED] Hey yall, I'm having all kinds of problems trying to install DBD::mysql on my newly built Solaris 10 box. I have installed the Sun CC compiler, and DBI installed fine along with a number of other CPAN modules. I have installed mysql via the pkgadd package. Here's the output (this is only the results from the first test. none of the tests passed 100% - there were TONS of failures.) note that there are some warnings thrown by make - duplicate functions? xarch=v9 not recognized? also, libmtmalloc.so.1 is located in /usr/lib. Thanks in advance, -jp CPAN.pm: Going to build C/CA/CAPTTOFU/DBD- mysql-3.0002.tar.gz I will use the following settings for compiling and testing: cflags(mysql_config) = -I/opt/mysql/mysql/include -xO3 -mt -D_FORTEC_ -xarch=v9 -xc99=none embedded (mysql_config) = libs (mysql_config) = -xarch=v9 -L/opt/mysql/mysql/lib -lmysqlclient -lz -lposix4 -lcrypt -lgen -lsocket -lnsl -lm -lmtmalloc mysql_config (guessed ) = mysql_config nocatchstderr (default ) = 0 nofoundrows (default ) = 0 ssl (guessed ) = 0 testdb(default ) = test testhost (default ) = testpassword (default ) = testsocket(default ) = testuser (default ) = To change these settings, see 'perl Makefile.PL --help' and 'perldoc INSTALL'. Checking if your kit is complete... Looks good Unrecognized argument in LIBS ignored: '-xarch=v9' Using DBI 1.48 (for perl 5.008004 on sun4-solaris-64int) installed in /usr/perl5/site_perl/5.8.4/sun4-solaris-64int/auto/DBI/ Writing Makefile for DBD::mysql cp lib/DBD/mysql.pm blib/lib/DBD/mysql.pm cp lib/DBD/mysql/GetInfo.pm blib/lib/DBD/mysql/GetInfo.pm cp lib/Mysql.pm blib/lib/Mysql.pm cp lib/DBD/mysql/INSTALL.pod blib/lib/DBD/mysql/INSTALL.pod cp lib/Mysql/Statement.pm blib/lib/Mysql/Statement.pm cp lib/Bundle/DBD/mysql.pm blib/lib/Bundle/DBD/mysql.pm cc -c -I/usr/perl5/site_perl/5.8.4/sun4-solaris-64int/auto/DBI/ -I/opt/mysql/mysql/include -xO3 -mt -D_FORTEC_ -xarch=v9 -xc99=none -DDBD_MYSQL_INSERT_ID_IS_G OOD -g -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -xarch=v8 -D_TS_ERRNO -xO3 -xspace -xildoff -DVERSION=\ 3.0002\ -DXS_VERSION=\3.0002\ -KPIC -I/usr/per l5/5.8.4/lib/sun4-solaris-64int/CORE dbdimp.c /usr/bin/perl -p -e s/~DRIVER~/mysql/g /usr/perl5/site_perl/5.8.4/sun4-solaris-64int/auto/DBI//Driver.xst mysql.xsi /usr/bin/perl /usr/perl5/5.8.4/lib/ExtUtils
how to test if strings are numeric ?
Hi everybody, I looked for a function to test whether a string is numeric (having characters 0..9 only). I found in the 5.0 manual Cast() and Convert(), but I don't think these do what I need. Any suggestion what function to use ? Thanks in advance, Cor
Re: how to test if strings are numeric ?
Hello. Possible solution is to use REGEXP: mysql select '911' regexp '^[1-9]*$'; +-+ | '911' regexp '^[1-9]*$' | +-+ | 1 | +-+ mysql select '91a1' regexp '^[1-9]*$'; +--+ | '91a1' regexp '^[1-9]*$' | +--+ |0 | +--+ C.R.Vegelin [EMAIL PROTECTED] wrote: Hi everybody, I looked for a function to test whether a string is numeric (having characters 0..9 only). I found in the 5.0 manual Cast() and Convert(), but I don't think these do what I need. Any suggestion what function to use ? Thanks in advance, Cor -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: how to test if strings are numeric ?
This is very useful. Can you please also show how this can be used to validate user input like for example: We have this query currently: select id from users where id like 'user_enterred-value%'; Now I want to validate that the user-enterred-value is only a numeric value... (the major problem is where users enter special characters that leads to exceptions / errors being thrown - like if the user enterred ' (a single quote) that would close the string and the %' would be considered as an invalid character..) Thanks - Anoop On 12/3/05, Gleb Paharenko [EMAIL PROTECTED] wrote: Hello. Possible solution is to use REGEXP: mysql select '911' regexp '^[1-9]*$'; +-+ | '911' regexp '^[1-9]*$' | +-+ | 1 | +-+ mysql select '91a1' regexp '^[1-9]*$'; +--+ | '91a1' regexp '^[1-9]*$' | +--+ |0 | +--+ C.R.Vegelin [EMAIL PROTECTED] wrote: Hi everybody, I looked for a function to test whether a string is numeric (having characters 0..9 only). I found in the 5.0 manual Cast() and Convert(), but I don't think these do what I need. Any suggestion what function to use ? Thanks in advance, Cor -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Thanks and best regards, Anoop
Re: how to test if strings are numeric ?
C.R.Vegelin [EMAIL PROTECTED] wrote: Hi everybody, I looked for a function to test whether a string is numeric (having characters 0..9 only). I found in the 5.0 manual Cast() and Convert(), but I don't think these do what I need. Any suggestion what function to use ? Thanks in advance, Cor Gleb Paharenko wrote: Hello. Possible solution is to use REGEXP: mysql select '911' regexp '^[1-9]*$'; +-+ | '911' regexp '^[1-9]*$' | +-+ | 1 | +-+ mysql select '91a1' regexp '^[1-9]*$'; +--+ | '91a1' regexp '^[1-9]*$' | +--+ |0 | +--+ This is close, but not quite what you want, I think. The problem is that this will also match empty strings: mysql SELECT '' REGEXP '^[1-9]*$'; +--+ | '' REGEXP '^[1-9]*$' | +--+ |1 | +--+ 1 row in set (0.00 sec) That's easily fixed, though. Just change the * to a +. mysql SELECT '' REGEXP '^[1-9]+$'; +--+ | '' REGEXP '^[1-9]+$' | +--+ |0 | +--+ 1 row in set (0.00 sec) Michael -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: how to test if strings are numeric ?
Anoop kumar V [EMAIL PROTECTED] wrote on 12/03/2005 11:59:10 AM: This is very useful. Can you please also show how this can be used to validate user input like for example: We have this query currently: select id from users where id like 'user_enterred-value%'; Now I want to validate that the user-enterred-value is only a numeric value... (the major problem is where users enter special characters that leads to exceptions / errors being thrown - like if the user enterred ' (a single quote) that would close the string and the %' would be considered as an invalid character..) Thanks - Anoop On 12/3/05, Gleb Paharenko [EMAIL PROTECTED] wrote: Hello. Possible solution is to use REGEXP: mysql select '911' regexp '^[1-9]*$'; +-+ | '911' regexp '^[1-9]*$' | +-+ | 1 | +-+ mysql select '91a1' regexp '^[1-9]*$'; +--+ | '91a1' regexp '^[1-9]*$' | +--+ |0 | +--+ C.R.Vegelin [EMAIL PROTECTED] wrote: Hi everybody, I looked for a function to test whether a string is numeric (having characters 0..9 only). I found in the 5.0 manual Cast() and Convert(), but I don't think these do what I need. Any suggestion what function to use ? Thanks in advance, Cor -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- Thanks and best regards, Anoop User input is generally validated BEFORE it hits the database. Do it in your application so that you don't need to spend the time for another round-trip to the database to verify if a string is all numeric or not. Most languages have some sort of REGEXP function in them so the same tip should apply no matter what you are using to get the user's input. Once MySQL develops CHECK constraints, then it makes sense to second-check the data at the database level. Until then, just validate your user input at the application level. Shawn Green Database Administrator Unimin Corporation - Spruce Pine
Re: mysql-test-run -- func_compress failed with out of memory error...
Hi Scott, all!
Scott Fletcher wrote:
Hi!
I am in the process of upgrading the machine with everything
to a newer versions. This time, I'm getting rid of the IBM DB2 as it
won't be there. So, I downloaded the MySQL 64 bits for the AIX and
extracted it there. The AIX server use 64 bits kernel and Enhanced
Journal File System (JFS2). It also have 1 GB of RAM and 35 GB Hard
Disk. I remembered that running this test is require to make sure MySQL
work properly and can handle the workload with the machine. So, I typed
the mysql-test-run command and here's what I got.
[[...]]
func_compress [ fail ]
Errors are (from /usr/local/mysql/mysql-test/var/log/mysqltest-time) :
mysqltest: At line 48: query 'select compress(repeat('aa',
IF('', 10, 1000))) is null' failed: 5: Out of memory (Needed
12024 bytes)
[[...]]
I'm a little baffled because the server have 1 GB of RAM. Something is
wrong. So, what's up with that?
Well, I trust you did your math:
IF('', 10, 1000) evaluates to 1000 (ten million)
repeat('aa', IF('', 10, 1000)) evaluates to
repeat('aa', 1000)which evaluates to
ten million repetitions of a ten character string
So the command demands the compression of a (roughly) 100 MB string, and
it should not be too surprising it requires 120 MB for this.
(Yes, inexact - I ignored the distinction between 10^3 and 2^10, these
are just first approximations.)
If you want this to succeed, ensure that the MySQL server process is
started with unlimited memory settings, so that it can dynamically
allocate a sufficient amount of RAM.
The mere presence of that RAM (or swap space) does not yet give a
process the rights to allocate it.
I think you may safely ignore this test failure, if all other tests pass
- this kind of failure is to be expected unless the machine setup is
specifically tailored.
But if you expect your MySQL server to allocate large amounts of RAM, it
may be better to configure it so that the test passes. One way to do
this is the command we use on our build + test box:
ulimit -d unlimited
Note that it must be executed in the shell (hierarchy) that later starts
the server, so you have to integrate it at a suitable place.
Regards,
Joerg
--
Joerg Bruehe, Senior Production Engineer
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysql-test-run -- func_compress failed with out of memory error...
Hi!
I am in the process of upgrading the machine with everything
to a newer versions. This time, I'm getting rid of the IBM DB2 as it
won't be there. So, I downloaded the MySQL 64 bits for the AIX and
extracted it there. The AIX server use 64 bits kernel and Enhanced
Journal File System (JFS2). It also have 1 GB of RAM and 35 GB Hard
Disk. I remembered that running this test is require to make sure MySQL
work properly and can handle the workload with the machine. So, I typed
the mysql-test-run command and here's what I got.
--snip-
fulltext [ pass ]
fulltext2 [ pass ]
fulltext_cache [ pass ]
fulltext_distinct [ pass ]
fulltext_left_join [ pass ]
fulltext_multi [ pass ]
fulltext_order_by [ pass ]
fulltext_update[ pass ]
fulltext_var [ pass ]
func_compress [ fail ]
Errors are (from /usr/local/mysql/mysql-test/var/log/mysqltest-time) :
mysqltest: At line 48: query 'select compress(repeat('aa',
IF('', 10, 1000))) is null' failed: 5: Out of memory (Needed
12024 bytes)
(the last lines may be the most important ones)
Aborting: func_compress failed in default mode. To continue, re-run with
'--force'.
Ending Tests
Shutting-down MySQL daemon
Master shutdown finished
Slave shutdown finished
--snip-
I'm a little baffled because the server have 1 GB of RAM. Something is
wrong. So, what's up with that?
Thanks,
Scott
Re: Re:Re: Re: How Can I upgrade TPC-C performance test result for mysql
George, is the utilization of both CPUs only 10 %? How big it is in the test with MS SQL Server? The workload is very much disk-bound if CPU usage is only 10 %. Regards, Heikki Oracle/Innobase - Original Message - From: yanghaifeng [EMAIL PROTECTED] Newsgroups: mailing.database.myodbc Sent: Wednesday, November 02, 2005 3:28 AM Subject: Re:Re: Re: How Can I upgrade TPC-C performance test result for mysql Heikki, We thanks vary much for your response. The CPU usage is avg 10% during the test. We think if you need we will give you our test source code. Best regards, george -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re:Re: Re: How Can I upgrade TPC-C performance test result for mysql
Heikki, We thanks vary much for your response. The CPU usage is avg 10% during the test. We think if you need we will give you our test source code. Best regards, george
Re: Re: How Can I upgrade TPC-C performance test result for mysql
George, there seem to be two bottlenecks: 1) InnoDB has contention on the buffer pool mutex; 2) the workload is also disk-read-bound. For 1), we might have an improvement available in the future. We must let the threads leave the 'wait array' in sync0arr.c without reserving the wait array mutex. Also, we need to study if we can reduce the code that is executed when we have the buffer pool mutex reserved. To reduce 2), you can try increasing innodb_buffer_pool_size further. But be careful that Windows will not start swapping. What does the Task Manager say about CPU usage during the test? Regards, Heikki Oracle/Innobase ... Dear Heikki, we change the system's environment. now we use RAID0 disk to store the InnoDB data file,and other disk to store log file. follow is system's information: CPU: 4X2.8GHz RAM: 1G Disk: 4X36G the SHOW INNIDB STATUS\G result is: = 051021 10:51:59 INNODB MONITOR OUTPUT = Per second averages calculated from the last 16 seconds -- SEMAPHORES -- OS WAIT ARRAY INFO: reservation count 1416712, signal count 577079 --Thread 2364 has waited at e:\mysqldev\build\mysql-5.0.12-beta-build\mysql-5.0.12-beta\innobase\btr\btr0cur.c line 560 for 0.00 seconds the semaphore: S-lock on RW-latch at 01471B80 created in file e:\mysqldev\build\mysql-5.0.12-beta-build\mysql-5.0.12-beta\innobase\btr\btr0sea.c line 139 a writer (thread id 2400) has reserved it in mode wait exclusive number of readers 1, waiters flag 1 Last time read locked in file e:\mysqldev\build\mysql-5.0.12-beta-build\mysql-5.0.12-beta\innobase\btr\btr0cur.c line 560 Last time write locked in file e:\mysqldev\build\mysql-5.0.12-beta-build\mysql-5.0.12-beta\innobase\btr\btr0sea.c line 489 wait has ended --Thread 2408 has waited at e:\mysqldev\build\mysql-5.0.12-beta-build\mysql-5.0.12-beta\innobase\buf\buf0buf.c line 1286 for 0.00 seconds the semaphore: Mutex at 01471880 created file e:\mysqldev\build\mysql-5.0.12-beta-build\mysql-5.0.12-beta\innobase\buf\buf0buf.c line 531, lock var 0 waiters flag 0 wait is ending --Thread 2400 has waited at e:\mysqldev\build\mysql-5.0.12-beta-build\mysql-5.0.12-beta\innobase\btr\btr0sea.c line 489 for 0.00 seconds the semaphore: X-lock on RW-latch at 01471B80 created in file e:\mysqldev\build\mysql-5.0.12-beta-build\mysql-5.0.12-beta\innobase\btr\btr0sea.c line 139 a writer (thread id 2400) has reserved it in mode wait exclusive number of readers 1, waiters flag 1 Last time read locked in file e:\mysqldev\build\mysql-5.0.12-beta-build\mysql-5.0.12-beta\innobase\btr\btr0cur.c line 560 Last time write locked in file e:\mysqldev\build\mysql-5.0.12-beta-build\mysql-5.0.12-beta\innobase\btr\btr0sea.c line 489 --Thread 2332 has waited at ../innobase/include\log0log.ic line 315 for 0.00 seconds the semaphore: Mutex at 014740D0 created file e:\mysqldev\build\mysql-5.0.12-beta-build\mysql-5.0.12-beta\innobase\log\log0log.c line 744, lock var 1 waiters flag 1 --Thread 2420 has waited at ../innobase/include\log0log.ic line 315 for 0.00 seconds the semaphore: Mutex at 014740D0 created file e:\mysqldev\build\mysql-5.0.12-beta-build\mysql-5.0.12-beta\innobase\log\log0log.c line 744, lock var 1 waiters flag 1 --Thread 2404 has waited at ../innobase/include\buf0buf.ic line 621 for 0.00 seconds the semaphore: Mutex at 01471880 created file e:\mysqldev\build\mysql-5.0.12-beta-build\mysql-5.0.12-beta\innobase\buf\buf0buf.c line 531, lock var 0 waiters flag 0 wait is ending --Thread 2380 has waited at ../innobase/include\buf0buf.ic line 621 for 0.00 seconds the semaphore: Mutex at 01471880 created file e:\mysqldev\build\mysql-5.0.12-beta-build\mysql-5.0.12-beta\innobase\buf\buf0buf.c line 531, lock var 0 waiters flag 0 wait is ending --Thread 2348 has waited at ../innobase/include\buf0buf.ic line 621 for 0.00 seconds the semaphore: Mutex at 01471880 created file e:\mysqldev\build\mysql-5.0.12-beta-build\mysql-5.0.12-beta\innobase\buf\buf0buf.c line 531, lock var 0 waiters flag 0 wait is ending --Thread 2424 has waited at e:\mysqldev\build\mysql-5.0.12-beta-build\mysql-5.0.12-beta\innobase\buf\buf0buf.c line 1088 for 0.00 seconds the semaphore: Mutex at 01471880 created file e:\mysqldev\build\mysql-5.0.12-beta-build\mysql-5.0.12-beta\innobase\buf\buf0buf.c line 531, lock var 0 waiters flag 0 wait is ending --Thread 380 has waited at e:\mysqldev\build\mysql-5.0.12-beta-build\mysql-5.0.12-beta\innobase\buf\buf0buf.c line 1088 for 0.00 seconds the semaphore: Mutex at 01471880 created file e:\mysqldev\build\mysql-5.0.12-beta-build\mysql-5.0.12-beta\innobase\buf\buf0buf.c line 531, lock var 0 waiters flag 0 wait is ending --Thread 2392 has waited at ../innobase/include\buf0buf.ic line 621 for 0.00 seconds the semaphore: Mutex at 01471880 created file e:\mysqldev\build\mysql-5.0.12-beta-build\mysql-5.0.12-beta\innobase\buf\buf0buf.c line 531, lock var 0
Re: Re: How Can I upgrade TPC-C performance test result for mysql
(DISTINCT (s_i_id) ) FROM order_line, stock WHERE ol_w_id = 72 AND ol_d_id = 1 AND ol_o_id 3064 AND ol_o_id=3044 AND s_w_id = ol_w_id AND s_i_id = ol_i_id AND s_quantity 18 Trx read view will not see trx with id = 0 330669, sees 0 330529 ---TRANSACTION 0 330622, ACTIVE 3 sec, OS thread id 2376 starting index read mysql tables in use 2, locked 0 , holds adaptive hash latch MySQL thread id 18, query id 808931 SERVER3 192.168.1.3 dbt Sending data SELECT count(DISTINCT (s_i_id) ) FROM order_line, stock WHERE ol_w_id = 16 AND ol_d_id = 8 AND ol_o_id 3090 AND ol_o_id=3070 AND s_w_id = ol_w_id AND s_i_id = ol_i_id AND s_quantity 19 Trx read view will not see trx with id = 0 330625, sees 0 330488 ---TRANSACTION 0 330619, ACTIVE 3 sec, OS thread id 1204 starting index read mysql tables in use 2, locked 0 , holds adaptive hash latch MySQL thread id 2, query id 808922 SERVER3 192.168.1.3 dbt Sending data SELECT count(DISTINCT (s_i_id) ) FROM order_line, stock WHERE ol_w_id = 80 AND ol_d_id = 5 AND ol_o_id 3059 AND ol_o_id=3039 AND s_w_id = ol_w_id AND s_i_id = ol_i_id AND s_quantity 12 Trx read view will not see trx with id = 0 330645, sees 0 330529 FILE I/O I/O thread 0 state: wait Windows aio (insert buffer thread) I/O thread 1 state: wait Windows aio (log thread) I/O thread 2 state: wait Windows aio (read thread) I/O thread 3 state: wait Windows aio (read thread) I/O thread 4 state: wait Windows aio (read thread) I/O thread 5 state: wait Windows aio (read thread) I/O thread 6 state: wait Windows aio (read thread) I/O thread 7 state: wait Windows aio (read thread) I/O thread 8 state: wait Windows aio (read thread) I/O thread 9 state: wait Windows aio (read thread) I/O thread 10 state: wait Windows aio (read thread) I/O thread 11 state: wait Windows aio (read thread) I/O thread 12 state: wait Windows aio (read thread) I/O thread 13 state: wait Windows aio (read thread) I/O thread 14 state: wait Windows aio (read thread) I/O thread 15 state: wait Windows aio (read thread) I/O thread 16 state: wait Windows aio (read thread) I/O thread 17 state: wait Windows aio (read thread) I/O thread 18 state: wait Windows aio (write thread) I/O thread 19 state: wait Windows aio (write thread) I/O thread 20 state: wait Windows aio (write thread) I/O thread 21 state: wait Windows aio (write thread) I/O thread 22 state: wait Windows aio (write thread) I/O thread 23 state: wait Windows aio (write thread) I/O thread 24 state: wait Windows aio (write thread) I/O thread 25 state: wait Windows aio (write thread) I/O thread 26 state: wait Windows aio (write thread) I/O thread 27 state: wait Windows aio (write thread) I/O thread 28 state: wait Windows aio (write thread) I/O thread 29 state: wait Windows aio (write thread) I/O thread 30 state: wait Windows aio (write thread) I/O thread 31 state: wait Windows aio (write thread) I/O thread 32 state: wait Windows aio (write thread) I/O thread 33 state: wait Windows aio (write thread) Pending normal aio reads: 1, aio writes: 0, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 16 Pending flushes (fsync) log: 0; buffer pool: 0 500232 OS file reads, 195736 OS file writes, 7456 OS fsyncs 688.77 reads/s, 16384 avg bytes/read, 234.17 writes/s, 1.44 fsyncs/s - INSERT BUFFER AND ADAPTIVE HASH INDEX - Ibuf for space 0: size 1787, free list len 2376, seg size 4164, is not empty Ibuf for space 0: size 1787, free list len 2376, seg size 4164, 152636 inserts, 250105 merged recs, 44196 merges Hash table size 3320377, used cells 411665, node heap has 432 buffer(s) 497.59 hash searches/s, 2978.00 non-hash searches/s --- LOG --- Log sequence number 3 3047845732 Log flushed up to 3 3047756967 Last checkpoint at 3 2957785285 0 pending log writes, 0 pending chkp writes 5711 log i/o's done, 1.31 log i/o's/second -- BUFFER POOL AND MEMORY -- Total memory allocated 897775285; in additional pool allocated 2309760 Buffer pool size 51200 Free buffers 0 Database pages 50768 Modified db pages 19934 Pending reads 19 Pending writes: LRU 0, flush list 0, single page 0 Pages read 500228, created 2444, written 190030 695.21 reads/s, 4.81 creates/s, 232.86 writes/s Buffer pool hit rate 977 / 1000 -- ROW OPERATIONS -- 0 queries inside InnoDB, 0 queries in queue 6 read views open inside InnoDB Main thread id 2268, state: sleeping Number of rows inserted 170029, updated 319443, deleted 11947, read 12318619 257.92 inserts/s, 462.22 updates/s, 16.25 deletes/s, 16958.19 reads/s END OF INNODB MONITOR OUTPUT Best regards, george - Original Message - From: Heikkinbsp;TuuriDate: October 25 2005 12:28am Subject: Re: How Can I upgrade TPC-C performance test result for mysql George, can you please post a few typical SHOW INNODB STATUS\G outputs during the stress test. Best regards, Heikki
How Can I upgrade TPC-C performance test result for mysql
dear sir: we develop a TPC-C test progrom,this program use mysql ODBC3.51 to connect mysql server, and use microsoft sqlserver odbc to connect sqlserver2000. we suppose you are know well the TPC-C. we use InnoDB as mysql's store engine. follow is the os and hardware information: os : Windows advance server 2000 CPU: 2X3.0Ghz memory:2G disk: only one 40G IDE disk table struct: for one warehouse,we stat all table list: table name | record numbers | type record size(bytes) | type table size(K bytes) Warehouse | 1 |89 | 0.089 District | 10 |95 | 0.950 Customer | 30k |655 | 19650 History | 30k |46 | 1380 Order | 30k |24 | 720 New-Order | 9k |8| 72 Order-Line | 300k|54 | 16200 Stock | 100k |306 | 30600 Item | 100k |82 | 8200 SQL sentence: create table warehouse ( w_id int not null, w_name varchar(10) null, w_street_1 varchar(20) null, w_street_2 varchar(20) null, w_city varchar(20) null, w_state char(2) null, w_zip char(9) null, w_tax float null, w_ytd float null, primary key(w_id) ); create table district ( d_id int not null, d_w_id int not null, d_name varchar(10) null, d_street_1 varchar(20) null, d_street_2 varchar(20) null, d_city varchar(20) null, d_state char(2) null, d_zip char(9) null, d_tax float null, d_ytd float null, d_next_o_id int null, primary key(d_w_id, d_id),foreign key(d_w_id)references warehouse(w_id) ); create table customer ( c_id int not null, c_d_id int not null, c_w_id int not null, c_first varchar(16) null, c_middle char(2) null, c_last varchar(16) null, c_street_1 varchar(20) null, c_street_2 varchar(20) null, c_city varchar(20) null, c_state char(2) null, c_zip char(9) null, c_phone char(16) null, c_since timestamp null, c_credit char(2) null, c_credit_lim float null, c_discount float null, c_balance float null, c_ytd_payment float null, c_payment_cnt int null, c_delivery_cnt int null, c_data varchar(500) null, primary key(c_w_id, c_d_id, c_id),foreign key(c_w_id,c_d_id) references district(d_w_id,d_id) ); create table history ( h_c_id int null, h_c_d_id int null, h_c_w_id int null, h_d_id int null, h_w_id int null, h_date timestamp null, h_amount float null, h_data varchar(24) null,foreign key(h_c_w_id,h_c_d_id,h_c_id) references customer(c_w_id,c_d_id,c_id),foreign key(h_w_id,h_d_id)references district(d_w_id,d_id) ); create table orders ( o_id int not null, o_d_id int not null, o_w_id int not null, o_c_id int null, o_entry_d timestamp null, o_carrier_id int null, o_ol_cnt int null, o_all_local int null, primary key(o_w_id, o_d_id, o_id),foreign key(o_w_id,o_d_id,o_c_id)references customer(c_w_id,c_d_id,c_id) ); create table new_order ( no_o_id int not null, no_d_id int not null, no_w_id int not null, primary key(no_w_id, no_d_id, no_o_id),foreign key(no_w_id,no_d_id,no_o_id)references orders(o_w_id,o_d_id,o_id) ); create table item ( i_id int not null, i_im_id int null, i_name varchar(24) null, i_price float null, i_data varchar(50) null, primary key(i_id) ); create table stock ( s_i_id int not null, s_w_id int not null, s_quantity int null, s_dist_01 varchar(24) null, s_dist_02 varchar(24) null, s_dist_03 varchar(24) null, s_dist_04 varchar(24) null, s_dist_05 varchar(24) null, s_dist_06 varchar(24) null, s_dist_07 varchar(24) null, s_dist_08 varchar(24) null, s_dist_09 varchar(24) null, s_dist_10 varchar(24) null, s_ytd int null, s_order_cnt int null, s_remote_cnt int null, s_data varchar(50) null, primary key(s_w_id, s_i_id),foreign key(s_w_id)references warehouse(w_id),foreign key(s_i_id)references item(i_id) ); create table order_line ( ol_o_id int not null, ol_d_id int not null, ol_w_id int not null, ol_number int not null, ol_i_id int null, ol_supply_w_id int null, ol_delivery_d timestamp null, ol_quantity int null, ol_amount float null, ol_dist_info char(24) null, primary key(ol_w_id, ol_d_id, ol_o_id, ol_number),foreign key(ol_w_id,ol_d_id,ol_o_id) references orders(o_w_id,o_d_id,o_id),foreign key(ol_supply_w_id,ol_i_id)references stock(s_w_id,s_i_id) ); index: create index i_orders on orders (o_w_id, o_d_id, o_c_id, o_id); create index i_customer on customer (c_w_id, c_d_id, c_last, c_first, c_id); transaction information: transaction type | min percent(%) | min keyboard time(sec) | 90% response time(sec) |min think time(sec
Re: How Can I upgrade TPC-C performance test result for mysql
George, can you please post a few typical SHOW INNODB STATUS\G outputs during the stress test. Best regards, Heikki Oracle/Innobase - Original Message - From: yang george [EMAIL PROTECTED] Newsgroups: mailing.database.myodbc Sent: Monday, October 24, 2005 1:50 PM Subject: How Can I upgrade TPC-C performance test result for mysql dear sir: we develop a TPC-C test progrom,this program use mysql ODBC3.51 to connect mysql server, and use microsoft sqlserver odbc to connect sqlserver2000. we suppose you are know well the TPC-C. we use InnoDB as mysql's store engine. follow is the os and hardware information: =09os : Windows advance server 2000 =09CPU: 2X3.0Ghz =09memory:2G =09disk: only one 40G IDE disk table struct: =09for one warehouse,we stat all table list: =09table name=09| record numbers |=09type record size(bytes)=09| type tab= le size(K bytes) =09 Warehouse=09 | 1=09 |89=09 | 0.0= 89 District=09 | 10=09 |95=09 | 0.95= 0 Customer=09 | 30k=09|655=09 | 1965= 0 History=09| 30k=09|46=09 | 1380 Order=09 | 30k=09|24=09 | 720 New-Order=09 | 9k=09 |8=09| 72 Order-Line=09| 300k=09|54=09 | 1620= 0 Stock=09 | 100k=09|306=09 | 30= 600 Item=09 | 100k=09|82=09 | 8200 =09SQL sentence: =09create table warehouse ( w_id int not null, w_name varchar(10) null, w_street_1 varchar(20) null, w_street_2 varchar(20) null, w_city varchar(20) null, w_state char(2) null, w_zip char(9) null, w_tax float null, w_ytd float null, primary key(w_id) ); =09create table district ( d_id int not null, d_w_id int not null, d_name varchar(10) null, d_street_1 varchar(20) null, d_street_2 varchar(20) null, d_city varchar(20) null, d_state char(2) null, d_zip char(9) null, d_tax float null, d_ytd float null, d_next_o_id int null, primary key(d_w_id, d_id),foreign key(d_w_id)references warehouse(w_id) ); =09create table customer ( c_id int not null, c_d_id int not null, c_w_id int not null, c_first varchar(16) null, c_middle char(2) null, c_last varchar(16) null, c_street_1 varchar(20) null, c_street_2 varchar(20) null, c_city varchar(20) null, c_state char(2) null, c_zip char(9) null, c_phone char(16) null, c_since timestamp null, c_credit char(2) null, c_credit_lim float null, c_discount float null, c_balance float null, c_ytd_payment float null, c_payment_cnt int null, c_delivery_cnt int null, c_data varchar(500) null, primary key(c_w_id, c_d_id, c_id),foreign key(c_w_id,c_d_id) references district(d_w_id,d_id) ); =09create table history ( h_c_id int null, h_c_d_id int null, h_c_w_id int null, h_d_id int null, h_w_id int null, h_date timestamp null, h_amount float null, h_data varchar(24) null,foreign key(h_c_w_id,h_c_d_id,h_c_id) references customer(c_w_id,c_d_id,c_id),foreign key(h_w_id,h_d_id)references district(d_w_id,d_id) ); =09create table orders ( o_id int not null, o_d_id int not null, o_w_id int not null, o_c_id int null, o_entry_d timestamp null, o_carrier_id int null, o_ol_cnt int null, o_all_local int null, primary key(o_w_id, o_d_id, o_id),foreign key(o_w_id,o_d_id,o_c_id)references customer(c_w_id,c_d_id,c_id) ); =09create table new_order ( no_o_id int not null, no_d_id int not null, no_w_id int not null, primary key(no_w_id, no_d_id, no_o_id),foreign key(no_w_id,no_d_id,no_o_id)references orders(o_w_id,o_d_id,o_id) ); =09create table item ( i_id int not null, i_im_id int null, i_name varchar(24) null, i_price float null, i_data varchar(50) null, primary key(i_id) ); =09create table stock ( s_i_id int not null, s_w_id int not null, s_quantity int null, s_dist_01 varchar(24) null, s_dist_02 varchar(24) null, s_dist_03 varchar(24) null, s_dist_04 varchar(24) null, s_dist_05 varchar(24) null, s_dist_06 varchar(24) null, s_dist_07 varchar(24) null, s_dist_08 varchar(24) null, s_dist_09 varchar(24) null, s_dist_10 varchar(24) null, s_ytd int null, s_order_cnt int null, s_remote_cnt int null, s_data varchar(50) null, primary key(s_w_id, s_i_id),foreign key(s_w_id)references warehouse(w_id),foreign key(s_i_id)references item(i_id) ); =09create table order_line ( ol_o_id int not null, ol_d_id int not null, ol_w_id int not null, ol_number int not null, ol_i_id int null, ol_supply_w_id int null, ol_delivery_d timestamp null, ol_quantity int null, ol_amount float null, ol_dist_info char(24) null, primary key(ol_w_id, ol_d_id, ol_o_id, ol_number),foreign key(ol_w_id,ol_d_id,ol_o_id) references orders(o_w_id,o_d_id,o_id),foreign key(ol_supply_w_id,ol_i_id)references stock(s_w_id,s_i_id) ); =09 =09index: =09create index i_orders on orders (o_w_id, o_d_id, o_c_id, o_id); =09create index i_customer on customer (c_w_id, c_d_id, c_last, c_first, c_
Re: How to test the MySQL Server (windows version) ?
Hi! lu ming wrote: Hi! I tried to run the perl scripts in the windows platform yesterday,but an error occured [[...]] I can just repeat: This script is still under construction, and adaptions are still needed to make tests work correctly on Windows platforms. If you run it, you are on your own, and we are not investing any effort in supporting it externally now; we fully concentrate on improving it for our own internal tests. When this is finished, we can still announce it and then work on the problems which you and other users may experience. Jörg -- Joerg Bruehe, Senior Production Engineer MySQL AB, www.mysql.com Office: (+49 30) 417 01 487 VoIP: [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How to test the MySQL Server (windows version) ?
Hi, joerg Thanks for your patient answer! I hope that we will have the ability to run the test suite on windows system early. Best regards luming _ 与联机的朋友进行交流，请使用 MSN Messenger: http://messenger.msn.com/cn -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How to test the MySQL Server (windows version) ?
Hi! I tried to run the perl scripts in the windows platform yesterday,but an error occured as following output info: C:\MySQL\MySQLServer5\mysql-test\perl mysql-test-run.pl mysql-test-run: *** ERROR: Could not find C:/MySQL/MySQLServer5/scripts/mysql_fix_privilege_tables I find that the mysql_fix_privilege_tables file is already exist, why did it occured this error? Is my method wrong? Or the perl test script that is included in the source distribution has some bugs? ( the source distribution i used is mysql-5.0.12-beta-linux ) Best regards lu ming _ 享用世界上最大的电子邮件系统― MSN Hotmail。 http://www.hotmail.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How to test the MySQL Server (windows version) ?
lu ming [EMAIL PROTECTED] wrote on 10/14/2005 12:20:19 AM: Hi, joerg Thank you very much! But i want to know more about this problem. I find a perl script about mysql server's test in the mysql-test subdirectory(/mysql-test/mysql-test-run.pl). Is this the test script written by perl what could replace the shell script(/mysql-test/mysql-test-run.sh) in Windows mentioned in your e-mail? Could it be rightly run in windows now? Or it cann't be run due to the unfinished work? Are the perl scripts that mentioned in your e-mail included in the MySQL Server's Unix source distributions(mysql-5.0.12-beta-linux) ? Are the perl test scripts only used in Mysql's internal works now? Best regards luming The problems are more with Windows than with the script. The testing script was written in BASH (I believe) which does not have an interpreter for Windows (outside of Cygwin. However if you are inside Cygwin, you really aren't working with Windows any more.) Several other scripting languages do have interpreters for Windows: VBScript (d), JScript (d), PHP, Python, PERL, and more. (d) = installed by default. I think that the mysql testing script is being ported from BASH into PERL and when that happens you will have the ability to run it on any Windows system configured to run PERL scripts. Until then, we Win32 people just trust the binaries and avoid compiling our own copies unless we absolutely need to. Shawn Green Database Administrator Unimin Corporation - Spruce Pine
Re: How to test the MySQL Server (windows version) ?
Hi! [EMAIL PROTECTED] wrote: lu ming [EMAIL PROTECTED] wrote on 10/14/2005 12:20:19 AM: Hi, joerg Thank you very much! But i want to know more about this problem. I find a perl script about mysql server's test in the mysql-test subdirectory(/mysql-test/mysql-test-run.pl). Is this the test script written by perl what could replace the shell script(/mysql-test/mysql-test-run.sh) in Windows mentioned in your e-mail? It will be the one. It is not yet finished. Could it be rightly run in windows now? Or it cann't be run due to the unfinished work? You can run it, but you may have problems interpreting the results. Several tests will seem to fail, just because some output differs from the expected one. Obviously, much output is platform dependent (starting with file names, then process or thread IDs, ...), and the tests do not yet allow for the output generated on Windows. Note that I say output, not database result! Are the perl scripts that mentioned in your e-mail included in the MySQL Server's Unix source distributions(mysql-5.0.12-beta-linux) ? Yes, they are included (AFAIK - not checked), but they are under construction even for Unix. Just today, I fixed another problem in them, that had shown up during our internal 5.0 builds. Are the perl test scripts only used in Mysql's internal works now? Obviously, I cannot guarantee that nobody else is using them. But we have not proposed to anybody outside MySQL to do so. The problems are more with Windows than with the script. The testing script was written in BASH (I believe) which does not have an interpreter for Windows (outside of Cygwin. However if you are inside Cygwin, you really aren't working with Windows any more.) Just for completeness: If anybody wants to use Unix style tools (shell, awk, ed, tr, sed, lex/bison/yacc, ...) in a Windows environment, I propose to look at MinGW because these are native Windows binaries. Several other scripting languages do have interpreters for Windows: VBScript (d), JScript (d), PHP, Python, PERL, and more. (d) = installed by default. Right. So for us, Perl is the language of choice, as we can make it available on all platforms. I think that the mysql testing script is being ported from BASH into PERL and when that happens you will have the ability to run it on any Windows system configured to run PERL scripts. Until then, we Win32 people just trust the binaries and avoid compiling our own copies unless we absolutely need to. We will see not to disappoint that trust, and appreciate it. Thanks! Joerg -- Joerg Bruehe, Senior Production Engineer MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
How to test the MySQL Server (windows version) ?
The test system that is included in MySQL Server's Unix source distributions.(/mysql-test/mysql-test-run.sh) We can use the suite to run a test against to the MySQL Server. But these tests only can be run on Unix(linux). If you want to run the tests on Windows, you must use the Cygwin environment, and the server must be compiled under Cygwin environment. Actually, it doesn't test the MySQL Server's Windows version because the Cygwin had make the running environment be equal to the Unix's i think. Is my opinion right? I want to know how to test the MySQL Server's Windows version. Is MySQL AB doesn't provide the test method? Who can give me an answer? _ 与联机的朋友进行交流，请使用 MSN Messenger: http://messenger.msn.com/cn -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How to test the MySQL Server (windows version) ?
Hi ! lu ming wrote: The test system that is included in MySQL Server's Unix source distributions.(/mysql-test/mysql-test-run.sh) We can use the suite to run a test against to the MySQL Server. But these tests only can be run on Unix(linux). If you want to run the tests on Windows, you must use the Cygwin environment, and the server must be compiled under Cygwin environment. Actually, it doesn't test the MySQL Server's Windows version because the Cygwin had make the running environment be equal to the Unix's i think. Is my opinion right? Well, this is a typical Windows problem (yes, I admit being a Unix guy): Native Windows does not come with a decent portable scripting language. You are right that the MySQL test suite is based on a shell script approach which does not work in (native) Windows. (You might get MinGW, MKS or similar suites to get a shell and try in that environment, but this would be your own personal experiment. If you have looked into that script, you get an idea of the complexity needed, plain batch files will not work for this.) I want to know how to test the MySQL Server's Windows version. Is MySQL AB doesn't provide the test method? Who can give me an answer? MySQL is internally working on replacing the shell script by a set of Perl scripts, which can also be used on Windows (provided you install Perl). However, this work is not yet finished, and several tests will produce different results on Windows from the Unix ones, which the tool considers to be failures - even if it is just the way the result is written,no real database difference. So currently there is no way for you to run the test suite on Windows and get usable results - sorry. We are working on this. Regards, Jörg -- Joerg Bruehe, Senior Production Engineer MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How to test the MySQL Server (windows version) ?
Hi, joerg Thank you very much! But i want to know more about this problem. I find a perl script about mysql server's test in the mysql-test subdirectory(/mysql-test/mysql-test-run.pl). Is this the test script written by perl what could replace the shell script(/mysql-test/mysql-test-run.sh) in Windows mentioned in your e-mail? Could it be rightly run in windows now? Or it cann't be run due to the unfinished work? Are the perl scripts that mentioned in your e-mail included in the MySQL Server's Unix source distributions(mysql-5.0.12-beta-linux) ? Are the perl test scripts only used in Mysql's internal works now? Best regards luming _ 享用世界上最大的电子邮件系统― MSN Hotmail。 http://www.hotmail.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
problem about the mysql test suite
I run a test against to the MySQL Server with the test tool of the binary distribution in Linux OS(red hat 9.0). But many of the test cases failed. My test method and the output results are following: 1.batch test command mysqltest -h localhost -u root -R r/alias.result test t/alias.test mysqltest -h localhost -u root -R r/alter_table.result test t/alter_table.test mysqltest -h localhost -u root -R r/analyse.result test t/analyse.test mysqltest -h localhost -u root -R r/analyze.result test t/analyze.test mysqltest -h localhost -u root -R r/ansi.result test t/ansi.test mysqltest -h localhost -u root -R r/archive.result test t/archive.test mysqltest -h localhost -u root -R r/auto_increment.result test t/auto_increment.test mysqltest -h localhost -u root -R r/backup.result test t/backup.test mysqltest -h localhost -u root -R r/bdb-alter-table-1.result test t/bdb-alter-table-1.test mysqltest -h localhost -u root -R r/bdb-alter-table-2.result test t/bdb-alter-table-2.test mysqltest -h localhost -u root -R r/bdb-crash.result test t/bdb-crash.test mysqltest -h localhost -u root -R r/bdb-deadlock.result test t/bdb-deadlock.test mysqltest -h localhost -u root -R r/bdb.result test t/bdb.test mysqltest -h localhost -u root -R r/bdb_cache.result test t/bdb_cache.test mysqltest -h localhost -u root -R r/bench_count_distinct.result test t/bench_count_distinct.test mysqltest -h localhost -u root -R r/bigint.result test t/bigint.test mysqltest -h localhost -u root -R r/binary.result test t/binary.test mysqltest -h localhost -u root -R r/binlog.result test t/binlog.test mysqltest -h localhost -u root -R r/blackhole.result test t/blackhole.test mysqltest -h localhost -u root -R r/bool.result test t/bool.test 2.output results ok mysqltest: At line 343: query 'CREATE TABLE T12207(a int) ENGINE=MYISAM' failed: 1050: Table 'T12207' already exists not ok ok ok This test is not supported by this installation skipped ok mysqltest: No to-string for last from-string mysqltest: Can't initialize replace from replace_result : 1 : X : 2 : X : 22 : X : 23 : X $MYSQL_TEST_DIR MYSQL_TEST_DIR This test is not supported by this installation skipped This test is not supported by this installation skipped This test is not supported by this installation skipped This test is not supported by this installation skipped This test is not supported by this installation skipped This test is not supported by this installation skipped ok not ok ok This test is not supported by this installation skipped This test is not supported by this installation skipped ok From the output results, we can find that many test cases are failed. These test cases is only a little part of the all test cases. Many others also failed. Is the test mothed that I used wrong ? Or the test cases that provided by MySQL are wrong? I don't think so many test cases failed like this is normal. But I could't ensure the reason. Who can help me? ( Note: MySQL Server 's version that i used is v5.0.12. The test cases are all come from the \mysql-test\r\ subdirectory. The test tools is included in /usr/bin/ that is installed with the MySQL Server's installation. ) _ 免费下载 MSN Explorer: http://explorer.msn.com/lccn/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Who can tell me how to use the MySQL's test tool ?
Who can tell me how to use the MySQL's test tool (\MySQL\MySQL Server 5.0\bin\mysqltest.exe) ? I want to test the mysql server, and i find the test tool in the directory \MySQL\MySQL Server 5.0\bin\ (my os is Windows2000), but it can not be executed directly. Further more i can not find any document and help about it. I need the information about how to use the test tools, who can help me? _ 享用世界上最大的电子邮件系统― MSN Hotmail。 http://www.hotmail.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Who can tell me how to use the MySQL's test tool ?
Hello. Have a look here: http://dev.mysql.com/doc/mysql/en/mysql-test-suite.html lu ming wrote: Who can tell me how to use the MySQL's test tool (\MySQL\MySQL Server 5.0\bin\mysqltest.exe) ?I want to test the mysql server, and i find the test tool in the directory \MySQL\MySQL Server 5.0\bin\ (my os is Windows2000), but it can not be executed directly. Further more i can not find any document and help about it.I need the information about how to use the test tools, who can help me? _ ÏíÓÃÊÀ½çÉÏ×î´óµÄµç×ÓÓʼþϵͳ¡ª MSN Hotmail¡£ http://www.hotmail.com -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: `gmake test` probs Solaris9 for M. 4.1.4.
On Fri, 9 Sep 2005, Michael Stassen wrote: With mysql 4.1.12, `make -n test` reveals cd mysql-test; ./mysql-test-run ./mysql-test-run --ps-protocol For the record, here's what I got on Solaris 9 for 4.1.13 neelix hgs 18 % cd mysql-test ./mysql-test-run --force Installing Test Databases Removing Stale Files Installing Master Databases running ../sql/mysqld --no-defaults --bootstrap --skip-grant-tables --basedir=. --datadir=./var/master-data --skip-innodb --skip-ndbcluster --skip-bdb --language=../sql/share/english/ --character-sets-dir=../sql/share/charsets/ Installing Slave Databases running ../sql/mysqld --no-defaults --bootstrap --skip-grant-tables --basedir=. --datadir=./var/slave-data --skip-innodb --skip-ndbcluster --skip-bdb --language=../sql/share/english/ --character-sets-dir=../sql/share/charsets/ Manager disabled, skipping manager start. Loading Standard Test Databases Starting Tests TESTRESULT --- alias [ pass ] alter_table[ pass ] analyse[ pass ] analyze[ pass ] ansi [ pass ] archive[ skipped ] auto_increment [ pass ] backup [ pass ] bdb-alter-table-1 [ skipped ] bdb-alter-table-2 [ skipped ] bdb-crash [ skipped ] bdb-deadlock [ skipped ] bdb[ skipped ] bdb_cache [ skipped ] bench_count_distinct [ pass ] bigint [ pass ] binary [ pass ] blackhole [ skipped ] bool [ pass ] bulk_replace [ pass ] case [ pass ] cast [ pass ] check [ pass ] comments [ pass ] compare[ pass ] connect[ pass ] consistent_snapshot[ pass ] constraints[ pass ] count_distinct [ pass ] count_distinct2[ pass ] count_distinct3[ pass ] create [ pass ] create_select_tmp [ pass ] csv[ skipped ] ctype_big5 [ skipped ] ctype_collate [ pass ] ctype_cp1250_ch[ skipped ] ctype_cp1251 [ pass ] ctype_cp932[ skipped ] ctype_create [ pass ] ctype_latin1 [ pass ] ctype_latin1_de[ pass ] ctype_latin2 [ pass ] ctype_many [ skipped ] ctype_mb [ pass ] ctype_recoding [ pass ] ctype_sjis [ skipped ] ctype_tis620 [ skipped ] ctype_uca [ skipped ] ctype_ucs [ skipped ] ctype_ucs_binlog [ skipped ] ctype_ujis [ skipped ] ctype_utf8 [ pass ] date_formats [ pass ] delayed[ pass ] delete [ pass ] derived[ pass ] dirty_close[ pass ] distinct [ pass ] drop [ pass ] drop_temp_table[ pass ] empty_table[ pass ] endspace [ pass ] errors [ pass ] exampledb [ skipped ] explain[ pass ] flush [ pass ] flush_block_commit [ pass ] flush_table[ pass ] foreign_key[ pass ] fulltext [ pass ] fulltext2 [ pass ] fulltext_cache [ pass ] fulltext_distinct [ pass ] fulltext_left_join [ pass ] fulltext_multi [ pass ] fulltext_order_by [ pass ] fulltext_update[ pass ] fulltext_var [ pass ] func_compress [ pass ] func_concat[ pass ] func_crypt [ pass ] func_date_add [ pass ] func_default [ pass ] func_des_encrypt [ skipped ] func_encrypt [ skipped ] func_encrypt_nossl [ pass ] func_equal [ pass ] func_gconcat [ pass ] func_group [ pass ] func_if[ pass ] func_in[ pass ] func_isnull[ pass ] func_like [ pass ] func_math [ pass ] func_misc [ pass ] func_op[ pass ] func_regexp
Re: `gmake test` probs Solaris9 for M. 4.1.4.
Hi Hugh, all,
sorry about the delay.
Hugh Sasse wrote:
On Fri, 9 Sep 2005, Joerg Bruehe wrote:
Michael,
you beat me in replying, and saved me from typing the analysis - thanks!
Michael Stassen wrote:
[[...]]
The test suite is broken.
Well, I would not put it that way - a diplomatic wording is:
The tool to run the test suite does not run as it should.
I understand that the effect for Hugh and you is the same ;-)
Nobody was claiming *deliberate* breakage! :-)
Neither did I get it that way - no offence taken. :-)
[...]
The specific error causing your and Hugh's problem, the incorrect
skipping of tests which are not applicable to the server to be tested,
has been fixed, but maybe this version has not yet been pushed to the
4.1 tree.
Can we grab the new version off the web (CVSweb or similar?)
AIUI, it is pushed to the 4.1 tree, so a current tree snapshot should
include it. But I cannot identify an individual change as beint _that_
correction. From a discussion about this problem, it was a different
handling of process exit codes in Perl and shell that made the skip fail.
somewhere? If it is feasible for me I'd like to translate it to
Ruby to give you that much wider coverage. Depends if my Perl
fluency is sufficient, etc. Whether {you, the committee, ???} accept
the contribution is another matter entirely, of course.
Until now, we have no Ruby code in the server and the various tools,
including the build tools. As using a new language would require the
corresponding tools to be installed on all build platforms, the
advantages have to be very great to outweigh that effort.
We have not yet decided whether this script will remain a Perl script or
will even be transformed to C later. Given the development speed in
Perl, we would have to finalize it first.
As several of our build tools are written in Perl, we cannot easily drop
that language.
What are the advantages of Ruby? (off-topic, personal mail please)
Regards,
Jörg
--
Joerg Bruehe, Senior Production Engineer
MySQL AB, www.mysql.com
Office: (+49 30) 417 01 487 VoIP: [EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: `gmake test` probs Solaris9 for M. 4.1.4.
I've see no reply to this and I checked the archives, so please excuse my resubmitting it. Maybe I shouldn't be using 4.1.14 but 4.0.x? Thank you, Hugh On Wed, 7 Sep 2005, Hugh Sasse wrote: Attempts to do make test prior to installation, to check that I'm installing something workable, give: quote neelix hgs 63 % gmake test cd mysql-test; perl mysql-test-run.pl perl mysql-test-run.pl --ps-protocol No ndbcluster support Killing Possible Leftover Processes Removing Stale Files Installing Master Databases Installing Master Databases Installing Slave Databases Installing Slave Databases Installing Slave Databases === Finding Tests in the 'main' suite Starting Tests in the 'main' suite TESTRESULT --- alias [ pass ] alter_table [ pass ] analyse [ pass ] analyze [ pass ] ansi[ pass ] archive [ fail ] Errors are (from /scratch/hgs/mysql-4.1.14/mysql-test/var/log/mysqltest-time) : This test is not supported by this installation mysqltest returned unexpected code 15872, it has probably crashed (the last lines may be the most important ones) Aborting: archive failed. To continue, re-run with '--force'. Ending Tests Shutting-down MySQL daemon Master(s) shutdown finished Slave(s) shutdown finished gmake: *** [test] Error 1 neelix hgs 64 % /quote So, firstly, invoke what with '--force'? You don't get anything useful if you pass that to make Also, how can I tell if InnoDB built OK? I'm doing this for use with Ruby on Rails, and I need it to be in a separate directory from the version we already have (3.x) used by others. I modified mysql-4.1.14/BUILD/compile-solaris-sparc thusly neelix hgs 81 % display_diffs.rb . --- ./compile-solaris-sparc.orig2005-08-17 18:06:41.0 +0100 +++ ./compile-solaris-sparc 2005-09-06 18:36:25.386697000 +0100 @@ -11,6 +11,6 @@ (cd gemini aclocal autoheader aclocal automake autoconf) fi -CFLAGS=-g -Wimplicit -Wreturn-type -Wswitch -Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat -Wparentheses -Wsign-compare -Wwrite-strings -Wunused -O3 -fno-omit-frame-pointer -mcpu=v8 -Wa,-xarch=v8plusa CXX=gcc CXXFLAGS=-Wimplicit -Wreturn-type -Wswitch -Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat -Wparentheses -Wsign-compare -Wwrite-strings -Woverloaded-virtual -Wsign-promo -Wreorder -Wctor-dtor-privacy -Wnon-virtual-dtor -felide-constructors -fno-exceptions -fno-rtti -O3 -fno-omit-frame-pointer -mcpu=v8 -Wa,-xarch=v8plusa -g ./configure --prefix=/usr/local/mysql --enable-assembler --with-extra-charsets=complex --enable-thread-safe-client +CFLAGS=-g -Wimplicit -Wreturn-type -Wswitch -Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat -Wparentheses -Wsign-compare -Wwrite-strings -Wunused -O3 -fno-omit-frame-pointer -mcpu=v8 -Wa,-xarch=v8plusa CXX=gcc CXXFLAGS=-Wimplicit -Wreturn-type -Wswitch -Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat -Wparentheses -Wsign-compare -Wwrite-strings -Woverloaded-virtual -Wsign-promo -Wreorder -Wctor-dtor-privacy -Wnon-virtual-dtor -felide-constructors -fno-exceptions -fno-rtti -O3 -fno-omit-frame-pointer -mcpu=v8 -Wa,-xarch=v8plusa -g ./configure --prefix=/usr/local/mysql --enable-assembler --with-extra-charsets=complex --enable-thread-safe-client --with-tcp-port=3308 --with-unix-socket-path=/tmp/mysql4.sock --prefix=/usr/local/mysql-4.1.14 gmake -j 4 neelix hgs 82 % and I invoked the script directly, and also tried with bash. Not sure what else to pass on. GNU Make version 3.79.1, by Richard Stallman and Roland McGrath. Built for sparc-sun-solaris2.9 gcc (GCC) 3.4.3 Thank you Hugh -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: `gmake test` probs Solaris9 for M. 4.1.4.
Hugh, I get the same thing on Mac OS X 10.3.9. My thinking was that rather than replying with an unhelpful Me too, I would do some digging and then reply with what I found. I realize now that left you hanging (sorry), so I'll report what I've found so far. The test suite is broken. The archive test is meant to test the archive table engine, but the archive engine is not built into mysql by default. You have to add the --with-archive-storage-engine if you want it. You didn't do that, so the archive test should have been skipped. With mysql 4.1.12, `make -n test` reveals cd mysql-test; ./mysql-test-run ./mysql-test-run --ps-protocol With 4.1.14, that has changed to cd mysql-test; perl mysql-test-run.pl perl mysql-test-run.pl --ps-protocol Apparently, the test program shell script, mysql-test-run, has been rewritten as a perl script, though there is no mention of this in the change log http://dev.mysql.com/doc/mysql/en/news-4-1-x.html. A quick glance at the source shows that the perl script is not finished -- it has quite a few commented-out, fix me sections. You still have a couple of options to test your build. You can run the new test suite with the --force option. Do what make would do, `cd mysql-test`, then `perl mysql-test-run.pl --force`. You will see that every test that should have been skipped will instead be run and fail (archive, the bdb tests, blackhole, csv, example, func_des_encrypt, isam, the ndb tests, openssl_1, raid, and so on). If every test passes except for tests of things you don't have, you should be OK. In particular, there are a set of innodb tests which should answer your question about whether or not innodb is working in your build. There's a second way, which I think is better. It turns out that the old shell-script test suite is still built. Hence, you can still test the old way. cd mysql-test ./mysql-test-run --force This will properly skip tests of features not compiled in. Note that I added --force because, at least in my case, the new embedded test, not_embedded_server, is run and fails. I'm not yet sure if that should have been skipped. As the old test script is still built and the new test script is unfinished, undocumented, and broken, I am suspicious that the real problem is that make was prematurely (accidentally?) changed to use the new one before it was ready. I've copied the bugs list in hopes of an answer. Michael P.S. Out of curiosity, why did you find it necessary to edit BUILD/compile-solaris-sparc? Couldn't you make the changes you wanted with options to configure? Hugh Sasse wrote: I've see no reply to this and I checked the archives, so please excuse my resubmitting it. Maybe I shouldn't be using 4.1.14 but 4.0.x? Thank you, Hugh On Wed, 7 Sep 2005, Hugh Sasse wrote: Attempts to do make test prior to installation, to check that I'm installing something workable, give: quote neelix hgs 63 % gmake test cd mysql-test; perl mysql-test-run.pl perl mysql-test-run.pl --ps-protocol No ndbcluster support Killing Possible Leftover Processes Removing Stale Files Installing Master Databases Installing Master Databases Installing Slave Databases Installing Slave Databases Installing Slave Databases === Finding Tests in the 'main' suite Starting Tests in the 'main' suite TESTRESULT --- alias [ pass ] alter_table [ pass ] analyse [ pass ] analyze [ pass ] ansi[ pass ] archive [ fail ] Errors are (from /scratch/hgs/mysql-4.1.14/mysql-test/var/log/mysqltest-time) : This test is not supported by this installation mysqltest returned unexpected code 15872, it has probably crashed (the last lines may be the most important ones) Aborting: archive failed. To continue, re-run with '--force'. Ending Tests Shutting-down MySQL daemon Master(s) shutdown finished Slave(s) shutdown finished gmake: *** [test] Error 1 neelix hgs 64 % /quote So, firstly, invoke what with '--force'? You don't get anything useful if you pass that to make Also, how can I tell if InnoDB built OK? I'm doing this for use with Ruby on Rails, and I need it to be in a separate directory from the version we already have (3.x) used by others. I modified mysql-4.1.14/BUILD/compile-solaris-sparc thusly neelix hgs 81 % display_diffs.rb . --- ./compile-solaris-sparc.orig2005-08-17 18:06:41.0 +0100 +++ ./compile-solaris-sparc 2005-09-06 18:36:25.386697000 +0100 @@ -11,6 +11,6 @@ (cd gemini aclocal autoheader aclocal automake autoconf) fi -CFLAGS=-g -Wimplicit -Wreturn-type -Wswitch -Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat -Wparentheses -Wsign-compare -Wwrite-strings -Wunused -O3 -fno-omit
Re: `gmake test` probs Solaris9 for M. 4.1.4.
On Fri, 9 Sep 2005, Michael Stassen wrote: Hugh, I get the same thing on Mac OS X 10.3.9. My thinking was that rather than replying with an unhelpful Me too, I would do some digging and then reply with what I found. I realize now that left you hanging (sorry), so I'll report what I've found so far. Ok, thanks for this report, which is in plenty of detail, even if it is so far :-) The test suite is broken. Who guards the guards? :-) The archive test is meant to test the archive table engine, but the archive engine is not built into mysql by default. You have to add the --with-archive-storage-engine if you want it. You didn't do that, so the I'm not sure what it is, so I probably don't need it. archive test should have been skipped. With mysql 4.1.12, `make -n test` reveals cd mysql-test; ./mysql-test-run ./mysql-test-run --ps-protocol With 4.1.14, that has changed to cd mysql-test; perl mysql-test-run.pl perl mysql-test-run.pl --ps-protocol Apparently, the test program shell script, mysql-test-run, has been rewritten as a perl script, though there is no mention of this in the change log http://dev.mysql.com/doc/mysql/en/news-4-1-x.html. A quick glance at the I was rather surpised about the dependency on Perl. source shows that the perl script is not finished -- it has quite a few commented-out, fix me sections. I'll have a look. You still have a couple of options to test your build. You can run the new test suite with the --force option. Do what make would do, `cd mysql-test`, then `perl mysql-test-run.pl --force`. You will see that every test that should have been skipped will instead be run and fail (archive, the bdb tests, blackhole, csv, example, func_des_encrypt, isam, the ndb tests, I'm fairly fluent in perl, though mine's a bit Chaucerian, since I learned Perl4 :-), and am not *so* familiar with the 5 constructs, but I could try to send patches (to whom?). openssl_1, raid, and so on). If every test passes except for tests of things you don't have, you should be OK. In particular, there are a set of innodb tests which should answer your question about whether or not innodb is working in your build. Thanks. There's a second way, which I think is better. It turns out that the old shell-script test suite is still built. Hence, you can still test the old way. Yes, and It may be worth trying both. cd mysql-test ./mysql-test-run --force This will properly skip tests of features not compiled in. Note that I added I can probably steal how to skip them and stick that in the Perl. --force because, at least in my case, the new embedded test, not_embedded_server, is run and fails. I'm not yet sure if that should have been skipped. The errors explicitly told me I needed --force, so that's OK. As the old test script is still built and the new test script is unfinished, undocumented, and broken, I am suspicious that the real problem is that make was prematurely (accidentally?) changed to use the new one before it was ready. I've copied the bugs list in hopes of an answer. Definitely some weirdness about the release process there :-) I'm sure I've done worse in the past, though. I'm not subscribed to the bugs list, so this might bounce back off there. The third way, I suppose, is to ask whether I'm actually using the correct version -- should I be on 4.1,x, or 4.0.x, or what? I'm under the impression that for work with Ruby on Rails I need the latest 4.x but I could have misunderstood something. What I really mean is: which versions are considered stable? [Ruby has a custom that minor release numbers are odd for developement, even for stable, but minorminor ones increment successively after that: 1.8.2, and 1.8.3 (due soon) are stable, 1.9.x is development (at present). I'm not sure how things work in the MySQL world.] Michael P.S. Out of curiosity, why did you find it necessary to edit BUILD/compile-solaris-sparc? Couldn't you make the changes you wanted with options to configure? I was passing options to configure, and the was a bit of setup in compile-solaris-sparc that was probably there for a reason. So I changed it there. I changed it to give me the alternative port and directory so I don't munge things for people using V3.x, used for teaching. [Besides, I'd have to mess with autoconf to fix configure properly, as it is setup by that, and I'm not so fluent in autoconf as I'd wish, plus it seems silly to mod the autoconf stuff for something so parochial as port + directory.] Maybe there's a better place altogether to define this stuff? Thank you, Hugh -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: `gmake test` probs Solaris9 for M. 4.1.4.
Michael, you beat me in replying, and saved me from typing the analysis - thanks! Michael Stassen wrote: [[...]] The test suite is broken. Well, I would not put it that way - a diplomatic wording is: The tool to run the test suite does not run as it should. I understand that the effect for Hugh and you is the same ;-) The archive test is meant to test the archive table engine, but the archive engine is not built into mysql by default. You have to add the --with-archive-storage-engine if you want it. You didn't do that, so the archive test should have been skipped. With mysql 4.1.12, `make -n test` reveals cd mysql-test; ./mysql-test-run ./mysql-test-run --ps-protocol With 4.1.14, that has changed to cd mysql-test; perl mysql-test-run.pl perl mysql-test-run.pl --ps-protocol Apparently, the test program shell script, mysql-test-run, has been rewritten as a perl script, though there is no mention of this in the change log http://dev.mysql.com/doc/mysql/en/news-4-1-x.html. A quick glance at the source shows that the perl script is not finished -- it has quite a few commented-out, fix me sections. Correct. A Perl script for the test suite is being worked on. Reasons: 1) A shell script will never work for native Windoes users who do not install Cygwwin, MinGW, MKS or similar suites. 2) The shell script lacks some functionality which is needed, and it is already too convoluted. So that Perl script is work in progress which we needed to test on all build platforms. It was an oversight that it got included in the source tree in the current status, the tests have also been done using the old shell script. [[...]] There's a second way, which I think is better. It turns out that the old shell-script test suite is still built. Hence, you can still test the old way. cd mysql-test ./mysql-test-run --force Right, this is what I recommend. To be a bit picky: There is one standard test suite only (which is included in the source tar-ball), but there are currently two different scripts to run it, the (old) shell and the (new) Perl script. The specific error causing your and Hugh's problem, the incorrect skipping of tests which are not applicable to the server to be tested, has been fixed, but maybe this version has not yet been pushed to the 4.1 tree. [[...]] As the old test script is still built and the new test script is unfinished, undocumented, and broken, I am suspicious that the real problem is that make was prematurely (accidentally?) changed to use the new one before it was ready. I've copied the bugs list in hopes of an answer. Both yes and no: yes in the sense that the new suite (as included in the 4.1.14 tree) is not yet correct. no in the sense that the change to use it _internally_ was deliberate in order to get full platform coverage. We are sorry it caused you inconveniences! Regards, Jörg -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: `gmake test` probs Solaris9 for M. 4.1.4.
On Fri, 9 Sep 2005, Joerg Bruehe wrote:
Michael,
you beat me in replying, and saved me from typing the analysis - thanks!
Michael Stassen wrote:
[[...]]
The test suite is broken.
Well, I would not put it that way - a diplomatic wording is:
The tool to run the test suite does not run as it should.
I understand that the effect for Hugh and you is the same ;-)
Nobody was claiming *deliberate* breakage! :-)
[...]
quite a few commented-out, fix me sections.
Correct. A Perl script for the test suite is being worked on. Reasons:
1) A shell script will never work for native Windoes users who do not
install Cygwwin, MinGW, MKS or similar suites.
2) The shell script lacks some functionality which is needed, and it is
already too convoluted.
Good reasons.
[...]
cd mysql-test ./mysql-test-run --force
Right, this is what I recommend.
To be a bit picky: There is one standard test suite only (which is included
in the source tar-ball), but there are currently two different scripts to run
it, the (old) shell and the (new) Perl script.
The specific error causing your and Hugh's problem, the incorrect skipping of
tests which are not applicable to the server to be tested,
has been fixed, but maybe this version has not yet been pushed to the 4.1
tree.
Can we grab the new version off the web (CVSweb or similar?)
somewhere? If it is feasible for me I'd like to translate it to
Ruby to give you that much wider coverage. Depends if my Perl
fluency is sufficient, etc. Whether {you, the committee, ???} accept
the contribution is another matter entirely, of course.
Regards, J?rg
Thank you,
Hugh
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
`gmake test` probs Solaris9 for M. 4.1.4.
Attempts to do make test prior to installation, to check that I'm installing something workable, give: quote neelix hgs 63 % gmake test cd mysql-test; perl mysql-test-run.pl perl mysql-test-run.pl --ps-protocol No ndbcluster support Killing Possible Leftover Processes Removing Stale Files Installing Master Databases Installing Master Databases Installing Slave Databases Installing Slave Databases Installing Slave Databases === Finding Tests in the 'main' suite Starting Tests in the 'main' suite TESTRESULT --- alias [ pass ] alter_table [ pass ] analyse [ pass ] analyze [ pass ] ansi[ pass ] archive [ fail ] Errors are (from /scratch/hgs/mysql-4.1.14/mysql-test/var/log/mysqltest-time) : This test is not supported by this installation mysqltest returned unexpected code 15872, it has probably crashed (the last lines may be the most important ones) Aborting: archive failed. To continue, re-run with '--force'. Ending Tests Shutting-down MySQL daemon Master(s) shutdown finished Slave(s) shutdown finished gmake: *** [test] Error 1 neelix hgs 64 % /quote So, firstly, invoke what with '--force'? You don't get anything useful if you pass that to make Also, how can I tell if InnoDB built OK? I'm doing this for use with Ruby on Rails, and I need it to be in a separate directory from the version we already have (3.x) used by others. I modified mysql-4.1.14/BUILD/compile-solaris-sparc thusly neelix hgs 81 % display_diffs.rb . --- ./compile-solaris-sparc.orig2005-08-17 18:06:41.0 +0100 +++ ./compile-solaris-sparc 2005-09-06 18:36:25.386697000 +0100 @@ -11,6 +11,6 @@ (cd gemini aclocal autoheader aclocal automake autoconf) fi -CFLAGS=-g -Wimplicit -Wreturn-type -Wswitch -Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat -Wparentheses -Wsign-compare -Wwrite-strings -Wunused -O3 -fno-omit-frame-pointer -mcpu=v8 -Wa,-xarch=v8plusa CXX=gcc CXXFLAGS=-Wimplicit -Wreturn-type -Wswitch -Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat -Wparentheses -Wsign-compare -Wwrite-strings -Woverloaded-virtual -Wsign-promo -Wreorder -Wctor-dtor-privacy -Wnon-virtual-dtor -felide-constructors -fno-exceptions -fno-rtti -O3 -fno-omit-frame-pointer -mcpu=v8 -Wa,-xarch=v8plusa -g ./configure --prefix=/usr/local/mysql --enable-assembler --with-extra-charsets=complex --enable-thread-safe-client +CFLAGS=-g -Wimplicit -Wreturn-type -Wswitch -Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat -Wparentheses -Wsign-compare -Wwrite-strings -Wunused -O3 -fno-omit-frame-pointer -mcpu=v8 -Wa,-xarch=v8plusa CXX=gcc CXXFLAGS=-Wimplicit -Wreturn-type -Wswitch -Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat -Wparentheses -Wsign-compare -Wwrite-strings -Woverloaded-virtual -Wsign-promo -Wreorder -Wctor-dtor-privacy -Wnon-virtual-dtor -felide-constructors -fno-exceptions -fno-rtti -O3 -fno-omit-frame-pointer -mcpu=v8 -Wa,-xarch=v8plusa -g ./configure --prefix=/usr/local/mysql --enable-assembler --with-extra-charsets=complex --enable-thread-safe-client --with-tcp-port=3308 --with-unix-socket-path=/tmp/mysql4.sock --prefix=/usr/local/mysql-4.1.14 gmake -j 4 neelix hgs 82 % and I invoked the script directly, and also tried with bash. Not sure what else to pass on. GNU Make version 3.79.1, by Richard Stallman and Roland McGrath. Built for sparc-sun-solaris2.9 gcc (GCC) 3.4.3 Thank you Hugh -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
perl run-all-test error
hello i just installed mysql-standard-4.1.13-pc-linux-gnu-i686.tar.gz then try typing the command perl run-all-test when this is error message came up. below is the error message. install_driver(mysql) failed: Can't load '/usr/lib/perl5/vendor_perl/5.8.5/i386-linux-thread-multi/auto/DBD/mysql/mys ql.so' for module DBD::mysql: libmysqlclient.so.14: cannot open shared object file: No such file or directory at /usr/lib/perl5/5.8.5/i386-linux-thread-multi/DynaLoader.pm line 230. at (eval 51) line 3 Compilation failed in require at (eval 51) line 3. Perhaps a required shared library or dll isn't installed where expected at /usr/src/webserver/mysql-standard-4.1.13-pc-linux-gnu-i686/sql-bench/server- cfg line 247 what library i'm missing. also can you give me the URL address. rgds, Joeffrey -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: perl run-all-test error
Hello. ql.so' for module DBD::mysql: libmysqlclient.so.14: cannot open shared object file: No such file or directory at Install Dynamic client libraries rpm from: http://dev.mysql.com/downloads/mysql/4.1.html Have a look here as well: http://dev.mysql.com/doc/mysql/en/perl-support-problems.html Joeffrey Betita [EMAIL PROTECTED] wrote: hello i just installed mysql-standard-4.1.13-pc-linux-gnu-i686.tar.gz then try typing the command perl run-all-test when this is error message came up. below is the error message. install_driver(mysql) failed: Can't load '/usr/lib/perl5/vendor_perl/5.8.5/i386-linux-thread-multi/auto/DBD/mysql/mys ql.so' for module DBD::mysql: libmysqlclient.so.14: cannot open shared object file: No such file or directory at /usr/lib/perl5/5.8.5/i386-linux-thread-multi/DynaLoader.pm line 230. at (eval 51) line 3 Compilation failed in require at (eval 51) line 3. Perhaps a required shared library or dll isn't installed where expected at /usr/src/webserver/mysql-standard-4.1.13-pc-linux-gnu-i686/sql-bench/server- cfg line 247 what library i'm missing. also can you give me the URL address. rgds, Joeffrey -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Populating table with test file
Hello. I'm not sure about 'myPHPadmin', but if it uses LOAD DATA INFILE you should use \N in the data file, if you want to insert a NULL value in the column. See: http://dev.mysql.com/doc/mysql/en/problems-with-null.html where I would supply the number (would it start with 0 (zero) or 1)? Don't use a zero in the AUTO_INCREMENT column if you want to explicitly specify the values in that column. I'm a little confused about the format of the data in the text file. From what I've read, In general you can use both, but for your first database I'd recommend you to use your second form (explicitly specify the values). Hello. I'm creating my first database and would prefer populating the tables using a text file I'll create in Notepad (not that it makes and difference). In case it matters, I'm using myPHPadmin provided by my web hosting service. I'm a little confused about the format of the data in the text file. From what I've read, it's simply listing the values in a row separated by a tab. But what if the first field/column is an ID number to be generated by MySQL? Table groups Two Fields: groups_id auto-increment Primary groups_namevarchar(15) Would the text file look like: NULLstudents NULLfaculty NULLstaff where I would acutally type NULL or 0students 1faculty 2staff where I would supply the number (would it start with 0 (zero) or 1)? or what else is there? Jeff Broomall [EMAIL PROTECTED] wrote: -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Populating table with test file
Hello. I'm creating my first database and would prefer populating the tables using a text file I'll create in Notepad (not that it makes and difference). In case it matters, I'm using myPHPadmin provided by my web hosting service. I'm a little confused about the format of the data in the text file. From what I've read, it's simply listing the values in a row separated by a tab. But what if the first field/column is an ID number to be generated by MySQL? Table groups Two Fields: groups_id auto-increment Primary groups_namevarchar(15) Would the text file look like: NULLstudents NULLfaculty NULLstaff where I would acutally type NULL or 0students 1faculty 2staff where I would supply the number (would it start with 0 (zero) or 1)? or what else is there? Thanks for the help. Jeff
Failure of sql-bench test?
I cd /usr/local/mysql/sql-bench and perl run_all_tests, just to get the following error: - Got error: 'Access denied for user 'root'@'localhost' (using password: NO)' when connecting to DBI:mysql:database=test;host=localhost with user: '' password: '' - By the way, before doing the bench test, I did this operation: /usr/local/mysql/bin/mysqladmin -u root password 'new-password' /usr/local/mysql/bin/mysqladmin -u root -h gso_dev_2.workgroup password 'new-password' Is this the cause? How to let the bench test run? Thanks in advance, Regards, Xu Qiang -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Failure of sql-bench test?
Xu Qiang wrote: I cd /usr/local/mysql/sql-bench and perl run_all_tests, just to get the following error: - Got error: 'Access denied for user 'root'@'localhost' (using password: NO)' when connecting to DBI:mysql:database=test;host=localhost with user: '' password: '' - Sorry I didn't read the file README in the sql-bench directory before asking the question. Now I run the test with perl run-all_tests --user=mysql, and it can run successfully now. Regards, Xu Qiang -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
IGNORE: test only
IGNORE: test only since I did not get my last posting. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysql-test-run --external?
According to the README, mysql-test-run supports an --external option: db1 mysql-test # grep -a1 external README If you want to run the test with a running MySQL server use the --external option to mysql-test-run. However it doesn't actually support it: db1 mysql-test # ./mysql-test-run --external Unrecognized option: --external How do I get the test suite to run with an existing DB? Cheers, ds -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql-test-run --external?
Hello David, I think you are looking for --extern option of the test suite. I corrected the README file. The changes should be propagated to the public repository soon, but you could check the commit mail for more details right now: http://lists.mysql.com/internals/26266 Petr On Tue, 2005-06-21 at 13:40 -0700, David Sparks wrote: According to the README, mysql-test-run supports an --external option: db1 mysql-test # grep -a1 external README If you want to run the test with a running MySQL server use the --external option to mysql-test-run. However it doesn't actually support it: db1 mysql-test # ./mysql-test-run --external Unrecognized option: --external How do I get the test suite to run with an existing DB? Cheers, ds -- Petr Chardin, Software Developer MySQL AB, www.mysql.com Are you MySQL certified? www.mysql.com/certification -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql-test-run --external?
Petr, Thanks for the reply! I think you are looking for --extern option of the test suite. I corrected the README file. The changes should be propagated to the public repository soon, but you could check the commit mail for more details right now: http://lists.mysql.com/internals/26266 Ahah, this explains it. We had tried the --extern option without any args but it didn't work due to the fallback behavior. A useful enhancement would be to send a warning to STDERR saying that the --extern option is being disregarded. The example shows how to run 2 tests. I though there were (a lot) more tests available? Why isn't there a simple way of running all available tests on an installed and running mysql server? And when I try it this happens: db1 mysql-test # ./mysql-test-run --extern alias analyze Starting Tests TESTRESULT --- alias [ fail ] Errors are (from /usr/share/mysql/mysql-test/var/log/mysqltest-time) : ./mysql-test-run: line 1637: /usr/share/mysql/bin/mysqltest: No such file or directory -%- A couple of fixes need to be made to this script similar to the patch below which does: a) doesn't try to use a full path to mysqltest (as it has already been installed) b) fixes a case sensitivity problem with $MYSQL_TEST_ARGS (there seems to be several more places in the script where it needs patching) Cheers, ds --- mysql-test-run.orig 2005-06-21 16:58:18.419746418 -0700 +++ mysql-test-run 2005-06-21 17:06:46.286679482 -0700 @@ -1634,9 +1634,9 @@ $RM -f r/$tname.*reject mysql_test_args=-R $result_file $EXTRA_MYSQL_TEST_OPT if [ -z $DO_CLIENT_GDB ] ; then - `$MYSQL_TEST $mysql_test_args $tf 2 $TIMEFILE`; + `mysqltest $MYSQL_TEST_ARGS $tf 2 $TIMEFILE`; else - do_gdb_test $mysql_test_args $tf + do_gdb_test $MYSQL_TEST_ARGS $tf fi res=$? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Just a test
Mikhail Berman
Test - please ignore
Just a test - thanks There are no problems, only solutions. Gabe Tucker Bloomberg LP (609) 750 6668 - P (646) 268 5681 - F -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
rpl_openssl test hangs in MySQL 4.1.12
Hello All, I am very new to the MySQL environment. I have built latest stable MySQL 4.1.12 in Hp-Unix 11.23 IPF platform with OpenSSL support. Following are my configuration options I have used to build, ./configure --prefix=/opt/iexpress/mysql --localstatedir=/var/opt/iexpress/mysql --enable-thread-safe-client --with-named-thread-libs=/usr/lib/libpthread.1 --with-zlib-dir=/usr/local --with-vio --with-openssl=/opt/openssl Compiler used is gcc version 3.4.3 and OpenSSL version is 09.07e. When I tried to run the tests inside mysql-test directory after the gmake as, ./mysql-test-run openssl_1 and rpl_openssl are skipped eventhough i have compiled with OpenSSL. So I have rerun these tests alone as, ./mysql-test-run --with-openssl openssl_1 rpl_openssl Now openssl_1 test passed but rpl_openssl get hanged. I have checked the slave.err file, it seems that access denied for slave and it is looks for sync_with_master, as it was not able to connect, it get hanged. The slave.err log details is given below, ==begin CURRENT_TEST: rpl_openssl /disk1/release5/mysql/4.1.12/Source/mysql-4.1.12/sql/mysqld: ready for connections. Version: '4.1.12-log' socket: '/disk1/release5/mysql/4.1.12/Source/mysql-4.1.12/mysql-test/var/tmp/slave.sock' port: 9308 Source distribution 050525 19:11:41 [Note] Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay lo g '/disk1/release5/mysql/4.1.12/Source/mysql-4.1.12/mysql-test/var/log/slave-relay -bin.01' position: 4 050525 19:11:41 [Note] Slave I/O thread: connected to master '[EMAIL PROTECTED]:9306', replication started in log 'FIRST' at position 4 050525 19:11:41 [ERROR] Slave I/O thread killed while reading event 050525 19:11:41 [ERROR] Slave I/O thread exiting, read up to log 'master-bin.01', position 229 050525 19:11:41 [ERROR] Error reading relay log event: slave SQL thread was killed 050525 19:11:41 [Note] Slave SQL thread initialized, starting replication in log 'master-bin.01' at position 229, relay log '/disk1/release5/mysql/4.1.12/Source/mysql-4.1.12/mysql-test/var/log/slave-relay -bin.01' pos ition: 4 050525 19:11:41 [Note] Slave I/O thread: connected to master '[EMAIL PROTECTED]:9306', replication started in l og 'master-bin.01' at position 229 050525 19:11:41 [ERROR] Error on COM_REGISTER_SLAVE: 1045 'Access denied for user ''@'localhost' (using password : NO)' 050525 19:11:41 [ERROR] Slave I/O thread exiting, read up to log 'master-bin.01', position 229 050525 19:11:44 [ERROR] Error reading relay log event: slave SQL thread was killed 050525 19:11:44 [Note] Slave SQL thread initialized, starting replication in log 'master-bin.01' at position 229, relay log '/disk1/release5/mysql/4.1.12/Source/mysql-4.1.12/mysql-test/var/log/slave-relay -bin.01' pos ition: 4 050525 19:11:44 [Note] Slave I/O thread: connected to master '[EMAIL PROTECTED]:9306', replication started in l og 'master-bin.01' at position 229 050525 19:11:44 [ERROR] Error on COM_REGISTER_SLAVE: 1045 'Access denied for user ''@'localhost' (using password : NO)' 050525 19:11:44 [ERROR] Slave I/O thread exiting, read up to log 'master-bin.01', position 229 end=== I have faced the same issue when i used MySQL 4.1.10a. Please suggest a fix or workaround for this problem... Or am i do anything wrong to this tests ? Could anyone suggent me steps to setup same replication test manually? You can repeat this scenario as, Run the MySQL OpenSSL tests in MySQL 4.1.12 source as, ./mysql-test-run --with-openssl rpl_openssl You will see it get hanged Thanks and Regards, Kathir. __ Do you Yahoo!? Yahoo! Small Business - Try our new Resources site http://smallbusiness.yahoo.com/resources/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: rpl_openssl test hangs in MySQL 4.1.12
On Wed, 25 May 2005 11:09:06 -0700 (PDT) Kathir Velu [EMAIL PROTECTED] wrote: openssl_1 and rpl_openssl are skipped eventhough i have compiled with OpenSSL. So I have rerun these tests alone as, ./mysql-test-run --with-openssl openssl_1 rpl_openssl Now openssl_1 test passed but rpl_openssl get hanged. I tested openssl a couple of weeks ago on 4.1.12 on Solaris and found the same thing. So this may not be platform specific. Did you check for a bugreport on this? I have not pursued it any further, but I need to: Alex -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Newbie question about test database...
Okay, so MySQL is now installed and running. It looks like a database named test was created with no tables. Is this just used for installation purposes? Can it now be deleted or is there a reason to keep it? Or does it have some magical purpose like the mysql database? Jeff -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Newbie question about test database...
on one level, the test database is there just have something to log into after intall to prove it's working.. some init.d startup scripts (I'm thinking RedHat here) try to log into the database as an authenticated user after each start up and when doing a 'status' call just to make sure it's alive. some scrupulously paranoid sysadmins prefer to delete it the moment the system comes up, other leave it there for convenience.. On Mon, 2005-03-14 at 19:52, Jeff Justice wrote: Okay, so MySQL is now installed and running. It looks like a database named test was created with no tables. Is this just used for installation purposes? Can it now be deleted or is there a reason to keep it? Or does it have some magical purpose like the mysql database? Jeff -- - michael dykman - [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
build fails make test
After building, I ran make test. The func_group test failed. Here is the output: func_group [ fail ] Errors are (from /mnt/raid/download/computer/software/mysql/mysql-5.0.2-alpha/mysql-test/var/log/mysqltest-time) : /mnt/raid/download/computer/software/mysql/mysql-5.0.2-alpha/client/.libs/mysqltest: At line 477: Result content mismatch (the last lines may be the most important ones) Below are the diffs between actual and expected results: --- *** r/func_group.result 2004-12-01 03:31:35.0 +0300 --- r/func_group.reject 2005-03-09 02:00:49.0 +0300 *** *** 578,584 explain select min(a1) from t1 where a1 != 'KKK'; idselect_type table typepossible_keys key key_len refrows Extra ! 1 SIMPLE t1 index PRIMARY PRIMARY 3 NULL14 Using where; Using index explain select max(a3) from t1 where a2 2 and a3 'SEA'; idselect_type table typepossible_keys key key_len refrows Extra --- 578,584 explain select min(a1) from t1 where a1 != 'KKK'; idselect_type table typepossible_keys key key_len refrows Extra ! 1 SIMPLE t1 range PRIMARY PRIMARY 3 NULL14 Using where; Using index explain select max(a3) from t1 where a2 2 and a3 'SEA'; idselect_type table typepossible_keys key key_len refrows Extra --- I re-ran mysql-test-run --force from the mysql-test directory. The following also failed: greedy_optimizer group_min_max (Their combined .reject files are well over 100k. Let me know where to send compressed versions.) Note that the entire build and test process was done from a user account, not from the root account. How-To-Repeat: simply ran make test after building. Fix: Unknown Submitter-Id: submitter ID Originator:Mark Johnson Organization: n/a MySQL support: none Synopsis: func_group test failed. Severity: Priority: Category: mysql Class: sw-bug Release: mysql-5.0.2-alpha (Source distribution) C compiler:gcc (GCC) 3.4.3 C++ compiler: g++ (GCC) 3.4.3 Environment: System: Linux enterprise 2.6.10 #1 Sat Feb 5 14:42:44 MST 2005 i686 unknown unknown GNU/Linux Architecture: i686 Additional notes on the system: It is based on Slackware 10.0, with security patches from slackware.com applied.When I tried to compile MySQL with the gcc version 3.3.4, which came with Slackware 10, there was an internal compiler error. I upgraded the compiler to the current version from slackware-current. Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc/i486-slackware-linux/3.4.3/specs Configured with: ../gcc-3.4.3/configure --prefix=/usr --enable-shared --enable-threads=posix --enable-__cxa_atexit --disable-checking --with-gnu-ld --verbose --target=i486-slackware-linux --host=i486-slackware-linux Thread model: posix gcc version 3.4.3 Compilation info: CC='gcc' CFLAGS='-O2 -march=pentium2' CXX='g++' CXXFLAGS='' LDFLAGS='' ASFLAGS='' LIBC: lrwxrwxrwx 1 root root 13 2004-10-21 06:28 /lib/libc.so.6 - libc-2.3.2.so -rwxr-xr-x 1 root root 1250840 2004-05-24 22:44 /lib/libc-2.3.2.so -rw-r--r-- 1 root root 2532408 2004-05-24 22:44 /usr/lib/libc.a -rw-r--r-- 1 root root 204 2004-05-24 22:31 /usr/lib/libc.so Configure command: ./configure 'CFLAGS=-O2 -march=pentium2' -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: InnoDB Row Lock test (A query maybe?)
Begumisa Gerald M [EMAIL PROTECTED] wrote on 02/22/2005 02:03:43 AM: Hi, I'm writing an application that uses InnoDB tables to provide transactional integrity. The front-end is a web-based interface. I'd like to know - is there a way one can issue a query to test whether a particular set of rows (or row) has already been locked by another session - rather than the default action of waiting for quite long for the lock to be granted. The idea is so that a person using the front-end may know whether the information they are attempting to access is unavailable at the time. There will be situations where rows will be locked exclusively for prolonged times and I wouldn't want the web application users to be subjected to these lengthy delays but rather be told to try later. Regards, Gerald. Are you saying that you want to use a transactional or table lock in place of an application-level mutex object? I think you are trying to ask the DB to do more than it is intended to do (not that it couldn't do what you ask but it is unusual to hold a table lock or transaction open for any intentional length of time. Usually the database sets and releases locks like that in response to a series of statements on the order of sub-seconds, not for the several seconds to minutes that may be required of an application-level lock). I have a similar situation (another user may already be editing a particular record. only one user can edit a record at any one time) in one of my web-based applications. I created a new field to hold the ID of the application user that has the exclusive privileges on that record. That way the application deals with application-level logic (no more than one editor at a time) and I use db-level transactions to set and unset the editor field as appropriate. The record is locked for the shortest length of time and you can easily and quickly check the value of the field so that your users can know immediately if they have rights to edit the record or not. It takes a bit more logic written into your application but the performance gains and the speed of the user-feedback is well worth the effort. Opening a transaction on one page request and closing it on another (as when the results are submitted) will be VERY difficult for you to manage as transactions are connection-specific and unless you are using a pooled or global connection variable, you will be creating and destroying connections rather frequently. It's generally not a good idea to put a DB-level lock (TABLE lock or open transaction) on a record to enforce an application-level rule, especially in the mostly-stateless, asynchronous world of web-based development. Shawn Green Database Administrator Unimin Corporation - Spruce Pine
RE: InnoDB Row Lock test (A query maybe?)
Hi I must be blind. Please help a DB-Newbie. What's wrong here: create table users ( email varchar (80) unique not null, ownerdomain int not null, foreign key (ownerdomain) references domains on delete cascade ) type=innodb; MySQL sais: ERROR 1005: Can't create table './postfix/users.frm' (errno: 150) Where can I lookup up error codes? Thanks Philipp -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: InnoDB Row Lock test (A query maybe?)
Your subject line is misleading; there is nothing in the body of your post suggesting that you are getting some kind of row lock, nor is there any query. Have you looked in the MySQL manual? If you have a look at this URL - http://dev.mysql.com/doc/mysql/en/innodb-error-codes.html - you'll see that InnoDB error 1005 means that your table could not be created; the 150 means that your foreign key constraint was not correctly formed. If you look up the REFERENCES clause in the article about the CREATE TABLE statement in the same manual (http://dev.mysql.com/doc/mysql/en/create-table.html), I think you'll see what's wrong with your statement. If you fix that, I think your table will be created correctly. Rhino - Original Message - From: Philipp Snizek [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Sent: Tuesday, February 22, 2005 11:08 AM Subject: RE: InnoDB Row Lock test (A query maybe?) Hi I must be blind. Please help a DB-Newbie. What's wrong here: create table users ( email varchar (80) unique not null, ownerdomain int not null, foreign key (ownerdomain) references domains on delete cascade ) type=innodb; MySQL sais: ERROR 1005: Can't create table './postfix/users.frm' (errno: 150) Where can I lookup up error codes? Thanks Philipp -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 266.3.0 - Release Date: 21/02/2005 -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 266.3.0 - Release Date: 21/02/2005 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: InnoDB Row Lock test (A query maybe?)
Hi Shawn,
Thanks for taking time to respond to this.
[...]Usually the database sets and releases locks like that in
response to a series of statements on the order of sub-seconds, not
for the several seconds to minutes that may be required of an
application-level lock).
Actually this is a bit different: On one side of the database is a
telephony application which requires that certain information in the table
does not change for the period of time that a call is active - and the
only way such information would change is if it were modified from the web
interface. Because within the [multithreaded] telephony system there are
application level locks that enforce concurrency in this respect - testing
a mutex lock here would tell whether an account is available or
unavailable quite easily - without having to attempt to lock a particular
set of rows in the DB.
The issue comes in ensuring that the web application does not modify that
information in the table while a call is in progress. To me it looked
like a DB level solution of some sort would be the best.
I have a similar situation (another user may already be editing a
particular record. only one user can edit a record at any one time)
in one of my web-based applications. I created a new field to hold
the ID of the application user that has the exclusive privileges on
that record. That way the application deals with application-level
logic (no more than one editor at a time) and I use db-level
transactions to set and unset the editor field as appropriate.
The record is locked for the shortest length of time and you can
easily and quickly check the value of the field so that your users
can know immediately if they have rights to edit the record or not.
That's an interesting way to do it, actually - it'll be abit of work but I
think its not bad at all. I was just curious about whether you could
test for a lock in InnoDB - it'd save alot of trouble.
Opening a transaction on one page request and closing it on another
(as when the results are submitted) will be VERY difficult for you
to manage as transactions are connection-specific and unless you are
using a pooled or global connection variable,
Actually, as I explained its abit different - its not between page
requests that I want to open / close transactions but rather to make sure
the web application users do not modify table information while a call is
in progress (i.e while the telephony application is holding the lock to
a given user's information).
you will be creating and destroying connections rather frequently.
Actually not, the web application architecture is abit as below:
[webserver]-{ENV}-[Small CGI Program]-{TCP/IP}-[Daemon]===[MySQL]
^^^
I.e there's a pool of persistent connections to the MySQL database that
are maintained and reused / shared.
It's generally not a good idea to put a DB-level lock (TABLE lock or
open transaction) on a record to enforce an application-level rule,
especially in the mostly-stateless, asynchronous world of web-based
development.
I see. What are some of the reasons why this would be so?
Thanks!
Rgds,
Gerald.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
