Re: next-key lock

Hi Geetanjali, It seems, you are confused with gap locking. Can you tell if there is a record with value 12 and 17 in the new table? Select count(*) from new where c1 = 17; AFAIK, if you run this query "Select * from new where c1 between 12 and 17 for update;" and if you don't have value 17 in th

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?

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 performance? MySQL 5.1.47/48 or MySQL 5.5? Should we use mysql development release for production se

Re: How to become a DBA on MySQL

Below link might be help you. http://forge.mysql.com/wiki/MySQL_University 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: 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: 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: Updating from 4 to 5

asswd/host tables etc) and the mysqlupgrade will update them as necessary? -Grant - Original Message - From: Nilnandan Joshi To: Grant Peel Cc: mysql@lists.mysql.com Sent: Tuesday, June 29, 2010 4:00 AM Subject: Re: Updating from 4 to 5 Grant, I think, you should run mysqlupgrade

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, an

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