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 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 that

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 that

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 value

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, a

RE: repost: Too many open files

TECTED]] > 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

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 /usr/local/mysql/libexec/mys

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 will

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 r

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 techn

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 see

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 '/data/file

RE: tty beeps uncontrollably when hitting 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 m

Exclude 1 db from update log?

Hi, I have looked, again, in the manual and can't remember ever reading about this - but is it possible? I have one server with multiple databases. One of these databases fills the update log up to 2Gb limit in days (and I am not too bothered about logging that stuff anyway. we have txt files

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 Marc

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

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 Se

RE: Slow Select count(*) - Second Post

#x27;ll try dropping 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: S

RE: Slow Select count(*) - Second Post

select against the queue_index take so long? Thanks for your help in advance, Robin -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 ind

Slow Select count(*) - Second Post

Hi, This is a repost. Can anyone help me? Where can I look for more clues as to why this select is slow? A MyISAMchk will take the database down for too long, so unless I know that it will give me some usefull information I am hesitant to try it. Can anyone please explain the following? I

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 IN

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, com

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 soon,