unfortunately truncate tables
Hi all unfortunately some body truncate the 2 tables , in this data we did not enable log-bin file.how can recovery that data.i am using innodb engine , plz help me its urgent , thanks advance
Re: Speed Up Query
using Execution plan:
++++-+---++-+---+-+-
---+
| id | select_type| table | type|
possible_keys | key| key_len | ref | rows|
Extra |
++++-+---++-+---+-+-
---+
| 1 | PRIMARY| b | ALL |
NULL | NULL | NULL| NULL | 273 | Using temporary;
Using f ilesort|
| 1 | PRIMARY| a | ref |
pack_id| pack_id | 5 | const | 1307430 | Using
where |
| 2 | DEPENDENT SUBQUERY | demo_users_info_table | unique_subquery |
PRIMARY | PRIMARY| 130 | func | 1 | Using index; Full
scan o n NULL key |
++++-+---++-+---+-+-
---+
On Fri, Nov 19, 2010 at 2:22 PM, Elizabeth Mattijsen wrote:
> 1. use EXPLAIN to find out what the execution plan is.
> 2. from experience: don't use sub SELECTs ("NOT IN (SELECT mob FROM
> demo_user_info_table)") if you want performance
> 3. from experience: don't use NOT IN (), but use IN () if you want
> performance
>
> On Nov 19, 2010, at 9:46 AM, kranthi kiran wrote:
> > Hi All,
> > Following query take 25 minutes time,in this table having 3 core
> > records,how to speed up this query,please help me.thanks advance
> >
> > SELECT b.circle_name,
> > COUNT(a.mob),
> > a.pack_price,
> > DATE(a.req_date)
> > FROM user_info_table a,
> > circle_info_table b
> > WHERE a.status = 'SUCCESS'
> > AND a.sub_type IN( 'SUB', 'RESUB' )
> > AND Substring(a.mob, 1, 4) = b.mob_series
> > AND DATE(a.req_date) = '2010-11-09'
> > AND a.pack_id IN ( '206' )
> > AND mob NOT IN (SELECT mob
> > FROM demo_user_info_table)
> > GROUP BY a.pack_price,
> > b.circle_name,
> > DATE(a.req_date);
>
>
Re:Speed Up Query
Hi All, Following query take 25 minutes time,in this table having 3 core records,how to speed up this query,please help me.thanks advance SELECT b.circle_name, COUNT(a.mob), a.pack_price, DATE(a.req_date) FROM user_info_table a, circle_info_table b WHERE a.status = 'SUCCESS' AND a.sub_type IN( 'SUB', 'RESUB' ) AND Substring(a.mob, 1, 4) = b.mob_series AND DATE(a.req_date) = '2010-11-09' AND a.pack_id IN ( '206' ) AND mob NOT IN (SELECT mob FROM demo_user_info_table) GROUP BY a.pack_price, b.circle_name, DATE(a.req_date);
kranthi kiran wants to chat
--- kranthi kiran wants to stay in better touch using some of Google's coolest new products. If you already have Gmail or Google Talk, visit: http://mail.google.com/mail/b-7b9f42b217-2ea453372e-yAnBROFNjKN29DW37cRa_kmftE8 You'll need to click this link to be able to chat with kranthi kiran. To get Gmail - a free email account from Google with over 2,800 megabytes of storage - and chat with kranthi kiran, visit: http://mail.google.com/mail/a-7b9f42b217-2ea453372e-yAnBROFNjKN29DW37cRa_kmftE8 Gmail offers: - Instant messaging right inside Gmail - Powerful spam protection - Built-in search for finding your messages and a helpful way of organizing emails into "conversations" - No pop-up ads or untargeted banners - just text ads and related information that are relevant to the content of your messages All this, and its yours for free. But wait, there's more! By opening a Gmail account, you also get access to Google Talk, Google's instant messaging service: http://www.google.com/talk/ Google Talk offers: - Web-based chat that you can use anywhere, without a download - A contact list that's synchronized with your Gmail account - Free, high quality PC-to-PC voice calls when you download the Google Talk client We're working hard to add new features and make improvements, so we might also ask for your comments and suggestions periodically. We appreciate your help in making our products even better! Thanks, The Google Team To learn more about Gmail and Google Talk, visit: http://mail.google.com/mail/help/about.html http://www.google.com/talk/about.html (If clicking the URLs in this message does not work, copy and paste them into the address bar of your browser). -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
kranthi kiran wants to chat
--- kranthi kiran wants to stay in better touch using some of Google's coolest new products. If you already have Gmail or Google Talk, visit: http://mail.google.com/mail/b-7b9f42b217-34446b6de3-Dp2zHVPU5AhNWkYs9pgMnHMgaM0 You'll need to click this link to be able to chat with kranthi kiran. To get Gmail - a free email account from Google with over 2,800 megabytes of storage - and chat with kranthi kiran, visit: http://mail.google.com/mail/a-7b9f42b217-34446b6de3-Dp2zHVPU5AhNWkYs9pgMnHMgaM0 Gmail offers: - Instant messaging right inside Gmail - Powerful spam protection - Built-in search for finding your messages and a helpful way of organizing emails into "conversations" - No pop-up ads or untargeted banners - just text ads and related information that are relevant to the content of your messages All this, and its yours for free. But wait, there's more! By opening a Gmail account, you also get access to Google Talk, Google's instant messaging service: http://www.google.com/talk/ Google Talk offers: - Web-based chat that you can use anywhere, without a download - A contact list that's synchronized with your Gmail account - Free, high quality PC-to-PC voice calls when you download the Google Talk client We're working hard to add new features and make improvements, so we might also ask for your comments and suggestions periodically. We appreciate your help in making our products even better! Thanks, The Google Team To learn more about Gmail and Google Talk, visit: http://mail.google.com/mail/help/about.html http://www.google.com/talk/about.html (If clicking the URLs in this message does not work, copy and paste them into the address bar of your browser). -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: Performance Tunning
Hi All, In performance tunning what are the steps can follow,please help me Thanks & Regards, Kranthi kiran
