Re: Changing storage engine in dump file.

t; For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/mysql > > -- Thanks, Trimurthy P Mobile : +91 97397 64298 http://mysqlinternals.blogspot.in/ https://www.linkedin.com/pub/trimurthy-pothanaboyina/5a/9a9/96b

Re: deleting big tables

Hi Pou, Before killing those connections first check for the undo log entries from the engine innodb status. If there are too many undo log entries it will take some time to clean up those entries. If you force fully kill those connections there are more chances to crash the DB instance. On 17 May

Re: create_time

hat was more or less identical with the > last update of the table. Which surprised me. > > From: Pothanaboyina Trimurthy skd.trimur...@gmail.com>> > Date: Friday, May 1, 2015 at 12:15 AM > To: Martin Mueller martinmuel...@northwestern.edu>> > Cc: "mysql@lis

Re: create_time

cent access. Which seems odd. > > Am I doing something wrong? Is there a way of finding the date when a > table was first created? > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql &

Issue with timestamp columns while working with MySQL load data in file

ta I could see only one timestamp value for both the columns, though the load data takes 2 hours to load the data. Can any one explain how exactly the load data infile works, and why only a single timestamp is inserting for all 1 million records though the load data taking around 2 hours. Tha

Re: Remote Access to MySQL

> > regards > Florian > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/mysql > > -- Thanks, Trimurthy P Mobile : +91 97397 64298 http://mysqlinternals.blogspot.in/ https://www.linkedin.com/pub/trimurthy-pothanaboyina/5a/9a9/96b

Re: ERROR : client option 'secure_auth' enabled

Hi Reindl Harald, i have included [mysqladmin] section in config file also. but still facing same issue. On Mon, Sep 16, 2013 at 3:54 PM, Reindl Harald wrote: > > > Am 16.09.2013 12:14, schrieb Pothanaboyina Trimurthy: > > Hi guys, > > today i have installed my

ERROR : client option 'secure_auth' enabled

Hi guys, today i have installed mysql 5.6.13 tar binary distribution, on redhat5 machine. i have started the server with "skip-secure-auth", server started successfully. when i am trying to shutdown the server, it throwing the following error, can any one please let me know why it is h

Query Resulting error

& Kind Regards, TRIMURTHY

index

& Kind Regards, TRIMURTHY

Replication setup hep

Hi everyone i have 4 mysql servers out of those one server will be online always and the remaining will be offline and online. the operations takes place at the offline servers i want to replicate the data from the offline servers to the online server. for this can any one help me

Is there any performance difference, maintaining separate ibdata files for each and every table insted of having one singl tabale for all databases.

hi every one Is there any performance difference, maintaining separate ibdata files for each and every table insted of having one singl tabale for all databases, for InnoDB Storage Engine. please let me know the difference. -- 3murthy -- MySQL General Mailing List For list archives: http://

update query

Hi all, i have one database with 120 tables and each table contains one common column that is "client" now i want to update all the tables column client = "NEW". is it possible to write a single query to update this one. please help me. thanks in advance Thanks & Kind Regards, Trimurthy.p