title: Insert,delete,update lock mysqld service
body: <p>I have a problem with MySql database.</p>
  <p>The beginning of the problem occurs on a server with very high specifications 80 Core and 200 GB RAM ( Ubuntu with Please Server Management System).</p>
  <p>The details of the problem are as follows:</p>
  <ul>
  <li><p>We have a table with about 100,000 records,</p>
  </li>
  <li><p>In the normal situation, and when I have no pressure on the server, all operations are very normal.</p>
  </li>
  <li><p>But at times there are 4000 users on the server and we do any of the operations of insert, update, delete in particular, the Insert statement can take 2 cores from the CPU. And in these times when the server is on the move and there are users working online (we are talking about consuming 13% of the server’s capabilities.</p>
  </li>
  <li><p>But at this time, if you make an insert process, it reaches up to 700%, and sometimes after two insertions, for example,
  Hanging of the Mysqld Service happens, looks like Dead Lock, and is only resolved by restarting mysqld several times.</p>
  </li>
  <li><p>The table contains only 2 Indexes,</p>
  </li>
  <li><p>And the information stored in it is just plain info, like name, description, link and stuff like that.</p>
  </li>
  <li><p>Note that there is another table with approximately 3 million records, so this problem never becomes.</p>
  </li>
  </ul>
  <p>Of course, the problem is not from the code, because when I performed the process manually from within the data base, the problem appeared clearly.</p>
  <p>I do not know what are the reasons that could be the cause of the occurrence of such a problem.</p>
  <p>This is the my.cnf database configs:</p>
  <pre><code>#innodb_flush_log_at_trx_commit = 2
  
  #innodb_log_file_size = 250M
  #innodb_log_buffer_size = 10M
  #innodb_flush_log_at_trx_commit = 1
  #innodb_lock_wait_timeout = 50
  
  max_connections = 1000
  
  wait_timeout = 30
  #query_cache_size=64M
  
  #query_cache_limit=64M
  
  #tmp_table_size=400M
  key_buffer_size = 2G
  
  slow_query_log=1
  slow_query_log_file=/var/lib/mysql/slowquery.log
  long_query_time=5
  
  log_queries_not_using_indexes = ON
  
  </code></pre>