Hot answers tagged

2 votes

innodb_buffer_pool_size complications

You don't need to calculate the pool size. Set innodb_buffer_pool_size to the total RAM you want to allocate to the buffer pool. Let MySQL calculate the pool instances and chunk size. MySQL does this ...
Bill Karwin's user avatar
  • 13.9k
1 vote

MySQL query optimisation

To speed the query up a little bit you could add a where clause based on your comment Is "" always at the beginning of jid? Yes The jid column is already indexed and the following ...
Ergest Basha's user avatar
  • 3,780
1 vote

INSERTing millions of files into a table

Some notes: InnoDB's COMPRESSED gives about 50% shrinkage of disk space. gzip (and most other file-based tools) compress down to about 33%. So, it is better to shrink in the client instead of the ...
Rick James's user avatar
  • 76.9k
1 vote

INSERTing millions of files into a table

This is a lot of work to get all these files into the database. Question: What are you going to do with them once they're in there? If the answer is something like ... When X happens, I want to ...
Phill  W.'s user avatar
  • 8,259

Only top scored, non community-wiki answers of a minimum length are eligible