Fork me on GitHub

Multiple querys without closing  Bottom

Go to page [-1] 1 - 2:

  • First install Medicula and try to clean up your database. You could also turn on debugging with a standard-template like andreas08, if you set

    Code

    $PNConfig['Debug']['sql_time']       = 1;   // time sql statements, 0 to disable
    $PNConfig['Debug']['sql_detail']     = 1;   // collect executed sql statements, 0 to disable

    you might be able to find out what's wrong. To me, it looks more and more like an error in your system, like metioned here and here.
  • Ok thank you. I'll try just as I indicate. I'll slowly conducting this test and I'm communicating the results.

    Thank you for your invaluable help.
  • Do you have acces to another host or do could you setup a LAMP-package (webserver with PHP) on your own computer and replicate the whole site. I wonder if it will behave the same on systems with other setups.



    Edited by bvdbos3 on Oct 27, 2011 - 01:23 PM.
  • Hello.

    The local behavior is not the same, and that local traffic does not have the same concurrent Internet standard.

    I installed MEDICULA, and I cleaned the hooks that were wrong. If I have seen that there are many meetings that have no users, probably because of robots or boots. I proceed to delete them to see the behavior after deletion, but the system remains unchanged. I have to reset every 24 hours the VPS is not blocked.
  • Hello.

    I created the my.cnf file that contains these parameters:

    Code

    # Para conseguir que vaya mejor las conexiones a BBDD
    max_connections=50
    wait_timeout=60
    interactive_timeout=60


    You get no higher than the barrier of memory 890000k used, but not achieved a substantial improvement in performance.
  • Hello again.

    I still have the same problems and I have to reboot my VPS every 24 hours or less.

    We have not installed anything new and the settings are the same, and the system deterira growing. Please, someone can give me some idea?
  • Every 12 hours I have a crontab that runs as follows:

    Code

    <?php
    $hostname="localhost";
    $username="myuser";
    $password="mypass";
    mysql_connect($hostname, $username, $password);
    $db_select = 'SHOW DATABASES';
    $db_result = mysql_query($db_select);
    while ($db_row = mysql_fetch_array($db_result)) {
    if (mysql_select_db($db_row[0])) {
    $tbl_status = 'SHOW TABLE STATUS FROM ' . $db_row[0];
    $tbl_result = mysql_query($tbl_status);
    if(mysql_num_rows($tbl_result)) {
    while ($tbl_row = mysql_fetch_array($tbl_result)) {
    $opt_table = 'REPAIR TABLE ' . $tbl_row[0];
    $opt_result = mysql_query($opt_table);
    $opt_table = 'OPTIMIZE TABLE ' . $tbl_row[0];
    $opt_result = mysql_query($opt_table);
    }
    } else {
    }
    }
    }
    ?>
  • This is a result od Debug from my www.delosduendeszahories.com/index.php:

    Página generada en 10.7 segundos.
    Count: 216 SQL statements
    SQL Exec Time: 1.766 (total), 0.008 (avg) seconds
    SQL Stmt #1
    - SELECT pn_value , pn_name FROM _module_vars WHERE pn_modname='/PNConfig'
    -- Rows Affected: 101
    -- Rows Marshalled: 101
    -- Time: 0.000918865203857

    SQL Stmt #2
    - SELECT pn_id AS "id",pn_name AS "name",pn_type AS "type",pn_displayname AS "displayname",pn_url AS "URL",pn_description AS "description",pn_regid AS "regid",pn_directory AS "directory",pn_version AS "version",pn_official AS "official",pn_author AS "author",pn_contact AS "contact",pn_admin_capable AS "admin_capable",pn_user_capable AS "user_capable",pn_profile_capable AS "profile_capable",pn_message_capable AS "message_capable",pn_state AS "state",pn_credits AS "credits",pn_changelog AS "changelog",pn_help AS "help",pn_license AS "license",pn_securityschema AS "securityschema" FROM _modules AS tbl
    -- Rows Affected: 60
    -- Rows Marshalled: 60
    -- Time: 0.000518083572388

    SQL Stmt #3
    - SELECT pn_id AS "id",pn_modname AS "modname",pn_name AS "name",pn_value AS "value" FROM _module_vars AS tbl WHERE pn_modname='/PNConfig' OR pn_modname='pnRender' OR pn_modname='Theme' OR pn_modname='Blocks' OR pn_modname='Users' OR pn_modname='Settings' OR pn_modname = 'Profile'
    -- Rows Affected: 156
    -- Rows Marshalled: 156
    -- Time: 0.000939846038818

    SQL Stmt #4
    - SELECT pn_sessid AS "sessid",pn_ipaddr AS "ipaddr",pn_lastused AS "lastused",pn_uid AS "uid",pn_remember AS "remember",pn_vars AS "vars" FROM _session_info AS tbl WHERE pn_sessid='83888f5ae3f9fdbfce878b81824ddff0246e9f62'
    -- Limit: 0, 1
    -- Rows Affected: 1
    -- Rows Marshalled: 1
    -- Time: 0.0118560791016

    SQL Stmt #5
    - SELECT pn_id AS "id",pn_name AS "name",pn_type AS "type",pn_displayname AS "displayname",pn_description AS "description",pn_regid AS "regid",pn_directory AS "directory",pn_version AS "version",pn_official AS "official",pn_author AS "author",pn_contact AS "contact",pn_admin AS "admin",pn_user AS "user",pn_system AS "system",pn_state AS "state",pn_credits AS "credits",pn_changelog AS "changelog",pn_help AS "help",pn_license AS "license",pn_xhtml AS "XHTML" FROM _themes AS tbl
    -- Rows Affected: 8
    -- Rows Marshalled: 8
    -- Time: 0.0185739994049

    SQL Stmt #6
    - SELECT pn_uid AS "uid",pn_uname AS "uname",pn_email AS "email",pn_user_regdate AS "user_regdate",pn_user_viewemail AS "user_viewemail",pn_user_theme AS "user_theme",pn_pass AS "pass",pn_storynum AS "storynum",pn_ublockon AS "ublockon",pn_ublock AS "ublock",pn_theme AS "theme",pn_counter AS "counter",pn_activated AS "activated",pn_lastlogin AS "lastlogin",pn_validfrom AS "validfrom",pn_validuntil AS "validuntil",pn_hash_method AS "hash_method" FROM _users AS tbl WHERE pn_uid='2'
    -- Limit: 0, 1
    -- Rows Affected: 1
    -- Rows Marshalled: 1
    -- Time: 0.00037407875061

    SQL Stmt #7
    - SELECT oba_id AS "id",oba_attribute_name AS "attribute_name",oba_object_id AS "object_id",oba_object_type AS "object_type",oba_value AS "value",oba_obj_status AS "obj_status",oba_cr_date AS "cr_date",oba_cr_uid AS "cr_uid",oba_lu_date AS "lu_date",oba_lu_uid AS "lu_uid" FROM _objectdata_attributes AS tbl WHERE oba_object_id= '2' AND oba_object_type='users'
    -- Rows Affected: 12
    -- Rows Marshalled: 12
    -- Time: 0.00544500350952

    SQL Stmt #8
    - SELECT pn_gid FROM _group_membership WHERE pn_uid IN (-1,2) ORDER BY pn_gid
    -- Rows Affected: 1
    -- Rows Marshalled: 1
    -- Time: 0.000312089920044

    SQL Stmt #9
    - SELECT pn_pid AS "pid",pn_gid AS "gid",pn_sequence AS "sequence",pn_realm AS "realm",pn_component AS "component",pn_instance AS "instance",pn_level AS "level",pn_bond AS "bond" FROM _group_perms AS tbl WHERE pn_gid IN (-1,2) ORDER BY pn_sequence
    -- Rows Affected: 5
    -- Rows Marshalled: 5
    -- Time: 0.000257968902588

    SQL Stmt #10
    - SELECT pn_id AS "id",pn_object AS "object",pn_action AS "action",pn_smodule AS "smodule",pn_stype AS "stype",pn_tarea AS "tarea",pn_tmodule AS "tmodule",pn_ttype AS "ttype",pn_tfunc AS "tfunc",pn_sequence AS "sequence" FROM _hooks AS tbl WHERE pn_smodule = 'zikula' ORDER BY pn_sequence ASC
    -- Rows Affected: 0
    -- Rows Marshalled: 0
    -- Time: 0.00929307937622

    SQL Stmt #11
    - SELECT pn_pid AS "pid",pn_name AS "name",pn_description AS "description" FROM _block_positions AS tbl
    -- Rows Affected: 3
    -- Rows Marshalled: 3
    -- Time: 0.00031590461731

    SQL Stmt #12
    - SELECT pn_pid AS "pid",pn_bid AS "bid",pn_order AS "order" FROM _block_placements AS tbl ORDER BY pn_order
    -- Rows Affected: 12
    -- Rows Marshalled: 12
    -- Time: 0.000211000442505

    SQL Stmt #13
    - SELECT pn_bid AS "bid",pn_bkey AS "bkey",pn_title AS "title",pn_content AS "content",pn_url AS "URL",pn_mid AS "mid",pn_filter AS "filter",pn_active AS "active",pn_collapsable AS "collapsable",pn_defaultstate AS "defaultstate",pn_refresh AS "refresh",pn_last_update AS "last_update",pn_language AS "language" FROM _blocks AS tbl
    -- Rows Affected: 13
    -- Rows Marshalled: 13
    -- Time: 0.000286817550659

    SQL Stmt #14
    - SELECT pn_value , pn_name FROM _module_vars WHERE pn_modname='Admin_Messages'
    -- Rows Affected: 2
    -- Rows Marshalled: 2
    -- Time: 0.00238513946533

    SQL Stmt #15
    - SELECT pn_mid AS "mid",pn_title AS "title",pn_content AS "content",pn_date AS "date",pn_expire AS "expire",pn_active AS "active",pn_view AS "view",pn_language AS "language" FROM _message AS tbl WHERE pn_active = 1 AND (pn_date+pn_expire > '1324980930' OR pn_expire = 0) ORDER by pn_mid DESC
    -- Limit: 0, 25
    -- Rows Affected: 1
    -- Rows Marshalled: 1
    -- Time: 0.000437021255493

    SQL Stmt #16
    - SELECT pn_mid AS "mid",pn_title AS "title",pn_content AS "content",pn_date AS "date",pn_expire AS "expire",pn_active AS "active",pn_view AS "view",pn_language AS "language" FROM _message AS tbl WHERE pn_active = 1 AND (pn_date+pn_expire > '1324980930' OR pn_expire = 0) ORDER by pn_mid DESC
    -- Limit: 1, 25
    -- Rows Affected: 0
    -- Rows Marshalled: 0
    -- Time: 0.0002760887146

    SQL Stmt #17
    - SELECT pn_id AS "id",pn_object AS "object",pn_action AS "action",pn_smodule AS "smodule",pn_stype AS "stype",pn_tarea AS "tarea",pn_tmodule AS "tmodule",pn_ttype AS "ttype",pn_tfunc AS "tfunc",pn_sequence AS "sequence" FROM _hooks AS tbl WHERE pn_smodule = 'Admin_Messages' ORDER BY pn_sequence ASC
    -- Rows Affected: 2
    -- Rows Marshalled: 2
    -- Time: 0.00340700149536

    SQL Stmt #18
    - SELECT pn_value , pn_name FROM _module_vars WHERE pn_modname='bbcode'
    -- Rows Affected: 21
    -- Rows Marshalled: 21
    -- Time: 0.000588178634644

    SQL Stmt #19
    - SELECT pn_value , pn_name FROM _module_vars WHERE pn_modname='bbsmile'
    -- Rows Affected: 5
    -- Rows Marshalled: 5
    -- Time: 0.0145370960236

    SQL Stmt #20
    - SELECT pn_value , pn_name FROM _module_vars WHERE pn_modname='Dizkus'
    -- Rows Affected: 32
    -- Rows Marshalled: 32
    -- Time: 0.000781059265137

    SQL Stmt #21
    - SELECT pn_value , pn_name FROM _module_vars WHERE pn_modname=''
    -- Rows Affected: 0
    -- Rows Marshalled: 0
    -- Time: 0.000218152999878

    SQL Stmt #22
    - SELECT COUNT( 1) FROM _dizkus_posts AS tbl
    -- Rows Affected: 1
    -- Time: 0.000349044799805

    SQL Stmt #23
    - SELECT tbl.forum_id AS "forum_id",tbl.forum_name AS "forum_name",tbl.forum_desc AS "forum_desc",tbl.forum_topics AS "forum_topics",tbl.forum_posts AS "forum_posts",tbl.forum_last_post_id AS "forum_last_post_id",tbl.cat_id AS "cat_id",tbl.forum_order AS "forum_order",tbl.forum_pop3_active AS "forum_pop3_active",tbl.forum_pop3_server AS "forum_pop3_server",tbl.forum_pop3_port AS "forum_pop3_port",tbl.forum_pop3_login AS "forum_pop3_login",tbl.forum_pop3_password AS "forum_pop3_password",tbl.forum_pop3_interval AS "forum_pop3_interval",tbl.forum_pop3_lastconnect AS "forum_pop3_lastconnect",tbl.forum_pop3_pnuser AS "forum_pop3_pnuser",tbl.forum_pop3_pnpassword AS "forum_pop3_pnpassword",tbl.forum_pop3_matchstring AS "forum_pop3_matchstring",tbl.forum_moduleref AS "forum_moduleref",tbl.forum_pntopic AS "forum_pntopic" , a.cat_title AS "cat_title" FROM _dizkus_forums AS tbl LEFT JOIN _dizkus_categories a ON a.cat_id = tbl.cat_id ORDER BY forum_id
    -- Rows Affected: 66
    -- Rows Marshalled: 66
    -- Time: 0.00103998184204

    SQL Stmt #24
    - SELECT t.topic_id, t.topic_title, t.topic_poster, t.topic_replies, t.topic_time, t.topic_last_post_id, t.sticky, t.topic_status, t.topic_views, f.forum_id, f.forum_name, c.cat_title, c.cat_id, p.poster_id, p.post_id, p.post_text FROM _dizkus_topics as t, _dizkus_forums as f, _dizkus_posts as p, _dizkus_categories as c WHERE t.forum_id IN (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 23, 24, 26, 27, 28, 29, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71) AND (f.forum_pop3_active = 0) AND t.forum_id = f.forum_id AND t.topic_last_post_id = p.post_id AND f.cat_id = c.cat_id ORDER by t.topic_time DESC
    -- Limit: -1, 20
    -- Rows Affected: 20
    -- Rows Marshalled: 20
    -- Time: 0.380057811737

    SQL Stmt #25
    - SELECT user_id AS "user_id",user_posts AS "user_posts",user_rank AS "user_rank",user_level AS "user_level",user_lastvisit AS "user_lastvisit",user_favorites AS "user_favorites",user_post_order AS "user_post_order" FROM _dizkus_users AS tbl WHERE user_id='2'
    -- Limit: 0, 1
    -- Rows Affected: 1
    -- Rows Marshalled: 1
    -- Time: 0.00244998931885

    SQL Stmt #26
    - SELECT pn_id AS "id",pn_object AS "object",pn_action AS "action",pn_smodule AS "smodule",pn_stype AS "stype",pn_tarea AS "tarea",pn_tmodule AS "tmodule",pn_ttype AS "ttype",pn_tfunc AS "tfunc",pn_sequence AS "sequence" FROM _hooks AS tbl WHERE pn_smodule = '' ORDER BY pn_sequence ASC
    -- Rows Affected: 26
    -- Rows Marshalled: 26
    -- Time: 0.000548839569092

    SQL Stmt #27
    - SELECT pn_uid AS "uid",pn_uname AS "uname",pn_email AS "email",pn_user_regdate AS "user_regdate",pn_user_viewemail AS "user_viewemail",pn_user_theme AS "user_theme",pn_pass AS "pass",pn_storynum AS "storynum",pn_ublockon AS "ublockon",pn_ublock AS "ublock",pn_theme AS "theme",pn_counter AS "counter",pn_activated AS "activated",pn_lastlogin AS "lastlogin",pn_validfrom AS "validfrom",pn_validuntil AS "validuntil",pn_hash_method AS "hash_method" FROM _users AS tbl WHERE pn_uid='5003'
    -- Limit: 0, 1
    -- Rows Affected: 1
    -- Rows Marshalled: 1
    -- Time: 0.0211029052734

    SQL Stmt #28
    - SELECT oba_id AS "id",oba_attribute_name AS "attribute_name",oba_object_id AS "object_id",oba_object_type AS "object_type",oba_value AS "value",oba_obj_status AS "obj_status",oba_cr_date AS "cr_date",oba_cr_uid AS "cr_uid",oba_lu_date AS "lu_date",oba_lu_uid AS "lu_uid" FROM _objectdata_attributes AS tbl WHERE oba_object_id= '5003' AND oba_object_type='users'
    -- Rows Affected: 2
    -- Rows Marshalled: 2
    -- Time: 0.0214741230011

    SQL Stmt #29
    - SELECT pn_uid AS "uid",pn_uname AS "uname",pn_email AS "email",pn_user_regdate AS "user_regdate",pn_user_viewemail AS "user_viewemail",pn_user_theme AS "user_theme",pn_pass AS "pass",pn_storynum AS "storynum",pn_ublockon AS "ublockon",pn_ublock AS "ublock",pn_theme AS "theme",pn_counter AS "counter",pn_activated AS "activated",pn_lastlogin AS "lastlogin",pn_validfrom AS "validfrom",pn_validuntil AS "validuntil",pn_hash_method AS "hash_method" FROM _users AS tbl WHERE pn_uid='4767'
    -- Limit: 0, 1
    -- Rows Affected: 1
    -- Rows Marshalled: 1
    -- Time: 0.000348091125488

    SQL Stmt #30
    - SELECT oba_id AS "id",oba_attribute_name AS "attribute_name",oba_object_id AS "object_id",oba_object_type AS "object_type",oba_value AS "value",oba_obj_status AS "obj_status",oba_cr_date AS "cr_date",oba_cr_uid AS "cr_uid",oba_lu_date AS "lu_date",oba_lu_uid AS "lu_uid" FROM _objectdata_attributes AS tbl WHERE oba_object_id= '4767' AND oba_object_type='users'
    -- Rows Affected: 15
    -- Rows Marshalled: 15
    -- Time: 0.0239431858063

    SQL Stmt #31
    - SELECT pn_uid AS "uid",pn_uname AS "uname",pn_email AS "email",pn_user_regdate AS "user_regdate",pn_user_viewemail AS "user_viewemail",pn_user_theme AS "user_theme",pn_pass AS "pass",pn_storynum AS "storynum",pn_ublockon AS "ublockon",pn_ublock AS "ublock",pn_theme AS "theme",pn_counter AS "counter",pn_activated AS "activated",pn_lastlogin AS "lastlogin",pn_validfrom AS "validfrom",pn_validuntil AS "validuntil",pn_hash_method AS "hash_method" FROM _users AS tbl WHERE pn_uid='5060'
    -- Limit: 0, 1
    -- Rows Affected: 1
    -- Rows Marshalled: 1
    -- Time: 0.0156898498535

    SQL Stmt #32
    - SELECT oba_id AS "id",oba_attribute_name AS "attribute_name",oba_object_id AS "object_id",oba_object_type AS "object_type",oba_value AS "value",oba_obj_status AS "obj_status",oba_cr_date AS "cr_date",oba_cr_uid AS "cr_uid",oba_lu_date AS "lu_date",oba_lu_uid AS "lu_uid" FROM _objectdata_attributes AS tbl WHERE oba_object_id= '5060' AND oba_object_type='users'
    -- Rows Affected: 1
    -- Rows Marshalled: 1
    -- Time: 0.00559711456299

    SQL Stmt #33
    - SELECT pn_uid AS "uid",pn_uname AS "uname",pn_email AS "email",pn_user_regdate AS "user_regdate",pn_user_viewemail AS "user_viewemail",pn_user_theme AS "user_theme",pn_pass AS "pass",pn_storynum AS "storynum",pn_ublockon AS "ublockon",pn_ublock AS "ublock",pn_theme AS "theme",pn_counter AS "counter",pn_activated AS "activated",pn_lastlogin AS "lastlogin",pn_validfrom AS "validfrom",pn_validuntil AS "validuntil",pn_hash_method AS "hash_method" FROM _users AS tbl WHERE pn_uid='5029'
    -- Limit: 0, 1
    -- Rows Affected: 1
    -- Rows Marshalled: 1
    -- Time: 0.00058388710022

    SQL Stmt #34
    - SELECT oba_id AS "id",oba_attribute_name AS "attribute_name",oba_object_id AS "object_id",oba_object_type AS "object_type",oba_value AS "value",oba_obj_status AS "obj_status",oba_cr_date AS "cr_date",oba_cr_uid AS "cr_uid",oba_lu_date AS "lu_date",oba_lu_uid AS "lu_uid" FROM _objectdata_attributes AS tbl WHERE oba_object_id= '5029' AND oba_object_type='users'
    -- Rows Affected: 0
    -- Rows Marshalled: 0
    -- Time: 0.00431418418884

    SQL Stmt #35
    - SELECT pn_uid AS "uid",pn_uname AS "uname",pn_email AS "email",pn_user_regdate AS "user_regdate",pn_user_viewemail AS "user_viewemail",pn_user_theme AS "user_theme",pn_pass AS "pass",pn_storynum AS "storynum",pn_ublockon AS "ublockon",pn_ublock AS "ublock",pn_theme AS "theme",pn_counter AS "counter",pn_activated AS "activated",pn_lastlogin AS "lastlogin",pn_validfrom AS "validfrom",pn_validuntil AS "validuntil",pn_hash_method AS "hash_method" FROM _users AS tbl WHERE pn_uid='3970'
    -- Limit: 0, 1
    -- Rows Affected: 1
    -- Rows Marshalled: 1
    -- Time: 0.00247287750244

    SQL Stmt #36
    - SELECT oba_id AS "id",oba_attribute_name AS "attribute_name",oba_object_id AS "object_id",oba_object_type AS "object_type",oba_value AS "value",oba_obj_status AS "obj_status",oba_cr_date AS "cr_date",oba_cr_uid AS "cr_uid",oba_lu_date AS "lu_date",oba_lu_uid AS "lu_uid" FROM _objectdata_attributes AS tbl WHERE oba_object_id= '3970' AND oba_object_type='users'
    -- Rows Affected: 18
    -- Rows Marshalled: 18
    -- Time: 0.00561785697937

    SQL Stmt #37
    - SELECT pn_uid AS "uid",pn_uname AS "uname",pn_email AS "email",pn_user_regdate AS "user_regdate",pn_user_viewemail AS "user_viewemail",pn_user_theme AS "user_theme",pn_pass AS "pass",pn_storynum AS "storynum",pn_ublockon AS "ublockon",pn_ublock AS "ublock",pn_theme AS "theme",pn_counter AS "counter",pn_activated AS "activated",pn_lastlogin AS "lastlogin",pn_validfrom AS "validfrom",pn_validuntil AS "validuntil",pn_hash_method AS "hash_method" FROM _users AS tbl WHERE pn_uid='5011'
    -- Limit: 0, 1
    -- Rows Affected: 1
    -- Rows Marshalled: 1
    -- Time: 0.000347137451172

    SQL Stmt #38
    - SELECT oba_id AS "id",oba_attribute_name AS "attribute_name",oba_object_id AS "object_id",oba_object_type AS "object_type",oba_value AS "value",oba_obj_status AS "obj_status",oba_cr_date AS "cr_date",oba_cr_uid AS "cr_uid",oba_lu_date AS "lu_date",oba_lu_uid AS "lu_uid" FROM _objectdata_attributes AS tbl WHERE oba_object_id= '5011' AND oba_object_type='users'
    -- Rows Affected: 0
    -- Rows Marshalled: 0
    -- Time: 0.00586915016174

    SQL Stmt #39
    - SELECT pn_uid AS "uid",pn_uname AS "uname",pn_email AS "email",pn_user_regdate AS "user_regdate",pn_user_viewemail AS "user_viewemail",pn_user_theme AS "user_theme",pn_pass AS "pass",pn_storynum AS "storynum",pn_ublockon AS "ublockon",pn_ublock AS "ublock",pn_theme AS "theme",pn_counter AS "counter",pn_activated AS "activated",pn_lastlogin AS "lastlogin",pn_validfrom AS "validfrom",pn_validuntil AS "validuntil",pn_hash_method AS "hash_method" FROM _users AS tbl WHERE pn_uid='4045'
    -- Limit: 0, 1
    -- Rows Affected: 1
    -- Rows Marshalled: 1
    -- Time: 0.000345945358276

    SQL Stmt #40
    - SELECT oba_id AS "id",oba_attribute_name AS "attribute_name",oba_object_id AS "object_id",oba_object_type AS "object_type",oba_value AS "value",oba_obj_status AS "obj_status",oba_cr_date AS "cr_date",oba_cr_uid AS "cr_uid",oba_lu_date AS "lu_date",oba_lu_uid AS "lu_uid" FROM _objectdata_attributes AS tbl WHERE oba_object_id= '4045' AND oba_object_type='users'
    -- Rows Affected: 17
    -- Rows Marshalled: 17
    -- Time: 0.00287508964539

    SQL Stmt #41
    - SELECT pn_uid AS "uid",pn_uname AS "uname",pn_email AS "email",pn_user_regdate AS "user_regdate",pn_user_viewemail AS "user_viewemail",pn_user_theme AS "user_theme",pn_pass AS "pass",pn_storynum AS "storynum",pn_ublockon AS "ublockon",pn_ublock AS "ublock",pn_theme AS "theme",pn_counter AS "counter",pn_activated AS "activated",pn_lastlogin AS "lastlogin",pn_validfrom AS "validfrom",pn_validuntil AS "validuntil",pn_hash_method AS "hash_method" FROM _users AS tbl WHERE pn_uid='4693'
    -- Limit: 0, 1
    -- Rows Affected: 1
    -- Rows Marshalled: 1
    -- Time: 0.000422954559326

    SQL Stmt #42
    - SELECT oba_id AS "id",oba_attribute_name AS "attribute_name",oba_object_id AS "object_id",oba_object_type AS "object_type",oba_value AS "value",oba_obj_status AS "obj_status",oba_cr_date AS "cr_date",oba_cr_uid AS "cr_uid",oba_lu_date AS "lu_date",oba_lu_uid AS "lu_uid" FROM _objectdata_attributes AS tbl WHERE oba_object_id= '4693' AND oba_object_type='users'
    -- Rows Affected: 30
    -- Rows Marshalled: 30
    -- Time: 0.00569796562195

    SQL Stmt #43
    - SELECT pn_uid AS "uid",pn_uname AS "uname",pn_email AS "email",pn_user_regdate AS "user_regdate",pn_user_viewemail AS "user_viewemail",pn_user_theme AS "user_theme",pn_pass AS "pass",pn_storynum AS "storynum",pn_ublockon AS "ublockon",pn_ublock AS "ublock",pn_theme AS "theme",pn_counter AS "counter",pn_activated AS "activated",pn_lastlogin AS "lastlogin",pn_validfrom AS "validfrom",pn_validuntil AS "validuntil",pn_hash_method AS "hash_method" FROM _users AS tbl WHERE pn_uid='4990'
    -- Limit: 0, 1
    -- Rows Affected: 1
    -- Rows Marshalled: 1
    -- Time: 0.000348091125488

    SQL Stmt #44
    - SELECT oba_id AS "id",oba_attribute_name AS "attribute_name",oba_object_id AS "object_id",oba_object_type AS "object_type",oba_value AS "value",oba_obj_status AS "obj_status",oba_cr_date AS "cr_date",oba_cr_uid AS "cr_uid",oba_lu_date AS "lu_date",oba_lu_uid AS "lu_uid" FROM _objectdata_attributes AS tbl WHERE oba_object_id= '4990' AND oba_object_type='users'
    -- Rows Affected: 14
    -- Rows Marshalled: 14
    -- Time: 0.00573015213013

    SQL Stmt #45
    - SELECT pn_uid AS "uid",pn_uname AS "uname",pn_email AS "email",pn_user_regdate AS "user_regdate",pn_user_viewemail AS "user_viewemail",pn_user_theme AS "user_theme",pn_pass AS "pass",pn_storynum AS "storynum",pn_ublockon AS "ublockon",pn_ublock AS "ublock",pn_theme AS "theme",pn_counter AS "counter",pn_activated AS "activated",pn_lastlogin AS "lastlogin",pn_validfrom AS "validfrom",pn_validuntil AS "validuntil",pn_hash_method AS "hash_method" FROM _users AS tbl WHERE pn_uid='5081'
    -- Limit: 0, 1
    -- Rows Affected: 1
    -- Rows Marshalled: 1
    -- Time: 0.000415086746216

    SQL Stmt #46
    - SELECT oba_id AS "id",oba_attribute_name AS "attribute_name",oba_object_id AS "object_id",oba_object_type AS "object_type",oba_value AS "value",oba_obj_status AS "obj_status",oba_cr_date AS "cr_date",oba_cr_uid AS "cr_uid",oba_lu_date AS "lu_date",oba_lu_uid AS "lu_uid" FROM _objectdata_attributes AS tbl WHERE oba_object_id= '5081' AND oba_object_type='users'
    -- Rows Affected: 14
    -- Rows Marshalled: 14
    -- Time: 0.0223579406738

    SQL Stmt #47
    - SELECT pn_value , pn_name FROM _module_vars WHERE pn_modname='PostCalendar'
    -- Rows Affected: 23
    -- Rows Marshalled: 23
    -- Time: 0.000411987304688

    SQL Stmt #48
    - SELECT COUNT( 1) FROM _hooks AS tbl WHERE pn_smodule = 'news' AND pn_tmodule = 'postcalendar'
    -- Rows Affected: 1
    -- Time: 0.000523090362549

    SQL Stmt #49
    - SELECT crg_id , crg_property FROM _categories_registry WHERE crg_modname='PostCalendar' AND crg_table='postcalendar_events' ORDER BY crg_id
    -- Rows Affected: 1
    -- Rows Marshalled: 1
    -- Time: 0.00603199005127

    SQL Stmt #50
    - SELECT cmo_obj_id FROM _categories_mapobj WHERE cmo_table='postcalendar_events' AND ((cmo_reg_id='16' AND (cmo_category_id='10117'))) ORDER BY cmo_obj_id
    -- Rows Affected: 71
    -- Rows Marshalled: 71
    -- Time: 0.00664496421814

    SQL Stmt #51
    - SELECT pc_eid AS "eid",pc_aid AS "aid",pc_title AS "title",pc_time AS "time",pc_hometext AS "hometext",pc_informant AS "informant",pc_eventDate AS "eventDate",pc_duration AS "duration",pc_endDate AS "endDate",pc_recurrtype AS "recurrtype",pc_recurrspec AS "recurrspec",pc_startTime AS "startTime",pc_alldayevent AS "alldayevent",pc_location AS "location",pc_conttel AS "conttel",pc_contname AS "contname",pc_contemail AS "contemail",pc_website AS "website",pc_fee AS "fee",pc_eventstatus AS "eventstatus",pc_sharing AS "sharing",pc_hooked_modulename AS "hooked_modulename",pc_hooked_objectid AS "hooked_objectid",pc_obj_status AS "obj_status",pc_cr_date AS "cr_date",pc_cr_uid AS "cr_uid",pc_lu_date AS "lu_date",pc_lu_uid AS "lu_uid" FROM _postcalendar_events AS tbl WHERE pc_eventstatus=1 AND (pc_endDate>='2011-10-27' OR (pc_endDate='0000-00-00' AND pc_recurrtype'0') OR pc_eventDate>='2011-10-27') AND pc_eventDate '2011-12-27 10:55:36' AND pn_uid > 0
    -- Rows Affected: 1
    -- Time: 0.0014808177948

    SQL Stmt #163
    - SELECT COUNT(DISTINCT pn_ipaddr) FROM _session_info AS tbl WHERE pn_lastused > '2011-12-27 10:55:36' AND pn_uid = '0'
    -- Rows Affected: 1
    -- Time: 0.00422692298889

    SQL Stmt #164
    - SELECT COUNT( 1) FROM _communicator_mail_header AS tbl WHERE c_to = 2 and c_mail_read = 0 and c_folder=0
    -- Rows Affected: 1
    -- Time: 0.00279188156128

    SQL Stmt #165
    - SELECT pn_value , pn_name FROM _module_vars WHERE pn_modname='StaffStatus'
    -- Rows Affected: 0
    -- Rows Marshalled: 0
    -- Time: 0.000364780426025

    SQL Stmt #166
    - SELECT pn_value , pn_name FROM _module_vars WHERE pn_modname=''
    -- Rows Affected: 0
    -- Rows Marshalled: 0
    -- Time: 0.000231981277466

    SQL Stmt #167
    - SELECT pn_value , pn_name FROM _module_vars WHERE pn_modname='StaffStatus'
    -- Rows Affected: 0
    -- Rows Marshalled: 0
    -- Time: 0.000211000442505

    SQL Stmt #168
    - SELECT COUNT( 1) FROM _communicator_mail_header AS tbl WHERE c_to = 2 and c_mail_read = 0 and c_folder=0
    -- Rows Affected: 1
    -- Time: 0.00341701507568

    SQL Stmt #169
    - SELECT COUNT( 1) FROM _communicator_mail_header AS tbl WHERE c_to = 2 and c_folder=0
    -- Rows Affected: 1
    -- Time: 0.00506901741028

    SQL Stmt #170
    - SELECT COUNT( 1) FROM _users AS tbl
    -- Rows Affected: 1
    -- Time: 0.000284910202026

    SQL Stmt #171
    - SELECT COUNT(DISTINCT pn_uid) FROM _users AS tbl WHERE pn_user_regdate LIKE '2011-12-26%' AND pn_uid > '2'
    -- Rows Affected: 1
    -- Time: 0.0019052028656

    SQL Stmt #172
    - SELECT COUNT(DISTINCT pn_uid) FROM _users AS tbl WHERE pn_user_regdate LIKE '2011-12-27%' AND pn_uid > '2'
    -- Rows Affected: 1
    -- Time: 0.0103759765625

    SQL Stmt #173
    - SELECT pn_uid AS "uid",pn_uname AS "uname" FROM _users AS tbl WHERE pn_uid > '2' ORDER BY uid DESC
    -- Limit: -1, 1
    -- Rows Affected: 1
    -- Rows Marshalled: 1
    -- Time: 0.000344038009644

    SQL Stmt #174
    - SELECT oba_id AS "id",oba_attribute_name AS "attribute_name",oba_object_id AS "object_id",oba_object_type AS "object_type",oba_value AS "value",oba_obj_status AS "obj_status",oba_cr_date AS "cr_date",oba_cr_uid AS "cr_uid",oba_lu_date AS "lu_date",oba_lu_uid AS "lu_uid" FROM _objectdata_attributes AS tbl WHERE oba_object_id= '5091' AND oba_object_type='users'
    -- Rows Affected: 0
    -- Rows Marshalled: 0
    -- Time: 0.00748491287231

    SQL Stmt #175
    - SELECT COUNT(DISTINCT pn_uid) FROM _session_info AS tbl WHERE pn_lastused > '2011-12-27 10:55:37' AND pn_uid > 0
    -- Rows Affected: 1
    -- Time: 0.00225496292114

    SQL Stmt #176
    - SELECT COUNT(DISTINCT pn_ipaddr) FROM _session_info AS tbl WHERE pn_lastused > '2011-12-27 10:55:37' AND pn_uid = '0'
    -- Rows Affected: 1
    -- Time: 0.00193405151367

    SQL Stmt #177
    - SELECT tbl.pn_uid AS "uid" , a.pn_uname AS "uname" FROM _session_info AS tbl LEFT JOIN _users a ON a.pn_uid = tbl.pn_uid WHERE tbl.pn_lastused > '2011-12-27 10:55:37' AND tbl.pn_uid > 1 ORDER BY uname ASC
    -- Rows Affected: 2
    -- Rows Marshalled: 2
    -- Time: 0.0015070438385

    SQL Stmt #178
    - SELECT pn_uid AS "uid",pn_uname AS "uname",pn_email AS "email",pn_user_regdate AS "user_regdate",pn_user_viewemail AS "user_viewemail",pn_user_theme AS "user_theme",pn_pass AS "pass",pn_storynum AS "storynum",pn_ublockon AS "ublockon",pn_ublock AS "ublock",pn_theme AS "theme",pn_counter AS "counter",pn_activated AS "activated",pn_lastlogin AS "lastlogin",pn_validfrom AS "validfrom",pn_validuntil AS "validuntil",pn_hash_method AS "hash_method" FROM _users AS tbl WHERE pn_uname='Adela'
    -- Limit: 0, 1
    -- Rows Affected: 1
    -- Rows Marshalled: 1
    -- Time: 0.000333786010742

    SQL Stmt #179
    - SELECT oba_id AS "id",oba_attribute_name AS "attribute_name",oba_object_id AS "object_id",oba_object_type AS "object_type",oba_value AS "value",oba_obj_status AS "obj_status",oba_cr_date AS "cr_date",oba_cr_uid AS "cr_uid",oba_lu_date AS "lu_date",oba_lu_uid AS "lu_uid" FROM _objectdata_attributes AS tbl WHERE oba_object_id= '34' AND oba_object_type='users'
    -- Rows Affected: 7
    -- Rows Marshalled: 7
    -- Time: 0.00304102897644

    SQL Stmt #180
    - SELECT pn_value , pn_name FROM _module_vars WHERE pn_modname='News'
    -- Rows Affected: 42
    -- Rows Marshalled: 41
    -- Time: 0.00052809715271

    SQL Stmt #181
    - SELECT pn_sid AS "sid",pn_title AS "title",pn_urltitle AS "urltitle",pn_hometext AS "hometext",pn_bodytext AS "bodytext",pn_counter AS "counter",pn_contributor AS "contributor",pn_approver AS "approver",pn_notes AS "notes",pn_hideonindex AS "hideonindex",pn_language AS "language",pn_disallowcomments AS "disallowcomments",pn_format_type AS "format_type",pn_published_status AS "published_status",pn_from AS "from",pn_to AS "to",pn_weight AS "weight",pn_pictures AS "pictures",pn_obj_status AS "obj_status",pn_cr_date AS "cr_date",pn_cr_uid AS "cr_uid",pn_lu_date AS "lu_date",pn_lu_uid AS "lu_uid" FROM _news AS tbl WHERE pn_published_status = '0' AND ('2011-12-27 11:15:37' >= pn_from AND (pn_to IS NULL OR '2011-12-27 11:15:37'
  • Hello.

    We have adapted everything comentais in the post, and all I get is that the system to crash.

    It is assumed that checking the cache and Xanthia pnRender would be better, but the system let me thousands of files in the folder pnTemp / pnRender_cache, and as not cleared, I had to create a crontab to delete the entire contents of the same every time.

    But I still do not see how to solve the system resources consumed MySQL without control or restraint.

Go to page [-1] 1 - 2:

  • 0 users

This list is based on users active over the last 60 minutes.