Dakado

  • Total activity 7
  • Last activity
  • Member since
  • Following 0 users
  • Followed by 0 users
  • Votes 0
  • Subscriptions 1

Activity overview

Latest activity by Dakado

  • Dakado commented,

    1. Community
    2. Miscellaneous
    3. Extreme MySQL CPU Usage

    I have solved the problem by adding keys to my tables to rows like "name" or "user". So it means rows WHERE I am selecting from table.

  • Dakado commented,

    1. Community
    2. Miscellaneous
    3. Extreme MySQL CPU Usage

    Sure, it analyses the statistics of MySQL and output the results with tips, read more info here:

  • Dakado commented,

    1. Community
    2. Miscellaneous
    3. Extreme MySQL CPU Usage

    What is the output of this script execution? wget https://launchpad.net/mysql-tuning-primer/trunk/1.6-r1/+download/tuning-primer.sh sh tuning-primer.sh Is this script safe ? I have a really rea...

  • Dakado commented,

    1. Community
    2. Miscellaneous
    3. Extreme MySQL CPU Usage

    Have you tried enabling slow queries. It will help you to track which database queries are eating up server resources and also try running "watch mysqladmin proc" command on server. This will help ...

  • Dakado commented,

    1. Community
    2. Miscellaneous
    3. Extreme MySQL CPU Usage

    There are about 1700-2000 active connections but I cannot really reduce it. 1 connection = 1 connected software and we got 1700 separated softwares running at the time. But I believe that there mu...

  • Dakado created a post,

    Extreme MySQL CPU Usage

    1. Community
    2. Miscellaneous

    Hello, We got MySQL DB under around 200 queries /sec in avarage. In rush hours the MySQL is consuming up to 500% of Intel Xeon E3-1246 v3 is that normal ? Also the entire DB takes 800 MB on the di...

    • Dakado
    • 4 followers
    • 10 comments
    • 0 votes