Distributed transactions?

Hi all, Looking through various database feature lists, a fairly common thing seems to be Distributed Transactions (as in two databases, each have an uncommited transaction that needs to be commited and either all of both commit or all of both are rolled back). Firstly, anyone got any links

mysqld 4.0.15 crashing once a week or so on same queries

Since moving to mysql 4.0.15 from 3.23.5x, I am getting a crash once a week on an hourly run set of queries that are disk intensive. # ./resolve_stack_dump -n /tmp/mysqld.stack -s mysqld.sym 0x8070640 handle_segfault + 420 0x8288108 pthread_sighandler + 184 0x80aca70 __9Log_eventP3THDUsb + 64

EXISTS Clause

Does MySQL support the EXISTS / NOT EXISTS clause in table query statements? What I want to do is to find tuples which do NOT have corresponding tuples in another table. For example - tell me who in my person table does not have an email address. -- MySQL General Mailing List For list

Re: MySQL SMP performance question

On Thu, Oct 30, 2003 at 03:35:51PM -0500, [EMAIL PROTECTED] wrote: Hi everyone. I've got a web app that I'm getting ready to make public and I'm to figure out how well MySQL will utilize multiple processors. Has anyone seen how MySQL would scale from 1 to 8 processors? Is it even remotely

replication setup

Hello, I'm not so newbie to mysql yet have troubles setting up the replication.. Could you advise a way out ? I set up slave, master and rerun them. But when I type LOAD DATA FROM MASTER on slave server - I see ERROR 1218: Error connecting to master: Access denied for user: '[EMAIL

Re: 2-way replication

On Fri, Oct 31, 2003 at 02:37:05AM +0300, Ilia Kantor wrote: Hello, I have 2 databases in different places. There is 1 question and 2 problems about that.. What happens if one server fails to be in internet for some time ? log-bin on another one grows and after the connection is

theoretical row/record limit of mysql?

Hi all: Does anyone know the maximum number of rows/records that mysql allows? thanks __ Do you Yahoo!? Exclusive Video Premiere - Britney Spears http://launch.yahoo.com/promos/britneyspears/ -- MySQL General Mailing List For list archives:

Heap table in replication,bug?

Hello, mysql, The replication running smoothly between the master and slave,except that the heap table can not be synchronized. While the master insert the record into the heap table,the slave would do the same job. While the master delete the record in the heap table,the slave wouldn't do so.

Re: theoretical row/record limit of mysql?

Hi, I believe the row limit is 4,294,967,295... or is it 4 billion even? Hmm. Hope that helps. Matt - Original Message - From: joffrey leevy Sent: Sunday, November 02, 2003 7:41 PM Subject: theoretical row/record limit of mysql? Hi all: Does anyone know the maximum number of

problem loading text files into table

Hi all: Got a problem/question. I am trying to load a tab delimited textfile into my table and it keeps saying file not found. I am confident I am doing everything correct (the pathname, text extension, syntax, etc.) But it keeps saying file not found (error 1105 and errcode:2). What could I

MySQL 4.0.16 on RHEL3 AS AMD64

I have Red Hat Enterprise Linux 3 AS installed on a dual Opteron server with 16GB of memory (hoping to solve innodb_buffer_pool size issues under x86). I upgraded the MySQL included with RHEL3 (3.23.58) to the 4.0.16 rpms from the MySQL website. I had thought this would be a piece of cake, as