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
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
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 l...@dijkmat.nl 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:How to install multiple instances in windows
Hi all, How to install multiple instances in windows??? Thank you.
Re:Incremental Backup Script
Hi Please be send sample incremental backup script (bash Shell script Easy to understand) Thanks Regards, Kranthikiran
Re: Backup
I get, I use following mysqlbinlog --start-date=2010-10-09 9:55:00 \ --stop-date=2010-10-10 10:05:00 \ /var/log/mysql/bin.123456 \ /tmp/mysql_restore.sql Thanks all From: andrew.2.mo...@nokia.com [mailto:andrew.2.mo...@nokia.com] Sent: Sunday, October 10, 2010 4:46 AM To: kranthikiran@gmail.com Subject: Re: Backup hmm a yesterday backup? MySqldump using where clauses? Why do you only want yesterday? -- Sent from my HTC Desire on 3 -- - Reply message - From: ext kranthi kranthikiran@gmail.com Date: Sun, Oct 10, 2010 04:51 Subject: Backup To: bac...@lists.mysql.com bac...@lists.mysql.com Hi , My database size is 900GB.i don't want full database backup. I need only yesterday backup. how can I take, please help me. Thanks Regards, Kranti
Re:Backup
Hi , My database size is 900GB.i don't want full database backup. I need only yesterday backup. how can I take, please help me. Thanks Regards, Kranti
RE: Performance Tunning
Hi All, In performance tunning what are the steps can follow,please help me Thanks Regards, Kranthi kiran
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
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
RE: Recover Records
Hi all, My database size is 1gb.I take backup at 12 am and unfortunately I deleted 8 records at 2 am . I checked 8 records in 12 am backup , that 8 records are not there, I think that 8 records inserted between 12 am to 2 am. I am maintaining log file how can I recover particular records. Thanks Regards, Kranthi
RE: Recover Records
Thank u Janqita, I can get Regards , Kranthi -Original Message- From: Jangita [mailto:jang...@jangita.com] Sent: Thursday, August 26, 2010 3:33 PM To: mysql@lists.mysql.com Subject: Re: Recover Records On 26/08/2010 11:35 a, Kranthi wrote: Hi all, My database size is 1gb.I take backup at 12 am and unfortunately I deleted 8 records at 2 am . I checked 8 records in 12 am backup , that 8 records are not there, I think that 8 records inserted between 12 am to 2 am. I am maintaining log file how can I recover particular records. Is it a binary log? if so use mysqlbinlog to search for the insert statements and re-insert them. -- Jangita | +256 76 91 8383 | Y! MSN: jang...@yahoo.com Skype: jangita | GTalk: jangita.nyag...@gmail.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=kranthi_penty...@iicindia.com -- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: Mysql BestPractices
Hi all, Please send sample mysql best practice document. Thanks Regards, Kranthi kiran
Reg: Migration
Hi , I am migrating the database from mssql server to Mysql.i am getting problem with newid(),I don't know about newid(),i am using mysql migration tool kit. if anybody knows please help me. Ex: CREATE TABLE cust ( cust_id uniqueidentifier NOT NULL DEFAULT newid(), company varchar(30) NOT NULL, contact_name varchar(60) NOT NULL, address varchar(30) NOT NULL, city varchar(30) NOT NULL, state_province varchar(10) NULL, country varchar(20) NOT NULL, ) GO Thanks Regards, Kranthi
RE: Migration
Hi Lenz, I used UUID() function, I am getting error Check the manual that corresponds to your mysql server version for the right syntax to use near UUID(). I am using mysql version 5.0.45. DROP TABLE IF EXISTS `AdventureWorks_HumanResources`.`Employee`; CREATE TABLE `AdventureWorks_HumanResources`.`Employee` ( `EmployeeID` INT(10) NOT NULL AUTO_INCREMENT, `NationalIDNumber` VARCHAR(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `ContactID` INT(10) NOT NULL, `LoginID` VARCHAR(256) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `ManagerID` INT(10) NULL, `Title` VARCHAR(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `BirthDate` DATETIME NOT NULL, `MaritalStatus` CHAR(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `Gender` CHAR(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `HireDate` DATETIME NOT NULL, `SalariedFlag` TINYINT NOT NULL DEFAULT 1, `VacationHours` SMALLINT(5) NOT NULL DEFAULT 0, `SickLeaveHours` SMALLINT(5) NOT NULL DEFAULT 0, `CurrentFlag` TINYINT NOT NULL DEFAULT 0, `rowguid` VARCHAR(64) NOT NULL DEFAULT uuid(), -- Here I am using UUID() instead of newid() PRIMARY KEY (`EmployeeID`) ) ENGINE = INNODB; Thanks Regards, Kranthi -Original Message- From: Lenz Grimmer [mailto:l...@mysql.com] Sent: Friday, August 13, 2010 3:56 PM To: mysql@lists.mysql.com Subject: Re: Reg: Migration Hi, On 08/13/10 09:34, Kranthi wrote: I am migrating the database from mssql server to Mysql.i am getting problem with newid(),I don't know about newid(),i am using mysql migration tool kit. if anybody knows please help me. Would using the UUID() MySQL function work for you in this case? http://dev.mysql.com/doc/refman/5.1/en/miscellaneous-functions.html#function _uuid Bye, Lenz -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=kranthi_penty...@iicindia.com -- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org