So after I setup clearos i left it alone for a while. The other day I needed to add a new rule and it was taking forever to pull up the web interface. I decided to ssh in and after waiting a long time as well to get logged in i was finally able to check the memory usage to find out I had 70 mb remaining. Top showed that mysql was uing 99% of memory. After killing the process the memory usage went to about 1 gb.

Here is top about an hour after i started the system-mysqld service again.

Tasks: 147 total,   1 running, 146 sleeping,   0 stopped,   0 zombie

Cpu(s):  1.9%us,  1.3%sy,  0.1%ni,  9.7%id, 86.7%wa,  0.0%hi,  0.2%si,  0.0%st

Mem:   1913876k total,  1844620k used,    69256k free,     3804k buffers

Swap:  2031608k total,   640724k used,  1390884k free,   440272k cached



  PID USER      PR  NI  VIRT  RES  SHR S %CPU %MEM    TIME+  COMMAND

 8149 system-m  20   0 1716m 609m 4388 S  3.9 32.6   5:11.87 system-mysqld

This is free -m

             total       used       free     shared    buffers     cached

Mem:          1869       1802         66          0          3        430

-/+ buffers/cache:       1367        501

Swap:         1983        625       1358

Here are the list of mysql processes:

mysql> show processlist;

+-----+---------+-----------------+---------+---------+------+----------+------------------------------------------------------------------------------------------------------+

| Id  | User    | Host            | db      | Command | Time | State    | Info                                                                                                 |

+-----+---------+-----------------+---------+---------+------+----------+------------------------------------------------------------------------------------------------------+

|  72 | reports | localhost:55060 | reports | Query   |    7 | update   | INSERT INTO `network_detail_external` (stamp_updated, stamp_inserted, ip_dst, packets, bytes) VALUES |

|  73 | reports | localhost:55061 | reports | Query   |    4 | update   | INSERT INTO `network_detail_external` (stamp_updated, stamp_inserted, ip_src, packets, bytes) VALUES |

|  93 | reports | localhost:55081 | reports | Query   |    1 | Updating | UPDATE `network_detail_external` SET packets=packets+1, bytes=bytes+151, stamp_updated=NOW() WHERE F |

|  95 | reports | localhost:55083 | reports | Query   |    0 | update   | INSERT INTO `network_detail_external` (stamp_updated, stamp_inserted, ip_src, packets, bytes) VALUES |

| 105 | reports | localhost:55099 | reports | Query   |    0 | update   | INSERT INTO `network_detail_external` (stamp_updated, stamp_inserted, ip_dst, packets, bytes) VALUES |

| 106 | reports | localhost:55100 | reports | Query   |    1 | Updating | UPDATE `network_detail_external` SET packets=packets+1, bytes=bytes+53, stamp_updated=NOW() WHERE FR |

| 118 | reports | localhost:55121 | reports | Query   |    0 | Updating | UPDATE `network_detail_external` SET packets=packets+1, bytes=bytes+53, stamp_updated=NOW() WHERE FR |

| 120 | reports | localhost:55123 | reports | Query   |    1 | Updating | UPDATE `network_detail_external` SET packets=packets+1, bytes=bytes+151, stamp_updated=NOW() WHERE F |

| 129 | root    | localhost       | NULL    | Query   |    1 | NULL     | show processlist                                                                                     |

| 131 | reports | localhost:55138 | reports | Query   |    0 | Updating | UPDATE network_detail SET ip='???', hostname='192.168.1.148', username='', device_vendor='', device |

+-----+---------+-----------------+---------+---------+------+----------+------------------------------------------------------------------------------------------------------+

10 rows in set (0.72 sec)

System Details



Item            Value

Version         ClearOS Community release 6.5.0 (Final)

Kernel Version  2.6.32-431.17.1.v6.x86_64

System Time     Thu Jun 26 15:56:30 CDT 2014

CPU Model       Intel(R) Pentium(R) Dual CPU E2140 @ 1.60GHz

Memory Size     1.83 GB

Uptime          20 Days 20.4 Hours

Load            4.41 4.16 3.73

I ran into this issue over a month back, and went ahead and thew an extra gig of ram bringing it up to 2 gb, i would figure is plenty for a router.... i guess maybe not?

Any suggestions would be great.

Thanks!