MySQL dying suddenly

. The problem has this pattern: it is always a query in a MyISAM table followed by an update. Although it happens all the time in our application, sometimes it crashes the database. Thanks, -- Leonardo Dias Catho Online WebDeveloper http://www.catho.com.br

Bug in Foreign key constraint

conline/#sql2-1a4-80a(usr_id); (emp_id) REFER conline/emp(emp_id) And the table it should be referencing was the table usr. This names looks particularly as a temporary table it changed for a while and didn't change it back to normal after the transaction was ready. -- Leonardo Dias Catho Online

Re: Bug in Foreign key constraint

it as a test environment. I want to make it clear that foreign key constraints are working before we put it on production. Or else I'd have to do it without foreign keys, which I think it's not a good idea. -- Leonardo Dias Catho Online WebDeveloper http://www.catho.com.br

A bug or problem

, -- Leonardo Dias Catho Online WebDeveloper http://www.catho.com.br/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail

Job Opening in Brazil

with PHP and MySQL. This job is to work in Brazil, So Paulo. For the brazilians out there, we are near Paulista Avenue, in Bela Vista. Please send rsums directly to [EMAIL PROTECTED] I prefer the rsum in the body of the message, but other formats will also be read. Greetings, -- Leonardo Dias

[Fwd: Re: Rotating the BINLogs]

I'm not the only one confused. Any ideas? Original Message Subject: Re: Rotating the BINLogs Date: 9 Feb 2001 12:37:03 -0300 From: "Rodolfo Sikora" [EMAIL PROTECTED] To: Leonardo Dias [EMAIL PROTECTED] I'm really confused like you. I've been using flush logs on m

SQL_SLAVE_SKIP_COUNTER not working

I've been trying a lot and the SET SQL_SLAVE_SKIP_COUNTER didn't work... what should I do then? -- Leonardo Dias Catho Online WebDeveloper http://www.catho.com.br/ - Before posting, please check: http://www.mysql.com

Re: Replication issues

carefully change our whole application here... -- Leonardo Dias Catho Online WebDeveloper http://www.catho.com.br/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists

Another problem with REPLICATIOn

using IP master-user = replication_user master-password = replication_password server-id = 2 When I started it at once, it seemed to be working fine. Now the slave just won't connect. What could be wrong? -- Leonardo Dias Catho Online WebDeveloper http://www.catho.com.br

Re: developer wanted

5tables, one with 3million records. We need to get it running fast enough for the web. Prob only one or two days work via Telnet. This is quite urgent so anyone interested, please respond ASAP. Would someone from BRazil do it? -- Leonardo Dias Catho Online WebDeveloper http

Problems with Replication

to sync clocks in two computers (one acting as master)? Thanks, -- Leonardo Dias Catho Online WebDeveloper http://www.catho.com.br/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

Re: MySQL driver for DELPHI ?

applications... Ah, voc brasileiro. De qualquer maneira, voc pode usar MyODBC e usar o driver OBDC do Delphi. -- Leonardo Dias Catho Online WebDeveloper http://www.catho.com.br/ - Before posting, please check: http

Very slow to connect

with the same problems out there? I'm waiting for a shout from the wild... :) Thanks. -- Leonardo Dias Catho Online WebDevelopper http://www.catho.com.br/ Variable_name Value ansi_mode OFF back_log100 basedir /usr/local/mysql/ binlog_cache_size 32768 character_set latin1

Re: Very slow to connect

is 2.2.17. I believe that upgrading it to 2.4 won't help either. Am I right or totally wrong? -- Leonardo Dias Catho Online WebDevelopper http://www.catho.com.br/ - Before posting, please check: http://www.mysql.com/manual.php

Re: Very slow to connect

and concurrent selects. Solved a problem. Found a new one. -- Leonardo Dias Catho Online WebDevelopper http://www.catho.com.br/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

Re: Very slow to connect

someday. Although they don't have LIMIT (which provides a nice "paging" system). We use LIMIT everywhere here. It's a nice functionality if you're doing searches all the time. -- Leonardo Dias Catho Online WebDevelopper http://www.ca

Re: Very slow to connect

scripts relies on database connections, it has become a big problem to our website and we've been unable to answer to our costumers what is going on. You don't seem to have mentioned how much memory you have. 1Gb. -- Leonardo Dias Catho Online WebDevelopper http://www.catho.com.br