I just changed back to the 'order by id LIMIT 5000' and I have not seen
further
corruption.
I also wanted to mention the other details about the system:
The system is running Linux 2.6.16.21-0.8-smp (SLES10)
mysql-5.0.18-20.5
And I do grant that we probably need to change the key cache.
mys
Odhiambo Washington <[EMAIL PROTECTED]> wrote:
>> > +--++--++
>> > | atmail.Users | repair | info | Key 1 - Found wrong stored record at 0 |
>> > | atmail.Users | repair | status | OK |
>>
On Wednesday 04 August 2004 06:44 am, Odhiambo Washington wrote:
> Is there hope for me in this situation??? I have googled and googled but
> all that I see doesn't seem to help me to recover the data in the table.
>
> This makes me very desparate.
>
> I'd be very thankful for any pointers that wo
* Egor Egorov <[EMAIL PROTECTED]> [20040804 16:24]: wrote:
> Odhiambo Washington <[EMAIL PROTECTED]> wrote:
>
> > +--++--++
> > | atmail.Users | repair | info | Key 1 - Found wrong stored record at 0 |
> > | atmail.Users | rep
Odhiambo Washington <[EMAIL PROTECTED]> wrote:
> +--++--++
> | atmail.Users | repair | info | Key 1 - Found wrong stored record at 0 |
> | atmail.Users | repair | status | OK |
> +
Hi!
On Nov 27, [EMAIL PROTECTED] wrote:
> >Description:
>
> The included sql test script (output of mysqldump 10.2 (create table
> statement and insertion of 250 records into this table) with added
> check for table integrity) results in corrupted table and error
> message 'Found key at pag
On Dec 01, 2003, at 18:00, Jared Klett wrote:
b.) Is there a proven way to backup MySQL databases that have to be up
and running 24/7/365?
Well, I don't know so much about a 'proven' way - but I use replication
on another server and it works pretty good for me. When i want to make
a static bac
[EMAIL PROTECTED] wrote:
>>Description:
>
> The included sql test script (output of mysqldump 10.2 (create table statement and
> insertion of 250 records into this table) with added check for table integrity)
> results in corrupted table and error message 'Found key at page 36864 that poi
Hi!
On Sep 09, [EMAIL PROTECTED] wrote:
>
> I'm using MySQL v4.0.12 on Redhat Linux 9.0
>
> I have a python script (using the MySQLdb module) that inserts a large
> batch of records to several MyISAM tables. The largest table (named
> 'log') has 20 columns. A single column defines the primary
On Tue, Sep 09, 2003 at 02:56:56PM -0700, [EMAIL PROTECTED] wrote:
>
> This seemed like an ideal case to DISABLE KEYS, insert the data and
> then ENABLE KEYS based on the MySQL documentation. And running some time
> tests proves that this approach runs much faster.
>
> However, in doing so, th
Hi!
> "Sinisa" == Sinisa Milivojevic <[EMAIL PROTECTED]> writes:
Sinisa> Fournier Jocelyn [Presence-PC] writes:
>> Hi,
>>
>> I noticed an annoying behaviour with MySQL 4.0.0.
>> I have 11 tables with a lot of rows (about 1 Million and more) which are constantly
>updated by a php script.
>
Fournier Jocelyn [Presence-PC] writes:
> Hi,
>
> I noticed an annoying behaviour with MySQL 4.0.0.
> I have 11 tables with a lot of rows (about 1 Million and more) which are constantly
>updated by a php script.
> It seems after a shutdown of mysql (mysqladmin -uroot -p shutdown) and a restart,
Do you 'refresh' your tables before each test ? If so, is it possible that
you're writing over the same disk space each time (which would point to a
drive surface problem). Is it possible that the larger runs of 'inserts'
are using more RAM than the smaller tests, and you're hitting a bad memo
Hi,
Thanks for the response !
> Howdy,
>
> On Tue, Jan 09, 2001 at 11:53:12AM +0800, [EMAIL PROTECTED] wrote:
> > I've got a linux server running MySQL 3.22.32 on kernel version
> > 2.4.0-test8.
>
> I'd be tentatively inclined to blame the problems on 2.4.0-test8. Do
> the problems still occur
Howdy,
On Tue, Jan 09, 2001 at 11:53:12AM +0800, [EMAIL PROTECTED] wrote:
> I've got a linux server running MySQL 3.22.32 on kernel version
> 2.4.0-test8.
I'd be tentatively inclined to blame the problems on 2.4.0-test8. Do
the problems still occur under (say) 2.2.18?
> The database server has
15 matches
Mail list logo
