Mysql use all cores

nisamudeen97

• June 25, 2016 14:24

Hi, I am currently setting up a website that uses a mysql database having more than 4 crore rows of data. I am using one server for files and separate mysql server. Two servers are having 20 core, 64 gb ram. Meanwhile I could see while executing longest mysql queries my mysql server is using two cores maximum hence it is taking more than 38 seconds to execute my longest query. see the result below. # User@Host: dev_data @ localhost [] # Query_time: 38.113460 Lock_time: 0.000514 Rows_sent: 10 Rows_examined: 48683733 How can i configure my mysql server so that it uses all the 20 cores to handle the mysql ? How can I achieve this ? Mysql version using 5.6

• 

  cPanelMichael

  • June 27, 2016 17:34

  Hello, Yes, as mentioned, you can start by using a MySQL tuner, like the one referenced in the following thread: mysqlmymonlite.sh server stats gathering tool for cPanel Server Thank you.

  0

Please sign in to leave a comment.