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 assum
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 s
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
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/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 there
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/2/2014 9:10 PM, Morgan Tocker wrote:
Hi Jatin,
On Jun 2, 2014, at 7:56 AM, Jatin Davey 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 to fix your problem
On 6/3/2014 4:47 PM, Johan De Meersman wrote:
- Original Message -
From: "Johan De Meersman"
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 been hammering a mun
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
every row but it still has to test against a significant
subset of all rows: If you have 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,
x27;s your technology stack?
On Mon, Jun 2, 2014 at 10:21 AM, Jatin Davey <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
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
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 fi
14 matches
Mail list logo