i[root@rab-sites log]# more mysql.log /usr/libexec/mysqld, Version: 5.0.77-log (Source distribution). started with: Tcp port: 0 Unix socket: /var/lib/mysql/mysql.sock Time Id Command Argument 100911 12:17:34 1 Connect UNKNOWN_MYSQL_US@localhost as anonymous on 1 Quit 100911 12:17:48 2 Connect cms@localhost on 2 Query SET NAMES 'utf8' COLLATE 'utf8_general_ci' 2 Init DB wpmu_cms 2 Query SELECT blog_id FROM wp_domain_mapping WHERE domain = 'sites.olt.ubc.ca' ORDER BY CHAR_LENGTH(domain) DESC LIMIT 1 2 Query SELECT meta_key, meta_value FROM wp_sitemeta WHERE meta_key IN ('site_name', 'siteurl', 'active_sitewide_plugins', '_site_tr ansient_timeout_theme_roots', '_site_transient_theme_roots', 'site_admins', 'das hboard_blog', 'can_compress_scripts', 'global_terms_enabled') AND site_id = 1 2 Query SELECT * FROM wp_blogs WHERE domain = 'sites .olt.ubc.ca' 2 Query SELECT option_name, option_value FROM wp_1_o ptions WHERE autoload = 'yes' 100911 12:17:49 2 Query SELECT meta_value FROM wp_sitemeta WHERE met a_key = 'ra_network_privacy' AND site_id = 1 2 Query SELECT option_value FROM wp_1_options WHERE option_name = 'stats_url' LIMIT 1 2 Query UPDATE `wp_1_options` SET `option_value` = ' 1284232669' WHERE `option_name` = '_transient_doing_cron' 2 Query SELECT meta_value FROM wp_sitemeta WHERE meta_key = 'fileupload_maxk' AND site_id = 1 2 Query show tables like 'wp_cwl_invitation' 2 Query SELECT option_value FROM wp_1_options WHERE option_name = 'wp_latex' LIMIT 1 2 Query SELECT option_value FROM wp_1_options WHERE option_name = 'section-widget-settings' LIMIT 1 2 Query SELECT wp_1_posts.* FROM wp_1_posts WHERE 1=1 AND wp_1_posts.ID = 935 AND wp_1_posts.post_type = 'page' ORDER BY wp_1_posts.post_date DESC 2 Query SELECT t.*, tt.*, tr.object_id FROM wp_1_terms AS t INNER JOIN wp_1_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_1_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (935) ORDER BY t.name ASC 2 Query SELECT post_id, meta_key, meta_value FROM wp_1_postmeta WHERE post_id IN (935) 2 Query SELECT meta_value FROM wp_sitemeta WHERE meta_key = 'dm_hash' AND site_id = 1 2 Quit 3 Connect cms@localhost on 3 Query SET NAMES 'utf8' COLLATE 'utf8_general_ci' 3 Init DB wpmu_cms 3 Query SELECT blog_id FROM wp_domain_mapping WHERE domain = 'elearning.sites.olt.ubc.ca' ORDER BY CHAR_LENGTH(domain) DESC LIMIT 1 3 Query SELECT meta_key, meta_value FROM wp_sitemeta WHERE meta_key IN ('site_name', 'siteurl', 'active_sitewide_plugins', '_site_transient_timeout_theme_roots', '_site_transient_theme_roots', 'site_admins', 'dashboard_blog', 'can_compress_scripts', 'global_terms_enabled') AND site_id = 1 4 Connect cms@localhost on 4 Query SET NAMES 'utf8' COLLATE 'utf8_general_ci' 4 Init DB wpmu_cms 4 Query SELECT blog_id FROM wp_domain_mapping WHERE domain = 'elearning.sites.olt.ubc.ca' ORDER BY CHAR_LENGTH(domain) DESC LIMIT 1 3 Query SELECT * FROM wp_blogs WHERE domain = 'elearning.sites.olt.ubc.ca' 3 Quit 4 Query SELECT meta_key, meta_value FROM wp_sitemeta WHERE meta_key IN ('site_name', 'siteurl', 'active_sitewide_plugins', '_site_transient_timeout_theme_roots', '_site_transient_theme_roots', 'site_admins', 'dashboard_blog', 'can_compress_scripts', 'global_terms_enabled') AND site_id = 1 4 Query SELECT * FROM wp_blogs WHERE domain = 'elearning.sites.olt.ubc.ca' 4 Quit 100911 12:17:51 5 Connect cms@localhost on 5 Query SET NAMES 'utf8' COLLATE 'utf8_general_ci' 5 Init DB wpmu_cms 5 Query SELECT blog_id FROM wp_domain_mapping WHERE domain = 'elearning.sites.olt.ubc.ca' ORDER BY CHAR_LENGTH(domain) DESC LIMIT 1 5 Query SELECT meta_key, meta_value FROM wp_sitemeta WHERE meta_key IN ('site_name', 'siteurl', 'active_sitewide_plugins', '_site_transient_timeout_theme_roots', '_site_transient_theme_roots', 'site_admins', 'dashboard_blog', 'can_compress_scripts', 'global_terms_enabled') AND site_id = 1 5 Query SELECT * FROM wp_blogs WHERE domain = 'elearning.sites.olt.ubc.ca' 5 Quit 6 Connect cms@localhost on 6 Query SET NAMES 'utf8' COLLATE 'utf8_general_ci' 6 Init DB wpmu_cms 6 Query SELECT blog_id FROM wp_domain_mapping WHERE domain = 'elearning.sites.olt.ubc.ca' ORDER BY CHAR_LENGTH(domain) DESC LIMIT 1 6 Query SELECT meta_key, meta_value FROM wp_sitemeta WHERE meta_key IN ('site_name', 'siteurl', 'active_sitewide_plugins', '_site_transient_timeout_theme_roots', '_site_transient_theme_roots', 'site_admins', 'dashboard_blog', 'can_compress_scripts', 'global_terms_enabled') AND site_id = 1 6 Query SELECT * FROM wp_blogs WHERE domain = 'elearning.sites.olt.ubc.ca' 6 Quit 7 Connect cms@localhost on 7 Query SET NAMES 'utf8' COLLATE 'utf8_general_ci' 7 Init DB wpmu_cms 7 Query SELECT blog_id FROM wp_domain_mapping WHERE domain = 'elearning.sites.olt.ubc.ca' ORDER BY CHAR_LENGTH(domain) DESC LIMIT 1 7 Query SELECT meta_key, meta_value FROM wp_sitemeta WHERE meta_key IN ('site_name', 'siteurl', 'active_sitewide_plugins', '_site_transient_timeout_theme_roots', '_site_transient_theme_roots', 'site_admins', 'dashboard_blog', 'can_compress_scripts', 'global_terms_enabled') AND site_id = 1 7 Query SELECT * FROM wp_blogs WHERE domain = 'elearning.sites.olt.ubc.ca' 7 Quit 8 Connect cms@localhost on 8 Query SET NAMES 'utf8' COLLATE 'utf8_general_ci' 8 Init DB wpmu_cms 8 Query SELECT blog_id FROM wp_domain_mapping WHERE domain = 'elearning.sites.olt.ubc.ca' ORDER BY CHAR_LENGTH(domain) DESC LIMIT 1 8 Query SELECT meta_key, meta_value FROM wp_sitemeta WHERE meta_key IN ('site_name', 'siteurl', 'active_sitewide_plugins', '_site_transient_timeout_theme_roots', '_site_transient_theme_roots', 'site_admins', 'dashboard_blog', 'can_compress_scripts', 'global_terms_enabled') AND site_id = 1 8 Query SELECT * FROM wp_blogs WHERE domain = 'elearning.sites.olt.ubc.ca' 8 Quit