Hi Raj, Ananda, the schema is very simple, we don't have any blob or text
column.
I thought the same about the log files, so I tried with diferent sizes but
nothing change.
This is the output of iostat -x 1 when the performance is slow running a
restore
avg-cpu: %user %nice %system %iowait %
How big is your /tmp folder, can u move this to other fast moving disk.
On Fri, Mar 19, 2010 at 4:27 AM, Raj Shekhar wrote:
> Max Bube gmail.com> writes:
>
>
> > The problem starts when I run bulk writes like an alter table or a
> restore
> > from mysqldump, its starts processing more than 5000
Max Bube gmail.com> writes:
> The problem starts when I run bulk writes like an alter table or a restore
> from mysqldump, its starts processing more than 5 rows/s but suddenly
> the ratio goes down to 100 rows /sec. and then its stucked at this ratio
> even if I restart MySQL. The only way
This is an output from console when its performnace goes dows
Query OK, 65469 rows affected (0.82 sec)
Records: 65469 Duplicates: 0 Warnings: 0
Query OK, 65469 rows affected (0.78 sec)
Records: 65469 Duplicates: 0 Warnings: 0
Query OK, 65469 rows affected (10 min 57.30 sec)
Records: 65469 D
when the writes are happening, please run "show full processlist" and let us
know the out put.
regards
anandkl
On Thu, Mar 18, 2010 at 9:09 PM, Max Bube wrote:
> Hi list,
>
> Im having problems with bulk writes (restores from mysqldumps, alters,
> delete in (select ...)) with innodb. The server
