1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

Data Transfer Statistics

Discussion in 'Plesk 10.x for Linux Suggestions and Feedback' started by kram@, Jan 8, 2012.

  1. kram@

    kram@ Regular Pleskian

    26
    40%
    Joined:
    Dec 11, 2003
    Messages:
    152
    Likes Received:
    2
    Location:
    South Africa
    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?
     
  2. kram@

    kram@ Regular Pleskian

    26
    40%
    Joined:
    Dec 11, 2003
    Messages:
    152
    Likes Received:
    2
    Location:
    South Africa
    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.
     
    Last edited: Jan 10, 2012
  3. burnleyvic

    burnleyvic Regular Pleskian

    17
    85%
    Joined:
    Nov 9, 2011
    Messages:
    174
    Likes Received:
    1
    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.
     
    Last edited: Jun 6, 2012
  4. burnleyvic

    burnleyvic Regular Pleskian

    17
    85%
    Joined:
    Nov 9, 2011
    Messages:
    174
    Likes Received:
    1
    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.
     
  5. IgorG

    IgorG Forums Analyst Staff Member

    49
    24%
    Joined:
    Oct 27, 2009
    Messages:
    24,576
    Likes Received:
    1,243
    Location:
    Novosibirsk, Russia
    Yes, just increase the 'wait_timeout' in '/etc/my.cnf' and restart mysql.
     
  6. burnleyvic

    burnleyvic Regular Pleskian

    17
    85%
    Joined:
    Nov 9, 2011
    Messages:
    174
    Likes Received:
    1
    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.
     
  7. burnleyvic

    burnleyvic Regular Pleskian

    17
    85%
    Joined:
    Nov 9, 2011
    Messages:
    174
    Likes Received:
    1
    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?
     
  8. IgorG

    IgorG Forums Analyst Staff Member

    49
    24%
    Joined:
    Oct 27, 2009
    Messages:
    24,576
    Likes Received:
    1,243
    Location:
    Novosibirsk, Russia
    wait_timeout was 20000 here forum.parallels.com/showthread.php?t=208854&page=5 and it was successful.
     
  9. burnleyvic

    burnleyvic Regular Pleskian

    17
    85%
    Joined:
    Nov 9, 2011
    Messages:
    174
    Likes Received:
    1
    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.
     
  10. burnleyvic

    burnleyvic Regular Pleskian

    17
    85%
    Joined:
    Nov 9, 2011
    Messages:
    174
    Likes Received:
    1
    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.
     
Loading...