-ppassword
mysql>show master status;
It show me the wrong logfile name and position, in fact it show
always the same log file name, not the file that the slave is taking
to replicate("show slave status" on slave), regardeless the mysql
instance port.
And &quo
fine, but when i need to see the log pos of an instance to
sync the replication or anything else(for example a delay in the links):
mysql -P instance_1_port -u user -ppassword
mysql>show master status;
It show me the wrong logfile name and position, in fact it show always
the same log file n
SHOW GLOBAL STATUS LIKE 'Innodb%';
Then do some math -- usually dividing by Uptime.
That will give you some insight in how hard the I/O is working, and how full
the buffer_pool is.
-Original Message-
From: Rafał Radecki [mailto:radecki.ra...@gmail.com]
Sent: Friday, June 21, 2013 4:59
knowing the time span
it took to come up to those counter values.
The per second values on the following line are much more interesting.
http://www.mysqlperformanceblog.com/2006/07/17/show-innodb-status-walk-through/
has a pretty good description of the SHOW ENGINE INNODB STATUS output
Hello Rafał,
On 6/24/2013 4:26 AM, Rafał Radecki wrote:
As I can see the changes in these values are use by percona cacti
monitoring templates to graph InnoDB I/O.
Can anyone answer the question finally? ;)
2013/6/21 Hartmut Holzgraefe hart...@skysql.com
On 21.06.2013 13:59, Rafał Radecki
the server started (or maybe last FLUSH call?)
and not very meaningful by themselves without knowing the time span
it took to come up to those counter values.
The per second values on the following line are much more interesting.
http://www.mysqlperformanceblog.com/2006/07/17/show-innodb-status-walk
Hi All.
I've searched but with no luck... what do exactly these variables mean:
1343928 OS file reads, 1085452262 OS file writes, 19976022 OS fsyncs
?
I am wondering if my innodb_buffer_pool setting is not to low. Does 'file
reads' show number of times innodb files have been read into memory
hi;
We are mirrorring Mysql for a while, but when i check mirror list
(http://dev.mysql.com/downloads/mirrors.html) i didn't see our mirror.
Can you add?
Server: ftp.itu.edu.tr/Mirror/Mysql/
Protocol: Ftp HTTP
IP: IPv4 IPv6 (ftp.itu.edu.tr has both A and )
Owner: İTÜ-BİDB (Istanbul
In the command show binary logs one may indifferently write binary or
master, and it is so for some other commands associated with this
function--but for the command show master status there is no such variant.
Why? Is it considered obsolescent?
--
MySQL General Mailing List
For list
problem.
Cheers
Claudio
2012/4/17 Halász Sándor h...@tbbs.net
In the command show binary logs one may indifferently write binary or
master, and it is so for some other commands associated with this
function--but for the command show master status there is no such
variant. Why? Is it considered
/#sql-1515_130f.frm' (errno: 150)
I have attached the create table syntax for both the parent and child tables
and the innodb status below. I am quite a newbie and want to know what I am
doing wrong.
My mysql version is mysql Ver 14.12 Distrib 5.0.51b, for
apple-darwin9.0.0b5 (i686) using readline
Hello Hari,
You already posted the best answer we could provide :)
On 2/22/2011 13:00, hari jayaram wrote:
Hi I am getting a Foreign key error .
...
I have attached the create table syntax for both the parent and child tables
and the innodb status below. ...
mysql show innodb status
Thanks shawn for your reply. Your simplification of the innodb status
message and this post which I just read (http://lists.mysql.com/mysql/221900
)
tells me what I am doing wrong.
I need the referenced column to be indexed. I guess one way of ensuring that
is to declare it as a primary key
of the innodb status
message and this post which I just read (
http://lists.mysql.com/mysql/221900)
tells me what I am doing wrong.
I need the referenced column to be indexed. I guess one way of ensuring
that is to declare it as a primary key .
So when I changed my example to do this:
mysql create
Hi,
I got this result on InnoDB Buffer Pool Status:
Free pages 1
Dirty pages 2,040
Pages containing data 31,359
Pages to be flushed 457,083,205
Busy pages 1,408
Read requests 31,348,288,497
Write requests 7,913,407,934
Read misses 39,736,110
Write waits 0
Read
Willy Mularto wrote:
Hi,
I got this result on InnoDB Buffer Pool Status:
Free pages1
Dirty pages 2,040
Pages containing data 31,359
Pages to be flushed 457,083,205
Busy pages1,408
Read requests 31,348,288,497
Write requests7,913,407,934
Read misses
On Tue, Sep 21, 2010 at 12:49 PM, Willy Mularto sangpr...@gmail.com wrote:
Hi,
I got this result on InnoDB Buffer Pool Status:
Free pages 1
Dirty pages 2,040
Pages containing data 31,359
Pages to be flushed 457,083,205
Busy pages 1,408
Read requests 31,348,288,497
Hi,
I have opened_table status is too high but i don't want increase the value of
table_cache and also dont want to flush table because it will reset the query
cache.
Now my question is how can i decrease the opened_table status ?
Thanks in advance
Jeetendra Ranjan
MySQL DBA
You don't need to flush tables, just increase the table_cache.
-Original Message-
From: jitendra ranjan [mailto:jitendra_ran...@yahoo.com]
Sent: Thursday, August 12, 2010 10:55 AM
To: mysql@lists.mysql.com
Subject: opened_table status
Hi,
I have opened_table status is too high but i
As our file descriptor does not allow to increase the table_cache is there any
other way to decrease the occurence of opened_table ?
--- On Fri, 13/8/10, Gavin Towey gto...@ffn.com wrote:
From: Gavin Towey gto...@ffn.com
Subject: RE: opened_table status
To: jitendra ranjan jitendra_ran
use?
Thanks.
James
On Tue, May 18, 2010 at 5:06 AM, Raj Shekhar rajl...@rajshekhar.net wrote:
In infinite wisdom James Corteciano ja...@linux-source.org wrote:
[1 text/plain; ISO-8859-1 (7bit)]
Hi All,
What is the other way to get the *processlist* and *status* of mysql
server
If your mysql server is hung, crashed or otherwise unreacheable (as you
first posted), you can't connect to it and request it's status and
processlist - it's threaded and thus all inline.
You could use GDB or something similar to go look in the execution stack, as
Raj said, and if you have full
In infinite wisdom James Corteciano ja...@linux-source.org wrote:
[1 text/plain; ISO-8859-1 (7bit)]
Hi All,
What is the other way to get the *processlist* and *status* of mysql server
on event that the mysql server cannot be able to reach due to hung or
crashed?
GDB http
Hi All,
What is the other way to get the *processlist* and *status* of mysql server
on event that the mysql server cannot be able to reach due to hung or
crashed?
Cheers,
James
2010/4/7 Carsten Pedersen cars...@bitbybit.dk:
AFAIR, MySQL 4.x supports LIKE, e.g.
SHOW TABLE STATUS LIKE 'tab_%'
yes, but if the tables have different names (table1, tab_2, abcd... )
your syntax will not work. How to do?
--
MySQL General Mailing List
For list archives: http
On Thu, Apr 8, 2010 at 9:33 AM, spacemarc spacem...@gmail.com wrote:
2010/4/7 Carsten Pedersen cars...@bitbybit.dk:
AFAIR, MySQL 4.x supports LIKE, e.g.
SHOW TABLE STATUS LIKE 'tab_%'
yes, but if the tables have different names (table1, tab_2, abcd... )
your syntax will not work. How
hi all,
in MySQL 4.1.x i want to obtain the status of more tables with one only query.
In 5.x i use SHOW TABLE STATUS WHERE Name IN ('tab_1', tab_2, 'tab_3')
In 4.1.x i tried to use but it doesn't works: how to set the query?
Thanks
--
MySQL General Mailing List
For list archives: http
AFAIR, MySQL 4.x supports LIKE, e.g.
SHOW TABLE STATUS LIKE 'tab_%'
/ Carsten
spacemarc skrev:
hi all,
in MySQL 4.1.x i want to obtain the status of more tables with one only query.
In 5.x i use SHOW TABLE STATUS WHERE Name IN ('tab_1', tab_2, 'tab_3')
In 4.1.x i tried to use but it doesn't
Hi All,
Innodb status information is getting logged on to my mysql error log file
for every 15 seconds, can someone help in disabling it ?
Thanks
Anand
anand
Do you use innodb engine at all further
-D
-Original Message-
From: sanan...@gmail.com [mailto:sanan...@gmail.com] On Behalf Of Anand
Sent: Wednesday, March 17, 2010 3:00 PM
To: mysql@lists.mysql.com
Subject: Disable innodb status info in err log
Hi All,
Innodb status
[mailto:sanan...@gmail.com] On Behalf Of Anand
Sent: Wednesday, March 17, 2010 3:00 PM
To: mysql@lists.mysql.com
Subject: Disable innodb status info in err log
Hi All,
Innodb status information is getting logged on to my mysql error log
file for every 15 seconds, can someone help in disabling
you are right sir , the variables innodb_status_file will write the show
innodb status information on to the file innodb_status.PID ... however for
me the innodb status is logging into the default error log file... i dont
have any clue on how to stop it from writing...
Any help would
On 17/03/2010, at 9:10 PM, Anand kumar wrote:
you are right sir , the variables innodb_status_file will write the
show
innodb status information on to the file innodb_status.PID ...
however for
me the innodb status is logging into the default error log file...
i dont
have any clue on how
are right sir , the variables innodb_status_file will write the show
innodb status information on to the file innodb_status.PID ... however
for
me the innodb status is logging into the default error log file... i dont
have any clue on how to stop it from writing...
Any help would be appreciated
hi,all
can i get how long the client(s) in sleep staus after the client
connected to mysql server
how can i do it ?
thanks very much
tiredboy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
mysqladmin processlist -v
or
mysql show processlist;
Cheers
Claudio
2009/9/4 stutiredboy stutired...@gmail.com
hi,all
can i get how long the client(s) in sleep staus after the client
connected to mysql server
how can i do it ?
thanks very much
tiredboy
--
MySQL General
Good morning guys, (and girls), I hope all is well. I've been given the
task to, and I quote - Write a Nagios plugin to test the replication
status of two servers by
comparing the position on the master to that on the slave
To save myself a lot of work, I'd like to know if anything has been
@lists.mysql.com
Subject: MySQL replication status plugin
Good morning guys, (and girls), I hope all is well. I've been given the
task to, and I quote - Write a Nagios plugin to test the replication
status of two servers by
comparing the position on the master to that on the slave
To save
I'd just write a perl script to do it and return the appropriate status
code/message to nagios. Shouldn't be hard at all. PhP or any language that
can talk to mysql would work, too. You just mentioned the position, you'll
have to compare the names of the binlog files as well: position 100
I would not compare binlog positions. I would use mk-heartbeat from
Maatkit. It tells the truth in a much simpler and more direct way.
Instead of checking things that indicate your data is being
replicated, just replicate some data and check the data itself.
--
MySQL General Mailing List
For
$ watch -d mysqlshow --status myDB #shows the count of rows is
constantly fluctuating for some tables, even though the database is
offline. There ought to be a note about it here and on HELP SHOW TABLE STATUS;
Must use
o --count
Show the number of rows per table.
(Which also
= b.id
where a.status='SENT';
On Tue, Dec 23, 2008 at 7:28 PM, sangprabv sangpr...@gmail.com wrote:
Hi,
I have a table which stores log traffic. The table contains these
fields:
transaction_id, from, to, message, status, insertdate
For example there is a message from A send to B, when the message
Hi,
I have a table which stores log traffic. The table contains these
fields:
transaction_id, from, to, message, status, insertdate
For example there is a message from A send to B, when the message sent
to B it will insert new record. And when the message is read by B, it
will also insert new
Try show global status like 'com_select';
Donna
Jim Lyons
[EMAIL PROTECTED]
.com
I have been trying to compute query cache utilization in mysql 5 but cannot
because the com_select status variable is always 1 when I start a new mysql
session. This probably holds for all the com_* variables and maybe others,
but I've only been working with com_select. They're supposed
In infinite wisdom David Giragosian [EMAIL PROTECTED] spoke thus:
But you've asked the right question without a doubt.
I'm sure there'll be a next time...
Next time when you keep seeing inserts even after stopping all the
writes, turn on the general query log (--log or add log=filename in
Hurricane Ike has caused our replication set-up to misbehave.
I've stopped the (one and only) application that inserts data into the
master, but show master status's 'position' field continues to increment.
Have I missed something or is this unexpected behavior?
version 5.0.22 on CentOS 5.
Hi,
What's in the bin-logs? (mysqlbinlog log)
cheers,
Doug
Original Message:
-
From: David Giragosian [EMAIL PROTECTED]
Date: Wed, 17 Sep 2008 12:38:01 -0500
To: mysql@lists.mysql.com
Subject: Show Master Status
Hurricane Ike has caused our replication set-up to misbehave
@lists.mysql.com
Subject: RE: Show Master Status
Date: Wed, 17 Sep 2008 13:47:49 -0400
Hi,
What's in the bin-logs? (mysqlbinlog log)
cheers,
Doug
Original Message:
-
From: David Giragosian [EMAIL PROTECTED]
Date: Wed, 17 Sep 2008 12:38:01 -0500
To: mysql
On Wed, Sep 17, 2008 at 12:54 PM, Martin Gainty [EMAIL PROTECTED] wrote:
Dave-
we havent had a hurricane since up here since 1938..if you want to relocate
your servers just give a holler
and i'll lend you mine!
Martin
__
Thanks, Martin. Wish
to any party other than intended recipient. Sender does
not necessarily endorse content contained within this transmission.
Date: Wed, 17 Sep 2008 13:14:36 -0500
From: [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Subject: Re: Show Master Status
On Wed, Sep 17, 2008 at 12:54 PM, Martin Gainty
On Wed, Sep 17, 2008 at 12:47 PM, [EMAIL PROTECTED]
[EMAIL PROTECTED]wrote:
Hi,
What's in the bin-logs? (mysqlbinlog log)
cheers,
Doug
Doug,
We capture time-sensitive data, and after checking all the counts on tables
known to accept inserts, I restarted the server. That stopped the
I'm having an issue setting up a slave Where it doesn't seem to start:
mysql show master status;
+--+--+--+--+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB
Did you start from position Exec_Master_Log_Pos 1? Can you tell us the
command you used to get this going?
Mike
On Mon, Jul 28, 2008 at 4:14 PM, Bryan Irvine [EMAIL PROTECTED] wrote:
I'm having an issue setting up a slave Where it doesn't seem to start:
mysql show master status
Mike,
Yes take a peek here:
mysql show master status;
+--+--+--+--+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB |
+--+--+--+--+
| mysql-bin.45 | 98 | exampledb
Do you have the original mysql show slave status\G; off the master?
I have a feeling you have the position wrong. I about 100% sure you have
the position wrong because it happened to me.
if you don't have it do a show slave status\G; and try to remember which one
you took.
Mike
On Mon, Jul 28
here's the master status from the master;
mysql show master status;
+--+--+--+--+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB |
+--+--+--+--+
| mysql-bin.23 | 98
If that's the master server's master status, then yes, you want to
'change master to' this on the slave and see if it starts.
If it doesn't I'd take a fresh mysqldump with the --master-data
parameter and refresh the slave, run the 'change master' statement at
the top of the backup and it should
28, 2008 at 5:26 PM, Mary Bahrami [EMAIL PROTECTED]wrote:
If that's the master server's master status, then yes, you want to
'change master to' this on the slave and see if it starts.
If it doesn't I'd take a fresh mysqldump with the --master-data
parameter and refresh the slave, run
whoops! nevermind I just found it. Both of the servers had a server-id of 1.
*blush*
On Mon, Jul 28, 2008 at 2:26 PM, Mary Bahrami [EMAIL PROTECTED] wrote:
If that's the master server's master status, then yes, you want to
'change master to' this on the slave and see if it starts
I don't think anyone answered your actual question, so here's my attempt..
http://dev.mysql.com/doc/refman/5.0/en/server-status-variables.html
Many status variables are reset to 0 by the FLUSH STATUS
statement.
Atle
On Fri, 20 Jun 2008, Venu Madhav Padakanti wrote:
I am
/refman/5.0/en/server-status-variables.html
Many status variables are reset to 0 by the FLUSH STATUS
statement.
Atle
On Fri, 20 Jun 2008, Venu Madhav Padakanti wrote:
I am using MySQL version 5.0.22, I am interested in knowing the current
performance on the MySQL
I am using MySQL version 5.0.22, I am interested in knowing the current
performance on the MySQL.
With the status command we can get the queries per second but it will
average since the beginning of time when SQL was up and running and not
the current rate?
Is there any way to reset
if using innodb do
show innodb status\G.
Here u will see real time insert,delete,update and selects.
On 6/20/08, Venu Madhav Padakanti [EMAIL PROTECTED] wrote:
I am using MySQL version 5.0.22, I am interested in knowing the current
performance on the MySQL.
With the status command we
wrote:
I am using MySQL version 5.0.22, I am interested in knowing the current
performance on the MySQL.
With the status command we can get the queries per second but it will
average since the beginning of time when SQL was up and running and not
the current rate?
Is there any way
.
With the status command we can get the queries per second but it will
average since the beginning of time when SQL was up and running and not
the current rate?
Is there any way to reset that parameter so that the data can reflect
current without restarting the MySQL
Thanks in advance
Hi,
I just finished restoring a 22gig SQL dump but the server is not
performing anywhere near where it should be. I'm assuming this is
because it's still rebuilding indexes on the imported tables.
Is there any way to see the indexing status so I can gauge how far
it's got?
Thanks
to see the indexing status so I can gauge how far it's
got?
Thanks.
-Stut
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
assuming this is
because it's still rebuilding indexes on the imported tables.
Is there any way to see the indexing status so I can gauge how far
it's got?
Thanks.
-Stut
Thanks.
-Stut
--
http://stut.net/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
Hi All,
show engine innodb status gives the following information. I am not able to
draw conclusion.
SEMAPHORES
--
OS WAIT ARRAY INFO: reservation count 97641, signal count 97303
--Thread 1140881760 has waited at log0log.c line 1986 for 0.00 seconds the
semaphore:
S-lock on RW-latch
an email or alert whenever it is
down.
Every so often, I would logon to MySQl and issue this command: SHOW
SLAVE STATUS. I would like to automate this process. I would like to
parse the output of this command and look pertinent info such as
seconds_behind_master 10. If it greater
often, I would logon to MySQl and issue this command: SHOW
SLAVE STATUS. I would like to automate this process. I would like to
parse the output of this command and look pertinent info such as
seconds_behind_master 10. If it greater than 10, then I'll send out
an email saying replication is in error
replication in MySQL. Recently, my replication
stopped as a result of duplicate row found in the slave. Therefore, I
would like to monitor and send out an email or alert whenever it is
down.
Every so often, I would logon to MySQl and issue this command: SHOW
SLAVE STATUS. I would like
.
The first task I need to run is to determine the database table storage engines
(all make use of MyISAM, InnoDB and Archive), then update frequency and row
numbers.
Now if I use:
show table status from database name;
It will list all the table information I need however, what I am trying to
figure
version, some installations
have just 2 or 3 databases some have 20 or more.
The first task I need to run is to determine the database table storage
engines (all make use of MyISAM, InnoDB and Archive), then update frequency
and row numbers.
Now if I use:
show table status from database
databases some have 20 or more.
The first task I need to run is to determine the database table storage
engines (all make use of MyISAM, InnoDB and Archive), then update frequency
and row numbers.
Now if I use:
show table status from database name;
It will list all the table information I
Am Dienstag, den 08.01.2008, 14:48 +0800 schrieb Moon's Father:
I always confused to them.
It's explained in the documentation:
http://dev.mysql.com/doc/refman/5.0/en/show-status.html
http://dev.mysql.com/doc/refman/5.0/en/show-variables.html
Norbert
--
MySQL General Mailing List
On Fri, Sep 14, 2007 at 01:33:51AM -0700, Jeremy Cole wrote:
Hi Shawn, Lucio,
SELECT STRAIGHT_JOIN
FROM ...
LEFT JOIN ...
WHERE ...
...
Just to correct a point here... if a query uses only LEFT JOIN or RIGHT
JOIN, the join order is fixed by the query's order itself, so using
Just a quick note to add to this conversation:
Pete Harlan wrote:
On Fri, Sep 14, 2007 at 01:33:51AM -0700, Jeremy Cole wrote:
MySQL's optimizer cannot reorder the joins because it has the potential
to change the result of the query.
Not in all cases. If a LEFT JOIN query also has a WHERE
Hi Shawn, Lucio,
SELECT STRAIGHT_JOIN
FROM ...
LEFT JOIN ...
WHERE ...
...
Just to correct a point here... if a query uses only LEFT JOIN or RIGHT
JOIN, the join order is fixed by the query's order itself, so using
STRAIGHT_JOIN should have no effect whatsoever. Equally important,
On Fri, 14 Sep 2007, Jeremy Cole wrote:
Just to correct a point here... if a query uses only LEFT JOIN or RIGHT JOIN,
the join order is fixed by the query's order itself, so using STRAIGHT_JOIN
should have no effect whatsoever. Equally important, since the join order is
but experimentally
On Tue, 4 Sep 2007, Shawn Green wrote:
On Tue, 4 Sep 2007, Lucio Chiappetti wrote:
For each I tested 3 cases (total 16*3=48) :
a) the query on the virtual table correlated with the external
(the virtual is my G left join t1 ... left join tn). [...]
represents my REFERENCE,
this
which loops forever in
statistics status under default conditions) reaches an end rather fast,
and returns the same result (irrespective of 0/10/15/20).
The ORDER returned by playign with optimizer_search_depth is however
different from the one returned with SELECT STRAIGHT_JOIN. The difference
On Tue, 4 Sep 2007, Lucio Chiappetti wrote:
I'll do some experimenting and report back.
In lack of better ways of doing a tie-break, I've done the following
tests (with the linemode client), checking both the results of a query and
the total time spent. I tested 16 different combinations of
Lucio Chiappetti wrote:
On Tue, 4 Sep 2007, Lucio Chiappetti wrote:
I'll do some experimenting and report back.
In lack of better ways of doing a tie-break, I've done the following
tests (with the linemode client), checking both the results of a query and
the total time spent. I tested 16
:
Lucio Chiappetti wrote:
I have some queries, involving a largish number of JOIN, which are
[...] very slow or [...] remain in the statistics status [forever]
This involved creating a working table G
[...]
The simultaneous access was achieved in our interface by a mechanism
we called
Hello Lucio,
Thank you for the excellent description of you problem. I believe I
completely understand both the data you are handling and the problems
you are facing.
I would not ask you to change your schema at this point. There is far
too much work put into it at this phase to suggest a
Hello Lucio,
(reply below)
Lucio Chiappetti wrote:
I have some queries, involving a largish number of JOIN, which
are apparently very slow or even take forever (a mysqladmin processlist
shows them remain in the statistics status for a long time, in most
cases I have to kill them after several
I have some queries, involving a largish number of JOIN, which
are apparently very slow or even take forever (a mysqladmin processlist
shows them remain in the statistics status for a long time, in most
cases I have to kill them after several minutes).
When I first had the problem I googled
Hi Friends,
When i do SHOW INNODB STATUS\G. It gives me details of transaction
happening on INNODB engine.
Please let me know what all information i should consider from this output
to ensure if everything is fine or there are issue which i should address.
I am using mysql version 5.0.41
To have a good understanding on the show innodb status output checkout
http://www.mysqlperformanceblog.com/2006/07/17/show-innodb-status-walk-through/
One area you can look at is the LATEST DETECTED DEADLOCK. But in most
cases have found calculations on the status variables more helpful.
--
Alex
Thanks a lot Alex.
regards
anandkl
On 8/29/07, Alex Arul Lurthu [EMAIL PROTECTED] wrote:
To have a good understanding on the show innodb status output checkout
http://www.mysqlperformanceblog.com/2006/07/17/show-innodb-status-walk-through/
One area you can look at is the LATEST DETECTED
Alex Arul Lurthu wrote:
To have a good understanding on the show innodb status output checkout
http://www.mysqlperformanceblog.com/2006/07/17/show-innodb-status-walk-through/
One area you can look at is the LATEST DETECTED DEADLOCK. But in most
cases have found calculations on the status
'?
On Wed, 20 Jun 2007, Gerald L. Clark wrote:
Ananda Kumar wrote:
Hi All,
We have setup replication. Mysql version 5.0.40. On master db, if i
execute
the below command it showing
show master status\G;
Empty set (0.01 sec)
You do not have replication setup.
ERROR:
No query
execute
the below command it showing
show master status\G;
Empty set (0.01 sec)
You do not have replication setup.
ERROR:
No query specified
Use \G or ; but not both.
what could be the reason, and how do i fix it. Please help
regards
anandkl
--
Gerald L. Clark
Hi All,
We have setup replication. Mysql version 5.0.40. On master db, if i execute
the below command it showing
show master status\G;
Empty set (0.01 sec)
ERROR:
No query specified
what could be the reason, and how do i fix it. Please help
regards
anandkl
Ananda Kumar wrote:
Hi All,
We have setup replication. Mysql version 5.0.40. On master db, if i execute
the below command it showing
show master status\G;
Empty set (0.01 sec)
You do not have replication setup.
ERROR:
No query specified
Use \G or ; but not both.
what could be the reason
: master status is null
Hi All,
We have setup replication. Mysql version 5.0.40. On master db, if i
execute
the below command it showing
show master status\G;
Empty set (0.01 sec)
ERROR:
No query specified
what could be the reason, and how do i fix it. Please help
regards
anandkl
Hi All,
I tried both
mysql show master status;
Empty set (0.00 sec)
mysql show master status\G
Empty set (0.00 sec)
Can you please let me know what i need to do. Actually, when we loading data
using LOAD DATA method, the file system became 100% and the slave stop and
is giving the below error
Also, Flush logs on master is not creating any new bin-logs, any specific
reason. Now we have close to 19GB free space.
regards
anandkl
On 6/20/07, Ananda Kumar [EMAIL PROTECTED] wrote:
Hi All,
I tried both
mysql show master status;
Empty set (0.00 sec)
mysql show master status\G
Empty
1 - 100 of 390 matches
Mail list logo