Hi,
Have you tried changing the date format like
delete from TelecomAccountPosting where LocID=19014 and InvDate='2008-01-15';
I know it shouldn't matter but I have had similar issues due to the date
format.
Also are you sure there are 3773 records matching this criteria - according to
your t
On Tue, 2008-01-22 at 11:23 +1100, Chris wrote:
> > Why is it saying 'Impossible WHERE noticed after reading const tables'?
>
> http://dev.mysql.com/doc/refman/4.1/en/explain.html
> MySQL has read all const (and system) tables and notice that the WHERE
> clause is always false.
>
> ie - no rows
Daniel Kasak wrote:
Greetings.
I have a script which seems to be bringing our server to its knees.
I've isolated one query which is doing it:
delete from TelecomAccountPosting where LocID = 19014 and InvDate =
'20080115';
I have an index which covers both LocID and InvDate:
CREATE TABLE `Tel
You would need to find out the reason for the crash to prevent or minimize it.
The reason may be external to mysql.
Innodb can get really, really slow when tables get physically large if you
don't have a similar amount of RAM.
MyISAM doesn't support transactions, so no, that wouldn't help.
If y
Baba,
- Original Message -
From: "Baba Buehler" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Thursday, October 07, 2004 12:34 AM
Subject: corruption after database restore
I'm having a corruption problem after doing a backup and then a restore
with ibbackup (v1.40).
Afte
IL PROTECTED]
> Subject: Re: Corruption and my.cnf
>
>
> > I've experienced more corruption lately on my main site since I
> moved to my
> > own server running 4.0.17max. The site is very busy (60GB a
> month) and the
> > tables are large. I didn't have this
Mark,
- Original Message -
From: "Mark Susol|Ultimate Creative Media"
<[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Thursday, April 08, 2004 11:25 PM
Subject: Re: Corruption and my.cnf
> > I've experienced more corruption lately on my main s
> I've experienced more corruption lately on my main site since I moved to my
> own server running 4.0.17max. The site is very busy (60GB a month) and the
> tables are large. I didn't have this level of problems on the rental server.
>
> What are the variables to look into regarding why my tables
ith a signal
11 error code approximately every tenth minute.
Any words of the wise will be greatly appreciated.. :)
From:
Matt W
Date:
October 28 2003 2:59am
Subject:
Re: Corruption and
weird service
terminations
> For the corruption, upgrade to 4.0.16, since it may be caused by a
> corrup
Hi Mike,
For the corruption, upgrade to 4.0.16, since it may be caused by a
corruption bug in versions before 4.0.15.
Matt
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, October 27, 2003 12:07 PM
Subject: RE: Corruption and w
Hello Tommy!
> We suspect that the problem is related to the fact that we delete ~7000
> rows and inserts the same shortly thereafter. The mysql-manual mentions
> that you should run an "optimize table" after deleting many rows from a
> table, but doesn't list it as an requirement.
If you're hav
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of
> Martin Moss
> Sent: Wednesday 07 June 2000 16:03
> To: Perl-Win32-Users Mailing List; [EMAIL PROTECTED]
> Subject: Corruption of Database
>
>
> All,
>
> I have a problem with a mysql database.
>
On Monday 12 February 2001 16:57, Rodolfo Sikora wrote:
>mysql> select VERSION();
>+-+
>| VERSION() |
>+-+
>| 3.23.31-log |
>+-+
>1 row in set (0.00 sec)
>
>I swer I'm running 3.23.31 (with pgcc) but let's forget about
"Contratulation message", I think the er
mysql> select VERSION();
+-+
| VERSION() |
+-+
| 3.23.31-log |
+-+
1 row in set (0.00 sec)
I swer I'm running 3.23.31 (with pgcc) but let's forget about "Contratulation
message", I think the error is something related to master.info position.
Thanks for you
>This table is getting corrupted all the time (twice a week).
>We have only SELECTS and INSERTS with little updates. (we have 140.000
registers growing faster to 100 :))
>CREATE TABLE conta (
idConta int(8) unsigned NOT NULL auto_increment,
idDominio int(6) unsigned DEFAULT '0' NOT NUL
15 matches
Mail list logo