Hi guys,
Yesterday I noticed my Database went from 280MB to 580MB. When I attempted to back the DB up, the CPU on the server went as high as 128%.
When I clicked on “Trace”, it looks like the SQL process was in a loop.
<br />
Process 8282 attached - interrupt to quit<br />
select(22, [20 21], NULL, NULL, NULL) = 1 (in [21])<br />
fcntl(21, F_SETFL, O_RDWR|O_NONBLOCK) = 0<br />
accept(21, {sa_family=AF_FILE, NULL}, [2]) = 37<br />
fcntl(21, F_SETFL, O_RDWR) = 0<br />
getsockname(37, {sa_family=AF_FILE, path="/var/lib/mysql\1"}, [28]) = 0<br />
fcntl(37, F_SETFL, O_RDONLY) = 0<br />
fcntl(37, F_GETFL) = 0x2 (flags O_RDWR)<br />
fcntl(37, F_SETFL, O_RDWR|O_NONBLOCK) = 0<br />
setsockopt(37, SOL_IP, IP_TOS, [8], 4) = -1 EOPNOTSUPP (Operation not supported)<br />
clone(child_stack=0x7fb456af8ff0, flags=CLONE_VM|CLONE_FS|CLONE_FILES|CLONE_SIGHAND|CLONE_THREAD|CLONE_SYSVSEM|CLONE_SETTLS|CLONE_PARENT_SETTID|CLONE_CHILD_CLEARTID, parent_tidptr=0x7fb456af99d0, tls=0x7fb456af9700, child_tidptr=0x7fb456af99d0) = 32353<br />
select(22, [20 21], NULL, NULL, NULL) = 1 (in [21])<br />
fcntl(21, F_SETFL, O_RDWR|O_NONBLOCK) = 0<br />
accept(21, {sa_family=AF_FILE, NULL}, [2]) = 37<br />
fcntl(21, F_SETFL, O_RDWR) = 0<br />
getsockname(37, {sa_family=AF_FILE, path="/var/lib/mysql\1"}, [28]) = 0<br />
fcntl(37, F_SETFL, O_RDONLY) = 0<br />
fcntl(37, F_GETFL) = 0x2 (flags O_RDWR)<br />
fcntl(37, F_SETFL, O_RDWR|O_NONBLOCK) = 0<br />
setsockopt(37, SOL_IP, IP_TOS, [8], 4) = -1 EOPNOTSUPP (Operation not supported)<br />
clone(child_stack=0x7fb456af8ff0, flags=CLONE_VM|CLONE_FS|CLONE_FILES|CLONE_SIGHAND|CLONE_THREAD|CLONE_SYSVSEM|CLONE_SETTLS|CLONE_PARENT_SETTID|CLONE_CHILD_CLEARTID, parent_tidptr=0x7fb456af99d0, tls=0x7fb456af9700, child_tidptr=0x7fb456af99d0) = 32355<br />
select(22, [20 21], NULL, NULL, NULL) = 1 (in [21])<br />
fcntl(21, F_SETFL, O_RDWR|O_NONBLOCK) = 0<br />
accept(21, {sa_family=AF_FILE, NULL}, [2]) = 37<br />
fcntl(21, F_SETFL, O_RDWR) = 0<br />
getsockname(37, {sa_family=AF_FILE, path="/var/lib/mysql\1"}, [28]) = 0<br />
fcntl(37, F_SETFL, O_RDONLY) = 0<br />
fcntl(37, F_GETFL) = 0x2 (flags O_RDWR)<br />
fcntl(37, F_SETFL, O_RDWR|O_NONBLOCK) = 0<br />
setsockopt(37, SOL_IP, IP_TOS, [8], 4) = -1 EOPNOTSUPP (Operation not supported)<br />
clone(child_stack=0x7fb456af8ff0, flags=CLONE_VM|CLONE_FS|CLONE_FILES|CLONE_SIGHAND|CLONE_THREAD|CLONE_SYSVSEM|CLONE_SETTLS|CLONE_PARENT_SETTID|CLONE_CHILD_CLEARTID, parent_tidptr=0x7fb456af99d0, tls=0x7fb456af9700, child_tidptr=0x7fb456af99d0) = 32357<br />
select(22, [20 21], NULL, NULL, NULL) = 1 (in [21])<br />
fcntl(21, F_SETFL, O_RDWR|O_NONBLOCK) = 0<br />
accept(21, {sa_family=AF_FILE, NULL}, [2]) = 37<br />
fcntl(21, F_SETFL, O_RDWR) = 0<br />
getsockname(37, {sa_family=AF_FILE, path="/var/lib/mysql\1"}, [28]) = 0<br />
fcntl(37, F_SETFL, O_RDONLY) = 0<br />
fcntl(37, F_GETFL) = 0x2 (flags O_RDWR)<br />
fcntl(37, F_SETFL, O_RDWR|O_NONBLOCK) = 0<br />
setsockopt(37, SOL_IP, IP_TOS, [8], 4) = -1 EOPNOTSUPP (Operation not supported)<br />
clone(child_stack=0x7fb456af8ff0, flags=CLONE_VM|CLONE_FS|CLONE_FILES|CLONE_SIGHAND|CLONE_THREAD|CLONE_SYSVSEM|CLONE_SETTLS|CLONE_PARENT_SETTID|CLONE_CHILD_CLEARTID, parent_tidptr=0x7fb456af99d0, tls=0x7fb456af9700, child_tidptr=0x7fb456af99d0) = 32359<br />
select(22, [20 21], NULL, NULL, NULL) = 1 (in [21])<br />
fcntl(21, F_SETFL, O_RDWR|O_NONBLOCK) = 0<br />
```<br />
<br />
That is just a small section, but it kept repeating that sequence.<br />
<br />
Any idea what is happening?<p><a href="127.0.0.1/uploads/monthly_03_2014/post-13823-0-36444000-1395844729.jpg">SQL-Error.jpg</a></p>