Re: next-key lock

, if you have both the values. regards, Nilnandan On Tue, Sep 2, 2014 at 11:59 AM, geetanjali mehra mailtogeetanj...@gmail.com wrote: Dear Akshay, ASFIK, normal selects are always non-locking read and they do not put any locks. Select..., Select..where..,Select where

Re: MySQL slowlog - only in file?

Hi Rafal, If you are using MySQL 5.1 and later version than you can enable the log tables and you can see slow queries in the log tables. Please check this post: http://nilinfobin.com/2012/03/slow_log-and-general_log-tables-in-mysql-5-1/ regards, Nilnandan On Fri, May 11, 2012 at 2:40 PM, Rafał

Re: Doubt regarding Mysqlsump

Can you tell us which storage engine you are using? On Tue, Jun 7, 2011 at 11:30 AM, Adarsh Sharma adarsh.sha...@orkash.comwrote: Dear all, Is it possible to take backups of a table or complete database without stopping the application that continuously inserts and select data from the

Re: [ERROR] /usr/sbin/mysqld: Can't find file: './mysql/user.frm'

errono:13 is Permission Denied. Check permissions for mysql data dir. On Mon, Mar 14, 2011 at 11:02 AM, Adarsh Sharma adarsh.sha...@orkash.comwrote: Dear all, I am facing the below problem while installing mysql in a debian based system from the last 2 days. I tried the command apt-get

which version is better for production servers?

server? regards, Nilnandan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: which version is better for production servers?

:05 AM, Nilnandan Joshi nilnand...@synechron.com mailto:nilnand...@synechron.com wrote: Hi all, I just wanna make new MySQL server for OLTP kind of environment. I want to use InnoDB storage engine. Which version is better for this kind of environment and which will give

Re: How to become a DBA on MySQL

Below link might be help you. http://forge.mysql.com/wiki/MySQL_University mailto:nilnand...@synechron.com regards, Nilnandan Jerry Schwartz wrote: Sorry, I wish I did. I've used courses at lvsonline.com for all kinds of things (programming, graphics, etc.), but I didn't see anything about

Re: stored procedure syntax error

I think, you have to use prepare() before run that select statement. i.e SET @s = CONCAT(SELECT * INTO OUTFILE, c ,FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '' LINES TERMINATED BY '\n' FROM cells_summary WHERE PMMDATEANDTIME=b); PREPARE stmt FROM @s; EXECUTE stmt; regards, nilnandan

Re: phpMyAdmin and other management tools

http://mysqlonlinehelp.wordpress.com/2010/06/30/tools-for-mysql-database/ regards, Nilnandan Noel Butler wrote: On Thu, 2010-07-01 at 07:38 -0400, David Stoltz wrote: Hi Folks, I'm currently using phpMyAdmin to manage the mySQL databases. I'm wondering what most people like to use? I

Re: Updating from 4 to 5

Yeah, I'm agree with michael. For migration of DB from one major version to another, must use the below approach. by the using mysqlupgrade, might be we can loss some data. regards, Nilnandan Michael Dykman wrote: There are binary differences between v4.x and 5.x (5.1.x recommended

Re: Updating from 4 to 5

Grant, I think, you should run mysqlupgrade after copying old data in new servers. Regards, nilnandan Grant Peel wrote: Hi all, I am about to move from FreeBSD 6 to FreeBSD 8. With that, the mysql server version will be changed from 4 to 5. I am assuming I can load all the users tables

Re: MySQL Replication - Master-Slave crash

Hi Manasi, Please try with this one. Replicate_Wild_Ignore_Table = mydb\temp_.% Regards, Nilnandan Joshi Manasi Save wrote: Hi All, I have kept Replicate_Wild_Ignore_Table = mydb%.temp_% this is temporary table which i want should not be replicated. But still it is getting replicated

Re: Frequently MyISAM TABLE corruption.....Pls help

..Its frequently corrupted..It is very important table Regards, Nilnandan Joshi DBA-INDIA Nilnandan wrote: Hello Gerald, Data_lengthMax_data_length Index_length 596483288281474976710655 33758208 580 MB is table size and 32MB is index size. The default

Re: Frequently MyISAM TABLE corruption.....Pls help

Hello Gerald, Data_lengthMax_data_length Index_length 596483288281474976710655 33758208 580 MB is table size and 32MB is index size. The default maximum MyISAM size is 4GB. Now, tell me where is an issue? regards, Nilnandan Joshi DBA-SDU Juriscape Gerald

Frequently MyISAM TABLE corruption.....Pls help

- Fixing index 14 - Fixing index 15 - Fixing index 16 - Fixing index 17 - Fixing index 18 - Fixing index 19 - Fixing index 20 - Fixing index 21 - Fixing index 22 So, pls help me ASAP.Thanks in advance... regards, Nilnandan Joshi DBA - INDIA -- View this message in context: http