thinkbot

  • Total activity 275
  • Last activity
  • Member since
  • Following 0 users
  • Followed by 0 users
  • Votes 0
  • Subscriptions 67

Comments

Recent activity by thinkbot Recent activity Votes
    1. Community
    2. Miscellaneous
    3. mysql CPU usage too high

    adjust: tmp_table_size = 50M max_heap_table_size = 50M join_buffer_size=1M read_buffer_size=128K sort_buffer_size=2M read_rnd_buffer_size=256K table_open_cache=1024 query_cache_size=100M myisam_s...

    1. Community
    2. Miscellaneous
    3. MySQL & High Server Load

    No, I mean that on the left WHERE (DATE_FORMAT(ADDTIME(FROM_UNIXTIME(kouponidb_kino_wins_xls.timestamp), SEC_TO_TIME(7200)), '%Y-%m-%d\T%H:%i') >= '2014-01-03T09:00' There should NOT be any oper...

    1. Community
    2. Miscellaneous
    3. MySQL & High Server Load

    just modify the query so that WHERE (( (kouponidb_kino_wins_xls.winners > '0') AND (DATE_FORMAT(ADDTIME(FROM_UNIXTIME(kouponidb_kino_wins_xls.timestamp), SEC_TO_TIME(7200)), '%Y-%m-%d\T%H:%i') >=...

    1. Community
    2. Miscellaneous
    3. MySQL & High Server Load

    Sorry but I can't help you thru forums like that, it would take too much time Your case requires access to the code/server for the more detailed review About queries DATE_FORMAT(ADDTIME(FROM_UNIXT...

    1. Community
    2. Miscellaneous
    3. MySQL & High Server Load

    Sorry for late reply, but its very time consuming to help you witht this via forums, it would be much faster to get access to it and work directly I don't really have time to explain it all here, s...

    1. Community
    2. Miscellaneous
    3. MySQL & High Server Load

    Based on index structure of the tables I can say that the person who made it, doesn't understand indexes at all :) When you have new slowlog ready we will discuss the rest

    1. Community
    2. Miscellaneous
    3. MySQL & High Server Load

    ok, please also run to show current index scheme show indexes from kouponidb_kino_wins_xls; show indexes from kouponidb_prognosi_xml; show indexes from kouponidb_prognosi_xml_diff; show indexes ...

    1. Community
    2. Miscellaneous
    3. MySQL & High Server Load

    Q2: explain extended SELECT x.id, x.betgame_id, x.coupon_code, x.home_team, x.visit_team, x.code, x.start_timestamp, d.start_date, d.start_time, d.bet_field, d.from_value, d.to_value, d.status, d....

    1. Community
    2. Miscellaneous
    3. MySQL & High Server Load

    Yes, this one is correct, index added properly, query returns 16988 rows, ok But what about the rest of the queries that Ive mentioned ? can you run explain extended on them too ? btw. you can rem...

    1. Community
    2. Miscellaneous
    3. MySQL & High Server Load

    Did you optimize those queries that I wrote ? I mean indexes Your queries used temporary tables, some of them on disk, and that doesn't scale, some used row by row scan or expensive filesort on bi...