slave should not stop

Is there any way within mysql to have the slaves not stop replicating on an error. For some reason, my application is trying to insert duplicate keys. This fails and the slaves stop replicating from the master. Ideally, the command that failed would just be skipped automatically and the

Re: how to switch off logging?

You can stop creating the logs like rsl156-bin.00[123] (the bin logs) by commenting out the log-bin line in your my.cnf, and restarting mysql. You need them, though, if your server is a replication master. More on the logs here: http://dev.mysql.com/doc/mysql/en/Log_Files.html Jim Michael

Re: Data corruption on deletes

This sequence causes the same errors: ALTER TABLE postsearch DISABLE KEYS; delete from postsearch where postId=65031 limit 1; ALTER TABLE postsearch ENABLE KEYS; #1034 - Incorrect key file for table: 'postsearch'. Try to repair it Could this be a bug, as hinted at here by people using 4.1:

Re: Data corruption on deletes

gerald_clark wrote: Hardware? Celeron 1.3Ghz, IDE drive, 512Mb RAM OS and version? GNU/Linux, 2.4.20-8 kernel MySql version? 4.0.17 Size of data file? Size of index file? postsearch.frm 8.7K postsearch.MYD 3.5G postsearch.MYI 1.0G postsearch.TMD 3.5G Filesystem type? ext3 Sorry 'bout that! Also,

Data corruption on deletes

I have a table with several keys. When I try to delete anything from this table, I get data corruption and have to repair it with myisamchk. Selects, updates work fine. Here's the create table statement: CREATE TABLE `postsearch` ( `postId` int(11) NOT NULL default '0', `weblogId` int(11)

OPTIMIZE TABLE takes a very long time, can I kill it?

A few days ago, Dennis T Cook asked this list if it is OK to abort a OPTIMIZE that is taking a very long time. I am also wondering this. Will it cause any damage to the half-optimized table, adnd is there a right and a wrong way to stop this process? Any help appreciated! -Jim -- MySQL

Re: Backing up InnoDB MySQL DB

Victoria Reznichenko wrote: ColdFusion Lists [EMAIL PROTECTED] wrote: we're using MySQL 4.0.12 with InnoDB... please do you have any scripts, comments, suggestions, ideas, tutorials... about how to backup from that DB? It's possible to? You can use mysqldump utility that comes with MySQL

SHOW PROCESSLIST State Locked - what does this mean?

Hi, Currently, I have a situation where an app makes connections (via JDBC) to a mysql server, 50 connections at once, and everything just becomes super-slow. For instance, a SELECT that should take 0.01 sec takes several minutes. SHOW PROCESSLIST says that these threads that are connections

Copy a mysql user's permissions

Hi List, Is there a way to copy a user in the database's mysql database, so that it will have the same permissions (GRANTs) within the database? Or does one have to create a different user and then manually modify the permissions to match the first? Thanks, Jim -- MySQL General Mailing List

mysql slow server after crash

Hi List, Recently, a machine running an instance of mySQL crashed and had to be rebooted. Cause still unknown, but could have been RAID controller problem. Since then, the mySQL sserver has been extremely slow. For instance, a SELECT that would have taken 1 second can take 70 seconds.