Stanislav,
how big is the insert and update load to your table?
One user of InnoDB says that it copes with his average
load of 800 inserts/updates per second. The computer
has 4 processors.
Since InnoDB has the non-locking consistent read,
SELECT queries do not stop inserts or updates to your table.
When you delete data from the big table, it may be best
to do it in smaller batches. Because of multiversioning
InnoDB cannot internally use DROP TABLE if you issue
a full delete: DELETE FROM yourtablename.
In simple join queries InnoDB is the fastests disk-based database
backend in the world, at least I have not measured bigger
numbers for any other disk-based database. A main memory
database Polyhedra got about the same numbers for small
join queries and somewhat less on bigger.
See www.innodb.com/bench.html for benchmarks.
In inserts and updates InnoDB is about as fast as MyISAM.
In them most of the CPU time goes to Perl (if you use Perl)
and client-server communication.
About stability: the best reference is the page
http://www.innodb.com/bugfixes.html
and the mailing lists of MySQL. A problem is that people
do not write to the mailing list when it works ok.
Regards,
Heikki
Innobase Oy
Copied message:
.................
G'day,
I have a question about using InnoDB format of tables with MySQL.
We have a following problem:
our application collects data into MySQL database during some period of time
(say 1 hour) and then we need to analyze these data then move insert results
of analysis into other table within same db and then clean first table.
The problem is, what during analysis (it takes 30-40 secs) we have a lot of
pending queries (due to lock on target table) and then all these pending
queries start to execute the system load becomes to high.
Can it be faster if we will switch to using InnoDB tables instead of MyISAM?
How stable is InnoDB implementation in MySQL ?
And more important, how fast is it ?
With best regards,
Stanislav Dmitrenko
---------------------------------------------------------------------
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 <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
