I have moved the test database server from Windows to Synology. The size of the database is 5.5 GB and the innodb_buffer_pool_size = 6G. This Synology server is a dedicated database server.

After this change, end users are facing a performance issue in a web application.

  • What are the queries causing problems? Do you have any metrics running on the Synology server - iostat for example? Do Synology provide any monitoring tools with their system? It's based on FreeBSD, so you should have (with any db server) tools up and running all the time! How did you monitor your Windows setup? – Vérace May 23 at 18:59

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.