declaration of constants in MySQL functions

2007-09-18 Thread spikerlion
Hello, is there a possibility to declare constants in MySQL functions? declare test_name varchar(50) DEFAULT 'test'; The variable test_name here ist changeable but it should not be. Oracle syntax: test_name CONSTANT VARCHAR2(50) := 'test'; Regards, Spiker -- Pt! Schon vom neuen GMX

Re: Rollback on a Transaction with No Updates

2007-09-18 Thread Michael Dykman
I realize that wasn't the question, but it does seem like a lot of trouble to get the equivalent of setAutoCommit(true); On 9/17/07, Robert DiFalco [EMAIL PROTECTED] wrote: Sure, but that wasn't really the question. -Original Message- From: Michael Dykman [mailto:[EMAIL PROTECTED]

Re: Could drbd randomly flip bits? Was: Database page corruption on disk occurring during mysqldump on a fresh database and Was: Spontaneous development of supremely large files on different ext3 file

2007-09-18 Thread Stephen Samuel
You may want to excercise your I/O subsystem. Given that you probably don't want to stomp on a live filesystem, you might want to create a file of a couple of gigabytes and turn it into a pseudo-device with 'lofs(1)'. EG: # make a 15GB test file dd if=/dev/zero of=the_testfile bs=1M count=15000

non-blocking connect and EAGAIN

2007-09-18 Thread Dmitriy MiksIr
Hello! I got a lot of mysql errors Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (11). I trace one of this error and see, what non-blocking connect return EAGAIN. See: fcntl64(3, F_SETFL, O_RDWR|O_NONBLOCK) = 0 connect(3, {sa_family=AF_FILE,

RE: Rollback on a Transaction with No Updates

2007-09-18 Thread Robert DiFalco
Well, assume a higher level abstraction that does not give clients to that abstraction access to the raw connection. It only has methods like update, search, commit, or rollback. What the connection is doing is a kind of implementation detail. -Original Message- From: Michael Dykman