Multiple concurrent transactions per connection

Hi all, I'm currently designing an open-source messaging server that will use MySQL as the data store (in embedded form). High performance is one of the goals of this project, so I have been examining possible I/O models and seem to have settled on a model where each thread services many requests

Re: mysqld corruption

Hmm I'd check for hard disc problems (turn on SMART monitoring and look through your kernel logs), RAM problems (look at memtest) and rootkits. Regards, Chris On Sun, 2004-02-15 at 15:45, Juan E Suris wrote: > I just installed 4.0.16 linux (x86, libc6) rpms on a fresh RH7.3 installation. I

Re: Slow sql on one dataset, fast on others...how to use explain and optimize

At 11:34 AM 2/14/2004, Are Pedersen wrote: I am running OPTIMIZE table and ANALYZE table each night on all tables and databases. Shouldn't the explain statement tell me what's going on...it says 9,1,1,7,1,6,1 on rows, and multiplied up its not much. 378 rows to examine should run fast. Are,

mysqld corruption

I just installed 4.0.16 linux (x86, libc6) rpms on a fresh RH7.3 installation. I am experiencing a problem that when I reboot the machine (shutdown -r now), the mysqld binary gets corrupted and mysql will not start. Before reboot: $md5sum /usr/sbin/mysqld 9e80e423401d959a7c1ecdb87ba49988 /usr/s

Re: mysql and borland

Hi all Please ignore this message was an old version od libmysql.dll on my windows\system32 folder Regards Luiz --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.581 / Virus Database: 368 - Release Date: 9/2/2004 -- MySQL Gene

Re: MySQL big problem

Hi, The install of MySQL is mainly "only a unpack". If You make a new folder - ex. C:\mysql02 - and install in this, You have the \data available and can copy to Your first installation, or change You my.ini to use second installation. Best regards Peter WR - Original Message - From:

Fw: mysql and borland

- Original Message - From: "Luiz Rafael Culik Guimaraes" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, February 14, 2004 4:35 PM Subject: mysql and borland > Dear Friends > > i uas using mysql 4.0.16 with out any problem > now i updated my server to 4.0.18 > regenerated

REPLACE INTO and CASCADEs.

Hello, I just upgraded from 4.0.17 to 4.0.18 on a Linux box and realised the behaviour of REPLACE INTO appears to have changed. I have two tables: table2 references table1 with ON DELETE CASCADE and ON UPDATE CASCADE on a primary key. Previously in 4.0.17 when I issued a REPLACE INTO on table1,

Re: MySQL big problem

I have resolved the problem by: - removing the /var/lib/mysql/mysql folder - reinstalling the mysql-server package Anyway I have no idea of where this can come from. This seems like an obscure bug Is there a way to reinstall a new 'mysql' database without reinstalling the software ? - Origin

Update is deleting data

This is on my development machine using Lasso 6.0.4, MacOS 10.2, MySQL 4.0.12-standard. Using Lasso: On one database I can add and update records. On another I can add, but updating sets all the specified fields to NULL in the target record (the key and non-referenced fields stay OK), even though

MySQL big problem

Since today I can only access to 2 databases (instead of 10) : mysql -u root > show databases shows me only 2 db theres 10 in /var/lib/mysql I suspect that the grant tables are damaged . How can I repair them ? Note that I cannot do mysql -u mysql mysql which returns access denied to '@localhos

mysql ended

Description: Downloaded, installed, and tried to run mysql server 4.0.18 on Red Hat ES 3x and recieved the following error: Starting mysqld daemon with databases from /var/lib/mysql 040214 12:08:16 mysqld ended I can't get the mysql server to run. Any suggestions on what could be

Re: Slow sql on one dataset, fast on others...how to use explain and optimize

I am running OPTIMIZE table and ANALYZE table each night on all tables and databases. Shouldn't the explain statement tell me what's going on...it says 9,1,1,7,1,6,1 on rows, and multiplied up its not much. 378 rows to examine should run fast. mos wrote: At 04:21 AM 2/14/2004, you wrote: Thi

Re: Slow sql on one dataset, fast on others...how to use explain and optimize

At 04:21 AM 2/14/2004, you wrote: This SQL takes 2 minutes to run on one database, and seconds on another. The tables has the same indexes, but different number of rows in them. It could be you have deleted a lot of rows from the table and therefore it is fragmented. You may want to try optimizing

Re: Binary Logs and Transactions (with InnoDB and MyISAM)

Basically, only error-free statements are replicated.to the slave, thus ensuring that constraints are satisfied. Regards, Chris David Griffiths wrote: Thanks for the reply. So InnoDB (and even MyISAM) use transactions (expected with InnoDB) and slaves track their position in the binary log fi

Re: best-practices backups

In a message dated 2/11/2004 2:26:09 PM Eastern Standard Time, [EMAIL PROTECTED] writes: I read this over and over.. I am curious why replication is such high finance?? I run it here. The Production system is a high finance machine and the replicated box is a old clunker basically.. It doesn't t

Re: best-practices backups

In a message dated 2/11/2004 4:44:00 PM Eastern Standard Time, [EMAIL PROTECTED] writes: Hi, I do just this at the moment - I have a cron job that runs MySQL dump, gzips the output, and will then ftp the important files to a machine that get's backed-up to a tape drive. I also time the dump, and

Q: Load Infile (Fixed Length)???

Hello. I've been using 'load data infile...' to build a data warehouse and it seems to be extremely efficient. However, I receive very large, fixed delimited file and (so far) have to parse them with a little Perl code. It's not a terrible situation, but a step I'd like to eliminate if I coul

Slow sql on one dataset, fast on others...how to use explain and optimize

This SQL takes 2 minutes to run on one database, and seconds on another. The tables has the same indexes, but different number of rows in them. Slow database: persontbl2 = 25000 rows memberstbl = 196000 rows groupchildrentbl = 9000 rows structuretreetbl = 58000 rows structureacl = 8800 ro

Re: Default UTF-8 Encoding

"David Perron" <[EMAIL PROTECTED]> wrote: > Is there a way to change the default mysql encoding to be something else, > say UTF-16LE at the session level? MySQL doesn't support UTF-16LE. If you want to set up connection character set you can: - execute SET CHARACTER SET from the client

Re: Newbie Question

"Rhino" <[EMAIL PROTECTED]> wrote: > I'm new to MySQL but I have extensive experience with DB2 so I'm getting > quite confused about how MySQL is supposed to work. > > I am using MySQL 4.0.11 on a Linux server running RedHat 9.2. I am > trying to create a pair of InnoDB tables that are related

Massive memory utiliazation

Hello, We have currently tuned MySQL for a high rate of traffic. But, now we are seeing issues with memory usage. It reaches about 2GB and the server becomed wildly unstable. Below is our my.cnf file. Can anyone point out any glarring errors? We are running this on a Dell 2650 with Red Had Adva