MySql Process taking too much ram
/usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/lib/mysql/wind.foxnapdns.com.err --open-files-limit=50000 --pid-file=/var/lib/mysql/servername.com.pid this process taking highest cpu
i have running mysqltunner . its given me some recommendation.
-------- Recommendations ---------------------------------------------------------------------------
General recommendations:
3 user(s) used basic or weak password.
MySQL started within last 24 hours - recommendations may be inaccurate
Configure your accounts with ip or subnets only, then update your configuration with skip-name-resolve=1
When making adjustments, make tmp_table_size/max_heap_table_size equal
Reduce your SELECT DISTINCT queries which have no LIMIT clause
Set thread_cache_size to 4 as a starting value
Performance should be activated for better diagnostics
Consider installing Sys schema from GitHub - mysql/mysql-sys: The MySQL sys schema
Variables to adjust:
query_cache_size (=0)
query_cache_type (=0)
query_cache_limit (> 1M, or use smaller result sets)
tmp_table_size (> 16M)
max_heap_table_size (> 16M)
thread_cache_size (start at 4)
performance_schema = ON enable PFS
innodb_log_file_size should be (=16M) if possible, so InnoDB total log files size equals to 25% of buffer pool size.
innodb_buffer_pool_instances (=1)
can any one tell me what should i add into my my.cnf and what things to do.
-
Hello, Advice about tuning specific configuration values typically requires the help of a qualified system administrator. I'll leave this thread open for additional user-feedback, but I did want to note the "mysqladmin processlist" command is helpful if you are noticing bad MySQL performance. The command can help determine if any specific databases are responsible for the poor performance. You can also find a list of companies offering system administration services if you do not receive sufficient user-feedback to this thread: System Administration Services | cPanel Forums Thank you. 0
Please sign in to leave a comment.
Comments
1 comment