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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
