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]]
Sent: Monday, October 15, 2012 9:00 PM
To: [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]
https://lists.sourceforge.net/lists/listinfo/packetfence-users
