Re: next-key lock

ndly check with table, 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...

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 wrote: > 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 > tables. > > For taking c

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 wrote: > 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 install mysql-serve

Re: which version is better for production servers?

:05 AM, Nilnandan Joshi 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 the great perfo

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: 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

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

Re: stored procedure syntax error

=b"); PREPARE stmt FROM @s; EXECUTE stmt; regards, nilnandan DAREKAR, NAYAN (NAYAN) wrote: Hi all ! I m getting an error while writing stored procedure, the code is as below and error CODE -- DELIMITER

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

+ 10 rows in set (1 min 27.77 sec) PLS help me ASAP..Its frequently corrupted..It is very important table Regards, Nilnandan Joshi DBA-INDIA Nilnandan wrote: > > Hello Gerald, > > Data_lengthMax_data_length In

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

xing index 12 - Fixing index 13 - 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