Menu
We are going to allow many users to access to a MySQL database. Each use has his/her own tables. We are going to set limitations on each user's CPU/memory usages. For instance, each use can't use more than 15% CPU and 512M memory. What are the best practice to achieve this goal?
Our operation system is Windows Server 2012. As much as we know, windows has the abilities to set CPU/memory usage limitation on the process level. However, all users share the same process in our scenario. Can we limit users' CPU/memory consumption by configuring MySQL?
511
Increases in CPU utilization can be caused by several factors, such as user-initiated heavy workloads, multiple concurrent queries, or long-running transactions. To identify the source of the CPU usage in your Amazon RDS for MySQL instance, review the following approaches: Enhanced Monitoring. Performance Insights.
If you are using MEMORY tables and variable max_heap_table_size is set very high, this can also take a large memory since max_heap_table_size system variable determines how large a table can grow, and there is no conversion to on-disk format.
First of all, there are 3 major cases when MySQL will crash due to running out of memory: MySQL tries to allocate more memory than available because we specifically told it to do so. For example: you did not set innodb_buffer_pool_size correctly. This is very easy to fix.
This is not exactly what you are (or were) looking for, but for MySQL 5.6 and 5.7 at least, there are ways to limit:
-The number of queries an account can issue per hour
-The number of updates an account can issue per hour
-The number of times an account can connect to the server per hour
-The number of simultaneous connections to the server by an account
See http://dev.mysql.com/doc/refman/5.7/en/user-resources.html for more info.
I can't seem to find a CPU/memory locked solution, but will update this post if I find one.
103
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
