Welcome! Log In Create A New Profile

Advanced

Re: High Load mysql server

October 28, 2011 01:11PM
Кирюшкин Владимир Wrote:
-------------------------------------------------------
> Hello,
>
> > key_buffer_size = 1536M
>
> owh. i'd suggest you to try this tool:
> http://mysqltuner.pl/mysqltuner.pl
>
>
> Cheers,
>
> Vladimir
>

Thx for help, i was run that config but still load my CPU is high..
this is after installation :

-------- General Statistics --------------------------------------------------
[--] Skipped version check for MySQLTuner script
[OK] Currently running supported MySQL version 5.0.77
[OK] Operating on 64-bit architecture

-------- Storage Engine Statistics -------------------------------------------
[--] Status: -Archive +BDB -Federated -InnoDB -ISAM -NDBCluster
[--] Data in MyISAM tables: 3M (Tables: 6)
[!!] BDB is enabled but isn't being used
[!!] Total fragmented tables: 4

-------- Security Recommendations -------------------------------------------
[OK] All database users have passwords assigned

-------- Performance Metrics -------------------------------------------------
[--] Up for: 4h 9m 43s (5M q [378.161 qps], 1M conn, TX: 15B, RX: 259M)
[--] Reads / Writes: 85% / 15%
[--] Total buffers: 1.6G global + 5.0M per thread (500 max threads)
[!!] Maximum possible memory usage: 4.1G (543% of installed RAM)
[OK] Slow queries: 0% (0/5M)
[OK] Highest usage of available connections: 2% (12/500)
[OK] Key buffer size / total MyISAM indexes: 1.5G/945.0K
[OK] Key buffer hit rate: 99.8% (419K cached / 1K reads)
[OK] Query cache efficiency: 33.9% (667K cached / 1M selects)
[OK] Query cache prunes per day: 0
[OK] Sorts requiring temporary tables: 0% (0 temp sorts / 346K sorts)
[OK] Temporary tables created on disk: 0% (23 on disk / 5K total)
[OK] Thread cache hit rate: 99% (12 created / 1M connections)
[OK] Table cache hit rate: 39% (37 open / 94 opened)
[OK] Open file limit used: 0% (59/10K)
[OK] Table locks acquired immediately: 96% (1M immediate / 1M locks)

-------- Recommendations -----------------------------------------------------
General recommendations:
Add skip-bdb to MySQL configuration to disable BDB
Run OPTIMIZE TABLE to defragment tables for better performance
MySQL started within last 24 hours - recommendations may be inaccurate
Reduce your overall MySQL memory footprint for system stability
Enable the slow query log to troubleshoot bad queries

So, what i`ve must to do again.?
Subject Author Posted

High Load mysql server

MyName October 28, 2011 09:13AM

Re: High Load mysql server

Кирюшкин Владимир October 28, 2011 09:22AM

Re: High Load mysql server

MyName October 28, 2011 01:11PM

Re: High Load mysql server

Кирюшкин Владимир October 28, 2011 01:36PM

Re: High Load mysql server

Nginx User October 28, 2011 03:18PM

Re: High Load mysql server

Thinke365 October 29, 2011 02:00PM

Re: High Load mysql server

MyName October 29, 2011 02:03PM



Sorry, only registered users may post in this forum.

Click here to login

Online Users

Guests: 60
Record Number of Users: 6 on February 13, 2018
Record Number of Guests: 421 on December 02, 2018
Powered by nginx      Powered by FreeBSD      PHP Powered      Powered by MariaDB      ipv6 ready