experiment. try The Cloud.
at this point, really looking at zillions of records, you should have close
to zero wait access times. everything is so ^%$^%&* fast these days. by the
time you finger comes off the keys, you should see your data.
186,00 miles/second. or something like that. :-)
O
On 04/26/2010 12:53 PM, Nicholas Hart wrote:
Hi,
I am troubleshooting problems with slow inserts with innodb. Anyone
have list of recommended config settings to reduce or eliminate these
delays?
When you insert in innodb, it will check foreign keys, and like any
insert it will update index
InnoDB makes use of row locking as it is transactional. If the row is
locked it will make it a little bit more interesting for inserts (last time
I checked the storage engine doesn't do table locks any more). Also not to
push this off into another thread/mail trail but I think
my...@lists.nyphp.o
Can you be more descriptive? Try wrapping your inserts inside a single
transaction. What's your innodb_buffer_pool_size set to? How much RAM do
you have? Are you sure you should be using InnoDB for what you're doing?
On Mon, 26 Apr 2010, Nicholas Hart wrote:
Hi,
I am troubleshooting prob
On Apr 26, 2010, at 12:53 PM, Nicholas Hart wrote:
> I am troubleshooting problems with slow inserts with innodb. Anyone have
> list of recommended config settings to reduce or eliminate these delays?
Try out the "mysqltuner.pl" perl script. It can give you some nice suggestions.
http://blog.my
Hi,
I am troubleshooting problems with slow inserts with innodb. Anyone have
list of recommended config settings to reduce or eliminate these delays?
Thanks,
Nick
On Mon, Apr 26, 2010 at 12:00 PM, wrote:
> Send talk mailing list submissions to
>talk@lists.nyphp.org
>
> To subscribe or
