CCCi is an IT Staffing Leader in Service, Value, and Positive Impact! It’s our people, people like you, that make IT work! Our clients need your expertise! If you are looking for a new opportunity now or in the future, I would appreciate the opportunity to connect with you.
We have an outstanding opportunities right now for your expertise! Would it make sense for us to spend several minutes discussing your priorities for your next project or career step and how CCCi and our clients can meet them? I would appreciate the opportunity to discuss them with you.Read more
Recommendations and Best Practices for making MySQL DB changes per tuning-primer.sh and mysql slow table log.
I am running tuning-primer.sh and mysqltuner.pl
Run OPTIMIZE TABLE to defragment tables for better performance
Adjust your join queries to always utilize indexes
When making adjustments, make tmp_table_size/max_heap_table_size equal
Reduce your SELECT DISTINCT queries without LIMIT clauses
Increase table_cache gradually to avoid file descriptor limits
Variables to adjust:
join_buffer_size (> 128.0K, or always use indexes with joins)
tmp_table_size (> 50M)
max_heap_table_size (> 50M)