Performance degradation with InnoDB as compared to MyISAM

[Chirag Pandya]

We have a MySQL database where every second couple of tens of kilobytes to a couple 
hundred kilobytes of data is inserted into the database.  Note here that largest chunk 
of the data is consisted of a Blob.  This data (including the blob) is continuously 
queried by an application which displays it in a graphical format(waveform).

When the database size get to a few days i.e. about 10GB the performance slows down 
dramatically and InnoDB starts giving 995 error code on Windows2000 machine with 2GHz 
P4, 1GB RAM.  Size of each individual datafile is 3GB.  We donot have any complex 
database design and the SELECT queries are only on individual tables without any joins.

We had the database implemented using MyISAM but we switched to InnoDB and saw a huge 
performance decrease  This in terms of minutes when the database size is a few GBs 
and a couple of data files !!   What performance optimizations could be done to make 
the database more responsive and perform faster.


Thanks,
Chirag 





Sent via the WebMail system at mail.atcsoftware.us


 
   

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

strmov

[Chirag]

hi,

 Which header file or library i need to include for strmov ? i have
mysql v3 and i have included mysqlclient library. But it still tells
undefined reference.

Thanx in advance
Chirag


-
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

blob problem

[Chirag]

hi,

I want to insert binary structure into the mysql blob column.
I have a my own structure called MSG_STRUCT msg_struct;

Now i want to insert the whole structure (binary) into table having a column
of blob data type. I tried by

end = strmov(query,"INSERT INTO retry (msisdn, msg) values(");
*end++ = '\'';
end += mysql_real_escape_string(*sql, end,"91984503",11);
*end++ = '\'';
*end++ = ',';
*end++ = '\'';
end += mysql_real_escape_string(*sql, end, msg_struct, sizeof(msg_struct));
*end++ = '\'';
*end++ = ')';

I have mysql Ver 11.15 Distrib 3.23.41, for pc-linux-gnu (i686). I have
included the -lmysqlclient library but it says undefined reference for
strmov. What lib do i include for strmov ?

Also when the value is inserted into the blob fieldwhat will i see in
the table ? binary or hex value ? When i retrieve that field by select msg
from retry;.what format will i get the binary data ? Do i need to do any
conversion ?

Please guide me regarding inserting blob (binary) type and including strmov
function.

Thank you
Chirag



-
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