Force index command in query

those queries ? Thanks & Regards Jeetendra Ranjan

Re: innodb_data_file_path

file.[FAILED]" - Original Message - From: Suresh Kuna To: Jeetendra Ranjan Cc: mysql@lists.mysql.com Sent: Monday, January 04, 2010 12:45 PM Subject: Re: innodb_data_file_path Try this : /dev/sda3:10Graw;/dev/sda1:5Graw Change the newraw to raw and start the

Re: innodb_data_file_path

Hi Suresh, Thanks, this link we already have but it has no information right from creating the raw disk partition. Jeetendra Ranjan - Original Message - From: Suresh Kuna To: Jeetendra Ranjan Cc: mysql@lists.mysql.com Sent: Monday, January 04, 2010 12:12 PM Subject: Re

Re: innodb_data_file_path

nnoDB: the directory. Thanks Jeetendra Ranjan - Original Message - From: Suresh Kuna To: Jeetendra Ranjan Cc: mysql@lists.mysql.com Sent: Monday, January 04, 2010 10:28 AM Subject: Re: innodb_data_file_path Hi Jeetendra, What is the error it it saying in error log ?

Re: innodb_data_file_path

Thanks Suresh for your response. MySQL is already installed and will update you with the error log details. Thanks Jeetendra Ranjan - Original Message - From: Suresh Kuna To: Jeetendra Ranjan Cc: mysql@lists.mysql.com Sent: Monday, January 04, 2010 10:28 AM Subject: Re

innodb_data_file_path

est how to resolve this issue ? Thanks Jeetendra Ranjan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

innodb_data_file_path

est how to resolve this issue. Thanks Jeetendra Ranjan

Global variable for only one database

Hi, We have number of mysql database in one box. How can we set the variables that applies to only one database. Like when i set the query_cache_size it should be used by only those queries for which the parameter is set ? Thanks

Re: Aborted_connects is incresing repidly

Regards Jeetendra Ranjan - Original Message - From: Claudio Nanni To: Walter Heck - OlinData.com Cc: mysql@lists.mysql.com ; Jeetendra Ranjan Sent: Thursday, December 31, 2009 1:32 AM Subject: Re: Aborted_connects is incresing repidly @Walter By the way your guess i

Re: Aborted_connects is incresing repidly

Thanks , but i want to solve this problem without shutting down the db server. - Original Message - From: "Parikh, Dilip Kumar" To: "Jeetendra Ranjan" Cc: Sent: Wednesday, December 30, 2009 2:56 PM Subject: RE: Aborted_connects is incresing repidly Try us

Aborted_connects is incresing repidly

Hi, My MySQL server Aborted_connects status is showing 8692 and is rapidly increasing. What are reasons and how do i decrease the same? We are using connect() method in PHP code and have tried below command mysqladmin flush-hosts but still the value is same. Thanks Jeetendra Ranjan

Re: Slave is not updated

Please ignore the user name and ip. i am passing the right information here - Original Message - From: "Parikh, Dilip Kumar" To: "Jeetendra Ranjan" ; Sent: Thursday, December 24, 2009 2:51 PM Subject: RE: Slave is not updated User is not the replicat

Re: Slave is not updated

Until_Log_Pos: 0 Master_SSL_Allowed: No Master_SSL_CA_File: Master_SSL_CA_Path: Master_SSL_Cert: Master_SSL_Cipher: Master_SSL_Key: Seconds_Behind_Master: NULL Thanks Jeetendra Ranjan - Original Message - Fro

Re: Slave is not updated

n: 4 091224 0:00:16 [ERROR] Slave I/O thread: error connecting to master 'r...@201.107.236.77:3306': Error: 'Access denied for user 'root'@'ip-97-74-85-42.ip.secureserver.net' (using password: YES)' errno: 1045 retry-time: 60 retries: 86400 091224 1:04:48 [

Re: Slave is not updated

Hi Dilip, Thanks for your response I already run the below command at master: grant replication slave on *.* to 'mysqladm'@'95.84.86.41' identified by 'admmysql'; Thanks Jeetendra Ranjan - Original Message - From: "Parikh, Dilip Kumar" To

Slave is not updated

rds Jeetendra Ranjan

Error in running trigger

t the trigger it gives the error "SQL execution erro # 1227. Response from the database: Access denied ; you need the SUPER privilege for this operation". But this user has all privilege. Why it is not executing ? Thanks in advance. Regards Jeetendra Ranjan

Uninsall mysql 5.0.45 from RHEL 5

Hi, I have mysql 5.0.45 on Red Hat EL 5. How do i completely uninstall the same ? Thanks in advance. Jeetendra Ranjan

error while creating trigger

ses of this error ? Thanks in advance Jeetendra Ranjan

How to create new mysql instance

Hi, Can any body help me how to create new instance at the same mysql databas server in 5.0.85 community version ? Thanks Jeetendra Ranjan

Force index command in sql query

those queries ? Thanks & Regards Jeetendra Ranjan

ERROR 1235 (42000): This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'

,old.LAST_MOD_TIME,old.LAST_MOD_BY );END -> // ERROR 1235 (42000): This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' Or any other alternate to do the same ? Thanks & Regards Jeetendra Ranjan

How to enable partition in MySQL version 5.0.81-community

ow to enable the partition option in MySQL version 5.0.81-community? -- Regards, Jeetendra Ranjan SynapseIndia http://www.synapse.in I.T. Outsourcing @ Peace of Mind --

mysqlbinlog is not running

bol my_init_time, version libmysqlclient_15 not defined in file libmysqlclient.so.15 with linktime reference Please guide me what is the solution of this error ? -- Regards, Jeetendra Ranjan SynapseIndia http://www.synapse

Re: Req. suitable .cnf file for Server used by 2000 users daily

mysql is successfull in login with same user and password but when the same user and password is given at mysqltuner end it always shows the same error "[!!] Attempted to use login credentials, but they were invalid." Thanks Jeetendra Ranjan Synapse

Re: Req. suitable .cnf file for Server used by 2000 users daily

me how can i run this script Thanks & Regards Jeetendra Ranjan - Original Message - From: "Bruce Ferrell" To: Cc: Sent: Thursday, October 15, 2009 12:20 PM Subject: Re: Req. suitable .cnf file for Server used by 2000 users daily > > Have a look at mysqltuner. It

Re: Re: Req. suitable .cnf file for Server used by 2000 users daily

concern about connectoins. Initially 2000 visitor including marketer and customer will visit this site. Thanks in advance. Regards Jeetendra Ranjan At 21:21 14/10/2009, Shawn Green wrote: jeetendra.ran...@sampatti.com wrote: > Hi, > Will you plesae guide me ? > We are about to l

Req. suitable .cnf file for Server used by 2000 users daily

/mysqld.log pid-file=/var/run/mysqld/mysqld.pid Thanks in advance Regards Jeetendra Ranjan