Re: mysqldump: Error 2013: Lost connection to MySQL server

Hi, please increase your interactive_timeout variable to some big number and also try to log the erros if any thing by using the command: mysqldump --opt db_name > db_name.sql -p 2>>bkp.err check if you get some thing in the bkp.err file. Regards, Chandru, www.mafiree.com On Mo

Re: Locking database when 'creating sort index'

. Regards, Chandru forums.mafiree.com On Thu, Jan 8, 2009 at 12:37 AM, David Scott wrote: > Oh and we increased the key_buffer_size=1200M (30% of ram) no change. > > 2009/1/7 David Scott > > > 1) InnoDb2) 5.0.51 on Linux > > 3) No, a Select with a bunch of Joins, a Where, g

Re: On fighting with master-slave replication lag

Hi, I use Mycat to monitor more than 300 servers using a single config file. It can be used only for replication monitoring though Regards, Chandru www.mafiree.com On Tue, Dec 23, 2008 at 10:51 PM, Andy Shellam wrote: > Hi > > I would suggest a Nagios monitoring system, useful

Re: How many users access MySQL

Hi Shuly, you can use the method suggested by Shuly or you cook up your query logs if you need more accurate information. May be you can write a small script to do the job. Regards, Chandru forums.mafiree.com On Mon, Dec 22, 2008 at 7:34 AM, mos wrote: > At 02:32 PM 12/21/2

Re: MYSQL startup problem

Hi, I find that mysql is running fine :) TCP * 0.0.0.0:3306 * 0.0.0.0:0 LISTENING . you are connecting wrongly please connect using mysql -u root -p -h 127.0.0.1 I find that you tried the same option both times :) Regards, Chandru www.mafiree.com On Fri, Dec 12

Re: MYSQL startup problem

have missed the "-p" option which prompts for password. Regards, Chandru www.mafiree.com On Fri, Dec 12, 2008 at 1:39 PM, BAJAJ POOJA wrote: > Hi, > > Pls. Find response below: > > C:\wamp\mysql\bin>Mysql -h localhost -u root > ERROR 2003: Can't connect to MySQL

Re: About combine ssl with mysql.

can you please share how you have solved that? Did u use mysql -u root -p --ssl when connecting? Regards, Chandru www.mafiree.com On Fri, Dec 12, 2008 at 1:15 PM, Moon's Father wrote: > I have solved this problem. > ^_^ > > On Fri, Dec 12, 2008 at 10:54 AM, Moon's Fa

Re: MYSQL startup problem

Please also let me know how do you try to connect to mysql? Regards, Chandru www.mafiree.com On Fri, Dec 12, 2008 at 1:18 PM, Chandru wrote: > can you check the output of netstat -n or netstat -an and find if port 3306 > is listening? > > Regards, > > Chandru > > ww

Re: MYSQL startup problem

can you check the output of netstat -n or netstat -an and find if port 3306 is listening? Regards, Chandru www.mafiree.com On Fri, Dec 12, 2008 at 1:12 PM, wrote: > When you do the following > Mysql -h localhost -u root. > What do you get ? > > > Sent via BlackB

Re: MYSQL startup problem

Hi, By default you can find them in the datadirectory ( the place where you have all your databases stored) Regards, Chandru www.mafiree.com On Fri, Dec 12, 2008 at 12:42 PM, BAJAJ POOJA < pooja.ba...@alcatel-lucent.com> wrote: > Hi Chandru, > > Can you pls. help where c

Re: MYSQL startup problem

Hi, can you please look at the mysql error logs? if you are not able to figure out the reason, please paste the error log. Regards, Chandru www.mafiree.com On Fri, Dec 12, 2008 at 11:52 AM, BAJAJ POOJA < pooja.ba...@alcatel-lucent.com> wrote: > Hi, > > I am using wamp ser

Re: Compiled configure string

Hi, you can use mysqlbug to get the compiled options. Ususally mysqlbug generates a output that has the the one that you are looking for :) Regards, Chandru www.mafiree.com On Fri, Dec 12, 2008 at 3:19 AM, Madan Thapa wrote: > On Fri, Dec 12, 2008 at 12:05 AM, voipcore voipcore >

Re: Replication

give a clue what is happening. also let me know what are all the replication related paramenters that are set in the cnf. Regards, Chandru www.mafiree.com On Mon, Dec 8, 2008 at 4:31 PM, Ananda Kumar <[EMAIL PROTECTED]> wrote: > did u check if any of the file system holding bin-logs/

Re: Alter Table - InnoDB

ing then take a dump, reimport the same with "innodb_file_per_table" option enabled. Regards, Chandru. www.mafiree.com On Thu, Dec 4, 2008 at 4:19 PM, Shachi Govil <[EMAIL PROTECTED]>wrote: > I thought you always have to go to the physical location and delete the tmp > files

Re: Updating from MySQL 4.0.12 to 5.0.67 Community

