Search
 
SCRIPT & CODE EXAMPLE
 

SQL

InnoDB: page_cleaner: 1000ms intended loop took 7742ms. The settings might not be optimal

--
show variables like 'innodb_lru_scan_depth';
SET GLOBAL innodb_lru_scan_depth=512;

--
show variables like 'innodb_lock_wait_timeout';
set innodb_lock_wait_timeout=100;

--
show variables like 'innodb_flush_log_at_trx_commit';
SET GLOBAL innodb_flush_log_at_trx_commit=2;
Comment

PREVIOUS NEXT
Code Example
Sql :: how to get last row of table in sql 
Sql :: change varchar length mysql 
Sql :: postgresql datetrunc too slow 
Sql :: how to copy a table from one database to another in mysql 
Sql :: athena drop partition 
Sql :: postgresql select all column names 
Sql :: convert epoch to date in sql server 
Sql :: mysql loop insert 
Sql :: oracle wait 
Sql :: postgres extract number from string 
Sql :: how to give user privelege to create dblink in oracle 
Sql :: grab all records from one table to another oracle sql 
Sql :: oracle reset sequence 
Sql :: show structure of table in sql 
Sql :: hibernate dialect property xml for mysql 8 
Sql :: check database size in mysql 
Sql :: invalid reference to FROM-clause entry for table "unidades 
Sql :: sql beginning of previous month 
Sql :: sql remanecolumn 
Sql :: setVal pgsql 
Sql :: age postgres 
Sql :: sql random sampling per group 
Sql :: sql get table last modified time 
Sql :: remove password from root mysql 
Sql :: mysql modify default value 
Sql :: how to get table structure in sql server 
Sql :: mysql change data type of column 
Sql :: sql query length of string the longest 
Sql :: postgresql list columns 
Sql :: mysql one week ago 
ADD CONTENT
Topic
Content
Source link
Name
7+5 =