On 3/24/2015 12:57 PM, Robert Heinzmann wrote:
> One more question for clarification:
>
> Attribute spooling only solves "insert and update issues" and not select 
> issues right ?
>
> Our monitoring shows that we only have 10 -20 inserts/s for the DB but the 
> selects are capped at ~370 selects/second during peak times.

Look into enabling innodb_file_per_table setting. InnoDB uses 4 threads 
as i/o threads in addition to the connection manager thread and one 
thread per connection. Each table in a separate file means that indices 
on those tables are also separated and may allow for more parallel i/o. 
But still, attribute spooling is needed to optimize DB transactions.


------------------------------------------------------------------------------
Dive into the World of Parallel Programming The Go Parallel Website, sponsored
by Intel and developed in partnership with Slashdot Media, is your hub for all
things parallel software development, from weekly thought leadership blogs to
news, videos, case studies, tutorials and more. Take a look and join the 
conversation now. http://goparallel.sourceforge.net/
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users