steliosd
- Total activity 32
- Last activity
- Member since
- Following 0 users
- Followed by 0 users
- Votes 0
- Subscriptions 3
Comments
Recent activity by steliosd-
Ok i removed full_id from the indexes and now i have Index_2,betgame_id_status as possible_keys but key field still remains null in explain extended output.
-
Hi!Could you please assist me with the following problem? I have this query: SELECT x.id, x.home_team, x.visit_team, x.code, x.start_timestamp, d.rec_time, d.bet_field, d.from_value, d.to_value, d...
-
Is there anything we can do?
-
After 24 hours, here are slow.txt and the explain_extended output you requested: .vB .vB
-
I am going to wait 24 hours as you suggested before adding those indexes. Is there anything else I can do until then in order to decrease cpu consumption by mysql? Did you get any useful info from ...
-
Innodb tables: kouponidb_kino_wins_xls, kouponidb_prognosi_xml, kouponidb_prognosi_xml_diff, kouponi_xml, kouponi_xml_diff MyiSAM table: kouponidb_kino_delaysrepeats .vB
-
Ok I got it. Q2 + Q4: Q3 says: "ERROR 1146 (42S02): Table 'masterbe_app.kouponi_xml_diff' doesn't exist". I flushed slow.log as well. Q3 was in another database sorry.. mysql> explain extended s...
-
Ok I removed it. I thought that only this one was the query causing so much trouble.In which other queries do you refer? Mysql process is always at 700-1000% of cpu now!
-
Hope I got it right: Here is how my.cnf looks right now: [mysqld] max_connections=250 max_user_connections=150 query_cache_type=1 query_cache_size=150M query_cache_limit=1M long_query_time=0.1...
-
Nothing has changed. I noticed that table_cache_hit_rate is now 0% ( [!!] Table cache hit rate: 0% (2K open / 1M opened) )! I increased table_cache to 16384 but it didn't help. If the logged in use...