an
groups-icon

Hostgator problem long loading pages

Forum Home / Directory Theme
Wait a minute... This content is very very old. We no longer sell or support this theme version. New Topics
  • Version 9
    user
    William Tuttle
    0 points
    Beginner

    Does anyone know what is causing this problem. I have continued to get SQL restriction related to cpu over usage and receive the message below. Any thoughts or help would be great!

    CPU_TIME:1653 table_rows_read:23464814 SELECTS:1177 ROWS_UPDATED:5 ROWS_FETCHED:67036 BUSY_TIME:7246 ONNECTED_TIME:7277 BYTES_SENT:4842206 BYTES_RECEIVED:205576 WAIT_TIME:5593

    Top table row reads:
    DB_USER: bnpcom_rdp — TOTAL_CONNECTIONS: 18 — CONNECTED_TIME: 7401 — CPU_TIME: 1681 — TABLE_ROW_READS: 23799432 — SELECT_COMMANDS: 1146 — UPDATE_COMMANDS: — BUSY_TIME: 7373 — BYTES_SENT: 4194304 — BYTES_RECEIVED: 201647 — WAIT_TIME (IO): 5692
    DB_USER: bnpcom_bes11 — TOTAL_CONNECTIONS: 1 — CONNECTED_TIME: 5 — CPU_TIME: 0 — TABLE_ROW_READS: 31010 — SELECT_COMMANDS: 42 — UPDATE_COMMANDS: — BUSY_TIME: 2 — BYTES_SENT: 647902 — BYTES_RECEIVED: 5928 — WAIT_TIME (IO): 2

    Top WAIT (IO) TIME:
    DB_USER: bnpcom_rdp — TOTAL_CONNECTIONS: 18 — CONNECTED_TIME: 7401 — CPU_TIME: 1681 — TABLE_ROW_READS: 23799432 — SELECT_COMMANDS: 1146 — UPDATE_COMMANDS: — BUSY_TIME: 7373 — BYTES_SENT: 4194304 — BYTES_RECEIVED: 201647 — WAIT_TIME (IO): 5692
    DB_USER: bnpcom_bes11 — TOTAL_CONNECTIONS: 1 — CONNECTED_TIME: 5 — CPU_TIME: 0 — TABLE_ROW_READS: 31010 — SELECT_COMMANDS: 42 — UPDATE_COMMANDS: — BUSY_TIME: 2 — BYTES_SENT: 647902 — BYTES_RECEIVED: 5928 — WAIT_TIME (IO): 2

    bnpcom 1535 0.2 0.0 340104 61644 ? SN 10:19 0:00 /opt/php52/bin/php-cgi /home3/bnpcom/public_html/directory/index.php
    bnpcom 1827 0.5 0.0 272532 59292 ? SN 10:25 0:00 /opt/php52/bin/php-cgi /home3/bnpcom/public_html/directory/index.php
    bnpcom 3737 0.6 0.0 272520 59236 ? SN 10:25 0:00 /opt/php52/bin/php-cgi /home3/bnpcom/public_html/directory/index.php
    bnpcom 6121 0.8 0.0 272272 58968 ? SN 10:26 0:00 /opt/php52/bin/php-cgi /home3/bnpcom/public_html/directory/index.php
    bnpcom 6262 0.1 0.0 338800 60300 ? SN 10:20 0:00 /opt/php52/bin/php-cgi /home3/bnpcom/public_html/directory/index.php
    bnpcom 7312 0.2 0.0 340108 61580 ? SN 10:20 0:00 /opt/php52/bin/php-cgi /home3/bnpcom/public_html/directory/index.php
    bnpcom 8570 1.2 0.0 272516 59252 ? SN 10:26 0:00 /opt/php52/bin/php-cgi /home3/bnpcom/public_html/directory/index.php
    bnpcom 11450 2.7 0.0 272280 58964 ? SN 10:27 0:00 /opt/php52/bin/php-cgi /home3/bnpcom/public_html/directory/index.php
    bnpcom 16336 0.2 0.0 272528 59368 ? SN 10:22 0:00 /opt/php52/bin/php-cgi /home3/bnpcom/public_html/directory/index.php
    bnpcom 17571 0.1 0.0 340364 61108 ? SN 10:16 0:01 /opt/php52/bin/php-cgi /home3/bnpcom/public_html/directory/index.php
    bnpcom 19450 0.2 0.0 272516 59232 ? SN 10:22 0:00 /opt/php52/bin/php-cgi /home3/bnpcom/public_html/directory/index.php
    bnpcom 20463 0.2 0.0 272500 59176 ? SN 10:23 0:00 /opt/php52/bin/php-cgi /home3/bnpcom/public_html/directory/index.php
    bnpcom 23271 0.1 0.0 340360 61760 ? SN 10:17 0:01 /opt/php52/bin/php-cgi /home3/bnpcom/public_html/directory/index.php
    bnpcom 24382 0.3 0.0 338052 59308 ? SN 10:23 0:00 /opt/php52/bin/php-cgi /home3/bnpcom/public_html/directory/index.php
    bnpcom 25108 0.3 0.0 338052 59300 ? SN 10:23 0:00 /opt/php52/bin/php-cgi /home3/bnpcom/public_html/directory/index.php
    bnpcom 25673 0.3 0.0 337792 59224 ? SN 10:23 0:00 /opt/php52/bin/php-cgi /home3/bnpcom/public_html/directory/index.php
    bnpcom 26109 0.3 0.0 272500 59176 ? SN 10:24 0:00 /opt/php52/bin/php-cgi /home3/bnpcom/public_html/directory/index.php
    bnpcom 26452 0.3 0.0 272272 58952 ? SN 10:24 0:00 /opt/php52/bin/php-cgi /home3/bnpcom/public_html/directory/index.php
    bnpcom 28629 0.1 0.0 340364 61756 ? SN 10:18 0:01 /opt/php52/bin/php-cgi /home3/bnpcom/public_html/directory/index.php
    bnpcom 29719 0.4 0.0 272512 59240 ? SN 10:24 0:00 /opt/php52/bin/php-cgi /home3/bnpcom/public_html/directory/index.php
    bnpcom 30468 0.4 0.0 338052 59300 ? SN 10:24 0:00 /opt/php52/bin/php-cgi /home3/bnpcom/public_html/directory/index.php
    bnpcom 31152 0.4 0.0 272260 59156 ? SN 10:24 0:00 /opt/php52/bin/php-cgi /home3/bnpcom/public_html/directory/index.php
    bnpcom 32581 0.1 0.0 338796 60296 ? SN 10:19 0:00 /opt/php52/bin/php-cgi /home3/bnpcom/public_html/directory/index.php

    Wed Jul 29 10:27:43 CDT 2015
    Running Processes:
    bnpcom 1535 0.2 0.0 340104 61644 ? SN 10:19 0:00 /opt/php52/bin/php-cgi /home3/bnpcom/public_html/directory/index.php
    bnpcom 1827 0.5 0.0 272532 59292 ? SN 10:25 0:00 /opt/php52/bin/php-cgi /home3/bnpcom/public_html/directory/index.php
    bnpcom 3737 0.6 0.0 272520 59236 ? SN 10:25 0:00 /opt/php52/bin/php-cgi /home3/bnpcom/public_html/directory/index.php
    bnpcom 6121 0.8 0.0 272272 58968 ? SN 10:26 0:00 /opt/php52/bin/php-cgi /home3/bnpcom/public_html/directory/index.php
    bnpcom 6262 0.1 0.0 338800 60300 ? SN 10:20 0:00 /opt/php52/bin/php-cgi /home3/bnpcom/public_html/directory/index.php
    bnpcom 7312 0.2 0.0 340108 61580 ? SN 10:20 0:00 /opt/php52/bin/php-cgi /home3/bnpcom/public_html/directory/index.php
    bnpcom 8570 1.2 0.0 272516 59252 ? SN 10:26 0:00 /opt/php52/bin/php-cgi /home3/bnpcom/public_html/directory/index.php
    bnpcom 11450 2.7 0.0 272280 58964 ? SN 10:27 0:00 /opt/php52/bin/php-cgi /home3/bnpcom/public_html/directory/index.php
    bnpcom 16336 0.2 0.0 272528 59368 ? SN 10:22 0:00 /opt/php52/bin/php-cgi /home3/bnpcom/public_html/directory/index.php
    bnpcom 17571 0.1 0.0 340364 61108 ? SN 10:16 0:01 /opt/php52/bin/php-cgi /home3/bnpcom/public_html/directory/index.php
    bnpcom 19450 0.2 0.0 272516 59232 ? SN 10:22 0:00 /opt/php52/bin/php-cgi /home3/bnpcom/public_html/directory/index.php
    bnpcom 20463 0.2 0.0 272500 59176 ? SN 10:23 0:00 /opt/php52/bin/php-cgi /home3/bnpcom/public_html/directory/index.php
    bnpcom 23271 0.1 0.0 340360 61760 ? SN 10:17 0:01 /opt/php52/bin/php-cgi /home3/bnpcom/public_html/directory/index.php
    bnpcom 24382 0.3 0.0 338052 59308 ? SN 10:23 0:00 /opt/php52/bin/php-cgi /home3/bnpcom/public_html/directory/index.php
    bnpcom 25108 0.3 0.0 338052 59300 ? SN 10:23 0:00 /opt/php52/bin/php-cgi /home3/bnpcom/public_html/directory/index.php
    bnpcom 25673 0.3 0.0 337792 59224 ? SN 10:23 0:00 /opt/php52/bin/php-cgi /home3/bnpcom/public_html/directory/index.php
    bnpcom 26109 0.3 0.0 272500 59176 ? SN 10:24 0:00 /opt/php52/bin/php-cgi /home3/bnpcom/public_html/directory/index.php
    bnpcom 26452 0.3 0.0 272272 58952 ? SN 10:24 0:00 /opt/php52/bin/php-cgi /home3/bnpcom/public_html/directory/index.php
    bnpcom 28629 0.1 0.0 340364 61756 ? SN 10:18 0:01 /opt/php52/bin/php-cgi /home3/bnpcom/public_html/directory/index.php
    bnpcom 29719 0.4 0.0 272512 59240 ? SN 10:24 0:00 /opt/php52/bin/php-cgi /home3/bnpcom/public_html/directory/index.php
    bnpcom 30468 0.4 0.0 338052 59300 ? SN 10:24 0:00 /opt/php52/bin/php-cgi /home3/bnpcom/public_html/directory/index.php
    bnpcom 31152 0.4 0.0 272260 59156 ? SN 10:24 0:00 /opt/php52/bin/php-cgi /home3/bnpcom/public_html/directory/index.php
    bnpcom 32581 0.1 0.0 338796 60296 ? SN 10:19 0:00 /opt/php52/bin/php-cgi /home3/bnpcom/public_html/directory/index.php

    Running Queries:
    *************************** 1. row ***************************
    USER: bnpcom_rdp
    DB: bnpcom_rdp
    STATE: Copying to tmp table
    TIME: 4
    COMMAND: Query
    INFO: SELECT meta_key FROM wp_postmeta WHERE meta_key !=’_wp_page_template’ AND meta_key !=’_edit_last’ AND meta_key !=’_edit_lock’ AND meta_key !=’_encloseme’ AND meta_key !=’_pingme’ GROUP BY meta_key
    *************************** 2. row ***************************
    USER: bnpcom_rdp
    DB: bnpcom_rdp
    STATE: Copying to tmp table
    TIME: 1
    COMMAND: Query
    INFO: SELECT meta_key FROM wp_postmeta WHERE meta_key !=’_wp_page_template’ AND meta_key !=’_edit_last’ AND meta_key !=’_edit_lock’ AND meta_key !=’_encloseme’ AND meta_key !=’_pingme’ GROUP BY meta_key
    *************************** 3. row ***************************
    USER: bnpcom_rdp
    DB: bnpcom_rdp
    STATE: Copying to tmp table
    TIME: 6
    COMMAND: Query
    INFO: SELECT meta_key FROM wp_postmeta WHERE meta_key !=’_wp_page_template’ AND meta_key !=’_edit_last’ AND meta_key !=’_edit_lock’ AND meta_key !=’_encloseme’ AND meta_key !=’_pingme’ GROUP BY meta_key
    *************************** 4. row ***************************
    USER: bnpcom_rdp
    DB: bnpcom_rdp
    STATE: Copying to tmp table
    TIME: 13
    COMMAND: Query
    INFO: SELECT meta_key FROM wp_postmeta WHERE meta_key !=’_wp_page_template’ AND meta_key !=’_edit_last’ AND meta_key !=’_edit_lock’ AND meta_key !=’_encloseme’ AND meta_key !=’_pingme’ GROUP BY meta_key
    *************************** 5. row ***************************
    USER: bnpcom_rdp
    DB: bnpcom_rdp
    STATE: Copying to tmp table
    TIME: 0
    COMMAND: Query
    INFO: SELECT meta_key FROM wp_postmeta WHERE meta_key !=’_wp_page_template’ AND meta_key !=’_edit_last’ AND meta_key !=’_edit_lock’ AND meta_key !=’_encloseme’ AND meta_key !=’_pingme’ GROUP BY meta_key
    *************************** 6. row ***************************
    USER: bnpcom_rdp
    DB: bnpcom_rdp
    STATE: Copying to tmp table
    TIME: 8
    COMMAND: Query
    INFO: SELECT meta_key FROM wp_postmeta WHERE meta_key !=’_wp_page_template’ AND meta_key !=’_edit_last’ AND meta_key !=’_edit_lock’ AND meta_key !=’_encloseme’ AND meta_key !=’_pingme’ GROUP BY meta_key
    *************************** 7. row ***************************
    USER: bnpcom_rdp
    DB: bnpcom_rdp
    STATE: Copying to tmp table
    TIME: 1
    COMMAND: Query
    INFO: SELECT meta_key FROM wp_postmeta WHERE meta_key !=’_wp_page_template’ AND meta_key !=’_edit_last’ AND meta_key !=’_edit_lock’ AND meta_key !=’_encloseme’ AND meta_key !=’_pingme’ GROUP BY meta_key
    *************************** 8. row ***************************
    USER: bnpcom_rdp
    DB: bnpcom_rdp
    STATE: Copying to tmp table
    TIME: 11
    COMMAND: Query
    INFO: SELECT meta_key FROM wp_postmeta WHERE meta_key !=’_wp_page_template’ AND meta_key !=’_edit_last’ AND meta_key !=’_edit_lock’ AND meta_key !=’_encloseme’ AND meta_key !=’_pingme’ GROUP BY meta_key
    *************************** 9. row ***************************
    USER: bnpcom_rdp
    DB: bnpcom_rdp
    STATE: Copying to tmp table
    TIME: 4
    COMMAND: Query
    INFO: SELECT meta_key FROM wp_postmeta WHERE meta_key !=’_wp_page_template’ AND meta_key !=’_edit_last’ AND meta_key !=’_edit_lock’ AND meta_key !=’_encloseme’ AND meta_key !=’_pingme’ GROUP BY meta_key
    *************************** 10. row ***************************
    USER: bnpcom_rdp
    DB: bnpcom_rdp
    STATE: Copying to tmp table
    TIME: 5
    COMMAND: Query
    INFO: SELECT meta_key FROM wp_postmeta WHERE meta_key !=’_wp_page_template’ AND meta_key !=’_edit_last’ AND meta_key !=’_edit_lock’ AND meta_key !=’_encloseme’ AND meta_key !=’_pingme’ GROUP BY meta_key
    *************************** 11. row ***************************
    USER: bnpcom_rdp
    DB: bnpcom_rdp
    STATE: Copying to tmp table
    TIME: 14
    COMMAND: Query
    INFO: SELECT meta_key FROM wp_postmeta WHERE meta_key !=’_wp_page_template’ AND meta_key !=’_edit_last’ AND meta_key !=’_edit_lock’ AND meta_key !=’_encloseme’ AND meta_key !=’_pingme’ GROUP BY meta_key
    *************************** 12. row ***************************
    USER: bnpcom_rdp
    DB: bnpcom_rdp
    STATE: Copying to tmp table
    TIME: 8
    COMMAND: Query
    INFO: SELECT meta_key FROM wp_postmeta WHERE meta_key !=’_wp_page_template’ AND meta_key !=’_edit_last’ AND meta_key !=’_edit_lock’ AND meta_key !=’_encloseme’ AND meta_key !=’_pingme’ GROUP BY meta_key
    *************************** 13. row ***************************
    USER: bnpcom_rdp
    DB: bnpcom_rdp
    STATE: Copying to tmp table
    TIME: 6
    COMMAND: Query
    INFO: SELECT meta_key FROM wp_postmeta WHERE meta_key !=’_wp_page_template’ AND meta_key !=’_edit_last’ AND meta_key !=’_edit_lock’ AND meta_key !=’_encloseme’ AND meta_key !=’_pingme’ GROUP BY meta_key
    *************************** 14. row ***************************
    USER: bnpcom_rdp
    DB: bnpcom_rdp
    STATE: Copying to tmp table
    TIME: 10
    COMMAND: Query
    INFO: SELECT meta_key FROM wp_postmeta WHERE meta_key !=’_wp_page_template’ AND meta_key !=’_edit_last’ AND meta_key !=’_edit_lock’ AND meta_key !=’_encloseme’ AND meta_key !=’_pingme’ GROUP BY meta_key
    *************************** 15. row ***************************
    USER: bnpcom_rdp
    DB: bnpcom_rdp
    STATE: Copying to tmp table
    TIME: 8
    COMMAND: Query
    INFO: SELECT meta_key FROM wp_postmeta WHERE meta_key !=’_wp_page_template’ AND meta_key !=’_edit_last’ AND meta_key !=’_edit_lock’ AND meta_key !=’_encloseme’ AND meta_key !=’_pingme’ GROUP BY meta_key
    *************************** 16. row ***************************
    USER: bnpcom_rdp
    DB: bnpcom_rdp
    STATE: Copying to tmp table
    TIME: 6
    COMMAND: Query
    INFO: SELECT meta_key FROM wp_postmeta WHERE meta_key !=’_wp_page_template’ AND meta_key !=’_edit_last’ AND meta_key !=’_edit_lock’ AND meta_key !=’_encloseme’ AND meta_key !=’_pingme’ GROUP BY meta_key
    *************************** 17. row ***************************
    USER: bnpcom_rdp
    DB: bnpcom_rdp
    STATE: Copying to tmp table
    TIME: 7
    COMMAND: Query
    INFO: SELECT meta_key FROM wp_postmeta WHERE meta_key !=’_wp_page_template’ AND meta_key !=’_edit_last’ AND meta_key !=’_edit_lock’ AND meta_key !=’_encloseme’ AND meta_key !=’_pingme’ GROUP BY meta_key
    *************************** 18. row ***************************
    USER: bnpcom_rdp
    DB: bnpcom_rdp
    STATE: Copying to tmp table
    TIME: 5
    COMMAND: Query
    INFO: SELECT meta_key FROM wp_postmeta WHERE meta_key !=’_wp_page_template’ AND meta_key !=’_edit_last’ AND meta_key !=’_edit_lock’ AND meta_key !=’_encloseme’ AND meta_key !=’_pingme’ GROUP BY meta_key
    *************************** 19. row ***************************
    USER: bnpcom_rdp
    DB: bnpcom_rdp
    STATE: Copying to tmp table
    TIME: 10
    COMMAND: Query
    INFO: SELECT meta_key FROM wp_postmeta WHERE meta_key !=’_wp_page_template’ AND meta_key !=’_edit_last’ AND meta_key !=’_edit_lock’ AND meta_key !=’_encloseme’ AND meta_key !=’_pingme’ GROUP BY meta_key
    *************************** 20. row ***************************
    USER: bnpcom_rdp
    DB: bnpcom_rdp
    STATE: Copying to tmp table
    TIME: 5
    COMMAND: Query
    INFO: SELECT meta_key FROM wp_postmeta WHERE meta_key !=’_wp_page_template’ AND meta_key !=’_edit_last’ AND meta_key !=’_edit_lock’ AND meta_key !=’_encloseme’ AND meta_key !=’_pingme’ GROUP BY meta_key
    *************************** 21. row ***************************
    USER: bnpcom_rdp
    DB: bnpcom_rdp
    STATE: Copying to tmp table
    TIME: 0
    COMMAND: Query
    INFO: SELECT meta_key FROM wp_postmeta WHERE meta_key !=’_wp_page_template’ AND meta_key !=’_edit_last’ AND meta_key !=’_edit_lock’ AND meta_key !=’_encloseme’ AND meta_key !=’_pingme’ GROUP BY meta_key
    *************************** 22. row ***************************
    USER: bnpcom_rdp
    DB: bnpcom_rdp
    STATE: Copying to tmp table
    TIME: 8
    COMMAND: Query
    INFO: SELECT meta_key FROM wp_postmeta WHERE meta_key !=’_wp_page_template’ AND meta_key !=’_edit_last’ AND meta_key !=’_edit_lock’ AND meta_key !=’_encloseme’ AND meta_key !=’_pingme’ GROUP BY meta_key
    *************************** 23. row ***************************
    USER: bnpcom_rdp
    DB: bnpcom_rdp
    STATE: Copying to tmp table
    TIME: 4
    COMMAND: Query
    INFO: SELECT meta_key FROM wp_postmeta WHERE meta_key !=’_wp_page_template’ AND meta_key !=’_edit_last’ AND meta_key !=’_edit_lock’ AND meta_key !=’_encloseme’ AND meta_key !=’_pingme’ GROUP BY meta_key

    July 30, 2015 at 2:38 am
  • user
    Errol Hutchinson
    -4 points
    Beginner
    Members Only Content

    This reply is for PremiumPress customers only.

    Login Now
    July 30, 2015 at 4:02 am
  • user
    Aaron Whittaker
    4 points
    Beginner
    Members Only Content

    This reply is for PremiumPress customers only.

    Login Now
    July 30, 2015 at 6:00 am
  • user
    Mark Eting
    0 points
    Beginner
    Members Only Content

    This reply is for PremiumPress customers only.

    Login Now
    July 30, 2015 at 9:25 am
  • user
    Clive Boosey
    -1 points
    Beginner
    Members Only Content

    This reply is for PremiumPress customers only.

    Login Now
    July 30, 2015 at 9:39 am

465

Views

4

Replies

Discussion Groups
New Topics