/grant.html Regards, Chandru www.mafiree.com On Tue, Dec 2, 2008 at 3:48 AM, Claudio Nanni <[EMAIL PROTECTED]>wrote: > Hi Bai, > I think the best option is to read carefully the installation guide, > there are some post installation steps to set up initial privileges, > and everything

Re: mysql master slave security considerations and planning

er and the slave, by having a floating IP that is available in the master. You can have Heatbeat service do this task for you. Regards, Chandru. www.mafiree.com On Sun, Nov 30, 2008 at 3:09 AM, Madan Thapa <[EMAIL PROTECTED]>wrote: > Hi, > > First of all I am newbie to MySQL administr

Re: How to disable some of the mysql query?

Hi wayne, If you dont want any query with select * from " by mistake" then you can start the mysql by using the command --safe-updates or --i-am-a-dummy this does not allow queries to be executed if they dont have any where clause. Regards, Chandru www.mafiree.com On Fri, Nov 28,

Re: SELECT locking tables.... in other databases

Hi David, can you please let me know what is the select query and the update query along with the explain plan of the same. can you please let me know if you are using innodb storage engine? Regards, Chandru www.mafiree.com On Thu, Nov 27, 2008 at 4:45 PM, David Scott <[EMAIL PROTEC

Re: too many connections

connections. 3. Also check if the queries are getting locked or do you have any slow queries during that time. please let me know what are your current values for the above parameters what is the value of `netstat -an |grep -i est |wc -l` during the time of the error Regards, Pradeep Chandru. Brent

Re: Fwd: Why dont my query use the index keys?

Hi joerg, that was a excellent explanation. Regards, Pradeep Chandru. Joerg Bruehe wrote: Hi ! Parikh, Dilip Kumar schrieb: Hi , So you are trying to say that 1) when the Table has Low Cardinality, Mysql wont use Index? Is this the logic behind your words? Extreme example: If

Re: Fwd: Why dont my query use the index keys?

the index to be used. Regards Pradeep chandru. Nagaraj S wrote: Then do u mean if there is low cardinality index will not be used?. Regards, Naga On Thu, Sep 18, 2008 at 2:41 PM, chandru <[EMAIL PROTECTED]>wrote: Hi nagaraj, sorry.. Since the cardinality is low MySQL has chosen *

Re: Fwd: Why dont my query use the index keys?

the complete table can be faster than a index lookup that is going to search more than 30 % the table size. What i meant by increase data fetch is the time of data fetch. Regards, Pradeep Chandru Parikh, Dilip Kumar wrote: Hi pradeep, What are you trying to say ?. The query clearly

Re: Fwd: Why dont my query use the index keys?

Hi nagaraj, sorry.. Since the cardinality is low MySQL has chosen *not to use* a Index that can give the best performance. i missed that. Regards, Pradeep chandru. Nagaraj S wrote: Pradeep, Can you be clear on your statement. Becoz i read in few links if the cardinality is low also

Re: Fwd: Why dont my query use the index keys?

fetched. Regards, Pradeep chandru. Parikh, Dilip Kumar wrote: Hi johan, U can use and try to write a query to use index in it (like use index(index name) before where condition. And other variables also looks like ok seems let me check, Please try to send the output of global status. Show

Re: Why dont my query use the index keys?

cardinality of 35921 which is low which tells that there are more records matching the condition tm.tag_id IN (99, 10807, 20728, 447, 807) you might have to put some logic to over ride the same. Even putting some partitioning can help you. Regards, Pradeep Chandru. Johan Thorvaldsson wrote

Re: Fwd: Why dont my query use the index keys?

me know what is your sort_buffer_size by using the command show global variables like 'sort%'; Regards, Pradeep Chandru. Johan Thorvaldsson wrote: So query and index:es are ok ? Because the query runs very slow. Vidarebefordrat brev: Från: "Ananda Kumar" <[EMAIL PROTECTE

RE: How to delete all rows....

Hi, I prefer using TRUNCATE statement. syntax: TRUNCATE [TABLE] tbl_name This takes lesser time when compared to the delete from table. It takes hardly few seconds. take a backup before executing this if required. Regards, N.Pradeep Chandru. -Original Message- From: Peter Lauri

Re: Need help in recreating .MYD files

hi, Just to add up i have read some where ( i assume in the mailing list only) that OS recognizes the file based on few codes added at the starting / ending of a file. So there are ways to create a MYD file through vi editor as well (this is not from the angle of restoring the data in that

Re: How to repair a table,

Hi, I think the syntax is to be verified. myisamchk * * -u root -p * ///*.* mysql will accept only if the passwords is next to "-p" option **: some frequently used options are mentioned below -r, --recover -o, --safe-recover -e, --extend-check -q, --quick -S, --sort-index -f, --force ( to b

ndbd --initial startup issues in mysql cluster

hi, i am trying to install a cluster. i am facing issues in starting up the ndbd. My configuration is as follows. *Config.ini:* [NDBD DEFAULT] NoOfReplicas=2 [MYSQLD DEFAULT] [NDB_MGMD DEFAULT] [TCP DEFAULT] # Section for the cluster management node [NDB_MGMD] # IP address of the management n