Wilson Hauck
  • Member for 4 years, 4 months
  • Last seen this week
  • Birmingham AL wlhauck@aol.com
Why does MySQLTuner show query_cache_size (=0)?
Accepted answer
8 votes

Version 8 will not have Query Cache available, they are suggesting avoiding this crutch for poorly performing or simply expensive queries. Suggestions for your my.cnf-ini [mysqld] section ...

View answer
Slow queries when switching from GoDaddy to AWS
2 votes

Your query - select * from driver_events where driverId = '923' and FROM_UNIXTIME(time, '%m-%d-%Y') = '12-18-2019' order by time desc limit 0,5; - does NOT NEED the quotes around the driverID. The ...

View answer
MySQL server sporadically runs rampage
2 votes

Rate Per Second=RPS - Suggestions to consider for your my.cnf [mysqld] section key_cache_age_threshold=7200 # from 300 seconds to reduce key_reads RPS of 150 max_connections=128 # from 500 because ...

View answer
MariaDB 10.2.14 (Got timeout reading communication packets)
2 votes

Suggestions to consider for your my.cnf-ini [mysqld] section Lead with # or REMOVE to allow defaults to work for you. . sort_buffer_size . read_buffer_size . read_rnd_buffer_size . thread_concurrency ...

View answer
MariaDB Optimization
Accepted answer
2 votes

Suggestions to consider for your my.cnf-ini [mysqld] section query_cache_type=0 # from 1 for NO Query Cache query_cache_size=0 # from 32M to avoid wasting RAM - only 1G available query_cache_limit=...

View answer
mysqld taking 800% CPU since traffic increased on my site, how to fix
2 votes

Suggestions to consider for your my.cnf-ini [mysqld] section with current information analyzed. key_cache_age_threshold=64800 # from 300 second discard, only to RD again innodb_lru_scan_depth=100 # ...

View answer
mysqld taking 800% CPU since traffic increased on my site, how to fix
2 votes

Suggestions to consider for your my.cfg-ini [mysqld] section max_connections=400 # from 2000 - max_used_connections was 109 in 2 hours thread_cache_size=100 # from autocalc CAP at 100 to avoid OOM &...

View answer
OOM killer shut down MySQL although ram usage seems low
1 votes

Suggestions for your my.cnf/ini, [mysqld] section key_buffer_size=64M # from 16M to support your ~ 14,000 MyISAM tables query_cache_size=0 # from 16M to conserve CPU and ...

View answer
High CPU usage by Apache/MySQL
1 votes

Rate Per Second = RPS Suggestions to consider for your my.cnf [mysqld] section innodb_buffer_pool_size=22G # from 128M to better accomodate your 262G of data max_connections=256 # from 151 since you ...

View answer
MariaDB taking up 100-200% CPU
Accepted answer
1 votes

in your .cnf within [mysqld] section max_connections = 300 # from 3500 until you get stabilized thread_cache_size = 100 # from -1 100 CAP is upper limit at this time key_buffer_size = 32M # from ...

View answer
Intermittent KVM performance issues causing performance glitches
1 votes

Rate Per Second = RPS Suggestions to consider for your my.cnf [mysqld] read_rnd_buffer_size=128K # from 256K to reduce handler_read_rnd_next RPS of 262756 innodb_lru_scan_depth=100 # from 1024 to ...

View answer
mysql connection is slow sometimes on localhost
1 votes

Suggestions to consider for your my.cnf [mysqld] section thread_cache_size=256 # from 32 for default with v 10.0.38 innodb_io_capacity=1900 # from 200 to enable higher IOPS to your SSD devices ...

View answer
Apache Tuning for 512GB RAM
Accepted answer
1 votes

Suggestion for your ulimit -a results, ulimit -n 24000 to enable more than current limit of 1024 Open Files The above is dynamic with Linux OS. Stop/Start services would have access to the ...

View answer
MariaDB 10.3 CPU usage, Server performance suggestions
Accepted answer
1 votes

Suggestions to consider for your my.cnf OR my.ini [mysqld] section (RPS = Rate Per Second) # 20180901 1346 from mysqlservertuning.com # log_error=/var/lib/mysql/2cd908c24352-error.log # from default ...

View answer
Mysql high cpu usage (over 600%)
1 votes

