Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 3 of 3
  1. #1
    New Coder
    Join Date
    Apr 2011
    Posts
    38
    Thanks
    4
    Thanked 0 Times in 0 Posts

    I need a mySQL expert very badly.

    my site has serious database problems, here are the queries i am getting that are locking up the site and bringing it repatedly down

    Code:
    +---------+---------------+-----------+-------------+---------+------+----------------------+------------------------------------------------------------------------------------------------------+
    | Id | User | Host | db | Command | Time | State | Info |
    +---------+---------------+-----------+-------------+---------+------+----------------------+------------------------------------------------------------------------------------------------------+
    | 5713272 | warrior_acorn | localhost | warrior_smf | Query | 232 | Locked | SELECT t.id_topic, m.subject, t.id_board
    FROM smf_topics AS t
    INNER JOIN smf_messages AS m ON |
    | 5713273 | warrior_acorn | localhost | warrior_smf | Query | 232 | Locked | SELECT COUNT(*)
    FROM smf_topics AS t
    LEFT JOIN smf_log_boards AS lb ON (lb.id_board = 520 A |
    | 5713274 | warrior_acorn | localhost | warrior_smf | Query | 232 | Locked | SELECT
    IFNULL(lo.log_time, 0) AS is_online, IFNULL(a.id_attach, 0) AS id_attach, a.filename, a.at |
    | 5713275 | warrior_acorn | localhost | warrior_smf | Query | 233 | Locked | SELECT
    IFNULL(lo.log_time, 0) AS is_online, IFNULL(a.id_attach, 0) AS id_attach, a.filename, a.at |
    | 5713276 | warrior_acorn | localhost | warrior_smf | Query | 233 | Locked | SELECT
    
    t.id_topic, t.num_replies, t.locked, t.num_views, t.id_board, b.name AS board_name,
    
    I |
    | 5713277 | warrior_acorn | localhost | warrior_smf | Query | 232 | Locked | SELECT t.id_topic, m.subject, t.id_board
    FROM smf_topics AS t
    INNER JOIN smf_messages AS m ON |
    | 5713278 | warrior_acorn | localhost | warrior_smf | Query | 233 | Locked | REPLACE INTO smf_log_topics(`id_member`, `id_topic`, `id_msg`)
    VALUES
    (41168, 342441, 9330477) |
    | 5713279 | warrior_acorn | localhost | warrior_smf | Query | 232 | Locked | SELECT t.id_topic, m.subject, t.id_board
    FROM smf_topics AS t
    INNER JOIN smf_messages AS m ON |
    | 5713280 | warrior_acorn | localhost | warrior_smf | Query | 233 | Locked | INSERT INTO smf_messages(`id_board`, `id_topic`, `id_member`, `subject`, `body`, `poster_name`, `pos |
    | 5713281 | warrior_acorn | localhost | warrior_smf | Query | 233 | Locked | SELECT
    p.question, p.voting_locked, p.hide_results, p.expire_time, p.max_votes, p.change_vote,
    |
    | 5713282 | warrior_acorn | localhost | warrior_smf | Query | 232 | Locked | INSERT IGNORE INTO smf_log_topics(`id_member`, `id_topic`, `id_msg`)
    VALUES
    (40315, 347784, 933 |
    | 5713283 | warrior_acorn | localhost | warrior_smf | Query | 232 | Locked | SELECT m.subject, IFNULL(mem.real_name, m.poster_name) AS poster_name, m.poster_time, m.body
    FRO |
    | 5713284 | warrior_acorn | localhost | warrior_smf | Query | 233 | Locked | SELECT
    lo.id_member, lo.log_time, mem.real_name, mem.member_name, mem.show_online,
    mg.online |
    | 5713285 | warrior_acorn | localhost | warrior_smf | Query | 232 | Locked | SELECT
    ms.subject AS first_subject, ms.poster_time AS first_poster_time, ms.id_topic, t.id_boar |
    | 5713286 | warrior_acorn | localhost | warrior_smf | Query | 232 | Locked | SELECT IFNULL(mem.real_name, m.poster_name) AS poster_name, m.poster_time, m.body, m.smileys_enabled |
    | 5713287 | warrior_acorn | localhost | warrior_smf | Query | 232 | Locked | SELECT mem.id_member, mem.real_name, mem.member_name, mem.is_shareable
    FROM smf_members AS mem
    |
    | 5713288 | warrior_acorn | localhost | warrior_smf | Query | 233 | Locked | UPDATE smf_members
    SET unread_messages = 0
    WHERE id_member = 22869 |
    | 5713289 | warrior_acorn | localhost | warrior_smf | Query | 232 | Locked | UPDATE smf_messages
    SET id_msg_modified = 9330486
    WHERE id_msg = 9330486 |
    | 5713290 | warrior_acorn | localhost | warrior_smf | Query | 232 | Locked | SELECT
    IFNULL(lo.log_time, 0) AS is_online, IFNULL(a.id_attach, 0) AS id_attach, a.filename, a.at |
    | 5713291 | warrior_acorn | localhost | warrior_smf | Query | 232 | Locked | INSERT IGNORE INTO smf_log_topics(`id_member`, `id_topic`, `id_msg`)
    VALUES
    (37830, 347815, 933 |
    | 5713292 | warrior_acorn | localhost | warrior_smf | Query | 233 | Locked | REPLACE INTO smf_log_topics(`id_member`, `id_topic`, `id_msg`)
    VALUES
    (18789, 331337, 9330477) |
    | 5713293 | warrior_acorn | localhost | warrior_smf | Query | 233 | Locked | SELECT
    IFNULL(lo.log_time, 0) AS is_online, IFNULL(a.id_attach, 0) AS id_attach, a.filename, a.at |
    | 5713294 | warrior_acorn | localhost | warrior_smf | Query | 232 | Locked | UPDATE smf_members
    SET last_login = 1327369591, member_ip = '99.100.6.105', member_ip2 = '99.100.6 |
    | 5713295 | warrior_acorn | localhost | warrior_smf | Query | 232 | Locked | SELECT IFNULL(lt.id_msg, IFNULL(lmr.id_msg, -1)) + 1 AS new_from
    FROM smf_topics AS t
    LEF |
    | 5713296 | warrior_acorn | localhost | warrior_smf | Query | 233 | Locked | SELECT
    lo.id_member, lo.log_time, mem.real_name, mem.member_name, mem.show_online,
    mg.online |
    | 5713297 | warrior_acorn | localhost | warrior_smf | Query | 232 | Locked | SELECT IFNULL(mem.real_name, m.poster_name) AS poster_name, m.poster_time, m.body, m.smileys_enabled |
    | 5713298 | warrior_acorn | localhost | warrior_smf | Query | 232 | Locked | UPDATE smf_members
    SET last_login = 1327369591, member_ip = '173.71.210.228', member_ip2 = '173.71 |
    | 5713299 | warrior_acorn | localhost | warrior_smf | Query | 232 | Locked | REPLACE INTO smf_log_topics(`id_member`, `id_topic`, `id_msg`)
    VALUES
    (17017, 346170, 9330477) |
    | 5713300 | warrior_acorn | localhost | warrior_smf | Query | 232 | Locked | SELECT
    pm.id_pm, CASE WHEN pm.id_pm_head = 0 THEN pm.id_pm ELSE pm.id_pm_head END AS pm_head,
    |
    | 5713301 | warrior_acorn | localhost | warrior_smf | Query | 232 | Locked | UPDATE smf_members
    SET last_login = 1327369591, member_ip = '142.167.59.244', member_ip2 = '142.16 |
    | 5713302 | warrior_acorn | localhost | warrior_smf | Query | 232 | Locked | SELECT
    p.question, p.voting_locked, p.hide_results, p.expire_time, p.max_votes, p.change_vote,
    |
    | 5713303 | warrior_acorn | localhost | warrior_smf | Query | 232 | Locked | SELECT mem.id_member, mem.real_name, mem.member_name, mem.is_shareable
    FROM smf_members AS mem
    |
    | 5713304 | warrior_acorn | localhost | warrior_smf | Query | 232 | Locked | REPLACE INTO smf_log_topics(`id_member`, `id_topic`, `id_msg`)
    VALUES
    (17017, 346170, 9330477) |
    | 5713307 | warrior_acorn | localhost | warrior_smf | Query | 232 | Locked | UPDATE smf_members
    SET last_login = 1327369591, member_ip = '99.57.180.215', member_ip2 = '99.57.1 |
    | 5713308 | warrior_acorn | localhost | warrior_smf | Query | 232 | Locked | SELECT COUNT(mem.id_member)
    FROM smf_members AS mem
    LEFT JOIN smf_subaccounts AS sub ON (sub.id |
    | 5713309 | warrior_acorn | localhost | warrior_smf | Query | 233 | Locked | SELECT
    p.question, p.voting_locked, p.hide_results, p.expire_time, p.max_votes, p.change_vote,
    |
    | 5713311 | warrior_acorn | localhost | warrior_smf | Query | 232 | Locked | UPDATE smf_messages
    SET id_msg_modified = 9330479
    WHERE id_msg = 9330479 |
    
    (42203, 290496, 9330477) |
    | 5713348 | warrior_acorn | localhost | warrior_smf | Query | 232 | Locked | SELECT mem.id_member, mem.real_name, mem.member_name, mem.is_shareable
    FROM smf_members AS mem
    |
    | 5713349 | warrior_acorn | localhost | warrior_smf | Query | 232 | Locked | SELECT
    p.question, p.voting_locked, p.hide_results, p.expire_time, p.max_votes, p.change_vote,
    |
    | 5713350 | warrior_acorn | localhost | warrior_smf | Query | 232 | Locked | UPDATE smf_messages
    SET id_msg_modified = 9330483
    WHERE id_msg = 9330483 |
    | 5713351 | warrior_acorn | localhost | warrior_smf | Query | 232 | Locked | SELECT IFNULL(mem.real_name, m.poster_name) AS poster_name, m.poster_time, m.body, m.smileys_enabled |
    | 5713352 | warrior_acorn | localhost | warrior_smf | Query | 232 | Locked | SELECT
    IFNULL(lo.log_time, 0) AS is_online, IFNULL(a.id_attach, 0) AS id_attach, a.filename, a.at |
    | 5713353 | warrior_acorn | localhost | warrior_smf | Query | 232 | Locked | UPDATE smf_members
    SET last_login = 1327369591, member_ip = '99.57.180.215', member_ip2 = '99.57.1 |
    | 5713354 | warrior_acorn | localhost | warrior_smf | Query | 233 | Locked | SELECT IFNULL(mem.real_name, m.poster_name) AS poster_name, m.poster_time, m.body, m.smileys_enabled |
    | 5713355 | warrior_acorn | localhost | warrior_smf | Query | 232 | Locked | SELECT
    mem.id_member AS id_member, mem.real_name AS real_name, mem.is_activated AS is_activated,
    |
    | 5713356 | warrior_acorn | localhost | warrior_smf | Query | 232 | Locked | SELECT id_member, real_name
    FROM smf_members
    WHERE id_member IN (4383, 32119, 29749, 41833, 29 |
    | 5713357 | warrior_acorn | localhost | warrior_smf | Query | 232 | Locked | SELECT IFNULL(mem.real_name, m.poster_name) AS poster_name, m.poster_time, m.body, m.smileys_enabled |
    | 5713358 | warrior_acorn | localhost | warrior_smf | Query | 233 | Locked | SELECT IFNULL(mem.real_name, m.poster_name) AS poster_name, m.poster_time, m.body, m.smileys_enabled |
    | 5713360 | warrior_acorn | localhost | warrior_smf | Query | 232 | Locked | SELECT
    IFNULL(lo.log_time, 0) AS is_online, IFNULL(a.id_attach, 0) AS id_attach, a.filename, a.at |
    | 5713361 | warrior_acorn | localhost | warrior_smf | Query | 232 | Locked | SELECT IFNULL(mem.real_name, m.poster_name) AS poster_name, m.poster_time, m.body, m.smileys_enabled |
    | 5713362 | warrior_acorn | localhost | warrior_smf | Query | 233 | Locked | SELECT IFNULL(lt.id_msg, IFNULL(lmr.id_msg, -1)) + 1 AS new_from
    FROM smf_topics AS t
    LEF |
    | 5713363 | warrior_acorn | localhost | warrior_smf | Query | 232 | Locked | UPDATE smf_members
    SET last_login = 1327369591, member_ip = '96.228.181.2', member_ip2 = '96.228.1 |
    | 5713364 | warrior_acorn | localhost | warrior_smf | Query | 232 | Locked | SELECT
    IFNULL(lo.log_time, 0) AS is_online, IFNULL(a.id_attach, 0) AS id_attach, a.filename, a.at |
    | 5713365 | warrior_acorn | localhost | warrior_smf | Query | 232 | Locked | UPDATE smf_messages
    SET id_msg_modified = 9330481
    WHERE id_msg = 9330481 |
    | 5713366 | warrior_acorn | localhost | warrior_smf | Query | 232 | Locked | UPDATE smf_members
    SET last_login = 1327369591, member_ip = '207.102.46.103', member_ip2 = '207.10 |
    | 5713367 | warrior_acorn | localhost | warrior_smf | Query | 233 | Locked | UPDATE smf_log_topics
    SET id_msg = 9330478
    WHERE id_member = 34804
    AND id_topic = 28126 |
    | 5713369 | warrior_acorn | localhost | warrior_smf | Query | 233 | Copying to tmp table | SELECT mem.id_member, mem.real_name, mem.money
    FROM smf_members AS mem
    LEFT JOIN smf_subaccount |
    | 5713370 | warrior_acorn | localhost | warrior_smf | Query | 233 | Locked | SELECT
    ms.subject AS first_subject, ms.poster_time AS first_poster_time, ms.id_topic, t.id_boar |
    | 5713371 | warrior_acorn | localhost | warrior_smf | Query | 232 | Locked | SELECT mem.id_member, mem.real_name, mem.member_name, mem.is_shareable
    FROM smf_members AS mem
    |
    | 5713372 | warrior_acorn | localhost | warrior_smf | Query | 232 | Locked | INSERT IGNORE INTO smf_log_topics(`id_member`, `id_topic`, `id_msg`)
    VALUES
    (40315, 347784, 933 |
    | 5713374 | warrior_acorn | localhost | warrior_smf | Query | 232 | Locked | SELECT
    IFNULL(lo.log_time, 0) AS is_online, IFNULL(a.id_attach, 0) AS id_attach, a.filename, a.at |
    | 5713375 | warrior_acorn | localhost | warrior_smf | Query | 232 | Locked | UPDATE smf_members
    SET last_login = 1327369591, member_ip = '76.30.156.90', member_ip2 = '76.30.15 |
    | 5713376 | warrior_acorn | localhost | warrior_smf | Query | 232 | Locked | SELECT
    mem.id_member AS id_member, mem.real_name AS real_name, mem.is_activated AS is_activated,
    |
    | 5713377 | warrior_acorn | localhost | warrior_smf | Query | 232 | Locked | SELECT lngfile
    FROM smf_members
    WHERE id_member = 42588 |
    | 5713379 | warrior_acorn | localhost | warrior_smf | Query | 232 | Locked | SELECT
    ms.subject AS first_subject, ms.poster_time AS first_poster_time, ms.id_topic, t.id_boar |
    | 5713380 | warrior_acorn | localhost | warrior_smf | Query | 232 | Locked | UPDATE smf_messages
    SET id_msg_modified = 9330485
    WHERE id_msg = 9330485 |
    | 5713383 | warrior_acorn | localhost | warrior_smf | Query | 233 | Locked | SELECT
    mem.id_member AS id_member, mem.real_name AS real_name, mem.is_activated AS is_activated,
    |
    | 5713384 | warrior_acorn | localhost | warrior_smf | Query | 252 | Locked | SELECT IFNULL(mem.real_name, m.poster_name) AS poster_name, m.poster_time, m.body, m.smileys_enabled |
    | 5713385 | warrior_acorn | localhost | warrior_smf | Query | 232 | Locked | SELECT
    lo.id_member, lo.log_time, mem.real_name, mem.member_name, mem.show_online,
    mg.online |
    | 5713386 | warrior_acorn | localhost | warrior_smf | Query | 233 | Locked | SELECT
    IFNULL(lo.log_time, 0) AS is_online, IFNULL(a.id_attach, 0) AS id_attach, a.filename, a.at |
    | 5713387 | warrior_acorn | localhost | warrior_smf | Query | 232 | Locked | SELECT IFNULL(mem.real_name, m.poster_name) AS poster_name, m.poster_time, m.body, m.smileys_enabled |
    | 5713388 | warrior_acorn | localhost | warrior_smf | Query | 233 | Locked | SELECT IFNULL(lt.id_msg, IFNULL(lmr.id_msg, -1)) + 1 AS new_from
    FROM smf_topics AS t
    LEF |
    | 5713390 | warrior_acorn | localhost | warrior_smf | Query | 232 | Locked | SELECT IFNULL(mem.real_name, m.poster_name) AS poster_name, m.poster_time, m.body, m.smileys_enabled |
    | 5713393 | warrior_acorn | localhost | warrior_smf | Query | 232 | Locked | SELECT id_member, real_name
    FROM smf_members
    | 5713576 | warrior_acorn | localhost | warrior_smf | Query | 232 | Locked | SELECT mem.*, IFNULL(a.id_attach, 0) AS id_attach, a.filename, a.attachment_type,
    IFNULL(sub.id |
    | 5713577 | warrior_acorn | localhost | warrior_smf | Query | 232 | Locked | SELECT mem.*, IFNULL(a.id_attach, 0) AS id_attach, a.filename, a.attachment_type,
    IFNULL(sub.id |
    | 5713578 | warrior_acorn | localhost | warrior_smf | Query | 230 | Locked | SELECT mem.*, IFNULL(a.id_attach, 0) AS id_attach, a.filename, a.attachment_type,
    IFNULL(sub.id |
    | 5713580 | warrior_acorn | localhost | warrior_smf | Query | 229 | Locked | UPDATE smf_members
    SET last_login = 1327369594, member_ip = '50.55.45.229', member_ip2 = '50.55.45 |
    | 5713581 | warrior_acorn | localhost | warrior_smf | Query | 229 | Locked | SELECT mem.*, IFNULL(a.id_attach, 0) AS id_attach, a.filename, a.attachment_type,
    IFNULL(sub.id |
    | 5713582 | warrior_acorn | localhost | warrior_smf | Query | 229 | Locked | SELECT mem.id_member, mem.real_name, mem.member_name, mem.is_shareable
    FROM smf_members AS mem
    |
    | 5713583 | warrior_acorn | localhost | warrior_smf | Query | 227 | Locked | SELECT mem.*, IFNULL(a.id_attach, 0) AS id_attach, a.filename, a.attachment_type,
    IFNULL(sub.id |
    | 5713584 | warrior_acorn | localhost | warrior_smf | Query | 223 | Locked | SELECT
    c.id_cat, b.name AS bname, b.description, b.num_topics, b.member_groups,
    b.id_parent, |
    | 5713585 | warrior_acorn | localhost | warrior_smf | Query | 221 | Locked | SELECT mem.*, IFNULL(a.id_attach, 0) AS id_attach, a.filename, a.attachment_type,
    IFNULL(sub.id |
    | 5713586 | warrior_acorn | localhost | warrior_smf | Query | 213 | Locked | SELECT mem.*, IFNULL(a.id_attach, 0) AS id_attach, a.filename, a.attachment_type,
    IFNULL(sub.id |
    | 5713587 | warrior_acorn | localhost | warrior_smf | Query | 183 | Locked | SELECT mem.*, IFNULL(a.id_attach, 0) AS id_attach, a.filename, a.attachment_type,
    IFNULL(sub.id |
    | 5713588 | warrior_acorn | localhost | warrior_smf | Query | 178 | Locked | SELECT mem.*, IFNULL(a.id_attach, 0) AS id_attach, a.filename, a.attachment_type,
    IFNULL(sub.id |
    | 5713589 | warrior_acorn | localhost | warrior_smf | Query | 177 | Locked | SELECT
    c.id_cat, b.name AS bname, b.description, b.num_topics, b.member_groups,
    b.id_parent, |
    | 5713590 | warrior_acorn | localhost | warrior_smf | Query | 174 | Locked | SELECT mem.*, IFNULL(a.id_attach, 0) AS id_attach, a.filename, a.attachment_type,
    IFNULL(sub.id |
    | 5713591 | warrior_acorn | localhost | warrior_smf | Query | 174 | Locked | SELECT mem.*, IFNULL(a.id_attach, 0) AS id_attach, a.filename, a.attachment_type,
    IFNULL(sub.id |
    | 5713592 | warrior_acorn | localhost | warrior_smf | Query | 172 | Locked | SELECT
    c.id_cat, b.name AS bname, b.description, b.num_topics, b.member_groups,
    b.id_parent, |
    | 5713593 | warrior_acorn | localhost | warrior_smf | Query | 161 | Locked | SELECT mem.*, IFNULL(a.id_attach, 0) AS id_attach, a.filename, a.attachment_type,
    IFNULL(sub.id |
    | 5713594 | warrior_acorn | localhost | warrior_smf | Query | 155 | Locked | SELECT mem.*, IFNULL(a.id_attach, 0) AS id_attach, a.filename, a.attachment_type,
    IFNULL(sub.id |
    | 5713595 | warrior_acorn | localhost | warrior_smf | Query | 155 | Locked | SELECT
    c.id_cat, b.name AS bname, b.description, b.num_topics, b.member_groups,
    b.id_parent, |
    | 5713596 | warrior_acorn | localhost | warrior_smf | Query | 120 | Locked | SELECT mem.*, IFNULL(a.id_attach, 0) AS id_attach, a.filename, a.attachment_type,
    IFNULL(sub.id |
    | 5713597 | warrior_acorn | localhost | warrior_smf | Query | 117 | Locked | SELECT mem.*, IFNULL(a.id_attach, 0) AS id_attach, a.filename, a.attachment_type,
    IFNULL(sub.id |
    | 5713598 | warrior_acorn | localhost | warrior_smf | Query | 116 | Locked | SELECT
    c.id_cat, b.name AS bname, b.description, b.num_topics, b.member_groups,
    b.id_parent, |
    | 5713599 | warrior_acorn | localhost | warrior_smf | Query | 100 | Locked | SELECT mem.*, IFNULL(a.id_attach, 0) AS id_attach, a.filename, a.attachment_type,
    IFNULL(sub.id |
    | 5713601 | warrior_acorn | localhost | warrior_smf | Query | 100 | Locked | SELECT mem.*, IFNULL(a.id_attach, 0) AS id_attach, a.filename, a.attachment_type,
    IFNULL(sub.id |
    | 5713602 | warrior_acorn | localhost | warrior_smf | Query | 84 | Locked | SELECT
    c.id_cat, b.name AS bname, b.description, b.num_topics, b.member_groups,
    b.id_parent, |
    | 5713603 | warrior_acorn | localhost | warrior_smf | Query | 84 | Locked | SELECT mem.*, IFNULL(a.id_attach, 0) AS id_attach, a.filename, a.attachment_type,
    IFNULL(sub.id |
    | 5713604 | warrior_acorn | localhost | warrior_smf | Query | 74 | Locked | SELECT
    c.id_cat, b.name AS bname, b.description, b.num_topics, b.member_groups,
    b.id_parent, |
    | 5713605 | warrior_acorn | localhost | warrior_smf | Query | 61 | Locked | SELECT mem.*, IFNULL(a.id_attach, 0) AS id_attach, a.filename, a.attachment_type,
    IFNULL(sub.id |
    | 5713608 | eximstats | localhost | eximstats | Sleep | 25 | | |
    | 5713610 | warrior_acorn | localhost | warrior_smf | Query | 19 | Locked | SELECT mem.*, IFNULL(a.id_attach, 0) AS id_attach, a.filename, a.attachment_type,
    IFNULL(sub.id |
    | 5713611 | warrior_acorn | localhost | warrior_smf | Query | 16 | Locked | SELECT mem.*, IFNULL(a.id_attach, 0) AS id_attach, a.filename, a.attachment_type,
    IFNULL(sub.id |
    | 5713613 | warrior_acorn | localhost | warrior_smf | Query | 8 | Locked | SELECT mem.*, IFNULL(a.id_attach, 0) AS id_attach, a.filename, a.attachment_type,
    IFNULL(sub.id |
    | 5713615 | root | localhost | | Query | 0 | | show processlist |
    I need serious help. I need an expert. please, anybody...

  • #2
    Regular Coder
    Join Date
    Jan 2012
    Posts
    134
    Thanks
    0
    Thanked 32 Times in 32 Posts
    Can you do a show full processlist. The normal show processlist truncates your queries so it's impossible to tell what they are doing.

    Also, while it may be possible to identify a slow query merely by the SQL statement, you often have to use other tools like explain to see what indexes SQL is using. A database structure would also be helpful.

    At least start with show full processlist and post those results.

  • #3
    New Coder
    Join Date
    Apr 2011
    Posts
    38
    Thanks
    4
    Thanked 0 Times in 0 Posts
    All right. Thank you for the response. I am going to try here. I was given this as being my full process list. I am using memcached. The tables are myISAM.

    ame, mem.is_shareable
    FROM smf_members AS mem
    LEFT JOIN smf_subaccounts AS sub ON (sub.id_member = mem.id_member)
    WHERE sub.id_parent = 18754
    |
    | 4418331 | x | localhost | warrior_smf | Query | 7 | Locked | SELECT mem.*, IFNULL(a.id_attach, 0) AS
    id_attach, a.filename, a.attachment_type,
    IFNULL(sub.id_parent, 0) as id_parent
    FROM smf_members AS mem
    LEFT JOIN smf_attachments AS a ON (a.id_member = 43318)
    LEFT JOIN smf_subaccounts AS sub ON (sub.id_member = mem.id_member)
    WHERE mem.id_member = 43318
    LIMIT 1
    |
    | 4418332 | x | localhost | x | Query | 7 | Locked | SELECT
    c.id_cat, b.name AS bname, b.description, b.num_topics, b.member_groups,
    b.id_parent, c.name AS cname, IFNULL(mem.id_member, 0) AS id_moderator,
    mem.real_name, b.id_board, b.child_level,
    b.id_theme, b.override_theme, b.count_posts, b.id_profile, b.redirect,
    b.unapproved_topics, b.unapproved_posts, t.approved, t.id_member_started, b.post_template
    FROM smf_boards AS b
    INNER JOIN smf_topics AS t ON (t.id_topic = 178270)
    LEFT JOIN smf_categories AS c ON (c.id_cat = b.id_cat)
    LEFT JOIN smf_moderators AS mods ON (mods.id_board = t.id_board)
    LEFT JOIN smf_members AS mem ON (mem.id_member = mods.id_member)
    WHERE b.id_board = t.id_board
    |
    | 4418333 | x | localhost | x | Query | 7 | Locked | SELECT mem.*, IFNULL(a.id_attach, 0) AS
    id_attach, a.filename, a.attachment_type,
    IFNULL(sub.id_parent, 0) as id_parent
    FROM smf_members AS mem
    LEFT JOIN smf_attachments AS a ON (a.id_member = 33393)
    LEFT JOIN smf_subaccounts AS sub ON (sub.id_member = mem.id_member)
    WHERE mem.id_member = 33393
    LIMIT 1
    |
    | 4418334 |x | localhost | x | Query | 7 | Locked | SELECT mem.id_member, mem.real_name,
    mem.member_name, mem.is_shareable
    FROM smf_members AS mem
    LEFT JOIN smf_subaccounts AS sub ON (sub.id_member = mem.id_member)
    WHERE sub.id_parent = 37312
    |
    | 4418335 | x | localhost | x | Query | 7 | Locked | SELECT mem.id_member, mem.real_name,
    mem.member_name, mem.is_shareable
    FROM smf_members AS mem
    LEFT JOIN smf_subaccounts AS sub ON (sub.id_member = mem.id_member)
    WHERE sub.id_parent = 27525
    |
    | 4418336 | warrior_acorn | localhost | warrior_smf | Query | 7 | Locked | SELECT mem.id_member, mem.real_name,
    mem.member_name, mem.is_shareable
    FROM smf_members AS mem
    LEFT JOIN smf_subaccounts AS sub ON (sub.id_member = mem.id_member)
    WHERE sub.id_parent = 33603
    |
    | 4418337 | x| localhost | x | Query | 7 | Locked | SELECT mem.id_member, mem.real_name,
    mem.member_name, mem.is_shareable
    FROM smf_members AS mem
    LEFT JOIN smf_subaccounts AS sub ON (sub.id_member = mem.id_member)
    WHERE sub.id_parent = 20084
    |
    | 4418338 | x | localhost | x | Query | 7 | Locked | UPDATE smf_members
    SET last_login = 1327810157, member_ip = '24.154.26.173', member_ip2 = '24.154.26.173', total_time_logged_in = 1393548
    WHERE id_member = 11103
    |
    | 4418339 | x | localhost | x | Query | 7 | Locked | SELECT mem.*, IFNULL(a.id_attach, 0) AS
    id_attach, a.filename, a.attachment_type,
    IFNULL(sub.id_parent, 0) as id_parent
    FROM smf_members AS mem
    LEFT JOIN smf_attachments AS a ON (a.id_member = 23271)
    LEFT JOIN smf_subaccounts AS sub ON (sub.id_member = mem.id_member)
    WHERE mem.id_member = 23271
    LIMIT 1
    |
    | 4418340 | x | localhost | x| Query | 7 | Locked | SELECT
    c.id_cat, b.name AS bname, b.description, b.num_topics, b.member_groups,
    b.id_parent, c.name AS cname, IFNULL(mem.id_member, 0) AS id_moderator,
    mem.real_name, b.id_board, b.child_level,
    b.id_theme, b.override_theme, b.count_posts, b.id_profile, b.redirect,
    b.unapproved_topics, b.unapproved_posts, t.approved, t.id_member_started, b.post_template
    FROM smf_boards AS b
    INNER JOIN smf_topics AS t ON (t.id_topic = 341288)
    LEFT JOIN smf_categories AS c ON (c.id_cat = b.id_cat)
    LEFT JOIN smf_moderators AS mods ON (mods.id_board = t.id_board)
    LEFT JOIN smf_members AS mem ON (mem.id_member = mods.id_member)
    WHERE b.id_board = t.id_board
    |
    | 4418341 | x | localhost | x| Query | 7 | Locked | SELECT mem.id_member, mem.real_name,
    mem.member_name, mem.is_shareable
    FROM smf_members AS mem
    LEFT JOIN smf_subaccounts AS sub ON (sub.id_member = mem.id_member)
    WHERE sub.id_parent = 21527
    |
    | 4418342 | x | localhost | x| Query | 6 | Locked | SELECT mem.id_member, mem.real_name,
    mem.member_name, mem.is_shareable
    FROM smf_members AS mem
    LEFT JOIN smf_subaccounts AS sub ON (sub.id_member = mem.id_member)
    WHERE sub.id_parent = 39045
    |
    | 4418343 | x | localhost | x | Query | 6 | Locked | SELECT mem.id_member, mem.real_name,
    mem.member_name, mem.is_shareable
    FROM smf_members AS mem
    LEFT JOIN smf_subaccounts AS sub ON (sub.id_member = mem.id_member)
    WHERE sub.id_parent = 37558
    |
    | 4418344 | x | localhost | x | Query | 6 | Locked | SELECT mem.*, IFNULL(a.id_attach, 0) AS
    id_attach, a.filename, a.attachment_type,
    IFNULL(sub.id_parent, 0) as id_parent
    FROM smf_members AS mem
    LEFT JOIN smf_attachments AS a ON (a.id_member = 15244)
    LEFT JOIN smf_subaccounts AS sub ON (sub.id_member = mem.id_member)
    WHERE mem.id_member = 15244
    LIMIT 1
    |
    | 4418345 | x | localhost | x | Query | 6 | Locked | SELECT mem.*, IFNULL(a.id_attach, 0) AS
    id_attach, a.filename, a.attachment_type,
    IFNULL(sub.id_parent, 0) as id_parent
    FROM smf_members AS mem
    LEFT JOIN smf_attachments AS a ON (a.id_member = 36868)
    LEFT JOIN smf_subaccounts AS sub ON (sub.id_member = mem.id_member)
    WHERE mem.id_member = 36868
    LIMIT 1
    Last edited by doublerainbow; 01-29-2012 at 04:23 AM. Reason: Adding more up to date info


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •