RE: problem with DBI connection interaction with sub-process

really), Robin Keech Java Developer Synectics Ltd -Original Message- From: Martin Waite [mailto:[EMAIL PROTECTED] Sent: 09 June 2003 12:10 To: MySQL List Subject: problem with DBI connection interaction with sub-process snip What seems to happen is that when the child exits, the DBI

RE: performance help required. (2G - 4G Ram upgrade)

, Robin -Original Message- From: Almar van Pel [mailto:[EMAIL PROTECTED]] Sent: 05 February 2002 00:02 To: [EMAIL PROTECTED]; Robin Keech Subject: RE: performance help required. (2G - 4G Ram upgrade) Hi, Your problem is that your query uses all of the rows in the table. That means

RE: performance help required. (2G - 4G Ram upgrade)

, Robin -Original Message- From: Almar van Pel [mailto:[EMAIL PROTECTED]] Sent: 05 February 2002 00:02 To: [EMAIL PROTECTED]; Robin Keech Subject: RE: performance help required. (2G - 4G Ram upgrade) Hi, Your problem is that your query uses all of the rows in the table. That means

performance help required. (2G - 4G Ram upgrade)

(Please reply directly, I am only on the digest list, thanks) I have an SQL statement that is taking far too long to run, around 11 minutes (while locking inserts/updates). We have installed some more RAM, and I need help with my.cnf and the troublesome SQL. Can anyone suggest some config

RE: C API - mysql_store_result segfaulting

Hi Carsten, I have just had a similar experience, which Jorge from Mysql support helped me sort out (successfully) - here is his advice to me. Hi! Which compiler / version are you using ? If it is any from 2.96 series, you'd be better off using any in the 2.95 or 3 series,

RE: repost: Too many open files

]] Sent: 02 October 2001 19:08 To: Colin Faber Cc: Robin Keech; [EMAIL PROTECTED] Subject: Re: repost: Too many open files Colin Faber wrote: it sounds like you've run out of file descriptors, I suggest rebuilding your kernel to handle more. In a bsd kernel you can do

repost: Too many open files

Hi, Any help would be greatly appreciated as I have a production server that is struggling. (I only get the digest list, so could you copy me on any replies - thankyou). My error log show this... 011002 9:16:11 Error in accept: Too many open files 011002 9:36:43

Rolling over on sequence number?

I have a requirement to use a sequence number table that I can reserve a block of sequences, (so auto increment is not suitable). This is my proposed table structure create table SEQNO ( SEQNO INT UNSIGNED NOT NULL DEFAULT 0, SESSION VARCHAR(10), LOCK_TIMEOUT TIMESTAMP); my blocks

Too many open files

My Mysqld stopped accepting connections with Error log: 010910 15:34:19 Error in accept: Too many open files 010910 15:49:02 /usr/local/mysql/libexec/mysqld: Normal shutdown when trying to connect I got: ERROR 2013: Lost connection to MySQL server during query changed max_connections and

bin log question

]$ mysqlbinlog --offset=100 -j 110 host-bin.001 ERROR: failed on my_fseek() Thanks in advance, Robin Keech www.dialogue.co.uk Dialogue Communications (Estd. 1994) is a world leader in the development and implementation of mobile data and internet messaging solutions. The company's technology

RE: Having success with 20 million rows

We have a large database with two tables of around 31.5 million rows each. When I did an alter table, again to modify a column, it took 17 hours. I noticed that the table was still readable and writes were blocked. However, during the ALTER table MySQL repaired the table using a keysort. This

RE: Problem using SELECT INTO DUMPFILE

use SELECT * INTO OUTFILE 'filename' . -Original Message- From: Bill Moran [mailto:[EMAIL PROTECTED]] Sent: 09 May 2001 00:44 To: [EMAIL PROTECTED] Subject: Problem using SELECT INTO DUMPFILE I get an error stating: you have an error in your SQL syntax near 'dumpfile

RE: tty beeps uncontrollably when hitting CR after mysqld

It's just a quick thought, and may not be relevant at all, but ... If you have a tail on the mysql log file that is doing something with blobs (binary objects), sometimes the bell character turns up and causes your system to beep. It worried me untill I realised what was happening. May not be

RE: Off Topic Perl Mysql modules install problem

its looking for the z compression library. To fix do this 1) perl Makefile.PL 2) cd mysql 3) vi Makefile 4) search for line LDLOADLIBS and add -lz to end 5) cd .. 6) make 7) make test 8) make install Robin -Original Message- From: Curtis Maurand [mailto:[EMAIL PROTECTED]] Sent: 06

RE: Do index in MySQL is case insensitive?

Hi, Do you mean case insensitive when you do a like? a like is case insensitive, to make it sensitive do a LIKE BINARY 'abc', or use CLIKE (from memory, might be wrong). Robin -Original Message- From: Carfield Yim [mailto:[EMAIL PROTECTED]] Sent: 02 March 2001 10:42 To: '[EMAIL

RE: Slow Select count(*) - Second Post

-Original Message- From: Patrick FICHE [mailto:[EMAIL PROTECTED]] Sent: 20 February 2001 14:26 To: Robin Keech Subject: RE: Slow Select count(*) - Second Post Hi, What do you think of creating a combined index containing fro example soc_date, server_id, queue_id ) in this order

RE: Slow Select count(*) - Second Post

the q_idx and see what that gives me. Is there any way to re-write SQL to force the optimiser to use a certain index? Thanks again Robin -Original Message- From: Jarmo Paavilainen [mailto:[EMAIL PROTECTED]] Sent: 20 February 2001 15:50 To: Robin Keech Subject: SV: Slow Select count

RE: Slow Select count(*) - Second Post

Thanks for all your help. This has got the query time down to 5 seconds from 2 minutes!! Much appreciated everyone. Robin -Original Message- From: Tibor Simko [mailto:[EMAIL PROTECTED]] Sent: 20 February 2001 16:46 To: Robin Keech Cc: '[EMAIL PROTECTED]' Subject: Re: Slow Select count

RE: Innobase + transactions row level locks will be released in a few days in MySQL 3.23.3x

On a related note, how mature is the Innobase code? It is mostly new? Or like NuSphere's Gemini, it is older code which has been adapted to fit in with MySQL's table handler interface? Thanks! Jeremy Hi, I am also very interested in finding more out about innobase - code maturity, company

Help with slow select count(*)

Hi, Can anyone please explain the following? I do two select count(*)'s from a big table, (21,000,000 + rows 6.5 Gb). All columns in the where are indexed. The first select is very quick, the second very slow. The ONLY difference is the value of one column variable (queue_id), which is an

RE: Update: Status of MySQL 4.0/Innobase/trx row level locks

I'm confused. Am I right in thinking that the Nusphere Gemini project and this announcment are linked? Is the Innobase code going to provide the transactional support for MySQL v.4? If not, whats the difference between this and Nuspheres work? My company will definitely need transactions