Timeline for Queries getting stuck on very simple COUNT queries
Current License: CC BY-SA 3.0
11 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Apr 22, 2021 at 19:17 | history | edited | RolandoMySQLDBA |
edited tags
|
|
| May 10, 2013 at 0:40 | review | Close votes | |||
| May 12, 2013 at 11:25 | |||||
| Jan 10, 2013 at 13:53 | comment | added | virulence |
Rolando, server is FreeBSD, and the db is in a jail so bare metal. numactl doesn't exist. Result of that command is 45347913728 (data_length 20529397760 index_length 24818515968)
|
|
| Jan 10, 2013 at 12:56 | comment | added | RolandoMySQLDBA |
4) Please run SELECT SUM(data_length+index_length) FROM information_schema.tables WHERE engine='InnoDB'; , 5) Is the DB Server VM or Bare-Metal? 6) Please run numactl --hardware
|
|
| Jan 10, 2013 at 4:02 | comment | added | virulence | Rolando, 1. 4 (8 logical), 2. 32 GB (using about half ish for MySQL for now), 3. Correct, Percona 5.5.27-28.1 | |
| Jan 10, 2013 at 3:45 | comment | added | RolandoMySQLDBA | 1) How many cores do you have ??? 2) How much RAM do you have installed ??? 3) You are running Percona Server, aren't you ??? | |
| Jan 9, 2013 at 22:50 | history | edited | virulence | CC BY-SA 3.0 |
selects not updates
|
| Dec 31, 2012 at 18:41 | answer | added | RolandoMySQLDBA | timeline score: 1 | |
| Dec 31, 2012 at 17:50 | comment | added | ypercubeᵀᴹ |
Can you run SHOW ENGINE INNODB STATUS; and add the output in the question?
|
|
| Dec 31, 2012 at 17:25 | review | First posts | |||
| Dec 31, 2012 at 17:44 | |||||
| Dec 31, 2012 at 17:05 | history | asked | virulence | CC BY-SA 3.0 |