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]>
> 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]'
> *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]
> 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