Suggestions for your my.cnf [mysqld] section changes. key_buffer_size=100M # from 1G for more reasonable RAM allocation thread_cache_size=100 # from 8 to reduce threads_created REMOVE THE leading #...

View answer
my.cnf MariaDB configuration - hitting the CPU ceiling even with the optimizations in place
Accepted answer
1 votes

Suggestions to consider for your my.cnf [mysqld] section Rate per Second = RPS thread_handling=pool-of-threads # from one-thread-per-connection for scalability max_heap_table_size=512M # from 16M ...

View answer
MySQL becomes very slow until restart
1 votes

For much immediate relief, after reviewing your reference manual, consider set global read_rnd_buffer_size=256K; # from 16M per connection This can be done dynamically. Login's after this is done ...

View answer
MySQL maximum possible memory usage above installed RAM
Accepted answer
1 votes

Additional reduction in memory footprint can be achieved by REMOVING from your my.cnf the following to allow defaults to serve your system. sort_buffer_size read_buffer_size read_rnd_buffer_size ...

View answer
SQL query much slower on new server (5.7.19), vs old (5.5.52)
1 votes

Your additions of sort_buffer_size, read_buffer_size, read_rnd_buffer_size need to be REMOVED. This will allow higher performance defaults to work for you. Consider adding join_buffer_size = 512K ...

View answer
Mysql - Got a packet bigger than 'max_allowed_packet' bytes) when importing
1 votes

At input line 5995 of your input you should find a line longer than 512M. Adjust your max_allowed_packet to cover it * 1.25 for a little breathing space.

View answer
join_buffer_size >= 4 M is not advised?
1 votes

JOINS without INDEXES should be resolved with analysis and appropriate index creation. Use mysqlcalculator.com with your join_buffer_size to see the effects on memory requirements. Should take less ...

View answer
Apache server freeze - Memory filling fast
1 votes

in your .cnf, thread_cache_size = 100 # you should CAP at 100, not 16384 remove next 6 lines to allow use of defaults until you have some practical experience mysqlcalculator.com is a valuable ...

View answer
Using MySQL raw disk on Windows?
0 votes

It appears you are not following this specific detail from the documentation listed. The //./ corresponds to the Windows syntax of \.\ for accessing physical drives. Windows has different syntax than ...

View answer
How to validate mariadb/mysqld configuration options while it is running
0 votes

For version 8, this is from the manual, see this URL https://dev.mysql.com/doc/refman/8.0/en/server-configuration-validation.html

View answer
How can I optimize the memory usage of mysql server on ubuntu?
Accepted answer
0 votes

You may want to reconsider this situation reported in your error log - Jul 20 10:40:55 ITMI-PHSE-MYSQL kernel: [597449.195596] Free swap = 0kB Jul 20 10:40:55 ITMI-PHSE-MYSQL kernel: [597449.195597] ...

View answer
MySQL takes up totall installed memory of 16GB in 24 hours lie period
Accepted answer
0 votes

Rate Per Second = RPS Suggestions to consider for your my.cnf [mysqld] section thread_cache_size=100 # from 12 to reduce overhead of threads_created 18,140 in 4 days innodb_io_capacity=1900 # from ...

View answer
How to find out the mySQL query which uses most of the CPU using performance_sc
0 votes

SHOW FULL PROCESSLIST; might be more useful if the process is still running. The complete query would be listed.

View answer
product import is broke behind cloudflare
Accepted answer
0 votes

Rate Per Second = RPS Suggestions to consider for your Google Cloud database flags, log_slow_verbosity=query_plan,explain # from query_plan for a more useful slow log read_rnd_buffer_size=128K # ...

View answer
AWS RDS MySQL performance issues
0 votes

Rate Per Second = RPS Suggestions to consider for your staging server AWS RDS Parameters group [mysqld] section innodb_change_buffer_max_size=2 # from 25 (percent) set aside from buffer pool. ...

View answer
Slow queries when switching from GoDaddy to AWS
0 votes

Rate Per Second = RPS Suggestions to consider for your AWS Aurora Parameters group thread_cache_size=32 # from 2 to reduce threads_created innodb_lru_scan_depth=100 # from 1024 to conserve 90% of ...

View answer