bytes in Recv-Q not processed by mysql

see the above observation from the netstat -tonp command. Basically certain threads get into BLOCKED state unable to write to DB. Any help / pointers would be really appreciated. Thanks Jatin

Disk space required for taking backup

of file that mysqldump creates from a given DB. Thanks Jatin

Re: Pointers to Mysql Replication

On 7/6/2015 1:39 PM, Claudio Nanni wrote: Hi Jatin, Say if i am using a DB instance for quiet some time on node-1 and it has data in it. If i decide to have replication with another DB instance , will all the data from node-1 be first replicated to node-2's DB ? Or will it just

Pointers to Mysql Replication

in node-2 , node-1 can start the application and DB and start servicing application requests. Appreciate if you can provide some pointers of reading in this regard and the type of solution that i should implement to achieve it. Thanks Jatin

Re: Pointers to Mysql Replication

On 7/5/2015 10:48 PM, Claudio Nanni wrote: Hello Jatin, We are basically intending to implement High Availability for our application. In this regard , we want to use Mysql replication for this purpose. Your scenario(MySQL Master/Slave with Failover/Failback procedures) has been a typical

Re: Unable to start mysql after power Failure

On 7/4/2015 2:26 PM, Reindl Harald wrote: Am 04.07.2015 um 06:24 schrieb Jatin Davey: We are trying to High Availability solution for our database. We have our application running on a node-1 and the DB running on the shared storage which is shared across node-1 node-2. Whenever

Unable to start mysql after power Failure

17753 [Note] /var/lib/mysql/bin/mysqld: Shutdown complete 150703 16:05:43 mysqld_safe mysqld from pid file /var/lib/mysql/mysqld.pid ended End of Error Message * Appreciate your help in this regard. Thanks Jatin

Re: SHOW FULL COLUMNS QUERIES hogging my CPU

-slowness/ No guarantees, but it doesn't seem to have any significant downsides. I already have this variable turned off in my DB. It does not stop the SHOW FULL COLUMN queries from hitting the DB. | innodb_stats_on_metadata | OFF Thanks Jatin -- MySQL General

Re: SHOW FULL COLUMNS QUERIES hogging my CPU

On 6/2/2014 9:10 PM, Morgan Tocker wrote: Hi Jatin, On Jun 2, 2014, at 7:56 AM, Jatin Davey jasho...@cisco.com wrote: I found this blog while trying to find a fix for my problem. Thought it might be useful to share. Here it is: http://whirlpool.net.au/blog/5 To confirm - did you manage

SHOW FULL COLUMNS QUERIES hogging my CPU

. Could some one let me know how i can get rid of these queries being sent to the DB. I am using mysql server version: 5.6.10-enterprise-commercial-advanced Please let me know if any more information is required. Appreciate your help in this regard. Thanks Jatin

Re: SHOW FULL COLUMNS QUERIES hogging my CPU

On 6/2/2014 7:18 PM, Reindl Harald wrote: Am 02.06.2014 15:35, schrieb Jatin Davey: I am no expert with mysql and databases. Hence seeking out some help on this forum. Basically i got a query dump of my application during its operation. I had collected the queries for about 4 hours. Ran

Re: SHOW FULL COLUMNS QUERIES hogging my CPU

Certain part of our code uses DataNucleas while other parts of the code use JDBC to access the DB. I would say that 70% of our code uses DataNucleas while the remaining 30% of our code uses JDBC for databases related operations. Thanks Jatin On 6/2/2014 8:17 PM, Singer Wang wrote: What's

Re: SHOW FULL COLUMNS QUERIES hogging my CPU

in waiting for I/O as the databases reads would have to do a lot of I/O to read the data from the disks. Thanks Jatin On 6/2/2014 8:13 PM, Michael Dykman wrote: The advice to 'avoid LIKE in general' is a little strong. LIKE is very useful and does not always cause inefficient queries, although

Re: SHOW FULL COLUMNS QUERIES hogging my CPU

I found this blog while trying to find a fix for my problem. Thought it might be useful to share. Here it is: http://whirlpool.net.au/blog/5 Thanks Jatin On 6/2/2014 8:22 PM, Jatin Davey wrote: Certain part of our code uses DataNucleas while other parts of the code use JDBC to access the DB

Remote access for mysql what variable is needed to be set

Hi I am running mysql 4 on linux server. I want to have a remote access on it. what are the setting that i need to do this. --jatin http://mcabca.cjb.net - Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software

Suse V/S Redhat - mysql performance difference.

results on both systems. I will probably install Redhat on the suse system, but can anyone think of why this happens and what can i do to improve the response. As of now the rowcount for the largest table is 221165. Has anyone else noticed similar results? Thanks for any replies Jatin

Re: Porting from MS SQL to MySQL

for other options. you will definitely get lots of options. for starters go thru freshmeat.net. Jatin On Friday 18 January 2002 18:46, Markus Lervik wrote: Hello all! We've requested a database from different companies, and specifically said we wanted MySQL or PostgreSQL because of the open

MySql-3.22.32-client doesn`t install

error i m faing eith development rpm. Pls reply me asap Regards, Jatin. SNTPL

MySql-Client.rpm doesn`t install at all

Dear Sir, I have a Red-hat Linux6.2 . And i have installed MySql -3.23.32 server. It installed successfully. now when go to install MySql-3.23.32.rpm it doesn`t install, same for MySql-devel-2.32.32 it also doesn`t install. And also tell em how to Uninstalled .rpm. Pls reply me asap.