>
> Hi,
>
> I've got a couple a questions concerning the speed of insert queries when
> using the C API from MySQL. I've written an application that receives
> data through a CORBA event channel and stores it in a MySQL database. The
> problem is that a lot of events are dropped. I think (I'm quite sure
> actually) that the MySQL database is the bottleneck because it's a slow
> consumer. Now if I use a benchmark to check how many inserts the database
> can handle each second is will that result be about the same as the
> number of inserts the same database can handle using the C API? I guess
> not. Using a MySQL server on a machine with a 1000 mhz AMD processor I can
> insert 200 strings + timestamps a second through the API. Does that sound
> too less or am I expecting too much? Do benchmarks or test results for the
> C API exist? If someone has more experience on this or knows a place where
> I can find out more, plz let me know.
>
> Greetings,
> Raf
Hi Raf,
This might not help you much, but let me describe the config I have here.
A database server (PIII 800, 1 Gb RAM) running about a dozen database-aware
Perl sripts in the background constantly, with upto 20 CGI scripts all
accessing the same database.
5 machines on the network all accessing the same database, one machine has
a C application which every 5 minutes does a number of inserts into one
table as fast as it can. It has hit 1800 inserts per second at times, and
at other times has sunk as low as 400. The actual number of inserts depends
on the data processed, but it varies between 300ish and 10000.
All the tables are MYISAM, the one receiving the big inserts has 3 indexes
and usually about 5 million rows.
Response on the database server can be a bit iffy, the load average is about
3.5, but unless a number of instances of high-pressure CGI scripts get run
(which sometimes happens), the response isn't at all bad.
Hope this helps a little.
Regards,
Paul Wilson
iiNet Ltd
---------------------------------------------------------------------
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
