…otherwise you can have a really large log file generated. Another thing… localhost [] # Thread_id: 1 Schema: test Last_errno: 0 Killed: 0 # Query_time: … cold MySQL instance, then it would require reading nearly 40 pages from …-query-digest. # Query 4: 0.12 QPS, 0.00x concurrency, ID 0xA766EE8F7AB39063…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
Comment: Should you have your swap file enabled while running MySQL ?
April 8, 2008 By 31 Comments
… swap out the tempfiles and service the requests, than crash MySQL, or lower max_connections and have to give a ‘max…, and equals about 48GB) , page size is 2MB .. /proc/sys/kernel/shmmax is 32GB, shmall is 42GB. errno 12, btw, is just “cannot allocate memory” If anyone has experience with large_pages like this, please email me…
Comment: Should you have your swap file enabled while running MySQL ?
April 6, 2008 By 31 Comments
….conf looks like this: mysql soft memlock unlimited mysql hard memlock unlimited My my.cnf looks like this: large-pages innodb_buffer_pool_size… allocate 4412407808 bytes. errno 12 InnoDB HugeTLB: Warning: Using conventional memory pool Even though when I ps aux |grep mysql, I can see…
