Hi All
In my application while writing to DB , i could see the following output
from netstat for a single connection to the mysqld DB.
***
tcp 18 0 :::127.0.0.1:3306 :::127.0.0.1:43029
ESTABLISHED 30850/mysqld keepalive (3517.74/0/0)
Hi All
I use mysqldump to take the backup of the entire DB. I want to know if
there is way to find out how much disk space would mysqldump require to
take the backup of the entire DB in .sql file.
Currently what we are doing is to check the size of the
/var/lib/mysql/data directory and
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
Hi All
We are basically intending to implement High Availability for our
application. In this regard , we want to use Mysql replication for this
purpose.
We would have a two-node cluster , say node-1 node-2.
Assume that if node-1is functioning we want the DB changes on it to be
replicated
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
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
Hi All
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 there is a
power Failure on node-1 , we start our application on node-2 but our
problem is
On 6/3/2014 4:47 PM, Johan De Meersman wrote:
- Original Message -
From: Johan De Meersman vegiv...@tuxera.be
Subject: Re: SHOW FULL COLUMNS QUERIES hogging my CPU
In any case, this is nothing that can be fixed on the database level.
I may or may not have to swallow that :-p
I've
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
Hi All
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 some scripts on the
number of queries being sent to the databases.
The query
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
your technology stack?
On Mon, Jun 2, 2014 at 10:21 AM, Jatin Davey jasho...@cisco.com
mailto:jasho...@cisco.com wrote:
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
100 million rows, this will still
cause your query to visit a very large number of them.
So, I would have to ask: how many records are in that table? How many
columns? is it a table or a view?
On Mon, Jun 2, 2014 at 10:21 AM, Jatin Davey jasho...@cisco.com wrote:
On 6/2/2014 7:18 PM, Reindl
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
14 matches
Mail list logo