ignore
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
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
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
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
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
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
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
[[...]]
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
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
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:
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
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
,
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
:
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
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
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
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
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
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
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
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
Any information on how to run the test scripts for the embedded client.
Thanks,
-Alex
Test E-mail
Mikhail Berman
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
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 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
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
: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
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
test
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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
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
://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
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
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
:
***
#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
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
/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
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
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
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
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
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
] 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
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
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
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
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
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
|
+--+
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
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
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
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
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
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
, 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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
-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
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)
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
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
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
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]
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
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
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
Mikhail Berman
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]
/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
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
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
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
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
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
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
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
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
1 - 100 of 407 matches
Mail list logo