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
At 13:49 +0800 10/19/05, ⧠àÆ wrote:
yes.
I look reference manual of mysql5.0.12.
For example,there a variables named
"bdb_..",but i can't find these variables
used "show variables".
Your server probably doesn't have BDB support compiled in.
From:
yes.
I look reference manual of mysql5.0.12.
For example,there a variables named "bdb_..",but i can't find these
variables used "show variables".
From: Paul DuBois <[EMAIL PROTECTED]>
To: 猝 嗥 <[EMAIL PROTECTED]>,mysql@lists.mysql.com
Subject: Re:
>My kernel version is 5.0.12.
>When i learn the manual,i didn't find any variables in the manul
>when i used "show variables".Weither there is a lack of manual
>updating?
Some system variables can be read by running mysqld --help or mysqladmin
variables from
At 10:11 +0800 10/19/05, ⧠àÆ wrote:
My kernel version is 5.0.12.
When i learn the manual,i didn't find any
variables in the manul when i used "show
variables".Weither there is a lack of manual
updating?
Did you look here?
http://dev.mysql.com/doc/refman/5.0/e
My kernel version is 5.0.12.
When i learn the manual,i didn't find any variables in the manul when i
used "show variables".Weither there is a lack of manual updating?
thanks
_
免费下载 MSN Explorer: http://explor
or directory
> names ?
>
> Sample (datadir and basedir) :
>
> mysql> SHOW VARIABLES LIKE '%dir%';
> ++
Hello MySQL Fans,
This time I am using 4.0.13-max (tar format from www.mysql.com) on
Redhat 9.
I have an understanding question why would the command SHOW VRAIABLES
give me once the real output and once the symlink ouput for directory
names ?
Sample (datadir and basedir) :
mysql> S
"Primaria Falticeni" <[EMAIL PROTECTED]> wrote:
>
> 1. Is it a way to grow the speed of the replication out of the
> master-connect-retry variable?
What do you mean "speed of replication"?
>
> 2. I backup the databases. Assuming that the last relay log file is
> sql-relay-bin.005 and the last
03 1:16 PM
Subject: Re: show variables
> "Primaria Falticeni" <[EMAIL PROTECTED]> wrote:
> >
> > How can I see the value of master-connect-retry? show variables doesn't
work
> > on it.
>
> Use SHOW SLAVE STATUS command:
> http://www.mysql.com/doc/e
"Primaria Falticeni" <[EMAIL PROTECTED]> wrote:
>
> How can I see the value of master-connect-retry? show variables doesn't work
> on it.
Use SHOW SLAVE STATUS command:
http://www.mysql.com/doc/en/SHOW_SLAVE_STATUS.html
--
For technical support contracts
Hello List,
How can I see the value of master-connect-retry? show variables doesn't work
on it.
Thanks Anticipated,
Iulian
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Bogdan TARU <[EMAIL PROTECTED]> wrote:
>
>Hi Martin,
>
> Hm. Don't really get it. Basically both mysqladmin and 'show variables'
> should read these variables from the mysql server, right? Why then would
> they give separate results?
mysql comma
Hi Martin,
Hm. Don't really get it. Basically both mysqladmin and 'show variables'
should read these variables from the mysql server, right? Why then would
they give separate results?
Thanks,
bogdan
On Mon, 21 Jul 2003, Martin Gainty wrote:
> mysqladmin has
mysqladmin has the capability to specify the my.ini file to read on startup
under " my.ini Setup "
hth,
Martin
- Original Message -
From: "Bogdan TARU" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, July 21, 2003 6:37 AM
Subject: set/show variable
;). Then I restarted mysql, and a
'show variables' would show me:
wait_timeout| 28800
And a 'mysqladmin variables' would report:
wait_timeout| 60
What am I doing wrong here?
Thank you,
bogdan
--
MySQL General Mailin
>Description:
Any issue of the 'show variables' command via the mysql client is causing the
mysql server to get a signal 10 on HP-UX 11. The text in the .err log is as follows:
mysqld got signal 10;
This could be because you hit a bug. It is also possible that this binary
hello,
I'm running version 4.0.3-beta-max-log on SunOS 5.8 (Generic_108528-15
sun4u sparc SUNW,Sun-Fire-280R)
output from mysqlshow -V:
mysqlshow Ver 9.4 Distrib 4.0.3-beta, for sun-solaris2.8 (sparc)
I'm finding that executing either 'show variables' from a mysql se
>Description:
When I issue a "SHOW VARIABLES" request using the standard command
line client, I get a "ERROR 2013: Lost connection to MySQL server
during query". The server error log reports:
"mysqld got signal 10;
This could be because you hi
Hi!
- Original Message -
From: ""Anthony R. J. Ball"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Monday, September 09, 2002 7:52 PM
Subject: Re: SHOW VARIABLES bug in 4.0.3 on solaris 2.7?
>
> > Just out of interest, do you see the
> Just out of interest, do you see the equivalent of a core file when this
> happens? Or anything in the mysql logs?
Don't see any cores... here is the error log entry
mysqld got signal 10;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it wa
Mysql Query
---
Just out of interest, do you see the equivalent of a core file when this
happens? Or anything in the mysql logs?
DSL
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
I just installed the 4.0.3 binary of mysql on our
solaris 2.7 development box, and whenever I do a show variables,
mysql crashes... I can view some variables, and going through
the list is seems that querying 'log_slave_updates' is the one that
is killing mysql...
mysql> show v
Hi,
> Is there a way to redirect the output of a MySQL statement like SHOW
> VARIABLES to a file?
This is extremely easy. On the command line, simply do the following:
$ mysql -u youruser -p --execute="show variables" > yourfile.txt
For info on various command line a
Is there a way to redirect the output of a MySQL statement like SHOW
VARIABLES to a file?
Thanks
Frank
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com
Regards
Quentin
-Original Message-
From: Dave Camarillo [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 15 March 2001 8:43 a.m.
To: '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]'
Subject: RE: Full tables...w/ show
iginal Message-
From: Dave Camarillo [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 15 March 2001 8:43 a.m.
To: '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]'
Subject: RE: Full tables...w/ show variables
Wow...thanks
Wow...thanks for the quick response...
The mysql variables are:
+-+---+
| Variable_name | Value |
+-+---+
| ansi_mode | O
On Wed, Mar 14, 2001 at 03:51:18PM +0900, Tatsuhiko Miyagawa wrote:
> Oops, really :-)
Yes, he posted it in the message with
Message-ID: <[EMAIL PROTECTED]>
Jeremy
> On Tue, 13 Mar 2001 22:48:58 -0800
> "Jeremy D. Zawodny" <[EMAIL PROTECTED]> wrote:
>
> > > I can produce a core/backtrace if
Oops, really :-)
On Tue, 13 Mar 2001 22:48:58 -0800
"Jeremy D. Zawodny" <[EMAIL PROTECTED]> wrote:
> > I can produce a core/backtrace if necessary, but it sounds like this
> > easy to reproduce.
>
> Damn. Monty has already patched it. :-)
--
Tatsuhiko Miyagawa Livin' On The EDGE, Co.
;mysqladmin variables" command
> > always leads to mysql crashing & restarting.
>
> Similar here. Innobase appears to work well, but when I issue a "SHOW
> VARIABLES" on the server, it will crash.
>
> I can produce a core/backtrace if necessary, but it sounds
mysqld has gone away". The
> > /var/lib/mysql/host.err log says this repeatedly:
>
> same here.
>
> Compiling with Innobase, and doing "mysqladmin variables" command
> always leads to mysql crashing & restarting.
Similar here. Innobase appears to wor
Hi!
>>>>> "Andrew" == Andrew Sitnikov <[EMAIL PROTECTED]> writes:
Andrew> Hello Michael,
Andrew> Crash with 'show variables;'
Andrew> configure:
Andrew> CC=gcc \
Andrew> CFLAGS="-O6 -fomit-frame-pointer" \
Andrew>
33 matches
Mail list logo