Invision Community 4: SEO, prepare for v5 and dormant account notifications By Matt Monday at 02:04 PM
mark2012 Posted June 20, 2013 Posted June 20, 2013 Hello Every single day when im checking the forum logs via IPB admin panel seeing these two errors, sometime more than 4 times per day: Error: 2006 - MySQL server has gone away Error: 1317 - Query execution was interrupted and since they are not telling me much info ive set up from my.conf to record the logs. In two days the sql log file having already 4 G Not having a high cpu ussage problem everything is fine on this side but i`m looking to detect and solve the problem with slow querry. Im using nginx with php-fpm and this problem seems already exist even if was used mod+write with apache as well. my.conf file looks like this: #--------------------------------------------------------------------- # This file is part of iRedMail, which is an open source mail server # solution for Red Hat® Enterprise Linux, CentOS, Debian and Ubuntu. # # iRedMail is free software: you can redistribute it and/or modify # it under the terms of the GNU General Public License as published by # the Free Software Foundation, either version 3 of the License, or # (at your option) any later version. # # iRedMail is distributed in the hope that it will be useful, # but WITHOUT ANY WARRANTY; without even the implied warranty of # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the # GNU General Public License for more details. # # You should have received a copy of the GNU General Public License # along with iRedMail. If not, see <http://www.gnu.org/licenses/>. #--------------------------------------------------------------------- # # Sample MySQL configuration file. It should be localted at: # # - RHEL/CentOS: /etc/my.cnf # # Shipped within iRedMail project: # http://www.iredmail.org/ # [mysqld] #bind-address = 127.0.0.1 port = 3306 #default-character-set = utf8 datadir = /var/lib/mysql socket = /var/lib/mysql/mysql.sock user = mysql #log = /var/log/mysql.log #log-slow-queries #slow sql logs #log = /var/log/mysql_slow.log #log-slow-queries innodb_buffer_pool_size=256M # Default to using old password format for compatibility with mysql 3.x # clients (those using the mysqlclient10 compatibility package). old_passwords=1 skip-locking #skip-bdb #skip-networking query-cache-type = 1 # Use up to 64Mb of RAM to store query results. query-cache-size = 64M query_cache_limit = 10M thread_cache_size = 8 set-variable = max_connections=1024 #set-variable = max_connect_errors=150 set-variable = max_allowed_packet=500M # If you got error message like "The total number of locks exceeds the lock table size", # please try to increase 'innodb_buffer_pool_size' to a reasonable value. # Restarting MySQL server is required to make new value work. # You can get current value with SQL command: # # mysql> SHOW ENGINE INNODB STATUS G # [...] # Buffer pool size 512 # [...] # #set-variable=innodb_buffer_pool_size=512M #ssl-ca = ssl-cert = /etc/pki/tls/certs/iRedMail_CA.pem ssl-key = /etc/pki/tls/private/iRedMail.key ssl-cipher = ALL [client] default-character-set=utf8 [mysql.server] user = mysql basedir = /var/lib [mysqld_safe] log-error = /var/log/mysqld.log pid-file = /var/run/mysqld/mysqld.pid [root@x144 ~]# top top - 18:02:08 up 29 days, 21:55, 1 user, load average: 2.15, 2.26, 2.16 Tasks: 280 total, 2 running, 278 sleeping, 0 stopped, 0 zombie Cpu(s): 14.4%us, 0.7%sy, 0.0%ni, 82.9%id, 1.9%wa, 0.0%hi, 0.0%si, 0.0%st Mem: 16325540k total, 15252980k used, 1072560k free, 679872k buffers Swap: 2047992k total, 72852k used, 1975140k free, 10484784k cached The mysql version im using is 5.1.67 with myisam and innodb as well and IPB v 3.4.3 Any direction in order to help me to optimize those storage enginee from mysql is much appreciate. PS:Gary wrote awhile ago a very useful post here : http://community.invisionpower.com/topic/362126-tools-commands-to-diagnose-problems/#entry2290797 i`m thinking to start with this step.
AlexJ Posted June 21, 2013 Posted June 21, 2013 1. How much is your DB size? 2. http://mysqltuner.com/ - Download, save, chmod and run it once and post the results. 3. Enable slow query log for 3 seconds and analyze your queries. 4. Upgrade to MySQL 5.5 or use MariaDB (drop in replacement for MySQL and optimized for InnoDB and MyISAM engines) 5. Move IPB session table to memory. Much faster. What's your server OS?
mark2012 Posted June 21, 2013 Author Posted June 21, 2013 Hi Alex and thanks for answering. My datebase have 1.5 gb and im running centos 6 64 bits with no control panel. Other details: there are around 200k pageviews daily and 700 at peak time. This is a small part from slow querry log: /usr/libexec/mysqld, Version: 5.1.67-log (Source distribution). started with: Tcp port: 3306 Unix socket: /var/lib/mysql/mysql.sock Time Id Command Argument 130602 5:22:15 1 Connect root@localhost on nimfoman_ipb 1 Query set autocommit=1 1 Query SELECT * FROM cache_store WHERE cs_key IN ( 'systemvars','login_methods','vnums','app_cache','navigation_tabs','module_cache','hooks','useragents','useragentgroups','skinsets','outputformats','skin_remap','group_cache','settings','lang_data','banfilters','stats','badwords','bbcode','mediatag','profilefields','rss_output_cache','rss_export','meta_tags','ipseo_acronyms','attachtypes','multimod','moderators','announcements','report_cache','report_plugins','emoticons','ranks','reputation_levels','sharelinks','nexus_ads','fi_icons','adv_topic','ccs_menu','support_departments','chatting' ) 1 Query SELECT * FROM sessions WHERE id='00fce27f7092a25c32a856e76a7a00be' 1 Query SELECT m.*, m.member_id as my_member_id,p.*,pp.*,g.*,ccb.cache_content FROM members m LEFT JOIN pfields_content p ON ( p.member_id=m.member_id ) LEFT JOIN profile_portal pp ON ( pp.pp_member_id=m.member_id ) LEFT JOIN groups g ON ( g.g_id=m.member_group_id ) LEFT JOIN content_cache_sigs ccb ON ( ccb.cache_content_id=m.member_id ) WHERE m.member_id=37918 130602 5:22:16 2 Connect Access denied for user 'UNKNOWN_MYSQL_US'@'localhost' (using password: NO) 1 Query SELECT t.*,xxx.* FROM topics t LEFT JOIN core_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('forums',';','topics',';',t.tid)) ) WHERE t.tid=5426 1 Query SELECT f.*,p.*,itemmarking.* FROM forums f LEFT JOIN permission_index p ON ( p.perm_type='forum' AND p.app='forums' AND p.perm_type_id=f.id ) LEFT JOIN core_item_markers itemmarking ON ( itemmarking.item_member_id=37918 AND itemmarking.item_app='forums' AND itemmarking.item_app_key_1=f.id ) 1 Query SELECT * FROM skin_cache WHERE cache_set_id=7 AND cache_type IN ('css', 'replacements') 1 Query SELECT * FROM topic_ratings WHERE rating_tid=5426 and rating_member_id=37918 1 Query SELECT p.*,m.member_id as mid,m.name,m.member_group_id,m.email,m.joined,m.posts, m.last_visit, m.last_activity,m.login_anonymous,m.title as member_title, m.warn_level, m.warn_lastwarn, m.members_display_name, m.members_seo_name, m.member_banned, m.has_gallery, m.has_blog, m.members_bitoptions,m.mgroup_others,m.m_awards,m.m_awards_display,pp.*,w.wl_id,pc.*,rep_index.rep_rating as has_given_rep,rep_cache.rep_points, rep_cache.rep_like_cache,cca.*,ccb.cache_content as cache_content_sig, ccb.cache_updated as cache_updated_sig FROM ( SELECT pid FROM posts WHERE topic_id=5426 AND queued=0 ORDER BY pid asc LIMIT 0,20 ) z LEFT JOIN posts p ON ( p.pid=z.pid ) LEFT JOIN members m ON ( m.member_id=p.author_id ) LEFT JOIN profile_portal pp ON ( m.member_id=pp.pp_member_id ) LEFT JOIN members_warn_logs w ON ( w.wl_content_app='forums' and w.wl_content_id1=p.pid ) LEFT JOIN pfields_content pc ON ( pc.member_id=p.author_id ) LEFT JOIN reputation_index rep_index ON ( rep_index.app='forums' AND rep_index.type='pid' AND rep_index.type_id=p.pid AND rep_index.member_id=37918 ) LEFT JOIN reputation_cache rep_cache ON ( rep_cache.app='forums' AND rep_cache.type='pid' AND rep_cache.type_id=p.pid ) LEFT JOIN content_cache_posts cca ON ( cca.cache_content_id=p.pid ) LEFT JOIN content_cache_sigs ccb ON ( ccb.cache_content_id=m.member_id ) 1 Query SELECT * FROM moderators WHERE forum_id LIKE '%,49,%' AND (member_id=37918 OR (is_group=1 AND group_id IN(14))) 1 Query SELECT * FROM nexus_ads WHERE ad_id=1 1 Query UPDATE nexus_ads SET ad_impressions=ad_impressions+1 WHERE ad_id=1 1 Query SELECT COUNT(*) as cnt, MIN(last_post) as lastItem FROM topics WHERE forum_id=49 AND approved=1 AND tid NOT IN(5426,7292,8961,2605,6023,8398,8921,9810,9201,7760,3941,7578,9028,9125,9977,5711,10162,10496,4466,10591,9583,10592,8311,9241,10482,10755,10799,10122,9446,10699,10957,11046,9911,8595,7108,9775,11331,11306,7229,10975,11155,11353,11713,9555,11945,11555,5339,12344,11551,12289,8447,3964,11436,9736,10488,12545,11985,10053,7948,12634,9611,12754,9389,7085,6582,9961,12669,2478,12059,8702,7490,12390,12962,10932,10454,11257,8646,13108,12767,13009,13211,9840,13174,11837,6948,11203,10869,5663,4726,2179,3378) AND last_post > 1367551335 AND state != 'link' 1 Query INSERT INTO core_item_markers (`item_key`,`item_member_id`,`item_app`,`item_last_update`,`item_last_saved`,`item_read_array`,`item_global_reset`,`item_unread_count`,`item_app_key_1`,`item_app_key_2`,`item_app_key_3`,`item_is_deleted`) VALUES('6ca2c0e6f4824aa8d2aa46c857eb2095',37918,'forums',1370143336,1370143336,'a:91:{i:7292;i:1350591327;i:8961;i:1353068055;i:2605;i:1325837904;i:6023;i:1355056273;i:8398;i:1355949334;i:8921;i:1363129366;i:9810;i:1356641229;i:9201;i:1369933914;i:7760;i:1356642994;i:3941;i:1356643010;i:7578;i:1356643710;i:9028;i:1353844553;i:9125;i:1356775853;i:9977;i:1358087864;i:5711;i:1358149471;i:10162;i:1365970229;i:10496;i:1359463001;i:4466;i:1366386196;i:10591;i:1359810402;i:9583;i:1359907970;i:10592;i:1359911356;i:8311;i:1359912176;i:9241;i:1360068317;i:10482;i:1360179645;i:10755;i:1360316212;i:10799;i:1360694770;i:10122;i:1360693819;i:9446;i:1360693821;i:10699;i:1360693823;i:10957;i:1361015593;i:11046;i:1361137080;i:9911;i:1370033268;i:8595;i:1361053691;i:7108;i:1361303809;i:9775;i:1360932183;i:11331;i:1361816571;i:11306;i:1361976869;i:7229;i:1361991818;i:10975;i:1362175276;i:11155;i:1362244372;i:11353;i:1362347917;i:11713;i:1363203491;i:9555;i:1363211903;i:11945;i:1364067903;i:11555;i:1364506350;i:5339;i:1369758821;i:12344;i:1365885914;i:11551;i:1365970220;i:12289;i:1365970227;i:8447;i:1366223534;i:3964;i:1366379778;i:11436;i:1369758483;i:9736;i:1366744531;i:10488;i:1366744980;i:12545;i:1366745392;i:11985;i:1366745399;i:10053;i:1366745685;i:7948;i:1366745688;i:12634;i:1366745691;i:9611;i:1360371797;i:12754;i:1367153296;i:9389;i:1367334351;i:7085;i:1368045526;i:6582;i:1367831179;i:9961;i:1367945791;i:12669;i:1368873342;i:2478;i:1368886052;i:12059;i:1369070777;i:8702;i:1369758527;i:7490;i:1369161802;i:12390;i:1369328405;i:12962;i:1369598268;i:10932;i:1369514789;i:10454;i:1369535900;i:11257;i:1369535974;i:8646;i:1369549790;i:13108;i:1369758382;i:12767;i:1369758773;i:13009;i:1369758942;i:13211;i:1369770837;i:9840;i:1369934436;i:13174;i:1370020204;i:11837;i:1370025311;i:6948;i:1370085681;i:11203;i:1370087288;i:10869;i:1370116826;i:5663;i:1370124666;i:4726;i:1370124812;i:2179;i:1370143220;i:3378;i:1327062861;i:5426;i:1300223495;}',0,139,49,0,0,0) ON DUPLICATE KEY UPDATE item_key=VALUES(item_key),item_member_id=VALUES(item_member_id),item_app=VALUES(item_app),item_last_update=VALUES(item_last_update),item_last_saved=VALUES(item_last_saved),item_read_array=VALUES(item_read_array),item_global_reset=VALUES(item_global_reset),item_unread_count=VALUES(item_unread_count),item_app_key_1=VALUES(item_app_key_1),item_app_key_2=VALUES(item_app_key_2),item_app_key_3=VALUES(item_app_key_3),item_is_deleted=VALUES(item_is_deleted) 1 Query SELECT s.*, s.id as row_session_id,m.* FROM sessions s LEFT JOIN members m ON ( m.member_id=s.member_id ) WHERE s.id='00fce27f7092a25c32a856e76a7a00be' OR (s.current_appcomponent='forums' AND s.running_time > 1370142436 AND s.in_error=0 AND s.location_1_type='topic' AND s.location_1_id=5426) 1 Query SELECT * FROM core_like_cache WHERE like_cache_id='e63e850215700a4433b9fb9fe34abffc' 1 Query SELECT * FROM core_like WHERE like_id='a160da9c1d2e2690c7e6d059cf2fcc8a' AND like_visible=1 1 Query SELECT f.*,p.* FROM forums f LEFT JOIN permission_index p ON ( p.perm_type_id=f.id AND p.app='forums' AND p.perm_type='forum' ) WHERE f.id=0 1 Query SELECT tg.* ,t.*, t.approved, t.title as topic_title, t.posts as topic_posts, t.last_post as topic_last_post,m.*,p.*,xxx.* FROM core_tags tg LEFT JOIN topics t ON (t.tid=tg.tag_meta_id) LEFT JOIN members m ON (last_poster_id=m.member_id) LEFT JOIN profile_portal p ON (p.pp_member_id=m.member_id) LEFT JOIN core_tags_cache xxx ON (xxx.tag_cache_key=MD5(CONCAT('forums',';','topics',';',t.tid))) WHERE tg.tag_meta_app='forums' AND tg.tag_meta_area='topics' AND tg.tag_meta_id !=5426 AND tg.tag_text IN ('roxi','oral neprotejat','deepthroat','sex normal protejat') AND tg.tag_aai_lookup IN (SELECT tag_perm_aai_lookup FROM core_tags_perms WHERE ( ( FIND_IN_SET(8,tag_perm_text) ) OR ( tag_perm_text='*' ) ) AND tag_perm_visible=1 ) ORDER BY tg.tag_meta_id desc LIMIT 0,100 1 Query SELECT m.*, m.member_id as my_member_id,p.*,pp.*,g.*,ccb.cache_content FROM members m LEFT JOIN pfields_content p ON ( p.member_id=m.member_id ) LEFT JOIN profile_portal pp ON ( pp.pp_member_id=m.member_id ) LEFT JOIN groups g ON ( g.g_id=m.member_group_id ) LEFT JOIN content_cache_sigs ccb ON ( ccb.cache_content_id=m.member_id ) WHERE m.member_id IN (2797,42627,73323,15169,72488) 1 Query SELECT * FROM attachments WHERE attach_rel_module='post' AND ( attach_rel_id IN (15729,15886,15907,15908,15920,16057,16084,16118,16824,16946,16956,16959,16962,16964,17889,17915,18123,20721,20771,21015) ) 1 Query SELECT m.*, m.member_id as my_member_id,p.*,pp.*,g.*,ccb.cache_content FROM members m LEFT JOIN pfields_content p ON ( p.member_id=m.member_id ) LEFT JOIN profile_portal pp ON ( pp.pp_member_id=m.member_id ) LEFT JOIN groups g ON ( g.g_id=m.member_group_id ) LEFT JOIN content_cache_sigs ccb ON ( ccb.cache_content_id=m.member_id ) WHERE m.member_id=2883 1 Query SELECT * FROM core_like WHERE like_id='a160da9c1d2e2690c7e6d059cf2fcc8a' AND like_visible=1 1 Query SELECT * FROM cache_store WHERE cs_key IN ( 'awards_categories' ) 1 Query SELECT * FROM cache_store WHERE cs_key IN ( 'awards_awards' ) 1 Query SELECT * FROM core_editor_autosave WHERE eas_key='451d296c54d2bdad49bd00880bffce3f' 1 Query SELECT * FROM nexus_ads WHERE ad_id=7 1 Query UPDATE nexus_ads SET ad_impressions=ad_impressions+1 WHERE ad_id=7 1 Query SELECT * FROM cache_store WHERE cs_key IN ( 'promenu' ) 1 Query SELECT * FROM topic_notes WHERE n_tid=5426 1 Query SELECT * FROM HQ_badges WHERE ba_enabled = 1 1 Query SELECT blog_id FROM blog_blogs WHERE FIND_IN_SET(37918, blog_authorized_users) 1 Query SELECT * FROM cache_store WHERE cs_key IN ( 'blogmods' ) 1 Query SELECT blog_id FROM blog_blogs WHERE FIND_IN_SET(37918, blog_authorized_users) 1 Query SELECT * FROM blog_this WHERE bt_app='forums' AND bt_id1=5426 1 Query SELECT blog_id FROM blog_blogs WHERE FIND_IN_SET(37918, blog_authorized_users) 1 Query INSERT INTO topic_views (`views_tid`) VALUES(5426) 1 Query UPDATE sessions SET member_name='Sexything',seo_name='sexything',member_id=37918,member_group=14,login_type=0,running_time=1370143335,in_error=0,current_appcomponent='forums',current_module='forums',current_section='topics',location_1_type='topic',location_1_id=5426,location_2_type='forum',location_2_id=49,location_3_type='',location_3_id=0,uagent_key='firefox',uagent_version=18,uagent_type='browser' WHERE id='00fce27f7092a25c32a856e76a7a00be' 1 Quit 130602 5:22:17 3 Connect root@localhost on nimfoman_ipb 3 Query set autocommit=1 4 Connect root@localhost on nimfoman_ipb 4 Query set autocommit=1 3 Query SELECT * FROM cache_store WHERE cs_key IN ( 'systemvars','login_methods','vnums','app_cache','navigation_tabs','module_cache','hooks','useragents','useragentgroups','skinsets','outputformats','skin_remap','group_cache','settings','lang_data','banfilters','stats','badwords','bbcode','mediatag','profilefields','rss_output_cache','rss_export','meta_tags','ipseo_acronyms','ccs_databases','ccs_fields','ccs_menu','report_cache','report_plugins','emoticons','ranks','attachtypes','reputation_levels','ccs_frontpage','moderators','sharelinks','nexus_ads','fi_icons','adv_topic','support_departments','chatting' ) 4 Query SELECT * FROM cache_store WHERE cs_key IN ( 'systemvars','login_methods','vnums','app_cache','navigation_tabs','module_cache','hooks','useragents','useragentgroups','skinsets','outputformats','skin_remap','group_cache','settings','lang_data','banfilters','stats','badwords','bbcode','mediatag','profilefields','rss_output_cache','rss_export','meta_tags','ipseo_acronyms','ccs_databases','ccs_fields','ccs_menu','report_cache','report_plugins','emoticons','ranks','attachtypes','reputation_levels','ccs_frontpage','moderators','sharelinks','nexus_ads','fi_icons','adv_topic','support_departments','chatting' ) 3 Query SELECT * FROM sessions WHERE id='00fce27f7092a25c32a856e76a7a00be' 3 Query SELECT m.*, m.member_id as my_member_id,p.*,pp.*,g.*,ccb.cache_content FROM members m LEFT JOIN pfields_content p ON ( p.member_id=m.member_id ) LEFT JOIN profile_portal pp ON ( pp.pp_member_id=m.member_id ) LEFT JOIN groups g ON ( g.g_id=m.member_group_id ) LEFT JOIN content_cache_sigs ccb ON ( ccb.cache_content_id=m.member_id ) WHERE m.member_id=37918 4 Query SELECT * FROM sessions WHERE id='00fce27f7092a25c32a856e76a7a00be' 4 Query SELECT m.*, m.member_id as my_member_id,p.*,pp.*,g.*,ccb.cache_content FROM members m LEFT JOIN pfields_content p ON ( p.member_id=m.member_id ) LEFT JOIN profile_portal pp ON ( pp.pp_member_id=m.member_id ) LEFT JOIN groups g ON ( g.g_id=m.member_group_id ) LEFT JOIN content_cache_sigs ccb ON ( ccb.cache_content_id=m.member_id ) WHERE m.member_id=37918 3 Query SELECT * FROM skin_cache WHERE cache_set_id=7 AND cache_type IN ('css', 'replacements') 4 Query SELECT * FROM skin_cache WHERE cache_set_id=7 AND cache_type IN ('css', 'replacements') 3 Query SELECT cache_content FROM ccs_template_cache WHERE cache_type='full' 4 Query SELECT cache_content FROM ccs_template_cache WHERE cache_type='full' 3 Query SELECT * FROM ccs_pages WHERE page_seo_name='biggrin.png' AND page_folder='/ipb/public/style_emoticons/default' 3 Query SELECT * FROM ccs_pages WHERE page_seo_name='index.html' AND page_folder='/ipb/public/style_emoticons/default/biggrin.png' 3 Query SELECT * FROM ccs_pages WHERE page_seo_name='ipb/public/style_emoticons/default' AND page_folder='' 3 Query SELECT * FROM ccs_slug_memory WHERE memory_type='page' AND memory_url='http://nimfomane.com/ipb/public/style_emoticons/default/biggrin.png' 3 Query SELECT * FROM ccs_pages WHERE page_folder='' AND page_seo_name='404.html' 4 Query SELECT * FROM ccs_pages WHERE page_seo_name='smile.png' AND page_folder='/ipb/public/style_emoticons/default' 4 Query SELECT * FROM ccs_pages WHERE page_seo_name='index.html' AND page_folder='/ipb/public/style_emoticons/default/smile.png' 4 Query SELECT * FROM ccs_pages WHERE page_seo_name='ipb/public/style_emoticons/default' AND page_folder='' 4 Query SELECT * FROM ccs_slug_memory WHERE memory_type='page' AND memory_url='http://nimfomane.com/ipb/public/style_emoticons/default/smile.png' 4 Query SELECT * FROM ccs_pages WHERE page_folder='' AND page_seo_name='404.html' 5 Connect root@localhost on nimfoman_ipb 5 Query set autocommit=1 5 Query SELECT * FROM cache_store WHERE cs_key IN ( 'systemvars','login_methods','vnums','app_cache','navigation_tabs','module_cache','hooks','useragents','useragentgroups','skinsets','outputformats','skin_remap','group_cache','settings','lang_data','banfilters','stats','badwords','bbcode','mediatag','profilefields','rss_output_cache','rss_export','meta_tags','ipseo_acronyms','ccs_databases','ccs_fields','ccs_menu','report_cache','report_plugins','emoticons','ranks','attachtypes','reputation_levels','ccs_frontpage','moderators','sharelinks','nexus_ads','fi_icons','adv_topic','support_departments','chatting' ) 5 Query SELECT * FROM sessions WHERE id='00fce27f7092a25c32a856e76a7a00be' 5 Query SELECT m.*, m.member_id as my_member_id,p.*,pp.*,g.*,ccb.cache_content FROM members m LEFT JOIN pfields_content p ON ( p.member_id=m.member_id ) LEFT JOIN profile_portal pp ON ( pp.pp_member_id=m.member_id ) LEFT JOIN groups g ON ( g.g_id=m.member_group_id ) LEFT JOIN content_cache_sigs ccb ON ( ccb.cache_content_id=m.member_id ) WHERE m.member_id=37918 3 Query SELECT * FROM cache_store WHERE cs_key IN ( 'promenu' ) 5 Query SELECT * FROM skin_cache WHERE cache_set_id=7 AND cache_type IN ('css', 'replacements') 4 Query SELECT * FROM cache_store WHERE cs_key IN ( 'promenu' ) 5 Query SELECT cache_content FROM ccs_template_cache WHERE cache_type='full' 3 Query UPDATE sessions SET member_name='Sexything',seo_name='sexything',member_id=37918,member_group=14,login_type=0,running_time=1370143337,in_error=1,current_appcomponent='ccs',current_module='pages',current_section='pages',location_1_type='page',location_1_id=0,location_2_type='biggrin.png',location_2_id=0,location_3_type='/ipb/public/style_emoticons/default',location_3_id=0,uagent_key='firefox',uagent_version=18,uagent_type='browser' WHERE id='00fce27f7092a25c32a856e76a7a00be' 4 Query UPDATE sessions SET member_name='Sexything',seo_name='sexything',member_id=37918,member_group=14,login_type=0,running_time=1370143337,in_error=1,current_appcomponent='ccs',current_module='pages',current_section='pages',location_1_type='page',location_1_id=0,location_2_type='smile.png',location_2_id=0,location_3_type='/ipb/public/style_emoticons/default',location_3_id=0,uagent_key='firefox',uagent_version=18,uagent_type='browser' WHERE id='00fce27f7092a25c32a856e76a7a00be' 5 Query SELECT * FROM ccs_pages WHERE page_seo_name='sad.png' AND page_folder='/ipb/public/style_emoticons/default' 5 Query SELECT * FROM ccs_pages WHERE page_seo_name='index.html' AND page_folder='/ipb/public/style_emoticons/default/sad.png' 5 Query SELECT * FROM ccs_pages WHERE page_seo_name='ipb/public/style_emoticons/default' AND page_folder='' 5 Query SELECT * FROM ccs_slug_memory WHERE memory_type='page' AND memory_url='http://nimfomane.com/ipb/public/style_emoticons/default/sad.png' 5 Query SELECT * FROM ccs_pages WHERE page_folder='' AND page_seo_name='404.html' 5 Query SELECT * FROM cache_store WHERE cs_key IN ( 'promenu' ) 5 Query UPDATE sessions SET member_name='Sexything',seo_name='sexything',member_id=37918,member_group=14,login_type=0,running_time=1370143337,in_error=1,current_appcomponent='ccs',current_module='pages',current_section='pages',location_1_type='page',location_1_id=0,location_2_type='sad.png',location_2_id=0,location_3_type='/ipb/public/style_emoticons/default',location_3_id=0,uagent_key='firefox',uagent_version=18,uagent_type='browser' WHERE id='00fce27f7092a25c32a856e76a7a00be' 3 Quit 4 Quit 5 Quit 6 Connect root@localhost on nimfoman_ipb 6 Query set autocommit=1 6 Query SELECT * FROM cache_store WHERE cs_key IN ( 'systemvars','login_methods','vnums','app_cache','navigation_tabs','module_cache','hooks','useragents','useragentgroups','skinsets','outputformats','skin_remap','group_cache','settings','lang_data','banfilters','stats','badwords','bbcode','mediatag','profilefields','rss_output_cache','rss_export','meta_tags','ipseo_acronyms','report_cache','report_plugins','nexus_ads','fi_icons','adv_topic','ccs_menu','support_departments','chatting' ) 6 Query SELECT * FROM skin_cache WHERE cache_set_id=7 AND cache_type IN ('css', 'replacements') 6 Query SELECT * FROM task_manager WHERE task_enabled = 1 AND task_next_run <= 1370143337 ORDER BY task_next_run ASC LIMIT 0,1 6 Query UPDATE task_manager SET task_next_run=1370143380,task_locked=1370143337 WHERE task_id=44 6 Query SELECT task_next_run FROM task_manager WHERE task_enabled = 1 ORDER BY task_next_run ASC LIMIT 0,1 6 Query INSERT INTO cache_store (`cs_array`,`cs_key`,`cs_value`,`cs_updated`,`cs_rebuild`) VALUES(1,'systemvars','a:7:{s:10:"mail_queue";i:0;s:13:"task_next_run";s:10:"1370143380";s:14:"incomingEmails";b:1;s:19:"last_deepscan_check";i:1359356616;s:16:"last_virus_check";i:1361244787;s:9:"loadlimit";s:15:"0.53-1367214675";s:9:"nexus_ads";b:1;}',1370143337,0) ON DUPLICATE KEY UPDATE cs_array=VALUES(cs_array),cs_key=VALUES(cs_key),cs_value=VALUES(cs_value),cs_updated=VALUES(cs_updated),cs_rebuild=VALUES(cs_rebuild) 6 Query SELECT i.item_id FROM classifieds_items i WHERE i.expired = 1 AND date_expiry < 1339039337 ORDER BY date_added ASC 6 Query INSERT INTO task_logs (`log_title`,`log_date`,`log_ip`,`log_desc`) VALUES('Prune Ads',1370143337,'79.119.151.135','Classifieds prune task ran') 6 Query UPDATE task_manager SET task_locked=0 WHERE task_id=44 6 Quit 7 Connect root@localhost on nimfoman_ipb 7 Query set autocommit=1 7 Query SELECT * FROM cache_store WHERE cs_key IN ( 'systemvars','login_methods','vnums','app_cache','navigation_tabs','module_cache','hooks','useragents','useragentgroups','skinsets','outputformats','skin_remap','group_cache','settings','lang_data','banfilters','stats','badwords','bbcode','mediatag','profilefields','rss_output_cache','rss_export','meta_tags','ipseo_acronyms','attachtypes','multimod','moderators','announcements','report_cache','report_plugins','emoticons','ranks','reputation_levels','sharelinks','nexus_ads','fi_icons','adv_topic','ccs_menu','support_departments','chatting' ) 7 Query SELECT * FROM sessions WHERE id='00fce27f7092a25c32a856e76a7a00be' 7 Query SELECT m.*, m.member_id as my_member_id,p.*,pp.*,g.*,ccb.cache_content FROM members m LEFT JOIN pfields_content p ON ( p.member_id=m.member_id ) LEFT JOIN profile_portal pp ON ( pp.pp_member_id=m.member_id ) LEFT JOIN groups g ON ( g.g_id=m.member_group_id ) LEFT JOIN content_cache_sigs ccb ON ( ccb.cache_content_id=m.member_id ) WHERE m.member_id=37918 7 Quit 130602 5:22:18 8 Connect root@localhost on nimfoman_ipb 8 Query set autocommit=1 8 Query SELECT * FROM cache_store WHERE cs_key IN ( 'systemvars','login_methods','vnums','app_cache','navigation_tabs','module_cache','hooks','useragents','useragentgroups','skinsets','outputformats','skin_remap','group_cache','settings','lang_data','banfilters','stats','badwords','bbcode','mediatag','profilefields','rss_output_cache','rss_export','meta_tags','ipseo_acronyms','attachtypes','multimod','moderators','announcements','report_cache','report_plugins','emoticons','ranks','reputation_levels','sharelinks','nexus_ads','fi_icons','adv_topic','ccs_menu','support_departments','chatting' ) 8 Query SELECT * FROM sessions WHERE id='e6139fdc9449fa6af30e8de22365d0a0' 8 Query SELECT m.*, m.member_id as my_member_id,p.*,pp.*,g.*,ccb.cache_content FROM members m LEFT JOIN pfields_content p ON ( p.member_id=m.member_id ) LEFT JOIN profile_portal pp ON ( pp.pp_member_id=m.member_id ) LEFT JOIN groups g ON ( g.g_id=m.member_group_id ) LEFT JOIN content_cache_sigs ccb ON ( ccb.cache_content_id=m.member_id ) WHERE m.member_id=31184 8 Query SELECT t.*,xxx.* FROM topics t LEFT JOIN core_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('forums',';','topics',';',t.tid)) ) WHERE t.tid=5110 8 Query SELECT f.*,p.*,itemmarking.* FROM forums f LEFT JOIN permission_index p ON ( p.perm_type='forum' AND p.app='forums' AND p.perm_type_id=f.id ) LEFT JOIN core_item_markers itemmarking ON ( itemmarking.item_member_id=31184 AND itemmarking.item_app='forums' AND itemmarking.item_app_key_1=f.id ) 8 Query SELECT * FROM skin_cache WHERE cache_set_id=7 AND cache_type IN ('css', 'replacements') 8 Query SELECT * FROM topic_ratings WHERE rating_tid=5110 and rating_member_id=31184 8 Query SELECT p.*,m.member_id as mid,m.name,m.member_group_id,m.email,m.joined,m.posts, m.last_visit, m.last_activity,m.login_anonymous,m.title as member_title, m.warn_level, m.warn_lastwarn, m.members_display_name, m.members_seo_name, m.member_banned, m.has_gallery, m.has_blog, m.members_bitoptions,m.mgroup_others,m.m_awards,m.m_awards_display,pp.*,w.wl_id,pc.*,rep_index.rep_rating as has_given_rep,rep_cache.rep_points, rep_cache.rep_like_cache,cca.*,ccb.cache_content as cache_content_sig, ccb.cache_updated as cache_updated_sig FROM ( SELECT pid FROM posts WHERE topic_id=5110 AND queued=0 ORDER BY pid asc LIMIT 0,20 ) z LEFT JOIN posts p ON ( p.pid=z.pid ) LEFT JOIN members m ON ( m.member_id=p.author_id ) LEFT JOIN profile_portal pp ON ( m.member_id=pp.pp_member_id ) LEFT JOIN members_warn_logs w ON ( w.wl_content_app='forums' and w.wl_content_id1=p.pid ) LEFT JOIN pfields_content pc ON ( pc.member_id=p.author_id ) LEFT JOIN reputation_index rep_index ON ( rep_index.app='forums' AND rep_index.type='pid' AND rep_index.type_id=p.pid AND rep_index.member_id=31184 ) LEFT JOIN reputation_cache rep_cache ON ( rep_cache.app='forums' AND rep_cache.type='pid' AND rep_cache.type_id=p.pid ) LEFT JOIN content_cache_posts cca ON ( cca.cache_content_id=p.pid ) LEFT JOIN content_cache_sigs ccb ON ( ccb.cache_content_id=m.member_id ) 8 Query SELECT * FROM moderators WHERE forum_id LIKE '%,5,%' AND (member_id=31184 OR (is_group=1 AND group_id IN(3))) 8 Query SELECT * FROM nexus_ads WHERE ad_id=1 8 Query UPDATE nexus_ads SET ad_impressions=ad_impressions+1 WHERE ad_id=1 8 Query SELECT s.*, s.id as row_session_id,m.* FROM sessions s LEFT JOIN members m ON ( m.member_id=s.member_id ) WHERE s.id='e6139fdc9449fa6af30e8de22365d0a0' OR (s.current_appcomponent='forums' AND s.running_time > 1370142438 AND s.in_error=0 AND s.location_1_type='topic' AND s.location_1_id=5110) 8 Query SELECT * FROM core_like_cache WHERE like_cache_id='be9abb720fcd6a0807b86573d11cd3da' 8 Query SELECT * FROM core_like WHERE like_id='92173f9de14931553b60644708cb0d0a' AND like_visible=1 8 Query SELECT f.*,p.* FROM forums f LEFT JOIN permission_index p ON ( p.perm_type_id=f.id AND p.app='forums' AND p.perm_type='forum' ) WHERE f.id=0 8 Query SELECT tg.* ,t.*, t.approved, t.title as topic_title, t.posts as topic_posts, t.last_post as topic_last_post,m.*,p.*,xxx.* FROM core_tags tg LEFT JOIN topics t ON (t.tid=tg.tag_meta_id) LEFT JOIN members m ON (last_poster_id=m.member_id) LEFT JOIN profile_portal p ON (p.pp_member_id=m.member_id) LEFT JOIN core_tags_cache xxx ON (xxx.tag_cache_key=MD5(CONCAT('forums',';','topics',';',t.tid))) WHERE tg.tag_meta_app='forums' AND tg.tag_meta_area='topics' AND tg.tag_meta_id !=5110 AND tg.tag_text IN ('21 ani','GFE','blonda','sani mari','slabuta','sarut','finalizare orala','oral neprotejat','sex normal protejat','skinny','sex intre sani','pustoaica','teen','adolescenta') AND tg.tag_aai_lookup IN (SELECT tag_perm_aai_lookup FROM core_tags_perms WHERE ( ( FIND_IN_SET(3,tag_perm_text) ) OR ( tag_perm_text='*' ) ) AND tag_perm_visible=1 ) ORDER BY tg.tag_meta_id desc LIMIT 0,100 8 Query SELECT m.*, m.member_id as my_member_id,p.*,pp.*,g.*,ccb.cache_content FROM members m LEFT JOIN pfields_content p ON ( p.member_id=m.member_id ) LEFT JOIN profile_portal pp ON ( pp.pp_member_id=m.member_id ) LEFT JOIN groups g ON ( g.g_id=m.member_group_id ) LEFT JOIN content_cache_sigs ccb ON ( ccb.cache_content_id=m.member_id ) WHERE m.member_id IN (15977,78268,2797,77980,52835) 8 Query SELECT * FROM attachments WHERE attach_rel_module='post' AND ( attach_rel_id IN (39756,39823,39933,39938,39940,39944,39945,39959,39961,39964,40007,41188,41354,41402,41416,41464,41492,41794,41863,42360) ) 8 Query SELECT m.*, m.member_id as my_member_id,p.*,pp.*,g.*,ccb.cache_content FROM members m LEFT JOIN pfields_content p ON ( p.member_id=m.member_id ) LEFT JOIN profile_portal pp ON ( pp.pp_member_id=m.member_id ) LEFT JOIN groups g ON ( g.g_id=m.member_group_id ) LEFT JOIN content_cache_sigs ccb ON ( ccb.cache_content_id=m.member_id ) WHERE m.member_id=15900 8 Query SELECT * FROM core_like WHERE like_id='92173f9de14931553b60644708cb0d0a' AND like_visible=1 8 Query SELECT * FROM cache_store WHERE cs_key IN ( 'awards_categories' ) 8 Query SELECT * FROM cache_store WHERE cs_key IN ( 'awards_awards' ) 8 Query SELECT * FROM core_editor_autosave WHERE eas_key='d38bcfc5508285a1fd8638a61a8bd021' 8 Query SELECT * FROM nexus_ads WHERE ad_id=7 8 Query UPDATE nexus_ads SET ad_impressions=ad_impressions+1 WHERE ad_id=7 8 Query SELECT * FROM cache_store WHERE cs_key IN ( 'promenu' ) 8 Query SELECT * FROM topic_notes WHERE n_tid=5110 8 Query SELECT * FROM HQ_badges WHERE ba_enabled = 1 8 Query SELECT blog_id FROM blog_blogs WHERE FIND_IN_SET(31184, blog_authorized_users) 8 Query SELECT * FROM cache_store WHERE cs_key IN ( 'blogmods' ) 8 Query SELECT blog_id FROM blog_blogs WHERE FIND_IN_SET(31184, blog_authorized_users) 8 Query SELECT * FROM blog_this WHERE bt_app='forums' AND bt_id1=5110 8 Query SELECT blog_id FROM blog_blogs WHERE FIND_IN_SET(31184, blog_authorized_users) 8 Query INSERT INTO topic_views (`views_tid`) VALUES(5110) 8 Query UPDATE sessions SET member_name='Andreyu26',seo_name='andreyu26',member_id=31184,member_group=3,login_type=0,running_time=1370143338,in_error=0,current_appcomponent='forums',current_module='forums',current_section='topics',location_1_type='topic',location_1_id=5110,location_2_type='forum',location_2_id=5,location_3_type='',location_3_id=0,uagent_key='iPad',uagent_version=0,uagent_type='browser' WHERE id='e6139fdc9449fa6af30e8de22365d0a0' 8 Quit 9 Connect root@localhost on nimfoman_ipb 9 Query set autocommit=1 10 Connect root@localhost on nimfoman_ipb 10 Query set autocommit=1 9 Query SELECT * FROM cache_store WHERE cs_key IN ( 'systemvars','login_methods','vnums','app_cache','navigation_tabs','module_cache','hooks','useragents','useragentgroups','skinsets','outputformats','skin_remap','group_cache','settings','lang_data','banfilters','stats','badwords','bbcode','mediatag','profilefields','rss_output_cache','rss_export','meta_tags','ipseo_acronyms','ccs_databases','ccs_fields','ccs_menu','report_cache','report_plugins','emoticons','ranks','attachtypes','reputation_levels','ccs_frontpage','moderators','sharelinks','nexus_ads','fi_icons','adv_topic','support_departments','chatting' ) 10 Query SELECT * FROM cache_store WHERE cs_key IN ( 'systemvars','login_methods','vnums','app_cache','navigation_tabs','module_cache','hooks','useragents','useragentgroups','skinsets','outputformats','skin_remap','group_cache','settings','lang_data','banfilters','stats','badwords','bbcode','mediatag','profilefields','rss_output_cache','rss_export','meta_tags','ipseo_acronyms','report_cache','report_plugins','nexus_ads','fi_icons','adv_topic','ccs_menu','support_departments','chatting' ) 10 Query SELECT * FROM sessions WHERE id='059976b7f9ff93e41c257947b7860e68' 9 Query SELECT * FROM sessions WHERE id='e6139fdc9449fa6af30e8de22365d0a0' 9 Query SELECT m.*, m.member_id as my_member_id,p.*,pp.*,g.*,ccb.cache_content FROM members m LEFT JOIN pfields_content p ON ( p.member_id=m.member_id ) LEFT JOIN profile_portal pp ON ( pp.pp_member_id=m.member_id ) LEFT JOIN groups g ON ( g.g_id=m.member_group_id ) LEFT JOIN content_cache_sigs ccb ON ( ccb.cache_content_id=m.member_id ) WHERE m.member_id=31184 10 Query SELECT * FROM skin_cache WHERE cache_set_id=7 AND cache_type IN ('css', 'replacements') 9 Query SELECT * FROM skin_cache WHERE cache_set_id=7 AND cache_type IN ('css', 'replacements') 9 Query SELECT cache_content FROM ccs_template_cache WHERE cache_type='full' 10 Query SELECT i.item_id, i.category_id, i.member_id, i.name, i.description, i.price, i.date_added, i.date_updated, i.views, i.date_expiry, i.active, i.open, i.attachments, i.date_added, i.seo_title, i.advert_type, i.post_key, i.renewals, i.package_info,a.attach_id, a.thumb_location,t.type_id, t.name AS advert_type, t.show_badge, t.badge_color, t.zero_text FROM classifieds_items i LEFT JOIN classifieds_images a ON ( a.item_id = i.item_id ) LEFT JOIN classifieds_types t ON ( i.advert_type=t.type_id ) WHERE i.item_id = 298 9 Query SELECT * FROM ccs_pages WHERE page_seo_name='smile.png' AND page_folder='/ipb/public/style_emoticons/default' 9 Query SELECT * FROM ccs_pages WHERE page_seo_name='index.html' AND page_folder='/ipb/public/style_emoticons/default/smile.png' 9 Query SELECT * FROM ccs_pages WHERE page_seo_name='ipb/public/style_emoticons/default' AND page_folder='' 9 Query SELECT * FROM ccs_slug_memory WHERE memory_type='page' AND memory_url='http://nimfomane.com/ipb/public/style_emoticons/default/smile.png' 9 Query SELECT * FROM ccs_pages WHERE page_folder='' AND page_seo_name='404.html' 10 Query SELECT * FROM skin_cache WHERE cache_set_id=7 AND cache_value_1='skin_classifieds_global' 10 Query SELECT * FROM cache_store WHERE cs_key IN ( 'promenu' ) 10 Query SELECT * FROM cache_store WHERE cs_key IN ( 'emoticons' ) 9 Query SELECT * FROM cache_store WHERE cs_key IN ( 'promenu' ) 10 Query UPDATE sessions SET member_name='',member_id=0,member_group=2,login_type=0,running_time=1370143338,in_error=1,current_appcomponent='classifieds',current_module='core',current_section='',location_1_type='',location_1_id=0,location_2_type='',location_2_id=0,location_3_type='',location_3_id=0,uagent_key='firefox',uagent_version=21,uagent_type='browser' WHERE id='059976b7f9ff93e41c257947b7860e68' 10 Quit 9 Query UPDATE sessions SET member_name='Andreyu26',seo_name='andreyu26',member_id=31184,member_group=3,login_type=0,running_time=1370143338,in_error=1,current_appcomponent='ccs',current_module='pages',current_section='pages',location_1_type='page',location_1_id=0,location_2_type='smile.png',location_2_id=0,location_3_type='/ipb/public/style_emoticons/default',location_3_id=0,uagent_key='iPad',uagent_version=0,uagent_type='browser' WHERE id='e6139fdc9449fa6af30e8de22365d0a0' 9 Quit 130602 5:22:19 11 Connect root@localhost on nimfoman_ipb 11 Query set autocommit=1 11 Query SELECT * FROM cache_store WHERE cs_key IN ( 'systemvars','login_methods','vnums','app_cache','navigation_tabs','module_cache','hooks','useragents','useragentgroups','skinsets','outputformats','skin_remap','group_cache','settings','lang_data','banfilters','stats','badwords','bbcode','mediatag','profilefields','rss_output_cache','rss_export','meta_tags','ipseo_acronyms','attachtypes','multimod','moderators','announcements','report_cache','report_plugins','emoticons','ranks','reputation_levels','sharelinks','nexus_ads','fi_icons','adv_topic','ccs_menu','support_departments','chatting' ) 11 Query DELETE FROM sessions WHERE ip_address='66.249.78.131' OR id='google=be0975b5c03123bab0296150c84a16b3_session' 11 Query SELECT t.*,xxx.* FROM topics t LEFT JOIN core_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('forums',';','topics',';',t.tid)) ) WHERE t.tid=6152 11 Query SELECT f.*,p.* FROM forums f LEFT JOIN permission_index p ON ( p.perm_type='forum' AND p.app='forums' AND p.perm_type_id=f.id ) 11 Query SELECT * FROM skin_cache WHERE cache_set_id=7 AND cache_type IN ('css', 'replacements') 11 Query SELECT p.*, p.ip_address as post_ip,t.*, t.title as real_title,m.*, m.title as member_title,pp.*,pc.* FROM posts p LEFT JOIN topics t ON ( p.topic_id=t.tid ) LEFT JOIN members m ON ( m.member_id=p.author_id ) LEFT JOIN profile_portal pp ON ( pp.pp_member_id=p.author_id ) LEFT JOIN pfields_content pc ON ( pc.member_id=p.author_id ) WHERE p.pid IN (49682) AND p.queued=0 AND t.forum_id IN (8,5,49,35,10,19,11,12,15,21,27,14,9,6,7,95,103,109,96,97,98,104,105,113,115,117,119,121,123,125,128,130,173,175,177,179,181,182,184,223,232,237,294,298,299,300,28,30,22,36,18,39,17,47,16,13,20,23,24,25,26,29,31,32,33,34,37,38,40,41,42,43,44,46,89,90,91,111,229,50,132,190,236,192,270,52,134,196,197,198,271,51,133,193,194,195,234,60,142,314,243,58,140,302,241,276,75,157,303,304,235,282,59,141,242,54,313,136,239,305,273,62,144,244,63,145,205,206,207,278,64,146,245,53,135,217,218,219,272,57,139,311,240,275,65,147,246,66,148,247,67,149,248,68,150,249,61,143,202,203,204,277,56,138,220,221,222,274,69,151,250,70,152,208,209,210,279,71,153,251,72,154,252,73,155,253,74,156,254,55,137,199,200,201,238,76,158,211,212,213,280,77,159,255,78,160,316,256,79,161,214,215,216,281,80,162,257,81,163,258,82,164,259,83,165,260,84,166,85,167,261,86,168,262,309,310,92,169,263,93,170,264,315,94,171,265,99,100,101,102,106,107,108,110,112,172,266,114,116,118,120,122,124,126,129,131,174,176,178,180,87,224,4,88,127,186,185,233,227,230,231,269) ORDER BY p.pid asc 11 Query SELECT COUNT(*) as posts FROM posts WHERE topic_id=6152 AND pid <=49682 AND queued=0 11 Query INSERT INTO sessions (`id`,`member_name`,`member_id`,`member_group`,`login_type`,`running_time`,`ip_address`,`browser`,`in_error`,`current_appcomponent`,`current_module`,`current_section`,`location_1_type`,`location_1_id`,`location_2_type`,`location_2_id`,`location_3_type`,`location_3_id`,`uagent_key`,`uagent_version`,`uagent_type`,`uagent_bypass`) VALUES('google=be0975b5c03123bab0296150c84a16b3_session','Google',0,2,0,1370143339,'66.249.78.131','Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)',0,'forums','forums','findpost','',0,'',0,'',0,'google',0,'search',0) 11 Query INSERT INTO spider_logs (`bot`,`request_addr`,`ip_address`,`entry_date`) VALUES('google','/forum/topic/6152-0736479527-titan/?findpost=49682','66.249.78.131',1370143339) 11 Quit 12 Connect root@localhost on nimfoman_ipb 12 Query set autocommit=1 12 Query SELECT * FROM cache_store WHERE cs_key IN ( 'systemvars','login_methods','vnums','app_cache','navigation_tabs','module_cache','hooks','useragents','useragentgroups','skinsets','outputformats','skin_remap','group_cache','settings','lang_data','banfilters','stats','badwords','bbcode','mediatag','profilefields','rss_output_cache','rss_export','meta_tags','ipseo_acronyms','ccs_databases','ccs_fields','ccs_menu','report_cache','report_plugins','emoticons','ranks','attachtypes','reputation_levels','ccs_frontpage','moderators','sharelinks','nexus_ads','fi_icons','adv_topic','support_departments','chatting' ) 12 Query SELECT * FROM sessions WHERE id='e6139fdc9449fa6af30e8de22365d0a0' 12 Query SELECT m.*, m.member_id as my_member_id,p.*,pp.*,g.*,ccb.cache_content FROM members m LEFT JOIN pfields_content p ON ( p.member_id=m.member_id ) LEFT JOIN profile_portal pp ON ( pp.pp_member_id=m.member_id ) LEFT JOIN groups g ON ( g.g_id=m.member_group_id ) LEFT JOIN content_cache_sigs ccb ON ( ccb.cache_content_id=m.member_id ) WHERE m.member_id=31184 12 Query SELECT * FROM skin_cache WHERE cache_set_id=7 AND cache_type IN ('css', 'replacements') 12 Query SELECT cache_content FROM ccs_template_cache WHERE cache_type='full' 12 Query SELECT * FROM ccs_pages WHERE page_seo_name='biggrin.png' AND page_folder='/ipb/public/style_emoticons/default' 12 Query SELECT * FROM ccs_pages WHERE page_seo_name='index.html' AND page_folder='/ipb/public/style_emoticons/default/biggrin.png' 12 Query SELECT * FROM ccs_pages WHERE page_seo_name='ipb/public/style_emoticons/default' AND page_folder='' 12 Query SELECT * FROM ccs_slug_memory WHERE memory_type='page' AND memory_url='http://nimfomane.com/ipb/public/style_emoticons/default/biggrin.png' 12 Query SELECT * FROM ccs_pages WHERE page_folder='' AND page_seo_name='404.html' 12 Query SELECT * FROM cache_store WHERE cs_key IN ( 'promenu' ) 12 Query UPDATE sessions SET member_name='Andreyu26',seo_name='andreyu26',member_id=31184,member_group=3,login_type=0,running_time=1370143339,in_error=1,current_appcomponent='ccs',current_module='pages',current_section='pages',location_1_type='page',location_1_id=0,location_2_type='biggrin.png',location_2_id=0,location_3_type='/ipb/public/style_emoticons/default',location_3_id=0,uagent_key='iPad',uagent_version=0,uagent_type='browser' WHERE id='e6139fdc9449fa6af30e8de22365d0a0' 12 Quit 130602 5:22:20 13 Connect root@localhost on nimfoman_ipb 13 Query set autocommit=1 13 Query SELECT * FROM cache_store WHERE cs_key IN ( 'systemvars','login_methods','vnums','app_cache','navigation_tabs','module_cache','hooks','useragents','useragentgroups','skinsets','outputformats','skin_remap','group_cache','settings','lang_data','banfilters','stats','badwords','bbcode','mediatag','profilefields','rss_output_cache','rss_export','meta_tags','ipseo_acronyms','attachtypes','multimod','moderators','announcements','report_cache','report_plugins','emoticons','ranks','reputation_levels','sharelinks','nexus_ads','fi_icons','adv_topic','ccs_menu','support_departments','chatting' ) 13 Query DELETE FROM sessions WHERE ip_address='66.249.75.213' OR id='google=1f5b96abe570870f6c865b82b215c1ea_session' 13 Query SELECT t.*,xxx.* FROM topics t LEFT JOIN core_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('forums',';','topics',';',t.tid)) ) WHERE t.tid=6152 13 Query SELECT f.*,p.* FROM forums f LEFT JOIN permission_index p ON ( p.perm_type='forum' AND p.app='forums' AND p.perm_type_id=f.id ) 13 Query SELECT * FROM skin_cache WHERE cache_set_id=7 AND cache_type IN ('css', 'replacements') 13 Query SELECT tid, title_seo, title, forum_id FROM topics WHERE tid=6152 13 Query INSERT INTO sessions (`id`,`member_name`,`member_id`,`member_group`,`login_type`,`running_time`,`ip_address`,`browser`,`in_error`,`current_appcomponent`,`current_module`,`current_section`,`location_1_type`,`location_1_id`,`location_2_type`,`location_2_id`,`location_3_type`,`location_3_id`,`uagent_key`,`uagent_version`,`uagent_type`,`uagent_bypass`) VALUES('google=1f5b96abe570870f6c865b82b215c1ea_session','Google',0,2,0,1370143340,'66.249.75.213','Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)',0,'forums','forums','topics','topic',6152,'forum',0,'',0,'google',0,'search',0) 13 Query INSERT INTO spider_logs (`bot`,`request_addr`,`ip_address`,`entry_date`) VALUES('google','/forum/topic/6152-0736479527-titan/page-1','66.249.75.213',1370143340) 13 Quit 130602 5:22:21 14 Connect root@localhost on nimfoman_ipb 14 Query set autocommit=1 14 Query SELECT * FROM cache_store WHERE cs_key IN ( 'systemvars','login_methods','vnums','app_cache','navigation_tabs','module_cache','hooks','useragents','useragentgroups','skinsets','outputformats','skin_remap','group_cache','settings','lang_data','banfilters','stats','badwords','bbcode','mediatag','profilefields','rss_output_cache','rss_export','meta_tags','ipseo_acronyms','attachtypes','multimod','moderators','announcements','report_cache','report_plugins','emoticons','ranks','reputation_levels','sharelinks','nexus_ads','fi_icons','adv_topic','ccs_menu','support_departments','chatting' ) 14 Query DELETE FROM sessions WHERE ip_address='66.249.75.213' OR id='google=607f42b282ca2b1e541af4025f567d13_session' 15 Connect root@localhost on nimfoman_ipb 15 Query set autocommit=1 15 Query SELECT * FROM cache_store WHERE cs_key IN ( 'systemvars','login_methods','vnums','app_cache','navigation_tabs','module_cache','hooks','useragents','useragentgroups','skinsets','outputformats','skin_remap','group_cache','settings','lang_data','banfilters','stats','badwords','bbcode','mediatag','profilefields','rss_output_cache','rss_export','meta_tags','ipseo_acronyms','attachtypes','multimod','moderators','announcements','report_cache','report_plugins','emoticons','ranks','reputation_levels','sharelinks','nexus_ads','fi_icons','adv_topic','ccs_menu','support_departments','chatting' ) 15 Query SELECT * FROM sessions WHERE id='8398ecbdbaf23b61c60643b2c896fbfe' 15 Query SELECT m.*, m.member_id as my_member_id,p.*,pp.*,g.*,ccb.cache_content FROM members m LEFT JOIN pfields_content p ON ( p.member_id=m.member_id ) LEFT JOIN profile_portal pp ON ( pp.pp_member_id=m.member_id ) LEFT JOIN groups g ON ( g.g_id=m.member_group_id ) LEFT JOIN content_cache_sigs ccb ON ( ccb.cache_content_id=m.member_id ) WHERE m.member_id=71624 15 Query SELECT t.*,xxx.* FROM topics t LEFT JOIN core_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('forums',';','topics',';',t.tid)) ) WHERE t.tid=5413 15 Query SELECT f.*,p.*,itemmarking.* FROM forums f LEFT JOIN permission_index p ON ( p.perm_type='forum' AND p.app='forums' AND p.perm_type_id=f.id ) LEFT JOIN core_item_markers itemmarking ON ( itemmarking.item_member_id=71624 AND itemmarking.item_app='forums' AND itemmarking.item_app_key_1=f.id ) 14 Query SELECT t.*,xxx.* FROM topics t LEFT JOIN core_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('forums',';','topics',';',t.tid)) ) WHERE t.tid=8633 14 Query SELECT f.*,p.* FROM forums f LEFT JOIN permission_index p ON ( p.perm_type='forum' AND p.app='forums' AND p.perm_type_id=f.id ) 15 Query SELECT * FROM skin_cache WHERE cache_set_id=7 AND cache_type IN ('css', 'replacements') 15 Query SELECT * FROM topic_ratings WHERE rating_tid=5413 and rating_member_id=71624 15 Query SELECT p.*,m.member_id as mid,m.name,m.member_group_id,m.email,m.joined,m.posts, m.last_visit, m.last_activity,m.login_anonymous,m.title as member_title, m.warn_level, m.warn_lastwarn, m.members_display_name, m.members_seo_name, m.member_banned, m.has_gallery, m.has_blog, m.members_bitoptions,m.mgroup_others,m.m_awards,m.m_awards_display,pp.*,w.wl_id,pc.*,rep_index.rep_rating as has_given_rep,rep_cache.rep_points, rep_cache.rep_like_cache,cca.*,ccb.cache_content as cache_content_sig, ccb.cache_updated as cache_updated_sig FROM ( SELECT pid FROM posts WHERE topic_id=5413 AND queued=0 ORDER BY pid asc LIMIT 20,20 ) z LEFT JOIN posts p ON ( p.pid=z.pid ) LEFT JOIN members m ON ( m.member_id=p.author_id ) LEFT JOIN profile_portal pp ON ( m.member_id=pp.pp_member_id ) LEFT JOIN members_warn_logs w ON ( w.wl_content_app='forums' and w.wl_content_id1=p.pid ) LEFT JOIN pfields_content pc ON ( pc.member_id=p.author_id ) LEFT JOIN reputation_index rep_index ON ( rep_index.app='forums' AND rep_index.type='pid' AND rep_index.type_id=p.pid AND rep_index.member_id=71624 ) LEFT JOIN reputation_cache rep_cache ON ( rep_cache.app='forums' AND rep_cache.type='pid' AND rep_cache.type_id=p.pid ) LEFT JOIN content_cache_posts cca ON ( cca.cache_content_id=p.pid ) LEFT JOIN content_cache_sigs ccb ON ( ccb.cache_content_id=m.member_id ) 15 Query SELECT * FROM moderators WHERE forum_id LIKE '%,5,%' AND (member_id=71624 OR (is_group=1 AND group_id IN(11))) 15 Query SELECT * FROM nexus_ads WHERE ad_id=1 15 Query UPDATE nexus_ads SET ad_impressions=ad_impressions+1 WHERE ad_id=1 14 Query SELECT * FROM skin_cache WHERE cache_set_id=7 AND cache_type IN ('css', 'replacements') 14 Query SELECT * FROM topic_ratings WHERE rating_tid=8633 and rating_member_id=0 14 Query SELECT pid FROM posts WHERE topic_id=8633 AND queued=0 ORDER BY pid DESC LIMIT 0,1 14 Query INSERT INTO sessions (`id`,`member_name`,`member_id`,`member_group`,`login_type`,`running_time`,`ip_address`,`browser`,`in_error`,`current_appcomponent`,`current_module`,`current_section`,`location_1_type`,`location_1_id`,`location_2_type`,`location_2_id`,`location_3_type`,`location_3_id`,`uagent_key`,`uagent_version`,`uagent_type`,`uagent_bypass`) VALUES('google=607f42b282ca2b1e541af4025f567d13_session','Google',0,2,0,1370143341,'66.249.75.213','Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)',0,'forums','forums','topics','topic',8633,'forum',0,'',0,'google',0,'search',0) 14 Query INSERT INTO spider_logs (`bot`,`request_addr`,`ip_address`,`entry_date`) VALUES('google','/forum/topic/8633-0723120478-milf-roscata-camera-de-comert/?view=getlastpost','66.249.75.213',1370143341) 14 Quit 15 Query SELECT s.*, s.id as row_session_id,m.* FROM sessions s LEFT JOIN members m ON ( m.member_id=s.member_id ) WHERE s.id='8398ecbdbaf23b61c60643b2c896fbfe' OR (s.current_appcomponent='forums' AND s.running_time > 1370142441 AND s.in_error=0 AND s.location_1_type='topic' AND s.location_1_id=5413) 15 Query SELECT * FROM core_like_cache WHERE like_cache_id='9fe5eabc71e1aa0cd00e03cfe2e997ff' 15 Query SELECT * FROM core_like WHERE like_id='291c456276986e6d2380666553a11236' AND like_visible=1 15 Query SELECT f.*,p.* FROM forums f LEFT JOIN permission_index p ON ( p.perm_type_id=f.id AND p.app='forums' AND p.perm_type='forum' ) WHERE f.id=0 15 Query SELECT tg.* ,t.*, t.approved, t.title as topic_title, t.posts as topic_posts, t.last_post as topic_last_post,m.*,p.*,xxx.* FROM core_tags tg LEFT JOIN topics t ON (t.tid=tg.tag_meta_id) LEFT JOIN members m ON (last_poster_id=m.member_id) LEFT JOIN profile_portal p ON (p.pp_member_id=m.member_id) LEFT JOIN core_tags_cache xxx ON (xxx.tag_cache_key=MD5(CONCAT('forums',';','topics',';',t.tid))) WHERE tg.tag_meta_app='forums' AND tg.tag_meta_area='topics' AND tg.tag_meta_id !=5413 AND tg.tag_text IN ('Ika','inghit','oral neprotejat','finalizare orala','37 Ani','matura','MILF','SEX TOTAL','SEX anal','masaj erotic','deepthroat','uro','dominare','cunilingus','anilingus','masturbare') AND tg.tag_aai_lookup IN (SELECT tag_perm_aai_lookup FROM core_tags_perms WHERE ( ( FIND_IN_SET(7,tag_perm_text) ) OR ( tag_perm_text='*' ) ) AND tag_perm_visible=1 ) ORDER BY tg.tag_meta_id desc LIMIT 0,100 15 Query SELECT m.*, m.member_id as my_member_id,p.*,pp.*,g.*,ccb.cache_content FROM members m LEFT JOIN pfields_content p ON ( p.member_id=m.member_id ) LEFT JOIN profile_portal pp ON ( pp.pp_member_id=m.member_id ) LEFT JOIN groups g ON ( g.g_id=m.member_group_id ) LEFT JOIN content_cache_sigs ccb ON ( ccb.cache_content_id=m.member_id ) WHERE m.member_id IN (78268,2797,4236,18980,56978) 15 Query SELECT * FROM attachments WHERE attach_rel_module='post' AND ( attach_rel_id IN (50951,50967,51041,51164,52125,54560,54694,65794,65935,65979,66302,67205,67249,80136,80907,96389,96520,96523,107771,118918) ) 15 Query SELECT m.*, m.member_id as my_member_id,p.*,pp.*,g.*,ccb.cache_content FROM members m LEFT JOIN pfields_content p ON ( p.member_id=m.member_id ) LEFT JOIN profile_portal pp ON ( pp.pp_member_id=m.member_id ) LEFT JOIN groups g ON ( g.g_id=m.member_group_id ) LEFT JOIN content_cache_sigs ccb ON ( ccb.cache_content_id=m.member_id ) WHERE m.member_id=21722 15 Query SELECT * FROM core_like WHERE like_id='291c456276986e6d2380666553a11236' AND like_visible=1 15 Query SELECT * FROM cache_store WHERE cs_key IN ( 'awards_categories' ) 15 Query SELECT * FROM cache_store WHERE cs_key IN ( 'awards_awards' ) 15 Query SELECT * FROM core_editor_autosave WHERE eas_key='67dc1ba00ba7eeff0bcadc1b3fb5c8c8' 15 Query SELECT * FROM nexus_ads WHERE ad_id=7 15 Query UPDATE nexus_ads SET ad_impressions=ad_impressions+1 WHERE ad_id=7 15 Query SELECT * FROM cache_store WHERE cs_key IN ( 'promenu' ) 15 Query SELECT * FROM topic_notes WHERE n_tid=5413 15 Query SELECT * FROM HQ_badges WHERE ba_enabled = 1 15 Query SELECT blog_id FROM blog_blogs WHERE FIND_IN_SET(71624, blog_authorized_users) 15 Query SELECT * FROM cache_store WHERE cs_key IN ( 'blogmods' ) 15 Query SELECT blog_id FROM blog_blogs WHERE FIND_IN_SET(71624, blog_authorized_users) 15 Query SELECT * FROM blog_this WHERE bt_app='forums' AND bt_id1=5413 15 Query SELECT blog_id FROM blog_blogs WHERE FIND_IN_SET(71624, blog_authorized_users) 15 Query INSERT INTO topic_views (`views_tid`) VALUES(5413) 15 Query UPDATE sessions SET member_name='Joseph_Bavaria',seo_name='joseph-bavaria',member_id=71624,member_group=11,login_type=0,running_time=1370143341,in_error=0,current_appcomponent='forums',current_module='forums',current_section='topics',location_1_type='topic',location_1_id=5413,location_2_type='forum',location_2_id=5,location_3_type='',location_3_id=0,uagent_key='chrome',uagent_version=27,uagent_type='browser' WHERE id='8398ecbdbaf23b61c60643b2c896fbfe' 15 Quit 16 Connect root@localhost on nimfoman_ipb 16 Query set autocommit=1 16 Query SELECT * FROM cache_store WHERE cs_key IN ( 'systemvars','login_methods','vnums','app_cache','navigation_tabs','module_cache','hooks','useragents','useragentgroups','skinsets','outputformats','skin_remap','group_cache','settings','lang_data','banfilters','stats','badwords','bbcode','mediatag','profilefields','rss_output_cache','rss_export','meta_tags','ipseo_acronyms','attachtypes','multimod','moderators','announcements','report_cache','report_plugins','emoticons','ranks','reputation_levels','sharelinks','nexus_ads','fi_icons','adv_topic','ccs_menu','support_departments','chatting' ) 16 Query DELETE FROM sessions WHERE ip_address='66.249.78.131' OR id='google=59a236c1032f863b3b33a832843c87b9_session' 16 Query SELECT t.*,xxx.* FROM topics t LEFT JOIN core_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('forums',';','topics',';',t.tid)) ) WHERE t.tid=8633 16 Query SELECT f.*,p.* FROM forums f LEFT JOIN permission_index p ON ( p.perm_type='forum' AND p.app='forums' AND p.perm_type_id=f.id ) 16 Query SELECT * FROM skin_cache WHERE cache_set_id=7 AND cache_type IN ('css', 'replacements') 16 Query SELECT * FROM topic_ratings WHERE rating_tid=8633 and rating_member_id=0 16 Query SELECT p.*,m.member_id as mid,m.name,m.member_group_id,m.email,m.joined,m.posts, m.last_visit, m.last_activity,m.login_anonymous,m.title as member_title, m.warn_level, m.warn_lastwarn, m.members_display_name, m.members_seo_name, m.member_banned, m.has_gallery, m.has_blog, m.members_bitoptions,m.mgroup_others,m.m_awards,m.m_awards_display,pp.*,w.wl_id,pc.*,rep_index.rep_rating as has_given_rep,rep_cache.rep_points, rep_cache.rep_like_cache,cca.*,ccb.cache_content as cache_content_sig, ccb.cache_updated as cache_updated_sig FROM ( SELECT pid FROM posts WHERE topic_id=8633 AND queued=0 ORDER BY pid asc LIMIT 0,20 ) z LEFT JOIN posts p ON ( p.pid=z.pid ) LEFT JOIN members m ON ( m.member_id=p.author_id ) LEFT JOIN profile_portal pp ON ( m.member_id=pp.pp_member_id ) LEFT JOIN members_warn_logs w ON ( w.wl_content_app='forums' and w.wl_content_id1=p.pid ) LEFT JOIN pfields_content pc ON ( pc.member_id=p.author_id ) LEFT JOIN reputation_index rep_index ON ( rep_index.app='forums' AND rep_index.type='pid' AND rep_index.type_id=p.pid AND rep_index.member_id=0 ) LEFT JOIN reputation_cache rep_cache ON ( rep_cache.app='forums' AND rep_cache.type='pid' AND rep_cache.type_id=p.pid ) LEFT JOIN content_cache_posts cca ON ( cca.cache_content_id=p.pid ) LEFT JOIN content_cache_sigs ccb ON ( ccb.cache_content_id=m.member_id ) 16 Query SELECT * FROM nexus_ads WHERE ad_id=1 16 Query UPDATE nexus_ads SET ad_impressions=ad_impressions+1 WHERE ad_id=1 130602 5:22:22 16 Query SELECT s.*, s.id as row_session_id,m.* FROM sessions s LEFT JOIN members m ON ( m.member_id=s.member_id ) WHERE s.id='google=59a236c1032f863b3b33a832843c87b9_session' OR (s.current_appcomponent='forums' AND s.running_time > 1370142442 AND s.in_error=0 AND s.location_1_type='topic' AND s.location_1_id=8633) 16 Query SELECT * FROM core_like_cache WHERE like_cache_id='872b2cf7ad448c20d76695187318377e' 16 Query SELECT f.*,p.* FROM forums f LEFT JOIN permission_index p ON ( p.perm_type_id=f.id AND p.app='forums' AND p.perm_type='forum' ) WHERE f.id=0 16 Query SELECT tg.* ,t.*, t.approved, t.title as topic_title, t.posts as topic_posts, t.last_post as topic_last_post,m.*,p.*,xxx.* FROM core_tags tg LEFT JOIN topics t ON (t.tid=tg.tag_meta_id) LEFT JOIN members m ON (last_poster_id=m.member_id) LEFT JOIN profile_portal p ON (p.pp_member_id=m.member_id) LEFT JOIN core_tags_cache xxx ON (xxx.tag_cache_key=MD5(CONCAT('forums',';','topics',';',t.tid))) WHERE tg.tag_meta_app='forums' AND tg.tag_meta_area='topics' AND tg.tag_meta_id !=8633 AND tg.tag_text IN ('Milf','matura','roscata','35 ani','masaj de relaxare','sex oral','sex normal','sani mari','sani imensi','oral neprotejat') AND tg.tag_aai_lookup IN (SELECT tag_perm_aai_lookup FROM core_tags_perms WHERE ( ( FIND_IN_SET(2,tag_perm_text) ) OR ( tag_perm_text='*' ) ) AND tag_perm_visible=1 ) ORDER BY tg.tag_meta_id desc LIMIT 0,100 16 Query SELECT m.*, m.member_id as my_member_id,p.*,pp.*,g.*,ccb.cache_content FROM members m LEFT JOIN pfields_content p ON ( p.member_id=m.member_id ) LEFT JOIN profile_portal pp ON ( pp.pp_member_id=m.member_id ) LEFT JOIN groups g ON ( g.g_id=m.member_group_id ) LEFT JOIN content_cache_sigs ccb ON ( ccb.cache_content_id=m.member_id ) WHERE m.member_id IN (15977,2797,4236,56978,30962) 16 Query SELECT * FROM attachments WHERE attach_rel_module='post' AND ( attach_rel_id IN (75869,75977,76149,76216,76222,76359,76529,77492,81867,127337,127349,127472,132267,132284,132309,132614,132645,147371) ) 16 Query SELECT * FROM cache_store WHERE cs_key IN ( 'awards_categories' ) 16 Query SELECT * FROM cache_store WHERE cs_key IN ( 'awards_awards' ) 16 Query SELECT * FROM nexus_ads WHERE ad_id=7 16 Query UPDATE nexus_ads SET ad_impressions=ad_impressions+1 WHERE ad_id=7 16 Query SELECT * FROM cache_store WHERE cs_key IN ( 'promenu' ) 16 Query SELECT * FROM HQ_badges WHERE ba_enabled = 1 16 Query SELECT * FROM cache_store WHERE cs_key IN ( 'blogmods' ) 16 Query SELECT * FROM blog_this WHERE bt_app='forums' AND bt_id1=8633 16 Query INSERT INTO sessions (`id`,`member_name`,`member_id`,`member_group`,`login_type`,`running_time`,`ip_address`,`browser`,`in_error`,`current_appcomponent`,`current_module`,`current_section`,`location_1_type`,`location_1_id`,`location_2_type`,`location_2_id`,`location_3_type`,`location_3_id`,`uagent_key`,`uagent_version`,`uagent_type`,`uagent_bypass`) VALUES('google=59a236c1032f863b3b33a832843c87b9_session','Google',0,2,0,1370143341,'66.249.78.131','Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)',0,'forums','forums','topics','topic',8633,'forum',0,'',0,'google',0,'search',0) 16 Query INSERT INTO spider_logs (`bot`,`request_addr`,`ip_address`,`entry_date`) VALUES('google','/forum/topic/8633-0723120478-milf-roscata-camera-de-comert/','66.249.78.131',1370143341) 16 Query INSERT INTO topic_views (`views_tid`) VALUES(8633) 16 Quit 130602 5:22:23 17 Connect root@localhost on nimfoman_ipb 17 Query set autocommit=1 17 Query SELECT * FROM cache_store WHERE cs_key IN ( 'systemvars','login_methods','vnums','app_cache','navigation_tabs','module_cache','hooks','useragents','useragentgroups','skinsets','outputformats','skin_remap','group_cache','settings','lang_data','banfilters','stats','badwords','bbcode','mediatag','profilefields','rss_output_cache','rss_export','meta_tags','ipseo_acronyms','report_cache','report_plugins','nexus_ads','fi_icons','adv_topic','ccs_menu','support_departments','chatting' ) 17 Query SELECT * FROM sessions WHERE id='059976b7f9ff93e41c257947b7860e68' 17 Query SELECT * FROM skin_cache WHERE cache_set_id=7 AND cache_type IN ('css', 'replacements') 17 Query SELECT i.item_id, i.category_id, i.member_id, i.name, i.description, i.price, i.date_added, i.date_updated, i.views, i.date_expiry, i.active, i.open, i.attachments, i.date_added, i.seo_title, i.advert_type, i.post_key, i.renewals, i.package_info,a.attach_id, a.thumb_location,t.type_id, t.name AS advert_type, t.show_badge, t.badge_color, t.zero_text FROM classifieds_items i LEFT JOIN classifieds_images a ON ( a.item_id = i.item_id ) LEFT JOIN classifieds_types t ON ( i.advert_type=t.type_id ) WHERE i.item_id = 293 17 Query SELECT * FROM skin_cache WHERE cache_set_id=7 AND cache_value_1='skin_classifieds_global' 17 Query SELECT * FROM cache_store WHERE cs_key IN ( 'promenu' ) 17 Query SELECT * FROM cache_store WHERE cs_key IN ( 'emoticons' ) 17 Query UPDATE sessions SET member_name='',member_id=0,member_group=2,login_type=0,running_time=1370143343,in_error=1,current_appcomponent='classifieds',current_module='core',current_section='',location_1_type='',location_1_id=0,location_2_type='',location_2_id=0,location_3_type='',location_3_id=0,uagent_key='firefox',uagent_version=21,uagent_type='browser' WHERE id='059976b7f9ff93e41c257947b7860e68' 17 Quit 130602 5:22:24 18 Connect root@localhost on nimfoman_ipb 18 Query set autocommit=1 18 Query SELECT * FROM cache_store WHERE cs_key IN ( 'systemvars','login_methods','vnums','app_cache','navigation_tabs','module_cache','hooks','useragents','useragentgroups','skinsets','outputformats','skin_remap','group_cache','settings','lang_data','banfilters','stats','badwords','bbcode','mediatag','profilefields','rss_output_cache','rss_export','meta_tags','ipseo_acronyms','report_cache','report_plugins','feed_index','feed_portal','feed_types','nexus_ads','fi_icons','adv_topic','ccs_menu','support_departments','chatting' ) 18 Query SELECT * FROM sessions WHERE id='161f88ef4ceed8bac257776883c39ac3' 18 Query SELECT m.*, m.member_id as my_member_id,p.*,pp.*,g.*,ccb.cache_content FROM members m LEFT JOIN pfields_content p ON ( p.member_id=m.member_id ) LEFT JOIN profile_portal pp ON ( pp.pp_member_id=m.member_id ) LEFT JOIN groups g ON ( g.g_id=m.member_group_id ) LEFT JOIN content_cache_sigs ccb ON ( ccb.cache_content_id=m.member_id ) WHERE m.member_id=35672 18 Query SELECT * FROM rss_import WHERE rss_import_feed=1 18 Query SELECT * FROM skin_cache WHERE cache_set_id=7 AND cache_type IN ('css', 'replacements') 18 Query SELECT * FROM cache_store WHERE cs_key IN ( 'moderators' ) 18 Query SELECT * FROM feed_member_settings WHERE member_id=35672 18 Query SELECT count(*) as total FROM rss_import WHERE rss_import_feed=1 18 Query SELECT f.*,rep_cache.rep_points, rep_cache.rep_like_cache,rep_index.rep_rating as has_given_rep FROM feed f LEFT JOIN reputation_cache rep_cache ON ( rep_cache.app='supernewsfeed' AND rep_cache.type='action_id' AND rep_cache.type_id=f.action_id ) LEFT JOIN reputation_index rep_index ON ( rep_index.app='supernewsfeed' AND rep_index.type='action_id' AND rep_index.type_id=f.action_id AND rep_index.member_id=35672 ) WHERE action_type in ('blogComment','dbComment','displayName','friend','group','imageComment','newAlbum','newBlog','newDbRecord','newImage','newPost','newTopic','profileComment','profilePhoto','profileUpdate','registration','reputation','signature','statusComment','statusUpdate') GROUP BY f.action_id ORDER BY action_time desc LIMIT 0,50 18 Query SELECT m.*, m.member_id as my_member_id,p.*,pp.*,g.*,ccb.cache_content FROM members m LEFT JOIN pfields_content p ON ( p.member_id=m.member_id ) LEFT JOIN profile_portal pp ON ( pp.pp_member_id=m.member_id ) LEFT JOIN groups g ON ( g.g_id=m.member_group_id ) LEFT JOIN content_cache_sigs ccb ON ( ccb.cache_content_id=m.member_id ) WHERE m.member_id=28076 18 Query SELECT * FROM cache_store WHERE cs_key IN ( 'ranks' ) 18 Query SELECT * FROM skin_cache WHERE cache_set_id=7 AND cache_value_1='skin_a' 18 Query SELECT * FROM cache_store WHERE cs_key IN ( 'reputation_levels' ) 18 Query SELECT m.*, m.member_id as my_member_id,p.*,pp.*,g.*,ccb.cache_content FROM members m LEFT JOIN pfields_content p ON ( p.member_id=m.member_id ) LEFT JOIN profile_portal pp ON ( pp.pp_member_id=m.member_id ) LEFT JOIN groups g ON ( g.g_id=m.member_group_id ) LEFT JOIN content_cache_sigs ccb ON ( ccb.cache_content_id=m.member_id ) WHERE m.member_id=64193 18 Query SELECT m.*, m.member_id as my_member_id,p.*,pp.*,g.*,ccb.cache_content FROM members m LEFT JOIN pfields_content p ON ( p.member_id=m.member_id ) LEFT JOIN profile_portal pp ON ( pp.pp_member_id=m.member_id ) LEFT JOIN groups g ON ( g.g_id=m.member_group_id ) LEFT JOIN content_cache_sigs ccb ON ( ccb.cache_content_id=m.member_id ) WHERE m.member_id=78962 18 Query SELECT m.*, m.member_id as my_member_id,p.*,pp.*,g.*,ccb.cache_content FROM members m LEFT JOIN pfields_content p ON ( p.member_id=m.member_id ) LEFT JOIN profile_portal pp ON ( pp.pp_member_id=m.member_id ) LEFT JOIN groups g ON ( g.g_id=m.member_group_id ) LEFT JOIN content_cache_sigs ccb ON ( ccb.cache_content_id=m.member_id ) WHERE m.member_id=37622 18 Query SELECT m.*, m.member_id as my_member_id,p.*,pp.*,g.*,ccb.cache_content FROM members m LEFT JOIN pfields_content p ON ( p.member_id=m.member_id ) LEFT JOIN profile_portal pp ON ( pp.pp_member_id=m.member_id ) LEFT JOIN groups g ON ( g.g_id=m.member_group_id ) LEFT JOIN content_cache_sigs ccb ON ( ccb.cache_content_id=m.member_id ) WHERE m.member_id=77275 18 Query SELECT m.*, m.member_id as my_member_id,p.*,pp.*,g.*,ccb.cache_content FROM members m LEFT JOIN pfields_content p ON ( p.member_id=m.member_id ) LEFT JOIN profile_portal pp ON ( pp.pp_member_id=m.member_id ) LEFT JOIN groups g ON ( g.g_id=m.member_group_id ) LEFT JOIN content_cache_sigs ccb ON ( ccb.cache_content_id=m.member_id ) WHERE m.member_id=76852 18 Query SELECT m.*, m.member_id as my_member_id,p.*,pp.*,g.*,ccb.cache_content FROM members m LEFT JOIN pfields_content p ON ( p.member_id=m.member_id ) LEFT JOIN profile_portal pp ON ( pp.pp_member_id=m.member_id ) LEFT JOIN groups g ON ( g.g_id=m.member_group_id ) LEFT JOIN content_cache_sigs ccb ON ( ccb.cache_content_id=m.member_id ) WHERE m.member_id=49578 18 Query SELECT m.*, m.member_id as my_member_id,p.*,pp.*,g.*,ccb.cache_content FROM members m LEFT JOIN pfields_content p ON ( p.member_id=m.member_id ) LEFT JOIN profile_portal pp ON ( pp.pp_member_id=m.member_id ) LEFT JOIN groups g ON ( g.g_id=m.member_group_id ) LEFT JOIN content_cache_sigs ccb ON ( ccb.cache_content_id=m.member_id ) WHERE m.member_id=78961 18 Query SELECT m.*, m.member_id as my_member_id,p.*,pp.*,g.*,ccb.cache_content FROM members m LEFT JOIN pfields_content p ON ( p.member_id=m.member_id ) LEFT JOIN profile_portal pp ON ( pp.pp_member_id=m.member_id ) LEFT JOIN groups g ON ( g.g_id=m.member_group_id ) LEFT JOIN content_cache_sigs ccb ON ( ccb.cache_content_id=m.member_id ) WHERE m.member_id=24301 18 Query SELECT m.*, m.member_id as my_member_id,p.*,pp.*,g.*,ccb.cache_content FROM members m LEFT JOIN pfields_content p ON ( p.member_id=m.member_id ) LEFT JOIN profile_portal pp ON ( pp.pp_member_id=m.member_id ) LEFT JOIN groups g ON ( g.g_id=m.member_group_id ) LEFT JOIN content_cache_sigs ccb ON ( ccb.cache_content_id=m.member_id ) WHERE m.member_id=53405 18 Query SELECT m.*, m.member_id as my_member_id,p.*,pp.*,g.*,ccb.cache_content FROM members m LEFT JOIN pfields_content p ON ( p.member_id=m.member_id ) LEFT JOIN profile_portal pp ON ( pp.pp_member_id=m.member_id ) LEFT JOIN groups g ON ( g.g_id=m.member_group_id ) LEFT JOIN content_cache_sigs ccb ON ( ccb.cache_content_id=m.member_id ) WHERE m.member_id=78960 18 Query SELECT m.*, m.member_id as my_member_id,p.*,pp.*,g.*,ccb.cache_content FROM members m LEFT JOIN pfields_content p ON ( p.member_id=m.member_id ) LEFT JOIN profile_portal pp ON ( pp.pp_member_id=m.member_id ) LEFT JOIN groups g ON ( g.g_id=m.member_group_id ) LEFT JOIN content_cache_sigs ccb ON ( ccb.cache_content_id=m.member_id ) WHERE m.member_id=18482 18 Query SELECT m.*, m.member_id as my_member_id,p.*,pp.*,g.*,ccb.cache_content FROM members m LEFT JOIN pfields_content p ON ( p.member_id=m.member_id ) LEFT JOIN profile_portal pp ON ( pp.pp_member_id=m.member_id ) LEFT JOIN groups g ON ( g.g_id=m.member_group_id ) LEFT JOIN content_cache_sigs ccb ON ( ccb.cache_content_id=m.member_id ) WHERE m.member_id=46785 18 Query SELECT m.*, m.member_id as my_member_id,p.*,pp.*,g.*,ccb.cache_content FROM members m LEFT JOIN pfields_content p ON ( p.member_id=m.member_id ) LEFT JOIN profile_portal pp ON ( pp.pp_member_id=m.member_id ) LEFT JOIN groups g ON ( g.g_id=m.member_group_id ) LEFT JOIN content_cache_sigs ccb ON ( ccb.cache_content_id=m.member_id ) WHERE m.member_id=37918 18 Query SELECT m.*, m.member_id as my_member_id,p.*,pp.*,g.*,ccb.cache_content FROM members m LEFT JOIN pfields_content p ON ( p.member_id=m.member_id ) LEFT JOIN profile_portal pp ON ( pp.pp_member_id=m.member_id ) LEFT JOIN groups g ON ( g.g_id=m.member_group_id ) LEFT JOIN content_cache_sigs ccb ON ( ccb.cache_content_id=m.member_id ) WHERE m.member_id=70833 18 Query SELECT m.*, m.member_id as my_member_id,p.*,pp.*,g.*,ccb.cache_content FROM members m LEFT JOIN pfields_content p ON ( p.member_id=m.member_id ) LEFT JOIN profile_portal pp ON ( pp.pp_member_id=m.member_id ) LEFT JOIN groups g ON ( g.g_id=m.member_group_id ) LEFT JOIN content_cache_sigs ccb ON ( ccb.cache_content_id=m.member_id ) WHERE m.member_id=19551 18 Query SELECT m.*, m.member_id as my_member_id,p.*,pp.*,g.*,ccb.cache_content FROM members m LEFT JOIN pfields_content p ON ( p.member_id=m.member_id ) LEFT JOIN profile_portal pp ON ( pp.pp_member_id=m.member_id ) LEFT JOIN groups g ON ( g.g_id=m.member_group_id ) LEFT JOIN content_cache_sigs ccb ON ( ccb.cache_content_id=m.member_id ) WHERE m.member_id=71624 18 Query SELECT m.*, m.member_id as my_member_id,p.*,pp.*,g.*,ccb.cache_content FROM members m LEFT JOIN pfields_content p ON ( p.member_id=m.member_id ) LEFT JOIN profile_portal pp ON ( pp.pp_member_id=m.member_id ) LEFT JOIN groups g ON ( g.g_id=m.member_group_id ) LEFT JOIN content_cache_sigs ccb ON ( ccb.cache_content_id=m.member_id ) WHERE m.member_id=3622 18 Query SELECT m.*, m.member_id as my_member_id,p.*,pp.*,g.*,ccb.cache_content FROM members m LEFT JOIN pfields_content p ON ( p.member_id=m.member_id ) LEFT JOIN profile_portal pp ON ( pp.pp_member_id=m.member_id ) LEFT JOIN groups g ON ( g.g_id=m.member_group_id ) LEFT JOIN content_cache_sigs ccb ON ( ccb.cache_content_id=m.member_id ) WHERE m.member_id=78959 18 Query SELECT m.*, m.member_id as my_member_id,p.*,pp.*,g.*,ccb.cache_content FROM members m LEFT JOIN pfields_content p ON ( p.member_id=m.member_id ) LEFT JOIN profile_portal pp ON ( pp.pp_member_id=m.member_id ) LEFT JOIN groups g ON ( g.g_id=m.member_group_id ) LEFT JOIN content_cache_sigs ccb ON ( ccb.cache_content_id=m.member_id ) WHERE m.member_id=52835 18 Query SELECT m.*, m.member_id as my_member_id,p.*,pp.*,g.*,ccb.cache_content FROM members m LEFT JOIN pfields_content p ON ( p.member_id=m.member_id ) LEFT JOIN profile_portal pp ON ( pp.pp_member_id=m.member_id ) LEFT JOIN groups g ON ( g.g_id=m.member_group_id ) LEFT JOIN content_cache_sigs ccb ON ( ccb.cache_content_id=m.member_id ) WHERE m.member_id=78614 18 Query SELECT count(reply_id) as total_replies FROM feed_replies WHERE feed_id=91904 18 Query SELECT m.*, m.member_id as my_member_id,p.*,pp.*,g.*,ccb.cache_content FROM members m LEFT JOIN pfields_content p ON ( p.member_id=m.member_id ) LEFT JOIN profile_portal pp ON ( pp.pp_member_id=m.member_id ) LEFT JOIN groups g ON ( g.g_id=m.member_group_id ) LEFT JOIN content_cache_sigs ccb ON ( ccb.cache_content_id=m.member_id ) WHERE m.member_id=78605 18 Query SELECT count(reply_id) as total_replies FROM feed_replies WHERE feed_id=91903 18 Query SELECT m.*, m.member_id as my_member_id,p.*,pp.*,g.*,ccb.cache_content FROM members m LEFT JOIN pfields_content p ON ( p.member_id=m.member_id ) LEFT JOIN profile_portal pp ON ( pp.pp_member_id=m.member_id ) LEFT JOIN groups g ON ( g.g_id=m.member_group_id ) LEFT JOIN content_cache_sigs ccb ON ( ccb.cache_content_id=m.member_id ) WHERE m.member_id=78603 18 Query SELECT count(reply_id) as total_replies FROM feed_replies WHERE feed_id=91902 18 Query SELECT m.*, m.member_id as my_member_id,p.*,pp.*,g.*,ccb.cache_content FROM members m LEFT JOIN pfields_content p ON ( p.member_id=m.member_id ) LEFT JOIN profile_portal pp ON ( pp.pp_member_id=m.member_id ) LEFT JOIN groups g ON ( g.g_id=m.member_group_id ) LEFT JOIN content_cache_sigs ccb ON ( ccb.cache_content_id=m.member_id ) WHERE m.member_id=78601 18 Query SELECT count(reply_id) as total_replies FROM feed_replies WHERE feed_id=91901 18 Query SELECT m.*, m.member_id as my_member_id,p.*,pp.*,g.*,ccb.cache_content FROM members m LEFT JOIN pfields_content p ON ( p.member_id=m.member_id ) LEFT JOIN profile_portal pp ON ( pp.pp_member_id=m.member_id ) LEFT JOIN groups g ON ( g.g_id=m.member_group_id ) LEFT JOIN content_cache_sigs ccb ON ( ccb.cache_content_id=m.member_id ) WHERE m.member_id=78600 18 Query SELECT count(reply_id) as total_replies FROM feed_replies WHERE feed_id=91900 18 Query SELECT m.*, m.member_id as my_member_id,p.*,pp.*,g.*,ccb.cache_content FROM members m LEFT JOIN pfields_content p ON ( p.member_id=m.member_id ) LEFT JOIN profile_portal pp ON ( pp.pp_member_id=m.member_id ) LEFT JOIN groups g ON ( g.g_id=m.member_group_id ) LEFT JOIN content_cache_sigs ccb ON ( ccb.cache_content_id=m.member_id ) WHERE m.member_id=78594 18 Query SELECT count(reply_id) as total_replies FROM feed_replies WHERE feed_id=91899 18 Query SELECT m.*, m.member_id as my_member_id,p.*,pp.*,g.*,ccb.cache_content FROM members m LEFT JOIN pfields_content p ON ( p.member_id=m.member_id ) LEFT JOIN profile_portal pp ON ( pp.pp_member_id=m.member_id ) LEFT JOIN groups g ON ( g.g_id=m.member_group_id ) LEFT JOIN content_cache_sigs ccb ON ( ccb.cache_content_id=m.member_id ) WHERE m.member_id=78580 18 Query SELECT count(reply_id) as total_replies FROM feed_replies WHERE feed_id=91898 18 Query SELECT m.*, m.member_id as my_member_id,p.*,pp.*,g.*,ccb.cache_content FROM members m LEFT JOIN pfields_content p ON ( p.member_id=m.member_id ) LEFT JOIN profile_portal pp ON ( pp.pp_member_id=m.member_id ) LEFT JOIN groups g ON ( g.g_id=m.member_group_id ) LEFT JOIN content_cache_sigs ccb ON ( ccb.cache_content_id=m.member_id ) WHERE m.member_id=78576 18 Query SELECT count(reply_id) as total_replies FROM feed_replies WHERE feed_id=91897 18 Query SELECT m.*, m.member_id as my_member_id,p.*,pp.*,g.*,ccb.cache_content FROM members m LEFT JOIN pfields_content p ON ( p.member_id=m.member_id ) LEFT JOIN profile_portal pp ON ( pp.pp_member_id=m.member_id ) LEFT JOIN groups g ON ( g.g_id=m.member_group_id ) LEFT JOIN content_cache_sigs ccb ON ( ccb.cache_content_id=m.member_id ) WHERE m.member_id=78575 18 Query SELECT count(reply_id) as total_replies FROM feed_replies WHERE feed_id=91896 18 Query SELECT m.*, m.member_id as my_member_id,p.*,pp.*,g.*,ccb.cache_content FROM members m LEFT JOIN pfields_content p ON ( p.member_id=m.member_id ) LEFT JOIN profile_portal pp ON ( pp.pp_member_id=m.member_id ) LEFT JOIN groups g ON ( g.g_id=m.member_group_id ) LEFT JOIN content_cache_sigs ccb ON ( ccb.cache_content_id=m.member_id ) WHERE m.member_id=78566 18 Query SELECT count(reply_id) as total_replies FROM feed_replies WHERE feed_id=91895 18 Query SELECT m.*, m.member_id as my_member_id,p.*,pp.*,g.*,ccb.cache_content FROM members m LEFT JOIN pfields_content p ON ( p.member_id=m.member_id ) LEFT JOIN profile_portal pp ON ( pp.pp_member_id=m.member_id ) LEFT JOIN groups g ON ( g.g_id=m.member_group_id ) LEFT JOIN content_cache_sigs ccb ON ( ccb.cache_content_id=m.member_id ) WHERE m.member_id=78564 18 Query SELECT count(reply_id) as total_replies FROM feed_replies WHERE feed_id=91894 18 Query SELECT m.*, m.member_id as my_member_id,p.*,pp.*,g.*,ccb.cache_content FROM members m LEFT JOIN pfields_content p ON ( p.member_id=m.member_id ) LEFT JOIN profile_portal pp ON ( pp.pp_member_id=m.member_id ) LEFT JOIN groups g ON ( g.g_id=m.member_group_id ) LEFT JOIN content_cache_sigs ccb ON ( ccb.cache_content_id=m.member_id ) WHERE m.member_id=78561 18 Query SELECT count(reply_id) as total_replies FROM feed_replies WHERE feed_id=91893 18 Query SELECT m.*, m.member_id as my_member_id,p.*,pp.*,g.*,ccb.cache_content FROM members m LEFT JOIN pfields_content p ON ( p.member_id=m.member_id ) LEFT JOIN profile_portal pp ON ( pp.pp_member_id=m.member_id ) LEFT JOIN groups g ON ( g.g_id=m.member_group_id ) LEFT JOIN content_cache_sigs ccb ON ( ccb.cache_content_id=m.member_id ) WHERE m.member_id=78558 18 Query SELECT count(reply_id) as total_replies FROM feed_replies WHERE feed_id=91892 18 Query SELECT m.*, m.member_id as my_member_id,p.*,pp.*,g.*,ccb.cache_content FROM members m LEFT JOIN pfields_content p ON ( p.member_id=m.member_id ) LEFT JOIN profile_portal pp ON ( pp.pp_member_id=m.member_id ) LEFT JOIN groups g ON ( g.g_id=m.member_group_id ) LEFT JOIN content_cache_sigs ccb ON ( ccb.cache_content_id=m.member_id ) WHERE m.member_id=78556 18 Query SELECT count(reply_id) as total_replies FROM feed_replies WHERE feed_id=91891 18 Query SELECT m.*, m.member_id as my_member_id,p.*,pp.*,g.*,ccb.cache_content FROM members m LEFT JOIN pfields_content p ON ( p.member_id=m.member_id ) LEFT JOIN profile_portal pp ON ( pp.pp_member_id=m.member_id ) LEFT JOIN groups g ON ( g.g_id=m.member_group_id ) LEFT JOIN content_cache_sigs ccb ON ( ccb.cache_content_id=m.member_id ) WHERE m.member_id=78554 18 Query SELECT count(reply_id) as total_replies FROM feed_replies WHERE feed_id=91890 18 Query SELECT m.*, m.member_id as my_member_id,p.*,pp.*,g.*,ccb.cache_content FROM members m LEFT JOIN pfields_content p ON ( p.member_id=m.member_id ) LEFT JOIN profile_portal pp ON ( pp.pp_member_id=m.member_id ) LEFT JOIN groups g ON ( g.g_id=m.member_group_id ) LEFT JOIN content_cache_sigs ccb ON ( ccb.cache_content_id=m.member_id ) WHERE m.member_id=78544 18 Query SELECT count(reply_id) as total_replies FROM feed_replies WHERE feed_id=91889 18 Query SELECT m.*, m.member_id as my_member_id,p.*,pp.*,g.*,ccb.cache_content FROM members m LEFT JOIN pfields_content p ON ( p.member_id=m.member_id ) LEFT JOIN profile_portal pp ON ( pp.pp_member_id=m.member_id ) LEFT JOIN groups g ON ( g.g_id=m.member_group_id ) LEFT JOIN content_cache_sigs ccb ON ( ccb.cache_content_id=m.member_id ) WHERE m.member_id=78541 18 Query SELECT count(reply_id) as total_replies FROM feed_replies WHERE feed_id=91888 18 Query SELECT m.*, m.member_id as my_member_id,p.*,pp.*,g.*,ccb.cache_content FROM members m LEFT JOIN pfields_content p ON ( p.member_id=m.member_id ) LEFT JOIN profile_portal pp ON ( pp.pp_member_id=m.member_id ) LEFT JOIN groups g ON ( g.g_id=m.member_group_id ) LEFT JOIN content_cache_sigs ccb ON ( ccb.cache_content_id=m.member_id ) WHERE m.member_id=78539 18 Query SELECT count(reply_id) as total_replies FROM feed_replies WHERE feed_id=91887 18 Query SELECT m.*, m.member_id as my_member_id,p.*,pp.*,g.*,ccb.cache_content FROM members m LEFT JOIN pfields_content p ON ( p.member_id=m.member_id ) LEFT JOIN profile_portal pp ON ( pp.pp_member_id=m.member_id ) LEFT JOIN groups g ON ( g.g_id=m.member_group_id ) LEFT JOIN content_cache_sigs ccb ON ( ccb.cache_content_id=m.member_id ) WHERE m.member_id=78533 18 Query SELECT count(reply_id) as total_replies FROM feed_replies WHERE feed_id=91886 18 Query SELECT m.*, m.member_id as my_member_id,p.*,pp.*,g.*,ccb.cache_content FROM members m LEFT JOIN pfields_content p ON ( p.member_id=m.member_id ) LEFT JOIN profile_portal pp ON ( pp.pp_member_id=m.member_id ) LEFT JOIN groups g ON ( g.g_id=m.member_group_id ) LEFT JOIN content_cache_sigs ccb ON ( ccb.cache_content_id=m.member_id ) WHERE m.member_id=78532 18 Query SELECT count(reply_id) as total_replies FROM feed_replies WHERE feed_id=91885 130602 5:22:25 18 Quit 130602 5:22:26 19 Connect root@localhost on nimfoman_ipb 19 Query set autocommit=1 19 Query SELECT * FROM cache_store WHERE cs_key IN ( 'systemvars','login_methods','vnums','app_cache','navigation_tabs','module_cache','hooks','useragents','useragentgroups','skinsets','outputformats','skin_remap','group_cache','settings','lang_data','banfilters','stats','badwords','bbcode','mediatag','profilefields','rss_output_cache','rss_export','meta_tags','ipseo_acronyms','attachtypes','multimod','moderators','announcements','report_cache','report_plugins','emoticons','ranks','reputation_levels','sharelinks','nexus_ads','fi_icons','adv_topic','ccs_menu','support_departments','chatting' ) 19 Query DELETE FROM sessions WHERE ip_address='66.249.78.131' OR id='google=d33a99969e92a82fed61e5fda9cd06ed_session' 19 Query SELECT t.*,xxx.* FROM topics t LEFT JOIN core_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('forums',';','topics',';',t.tid)) ) WHERE t.tid=6617 19 Query SELECT f.*,p.* FROM forums f LEFT JOIN permission_index p ON ( p.perm_type='forum' AND p.app='forums' AND p.perm_type_id=f.id ) 19 Query SELECT * FROM skin_cache WHERE cache_set_id=7 AND cache_type IN ('css', 'replacements') 19 Query SELECT tid FROM topics WHERE forum_id=50 AND approved=1 AND tid NOT IN(6617) AND last_post < 1343081984 AND last_post > 0 AND state != 'link' ORDER BY last_post DESC LIMIT 0,1 19 Query SELECT t.*,p.pid, p.start_date as poll_start_date, p.choices, p.starter_id as poll_starter_id, p.votes, p.poll_question, p.poll_only, p.poll_view_voters FROM topics t LEFT JOIN polls p ON ( p.tid=t.tid ) WHERE t.tid=7279 19 Query SELECT MIN(pid) as pid FROM posts WHERE topic_id=7279 AND post_date > 0 AND queued=0 LIMIT 0,1 19 Query SELECT COUNT(*) as posts FROM posts WHERE topic_id=7279 AND pid <= 60659 AND queued=0 19 Query INSERT INTO sessions (`id`,`member_name`,`member_id`,`member_group`,`login_type`,`running_time`,`ip_address`,`browser`,`in_error`,`current_appcomponent`,`current_module`,`current_section`,`location_1_type`,`location_1_id`,`location_2_type`,`location_2_id`,`location_3_type`,`location_3_id`,`uagent_key`,`uagent_version`,`uagent_type`,`uagent_bypass`) VALUES('google=d33a99969e92a82fed61e5fda9cd06ed_session','Google',0,2,0,1370143346,'66.249.78.131','Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)',0,'forums','forums','topics','topic',6617,'forum',0,'',0,'google',0,'search',0) 19 Query INSERT INTO spider_logs (`bot`,`request_addr`,`ip_address`,`entry_date`) VALUES('google','/forum/topic/6617-0744163227-0754840084-anaeu2009yahoocom/?view=getnextunread','66.249.78.131',1370143346) 19 Quit 130602 5:22:27 20 Connect root@localhost on nimfoman_ipb 20 Query set autocommit=1 20 Query SELECT * FROM cache_store WHERE cs_key IN ( 'systemvars','login_methods','vnums','app_cache','navigation_tabs','module_cache','hooks','useragents','useragentgroups','skinsets','outputformats','skin_remap','group_cache','settings','lang_data','banfilters','stats','badwords','bbcode','mediatag','profilefields','rss_output_cache','rss_export','meta_tags','ipseo_acronyms','attachtypes','multimod','moderators','announcements','report_cache','report_plugins','emoticons','ranks','reputation_levels','sharelinks','nexus_ads','fi_icons','adv_topic','ccs_menu','support_departments','chatting' ) 20 Query DELETE FROM sessions WHERE ip_address='66.249.78.131' OR id='google=fd61e5de4a3718c1c96a0394a7ba8fed_session' 20 Query SELECT t.*,xxx.* FROM topics t LEFT JOIN core_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('forums',';','topics',';',t.tid)) ) WHERE t.tid=8633 20 Query SELECT f.*,p.* FROM forums f LEFT JOIN permission_index p ON ( p.perm_type='forum' AND p.app='forums' AND p.perm_type_id=f.id ) 20 Query SELECT * FROM skin_cache WHERE cache_set_id=7 AND cache_type IN ('css', 'replacements') 20 Query SELECT * FROM topic_ratings WHERE rating_tid=8633 and rating_member_id=0 20 Query SELECT MIN(pid) as pid FROM posts WHERE topic_id=8633 AND post_date > 0 AND queued=0 LIMIT 0,1 20 Query SELECT COUNT(*) as posts FROM posts WHERE topic_id=8633 AND pid <= 75869 AND queued=0 20 Query INSERT INTO sessions (`id`,`member_name`,`member_id`,`member_group`,`login_type`,`running_time`,`ip_address`,`browser`,`in_error`,`current_appcomponent`,`current_module`,`current_section`,`location_1_type`,`location_1_id`,`location_2_type`,`location_2_id`,`location_3_type`,`location_3_id`,`uagent_key`,`uagent_version`,`uagent_type`,`uagent_bypass`) VALUES('google=fd61e5de4a3718c1c96a0394a7ba8fed_session','Google',0,2,0,1370143347,'66.249.78.131','Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)',0,'forums','forums','topics','topic',8633,'forum',0,'',0,'google',0,'search',0) 20 Query INSERT INTO spider_logs (`bot`,`request_addr`,`ip_address`,`entry_date`) VALUES('google','/forum/topic/8633-0723120478-milf-roscata-camera-de-comert/?view=getnewpost','66.249.78.131',1370143347) 20 Quit 130602 5:22:28 21 Connect root@localhost on nimfoman_ipb 21 Query set autocommit=1 21 Query SELECT * FROM cache_store WHERE cs_key IN ( 'systemvars','login_methods','vnums','app_cache','navigation_tabs','module_cache','hooks','useragents','useragentgroups','skinsets','outputformats','skin_remap','group_cache','settings','lang_data','banfilters','stats','badwords','bbcode','mediatag','profilefields','rss_output_cache','rss_export','meta_tags','ipseo_acronyms','report_cache','report_plugins','ranks','emoticons','reputation_levels','attachtypes','nexus_ads','fi_icons','adv_topic','ccs_menu','support_departments','chatting' ) 21 Query SELECT * FROM sessions WHERE id='359f9aaa236a056a7658cbdd61122eb5' 21 Query SELECT * FROM skin_cache WHERE cache_set_id=7 AND cache_type IN ('css', 'replacements') 21 Query SELECT * FROM skin_cache WHERE cache_set_id=7 AND cache_value_1='skin_forums_global' 21 Query SELECT * FROM cache_store WHERE cs_key IN ( 'promenu' ) 21 Query UPDATE sessions SET member_name='',member_id=0,member_group=2,login_type=0,running_time=1370143347,in_error=1,current_appcomponent='core',current_module='search',current_section='',location_1_type='',location_1_id=0,location_2_type='',location_2_id=0,location_3_type='',location_3_id=0,uagent_key='mozilla',uagent_version=5,uagent_type='browser' WHERE id='359f9aaa236a056a7658cbdd61122eb5' 21 Quit 22 Connect root@localhost on nimfoman_ipb 22 Query set autocommit=1 22 Query SELECT * FROM cache_store WHERE cs_key IN ( 'systemvars','login_methods','vnums','app_cache','navigation_tabs','module_cache','hooks','useragents','useragentgroups','skinsets','outputformats','skin_remap','group_cache','settings','lang_data','banfilters','stats','badwords','bbcode','mediatag','profilefields','rss_output_cache','rss_export','meta_tags','ipseo_acronyms','attachtypes','multimod','moderators','announcements','report_cache','report_plugins','emoticons','ranks','reputation_levels','sharelinks','nexus_ads','fi_icons','adv_topic','ccs_menu','support_departments','chatting' ) 22 Query SELECT * FROM sessions WHERE id='00fce27f7092a25c32a856e76a7a00be' 22 Query SELECT m.*, m.member_id as my_member_id,p.*,pp.*,g.*,ccb.cache_content FROM members m LEFT JOIN pfields_content p ON ( p.member_id=m.member_id ) Will be back with details from mysqltuner tonight since i cannot run the script now. :sweat:
mark2012 Posted June 22, 2013 Author Posted June 22, 2013 These are the details from mysqltuner.pl -------- General Statistics -------------------------------------------------- [--] Skipped version check for MySQLTuner script [OK] Currently running supported MySQL version 5.1.67 [OK] Operating on 64-bit architecture -------- Storage Engine Statistics ------------------------------------------- [--] Status: -Archive -BDB -Federated +InnoDB -ISAM -NDBCluster [--] Data in MyISAM tables: 511M (Tables: 1858) [--] Data in InnoDB tables: 1G (Tables: 550) [--] Data in MEMORY tables: 248K (Tables: 2) [!!] Total fragmented tables: 678 -------- Security Recommendations ------------------------------------------- [!!] User 'root@127.0.0.1' has no password set. [!!] User 'root@x144' has no password set. -------- Performance Metrics ------------------------------------------------- [--] Up for: 18d 15h 59m 35s (141M q [87.473 qps], 6M conn, TX: 7436B, RX: 32B) [--] Reads / Writes: 67% / 33% [--] Total buffers: 346.0M global + 2.7M per thread (1024 max threads) [OK] Maximum possible memory usage: 3.1G (19% of installed RAM) [OK] Slow queries: 0% (77/141M) [OK] Highest usage of available connections: 21% (222/1024) [OK] Key buffer size / total MyISAM indexes: 8.0M/318.6M [OK] Key buffer hit rate: 99.1% (2B cached / 19M reads) [OK] Query cache efficiency: 50.8% (52M cached / 102M selects) [!!] Query cache prunes per day: 189006 [OK] Sorts requiring temporary tables: 4% (151K temp sorts / 3M sorts) [!!] Joins performed without indexes: 211923 [OK] Temporary tables created on disk: 17% (651K on disk / 3M total) [OK] Thread cache hit rate: 96% (219K created / 6M connections) [!!] Table cache hit rate: 0% (64 open / 3M opened) [OK] Open file limit used: 0% (21/5K) [OK] Table locks acquired immediately: 99% (152M immediate / 152M locks) [!!] InnoDB data size / buffer pool: 1.6G/256.0M -------- Recommendations ----------------------------------------------------- General recommendations: Run OPTIMIZE TABLE to defragment tables for better performance Enable the slow query log to troubleshoot bad queries Adjust your join queries to always utilize indexes Increase table_cache gradually to avoid file descriptor limits Variables to adjust: query_cache_size (> 64M) join_buffer_size (> 128.0K, or always use indexes with joins) table_cache (> 64) innodb_buffer_pool_size (>= 1G) [root@x144 ~]#
mark2012 Posted June 22, 2013 Author Posted June 22, 2013 ok, i have adjusted these variables and my.conf looks like this now: #--------------------------------------------------------------------- # This file is part of iRedMail, which is an open source mail server # solution for Red Hat® Enterprise Linux, CentOS, Debian and Ubuntu. # # iRedMail is free software: you can redistribute it and/or modify # it under the terms of the GNU General Public License as published by # the Free Software Foundation, either version 3 of the License, or # (at your option) any later version. # # iRedMail is distributed in the hope that it will be useful, # but WITHOUT ANY WARRANTY; without even the implied warranty of # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the # GNU General Public License for more details. # # You should have received a copy of the GNU General Public License # along with iRedMail. If not, see <http://www.gnu.org/licenses/>. #--------------------------------------------------------------------- # # Sample MySQL configuration file. It should be localted at: # # - RHEL/CentOS: /etc/my.cnf # # Shipped within iRedMail project: # http://www.iredmail.org/ # [mysqld] #bind-address = 127.0.0.1 port = 3306 #default-character-set = utf8 datadir = /var/lib/mysql socket = /var/lib/mysql/mysql.sock user = mysql #log = /var/log/mysql.log #log-slow-queries #Loguri incete de mysql #log = /var/log/mysql_slow.log #log-slow-queries innodb_buffer_pool_size=2G join_buffer_size=1000K key_buffer_size=500M table_cache = 128 # Default to using old password format for compatibility with mysql 3.x # clients (those using the mysqlclient10 compatibility package). old_passwords=1 skip-locking #skip-bdb #skip-networking query-cache-type = 1 # Use up to 64Mb of RAM to store query results. query-cache-size = 128M query_cache_limit = 10M thread_cache_size = 8 set-variable = max_connections=1024 #set-variable = max_connect_errors=150 set-variable = max_allowed_packet=500M # If you got error message like "The total number of locks exceeds the lock table size", # please try to increase 'innodb_buffer_pool_size' to a reasonable value. # Restarting MySQL server is required to make new value work. # You can get current value with SQL command: # # mysql> SHOW ENGINE INNODB STATUS G # [...] # Buffer pool size 512 # [...] # #set-variable=innodb_buffer_pool_size=512M #ssl-ca = ssl-cert = /etc/pki/tls/certs/iRedMail_CA.pem ssl-key = /etc/pki/tls/private/iRedMail.key ssl-cipher = ALL [client] default-character-set=utf8 [mysql.server] user = mysql basedir = /var/lib [mysqld_safe] log-error = /var/log/mysqld.log pid-file = /var/run/mysqld/mysqld.pid Now the perl script return this message: [root@x144 ~]# ./mysqltuner.pl >> MySQLTuner 1.2.0 - Major Hayden <major@mhtx.net> >> Bug reports, feature requests, and downloads at http://mysqltuner.com/ >> Run with '--help' for additional options and output filtering Please enter your MySQL administrative login: root Please enter your MySQL administrative password: -------- General Statistics -------------------------------------------------- [--] Skipped version check for MySQLTuner script [OK] Currently running supported MySQL version 5.1.67 [OK] Operating on 64-bit architecture -------- Storage Engine Statistics ------------------------------------------- [--] Status: -Archive -BDB -Federated +InnoDB -ISAM -NDBCluster [--] Data in MyISAM tables: 511M (Tables: 1858) [--] Data in InnoDB tables: 1G (Tables: 550) [--] Data in MEMORY tables: 0B (Tables: 2) [!!] Total fragmented tables: 679 -------- Security Recommendations ------------------------------------------- [!!] User 'root@127.0.0.1' has no password set. [!!] User 'root@x144' has no password set. -------- Performance Metrics ------------------------------------------------- [--] Up for: 7s (476 q [68.000 qps], 35 conn, TX: 20M, RX: 96K) [--] Reads / Writes: 79% / 21% [--] Total buffers: 2.6G global + 3.6M per thread (1024 max threads) [OK] Maximum possible memory usage: 6.2G (40% of installed RAM) [OK] Slow queries: 0% (0/476) [OK] Highest usage of available connections: 0% (7/1024) [OK] Key buffer size / total MyISAM indexes: 500.0M/318.6M [!!] Key buffer hit rate: 74.9% (1K cached / 385 reads) [OK] Query cache efficiency: 38.5% (135 cached / 351 selects) [OK] Query cache prunes per day: 0 [OK] Sorts requiring temporary tables: 0% (0 temp sorts / 17 sorts) [OK] Temporary tables created on disk: 18% (3 on disk / 16 total) [OK] Thread cache hit rate: 80% (7 created / 35 connections) [OK] Table cache hit rate: 93% (93 open / 100 opened) [OK] Open file limit used: 1% (89/5K) [OK] Table locks acquired immediately: 100% (572 immediate / 572 locks) [OK] InnoDB data size / buffer pool: 1.6G/2.0G -------- Recommendations ----------------------------------------------------- General recommendations: Run OPTIMIZE TABLE to defragment tables for better performance MySQL started within last 24 hours - recommendations may be inaccurate Enable the slow query log to troubleshoot bad queries [root@x144 ~]#
AlexJ Posted June 22, 2013 Posted June 22, 2013 Monitor for 24 hrs... and then try below config. Change your session table to memory and see how it goes. [mysqld] #bind-address = 127.0.0.1 port = 3306 datadir = /var/lib/mysql socket = /var/lib/mysql/mysql.sock user = mysql #log = /var/log/mysql.log #log-slow-queries #slow sql logs #log = /var/log/mysql_slow.log #log-slow-queries innodb_buffer_pool_size=256M # Default to using old password format for compatibility with mysql 3.x # clients (those using the mysqlclient10 compatibility package). old_passwords=1 skip-locking #skip-bdb #skip-networking query-cache-type = 1 query-cache-size = 128M query_cache_limit = 10M thread_cache_size = 8 interactive_timeout = 60 connect_timeout = 30 wait_timeout = 60 max_connections=512 max_allowed_packet=128M innodb_buffer_pool_size=2G innodb_flush_log_at_trx_commit = 2 innodb_flush_method = O_DIRECT join_buffer_size=2M key_buffer_size=512M table_cache = 1024 #innodb_log_file_size = 512M #ssl-ca = ssl-cert = /etc/pki/tls/certs/iRedMail_CA.pem ssl-key = /etc/pki/tls/private/iRedMail.key ssl-cipher = ALL [client] default-character-set=utf8 [mysql.server] user = mysql basedir = /var/lib [mysqld_safe] log-error = /var/log/mysqld.log pid-file = /var/run/mysqld/mysqld.pid
Machsterdaemon Posted June 22, 2013 Posted June 22, 2013 Have you really enabled the slow query log? You have that option commented in the option file, and it also needs to be corrected if you enable it, as the one you have commented in that file is deprecated for your version of MySQL. From version 5.1.29, it should be: slow-query-log which will enable it. You can also enable it with an argument of 1, like this: slow-query-log=1 slow query log file location entry should be like this: slow_query_log_file=your-slow-query-logfile-location You should have long_query_time option to change the default value of 10 (seconds) like this: long_query_time=your-value example options for all of the above: logging slow queries taking 1 sec or longer: slow-query-log=1 slow_query_log_file=your-file-location long_query_time=1
mark2012 Posted June 24, 2013 Author Posted June 24, 2013 Hell guys and thans for answering. @Alex After monitoring ,the error still continues , unfortunely. @Oplosium Yep, i have activated the slow log querry and after the file reached 4 gb i have stopped it. Part from the log posted above is from the slow query log :)
Machsterdaemon Posted June 24, 2013 Posted June 24, 2013 Hell guys and thans for answering. @Alex After monitoring ,the error still continues , unfortunely. @Oplosium Yep, i have activated the slow log querry and after the file reached 4 gb i have stopped it. Part from the log posted above is from the slow query log :smile: It seems to be the general query log you posted rather than the slow query log where you get the slow query time. I think it should be safe to enable the slow query log and have it enabled at all times. You can of course flush it when needed. update: this is an example of slow query log entry: # Time: 130624 0:30:03 # User@Host: root[root] @ localhost [] # Query_time: 1.176879 Lock_time: 0.000085 Rows_sent: 14 Rows_examined: 550 SET timestamp=1372033803; SELECT TABLE_SCHEMA as DB,SUM(DATA_LENGTH)+SUM(INDEX_LENGTH) AS SPACEUSED from information_schema.tables GROUP BY TABLE_SCHEMA;
AlexJ Posted June 25, 2013 Posted June 25, 2013 Hell guys and thans for answering. @Alex After monitoring ,the error still continues , unfortunely. The errors should be named something like this in /cache/ folder. sql_error_log_06_24_13.cgi Post the SQL error and we can look into it.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.