Data Transfer Statistics

[kram@]

Hello All,

Just noticed that in 10.4.4 MU#10 there are no Data Transfer Statistics.
Had a couple of test domains running during December, all stats are 0 and in the dropdown there is only an option for Jan 2012 which also only shows 0

Anybody seeying similar results?

 

[kram@]

Update

After running:

/usr/local/psa/admin/sbin/statistics

I found the following error:

MySQL query failed: MySQL server has gone away

To resolve this I changed the #Timeouts in /etc/my.cnf

I then re-ran /usr/local/psa/admin/sbin/statistics

/usr/local/psa/admin/sbin/statistics

WARNING during statistics_collector execution: : error: error accessing /usr/share/tomcat6/logs: No such file or directory error: tomcat:2 glob failed for /usr/share/tomcat6/logs/*.log

Stats are now visible in the panel.

 

[burnleyvic]

We're now seeing the same problem on 10.4.4 Update #27 for CentOS 6 x86_64. "Data transferred this month:" displays 0 bytes for the last 2 months. I'm now running /usr/local/psa/admin/sbin/statistics manually, I'll get back with more info.

 

[burnleyvic]

So far:

time /usr/local/psa/admin/sbin/statistics
MySQL query failed: MySQL server has gone away

real 34m29.250s
user 23m46.958s
sys 4m31.685s

In mysqld.log I have:
120607 9:48:23 [Warning] Aborted connection 442331 to db: 'psa' user: 'admin' host: 'localhost' (Got timeout reading communication packets)
120607 9:48:23 [Warning] Aborted connection 442330 to db: 'psa' user: 'admin' host: 'localhost' (Got timeout reading communication packets)

I'll try to see if adjusting the SQL timeouts fixed the problem.

 

[IgorG]

I'll try to see if adjusting the SQL timeouts fixed the problem.

Yes, just increase the 'wait_timeout' in '/etc/my.cnf' and restart mysql.

 

[burnleyvic]

Igor, didn't help yet. This is what I have now in MySQL:
mysql> show variables like '%timeout%';
+----------------------------+----------+
| Variable_name | Value |
+----------------------------+----------+
| connect_timeout | 180 |
| delayed_insert_timeout | 300 |
| innodb_lock_wait_timeout | 50 |
| innodb_rollback_on_timeout | OFF |
| interactive_timeout | 1800 |
| lock_wait_timeout | 31536000 |
| net_read_timeout | 180 |
| net_write_timeout | 120 |
| slave_net_timeout | 3600 |
| wait_timeout | 1800 |
+----------------------------+----------+
10 rows in set (0.00 sec)

Same result, except the script ran for one more minute:

time /usr/local/psa/admin/sbin/statistics
MySQL query failed: MySQL server has gone away

real 35m33.818s
user 24m18.955s
sys 4m36.841s

I've enabled slow query logging and now I'm re-running it.

 

[burnleyvic]

Nothing in the slow query log! Then I raised MySQL timeouts even more:
connect_timeout=600
net_read_timeout=600
net_write_timeout=120


# time /usr/local/psa/admin/sbin/statistics
MySQL query failed: MySQL server has gone away

real 31m43.114s
user 23m10.890s
sys 4m24.857s

Same 'Aborted connection' log message type in mysqld.log, where else can I look?

 

[IgorG]

wait_timeout was 20000 here forum.parallels.com/showthread.php?t=208854&page=5 and it was successful.

 

[burnleyvic]

Thanks Igor. Now testing with:
show variables like '%timeout%';
+----------------------------+----------+
| Variable_name | Value |
+----------------------------+----------+
| connect_timeout | 600 |
| delayed_insert_timeout | 300 |
| innodb_lock_wait_timeout | 50 |
| innodb_rollback_on_timeout | OFF |
| interactive_timeout | 28800 |
| lock_wait_timeout | 31536000 |
| net_read_timeout | 600 |
| net_write_timeout | 120 |
| slave_net_timeout | 3600 |
| wait_timeout | 28800 |
+----------------------------+----------+

Will come back with the result.

 

[burnleyvic]

Fixed!

# time /usr/local/psa/admin/sbin/statistics



WARNING during statistics_collector execution: : error: error accessing /usr/share/tomcat6/logs: No such file or directory
error: tomcat:2 glob failed for /usr/share/tomcat6/logs/*.log


real 34m17.654s
user 24m4.215s
sys 4m32.129s

Now data transfer stats are being displayed again. Thanks.