s just to avoid using bandwidth to the remote
datacenters with useless data.
It's working 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&g
rking 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 f
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: Frid
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
On 21.06.2013 13:59, Rafał Radecki wrote:
Hi All.
I
d (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-inno
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 fro
com/2006/07/17/show-innodb-status-walk-through/
has a pretty good description of the SHOW ENGINE INNODB STATUS output,
even though it is not too detailed in this specific section.
--
Hartmut Holzgraefe
Principal Support Engineer (EMEA)
SkySQL AB - http://www.skysql.com/
--
MySQL General Mailing Li
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
present any problem.
Cheers
Claudio
2012/4/17 Halász Sándor
> 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 "sho
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?
k (parent_id) REFERENCES parent(id) ON DELETE NO ACTION ON UPDATE
NO ACTION;
Query OK, 0 rows affected (0.24 sec)
Records: 0 Duplicates: 0 Warnings: 0
Thanks for your prompt help.
Hari
On Tue, Feb 22, 2011 at 2:13 PM, hari jayaram wrote:
> Thanks shawn for your reply. Your simplification of th
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
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 sta
syntax_lap/#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)
On Tue, Sep 21, 2010 at 12:49 PM, Willy Mularto 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 reques
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
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
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 wrote:
From: Gavin Towey
Subject: RE: opened_table status
To: "jitendra ranjan" , "mysql@lists.mysql.com"
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
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
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 i
tool/apps do you use?
Thanks.
James
On Tue, May 18, 2010 at 5:06 AM, Raj Shekhar wrote:
> In infinite wisdom James Corteciano wrote:
>
> > [1 ]
> > Hi All,
> >
> > What is the other way to get the *processlist* and *status* of mysql
> server
> > on event t
In infinite wisdom James Corteciano wrote:
> [1 ]
> 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://poormansprofiler.org/>
--
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
On Thu, Apr 8, 2010 at 9:33 AM, spacemarc wrote:
> 2010/4/7 Carsten Pedersen :
> > 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
2010/4/7 Carsten Pedersen :
> 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://lists
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'
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 M
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 wri
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 a
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 hel
anan...@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,
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
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
mysqladmin processlist -v
or
mysql> show processlist;
Cheers
Claudio
2009/9/4 stutiredboy
> 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
>
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
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 li
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:
@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&quo
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
$ 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
a.id = b.id
where a.status='SENT';
On Tue, Dec 23, 2008 at 7:28 PM, sangprabv 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
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"
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 supp
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=filen
On Wed, Sep 17, 2008 at 12:47 PM, [EMAIL PROTECTED]
<[EMAIL PROTECTED]>wrote:
> Hi,
>
> What's in the bin-logs? (mysqlbinlog )
>
> 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 t
ibution 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
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, Mar
TED]; mysql@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 )
>
> cheers,
> Doug
>
>
> Original Message:
> -
> From: David Giragosian [EMA
Hi,
What's in the bin-logs? (mysqlbinlog )
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 misb
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.
Th
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 o
less
than 5 minutes.
Mike
On Mon, Jul 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 t
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' statemen
here's the master status from the master;
mysql> show master status;
+--+--+--+--+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB |
+--+--+--+--+
| mysql-bin.23 |
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
Mike,
Yes take a peek here:
mysql> show master status;
+--+--+--+--+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB |
+--+--+--+--+
| mysql-bin.45 | 98 | exampl
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:
>
>
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 | Bin
;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 using My
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 Pada
sted 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 t
adhav Padakanti 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
> th
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.
&
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 that
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.
-Stut
Thanks.
-Stut
--
http://stut.net/
--
MySQL General Mailing List
For list archives
here any way 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]
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'
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 at
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 to autom
; method for monitoring 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
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 em
, 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:
>
&
> and row numbers.
>
> Now if I use:
>
> show table status from ;
>
> It will list all the table information I need however, what I am trying to
> figure out is how to get access to the data this produces directly.
>
> The data I want is name, engine, rows, avg_row_leng
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 ;
It will list all the table information I need however, what I am trying to
figure out is how to
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
Fo
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 cl
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,
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
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,
sin
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 REFERENC
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 d
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 a
hich according to 5.2.3
in the manual should be a sort of "automatic" value). In all cases the
explain select on our maximal statement (the one which loops forever in
statistics status under default conditions) reaches an end rather fast,
and returns the same result (irrespective of
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 re
.
On Sat, 1 Sep 2007, Shawn Green wrote:
> 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
&
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
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
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
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 ca
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 mo
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 versi
#x27;server-id'?
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;
> >
> &g
.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.
> >
, 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 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
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 mas
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
ySQL General
Subject: 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
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
1 - 100 of 400 matches
Mail list logo
