sometimes ont he top by mem looks like this:
just for few seconds pfsetvlan uses really much mem
18046 root 15 0 3056m 2.1g 3276 S 2.7 53.3 0:11.70 pfsetvlan
3596 mysql 15 0 1822m 578m 4512 S 1.3 14.6 10:21.95 mysqld
18047 root 16 0 181m 32m 2860 S 0.7 0.8 0:08.04 pfdhcplistener
17993 pf 15 0 1199m 242m 3148 S 0.3 6.1 0:11.71 radiusd
18043 root 16 0 181m 32m 2856 S 0.3 0.8 0:07.84 pfdhcplistener
From: Balla Tamás [mailto:[email protected]]
Sent: Monday, October 15, 2012 10:04 PM
To: Ilja Kravchenko
Cc: [email protected]
Subject: Re: [PacketFence-users] RAM usage problem
[root@NAC-1 ~]# du -sh /var/lib/mysql
609M /var/lib/mysql
From: Ilja Kravchenko [mailto:[email protected]]
Sent: Monday, October 15, 2012 9:45 PM
To: Balla Tamás
Subject: Re: [PacketFence-users] RAM usage problem
Hi,
56Mb of free it is extremely low!!!
Seem the system kills process of mysql in order to avoid system crash.
Show please du -sh /var/lib/mysql and do you have backups?
2012/10/15 Balla Tamás
<[email protected]<mailto:[email protected]>>
Hello,
logs shows nothing important mostly dhcp server events, not apperars on same
time yesterday about 11 pm today about 9 am and 5 pm.
But you might be right, becouse, when pf running
free -m
total used free shared buffers cached
Mem: 3948 3892 56 0 39 539
-/+ buffers/cache: 3312 635
Swap: 1023 623 400
when mysql running pf stopped:
free -m
total used free shared buffers cached
Mem: 3948 1239 2709 0 40 538
-/+ buffers/cache: 659 3288
Swap: 1023 267 756
From: Ilja Kravchenko
[mailto:[email protected]<mailto:[email protected]>]
Sent: Monday, October 15, 2012 9:00 PM
To:
[email protected]<mailto:[email protected]>
Subject: Re: [PacketFence-users] RAM usage problem
Hello Tamás,
could you provide us the last log of the mysql and /var/log/messages or
/var/log/syslog file log. The issue may be not in the mysql.
This issue appears always in the same time and what the LA of the server?
2012/10/15 Balla Tamás
<[email protected]<mailto:[email protected]>>
Hy!
I am usig radius accounting as well.
Is it normal, that radacct and radacct_log tables are really large:
mysql> SHOW TABLE STATUS LIKE 'radacct';
+---------+--------+---------+------------+--------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-------------------+----------+----------------+------------------------+
| Name | Engine | Version | Row_format | Rows | Avg_row_length |
Data_length | Max_data_length | Index_length | Data_free | Auto_increment |
Create_time | Update_time | Check_time | Collation | Checksum |
Create_options | Comment |
+---------+--------+---------+------------+--------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-------------------+----------+----------------+------------------------+
| radacct | InnoDB | 10 | Compact | 172649 | 246 |
42549248 | 0 | 68861952 | 0 | 172833 |
2012-10-15 20:38:07 | NULL | NULL | latin1_swedish_ci | NULL |
| InnoDB free: 205824 kB |
+---------+--------+---------+------------+--------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-------------------+----------+----------------+------------------------+
1 row in set (0.01 sec)
mysql> SHOW TABLE STATUS LIKE 'radacct_log';
+-------------+--------+---------+------------+--------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-------------------+----------+----------------+------------------------+
| Name | Engine | Version | Row_format | Rows | Avg_row_length |
Data_length | Max_data_length | Index_length | Data_free | Auto_increment |
Create_time | Update_time | Check_time | Collation | Checksum |
Create_options | Comment |
+-------------+--------+---------+------------+--------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-------------------+----------+----------------+------------------------+
| radacct_log | InnoDB | 10 | Compact | 819745 | 108 |
88719360 | 0 | 116736000 | 0 | NULL |
2012-10-15 20:39:35 | NULL | NULL | latin1_swedish_ci | NULL |
| InnoDB free: 205824 kB |
+-------------+--------+---------+------------+--------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-------------------+----------+----------------+------------------------+
Regards
Tamas
From: Balla Tamás
Sent: Monday, October 15, 2012 7:12 PM
To:
'[email protected]<mailto:[email protected]>'
Subject: RAM usage problem
Hy all!
I am using packetfence for 1 year.
Yesterday i had a strange problem Mysql unexpectedly stopped.
When i restarted the mysql service, packetfence started to working again.
Today it happened again, it looks like pf eats the memory on the server.
I am using mab with 3000 hosts.
On vmware, 4Gigs of ram and 4 vcpu.
pf version: 3.5.1
What can cause the problem?
Regards,
Tamas
------------------------------------------------------------------------------
Don't let slow site performance ruin your business. Deploy New Relic APM
Deploy New Relic app performance management and know exactly
what is happening inside your Ruby, Python, PHP, Java, and .NET app
Try New Relic at no cost today and get our sweet Data Nerd shirt too!
http://p.sf.net/sfu/newrelic-dev2dev
_______________________________________________
PacketFence-users mailing list
[email protected]<mailto:[email protected]>
https://lists.sourceforge.net/lists/listinfo/packetfence-users
------------------------------------------------------------------------------
Don't let slow site performance ruin your business. Deploy New Relic APM
Deploy New Relic app performance management and know exactly
what is happening inside your Ruby, Python, PHP, Java, and .NET app
Try New Relic at no cost today and get our sweet Data Nerd shirt too!
http://p.sf.net/sfu/newrelic-dev2dev
_______________________________________________
PacketFence-users mailing list
[email protected]<mailto:[email protected]>
https://lists.sourceforge.net/lists/listinfo/packetfence-users
------------------------------------------------------------------------------
Don't let slow site performance ruin your business. Deploy New Relic APM
Deploy New Relic app performance management and know exactly
what is happening inside your Ruby, Python, PHP, Java, and .NET app
Try New Relic at no cost today and get our sweet Data Nerd shirt too!
http://p.sf.net/sfu/newrelic-dev2dev
_______________________________________________
PacketFence-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/packetfence-users
