My SQL Fine Tuning & Administration

Our engineers take various critical measures to ensure healthy database environment; from improving performance of your database to avoiding disaster that would result in lost data and/or costly system downtime.

Installing SQL with default settings is half of the task, other half is to administer and fine tune it. We offer following services in this zone:

MySQL Administration

  • Optimize server for performance which includes space management, memory usage monitoring and problem diagnosis.
  • Administer server on daily basis to ensure server availability and the ongoing health of the system.
  • Disaster prevention and recovery that includes creating consistent backups, restoring databases in case of network, application or hardware failure.

MySQL Fine Tuning

Even though we can tune quite a lot of variables, only few of them are really important for common workload. Common variables we tune are:

  • key_buffer_size
  • innodb_buffer_pool_size
  • innodb_additional_mem_pool_size
  • innodb_log_file_size
  • innodb_flush_log_at_trx_commit
  • table_cache
  • thread_cache
  • query_cache_size

Contact us now to hire a network engineer to administer and fine tune My SQL.

# #