03.2018 um 22:59 schrieb Roger House:
>>> >>> In all respects except one, the treatment of Unicode works just
>>> fine.
>>> >>> I can write Unicode to database tables, read it, display it,
>etc.,
>>> >>> with no problems.
2:59 schrieb Roger House:
>>> In all respects except one, the treatment of Unicode works just
fine.
>>> I can write Unicode to database tables, read it, display it, etc.,
>>> with no problems. The exception is mysql, the MySQL Command-Line
>>> Tool. When I execute
ects except one, the treatment of Unicode works just fine.
>>> I can write Unicode to database tables, read it, display it, etc.,
>>> with no problems. The exception is mysql, the MySQL Command-Line
>>> Tool. When I execute a SELECT statement to see rows in a table
>>
ust fine.
>>> I can write Unicode to database tables, read it, display it, etc.,
>>> with no problems. The exception is mysql, the MySQL Command-Line
>>> Tool. When I execute a SELECT statement to see rows in a table
>>> containing the Venus and Mars Unicode ch
I am running Ubuntu MATE 16.04. I have the problem also on Windows 7
and on Mac OS Version 10.11.6. I do not think that the problem has to
do with the operating system nor the terminal. Everything about the
Unicode text works fine in all tools such as editors, the cat command,
etc. It is
Am 13.03.2018 um 22:59 schrieb Roger House:
In all respects except one, the treatment of Unicode works just fine. I
can write Unicode to database tables, read it, display it, etc., with no
problems. The exception is mysql, the MySQL Command-Line Tool. When I
execute a SELECT statement to see
Five months ago I posted the query shown below on StackOverflow. I got
one reply which was not of much help. So I am trying again, hoping a
more MySQL-centric forum might be able to solve my problem.
Roger House
How to get the MySQL Command-Line Tool to display Unicode properly?
I use a
2017/10/18 18:32 ... Roger House:
I get the same behavior with the MySQL Command Line Tool when I run it on
Windows, Mac OS X, and Ubuntu, so I'm pretty sure the problem has to do
with mysql itself.
What do you know about the displays to which the client is writing?
In the case of "
n, all tables are created with these parameters:
ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
In all respects except one, the treatment of Unicode works just fine. I can
write Unicode to database tables, read it, display it, etc., with no
problems. The exception is mysq
s out of sync, you can't run this command now'
This error is generated sometimes when opening a page ,and immediately
after refreshing the page, error gone.
Can you please help me to troubleshoot this issue, so that above error
disappears permanently? Is it a database issue or applica
-sync.html
http://stackoverflow.com/questions/15798762/mysqli-commands-out-of-sync-you-cant-run-this-command-now
On Friday, January 8, 2016 10:47 AM, geetanjali mehra
wrote:
Hi all,
Suddenly I have started getting below error from our web site:
'commands out of sync, you can'
Hi all,
Suddenly I have started getting below error from our web site:
'commands out of sync, you can't run this command now'
This error is generated sometimes when opening a page ,and immediately
after refreshing the page, error gone.
Can you please help me to troubleshoot this
>>>> 2014/12/12 02:10 +0100, Christophe >>>>
When the app tries to do this, it raises an error :
'The used command is not allowed with this MySQL version'
The used MySQL version is 5.5.40 from Debian Wheezy package.
I found that some parameters or variables
Hi,
Le 12/12/2014 11:51, Johan De Meersman a écrit :
- Original Message -
From: "yoku ts."
Subject: Re: command is not allowed with this MySQL version
Christophe has already told,
The used MySQL version is 5.5.40 from Debian Wheezy package.
No, that's the new versi
- Original Message -
> From: "yoku ts."
> Subject: Re: command is not allowed with this MySQL version
>
> Christophe has already told,
>> > The used MySQL version is 5.5.40 from Debian Wheezy package.
No, that's the new version. It'd be
Hi,
Christophe has already told,
> > The used MySQL version is 5.5.40 from Debian Wheezy package.
Maybe you missed *mysql command-line client's --local-infile option*
$ bin/mysql
mysql> SELECT @@version;
++
| @@version |
++
| 5.5.40-log |
+
- Original Message -
> From: "Christophe"
> Subject: command is not allowed with this MySQL version
>
> 'The used command is not allowed with this MySQL version'
Out of sheer morbid curiosity, what version were they running?
--
Unhappiness is discou
dummy, @dummy, @dummy,
@dummy, @dummy, @dummy, @dummy, @dummy)
When the app tries to do this, it raises an error :
'The used command is not allowed with this MySQL version'
The used MySQL version is 5.5.40 from Debian Wheezy package.
I found that some parameters or variables (local_infile
Hello ccleve,
On 9/19/2014 3:06 PM, ccleve wrote:
I need to do upserts and I need cross-database compatibility. I'd hate
to drop support for MySQL in my product. Does MySQL plan to support
the ANSI-standard MERGE command for upserts?
You appear to be looking for one of these com
I need to do upserts and I need cross-database compatibility. I'd hate
to drop support for MySQL in my product. Does MySQL plan to support the
ANSI-standard MERGE command for upserts?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
ne, and they had
> > been running functionally fine since about 6 years or so (catering to
> > millions of records per day).
> >
> > However, since last few days, we were experiencing some elongated
> > slowness on both the instances.
> > So, we decided to "
" on both the instances.
>
> We first ran the command on one instance.
> That speeded up things massively (select count(*) that was earlier
> taking 45 minutes was now running in less than 3 minutes).
>
>
> We then ran the command on the second instance. However, that
o that
via phpMysqlAdmin?
Yes, you will need to use your phpMysqlAdmin session to issue an
appropriate GRANT command so that the 'wybo' user can login from
'wybo.fritz.box'.
Example -
GRANT on *.* to
'wybo'@'wybo.fritz.box' IDENTIFIED BY 'passwor
o issue an
appropriate GRANT command so that the 'wybo' user can login from
'wybo.fritz.box'.
Example -
GRANT on *.* to
'wybo'@'wybo.fritz.box' IDENTIFIED BY 'password goes here in plain text'
Research the GRANT command itself (and the oth
Hi Wybo,
On 8/20/2014 3:47 PM, Wybo wrote:
My Synology station is on 192.168.178.27,
the database listens to port 3306,
on my FritzBox I forwarded port 3306 to 192.168.178.27,
I /can/ connect to the database on http://192.168.178.27/phpMyAdmin/
But when I try:
mysql --host=192.168.178.27 --pass
My Synology station is on 192.168.178.27,
the database listens to port 3306,
on my FritzBox I forwarded port 3306 to 192.168.178.27,
I /can/ connect to the database on http://192.168.178.27/phpMyAdmin/
But when I try:
mysql --host=192.168.178.27 --password=* --user=wybo
I get:
ERROR 1045 (2
Check your ~/.my.cnf and other places where configuration might be causing the
problem (such as "pager").
> -Original Message-
> From: Radoulov, Dimitre [mailto:cichomit...@gmail.com]
> Sent: Wednesday, September 18, 2013 7:32 AM
> To: zxycscj; mysql
> Subjec
On 18/09/2013 16:17, zxycscj wrote:
execute mysql command has no content. help
[...]
mysql> use ijdb;
Database changed
mysql> show tables;
7 rows in set (0.00 sec)
[...]
I suppose that the mysql pager is set to a non-default value.
On the mysql prompt try:
pager
repeat your comman
execute mysql command has no content. help
I google searched without answer
--
afj:~$ mysql -h localhost -u a -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 20
Server version: 5.1.56 Source
2013/3/31 Norah Jones
> Hi,
>
> To source sqldump i can use the source command, but if I need to do the
> same stuff using command line without going to the sqlpromt, can I achieve
> that.
>
>
Hello,
You mean cat sqldump.sql | mysql -uwhatever -pwhatever whatever_database ?
Manuel.
I'm getting an occasional error from one of my slaves running
community mysql 5.5.16:
'Got an error writing communication packets' on query. Query: 'flush tables'
Which halts replication on this slave until I issue a 'SET GLOBAL
sql_slave_skip_counter=1' com
sql/mysql/SELECT$ cat main.sql
> use test
> select * from event;
>
> ===
>
> The above command doesn't print as formatted in the following. I'm
> wondering what options I should use to produce a result similar to the
> following.
Add the --table option to your m
First birthday
~/linux/test/mysql/mysql/SELECT$ cat main.sh
^[#!/usr/bin/env bash
mysql -hlocalhost -uuser < main.sql
~/linux/test/mysql/mysql/SELECT$ cat main.sql
use test
select * from event;
===
The above command doesn't print as formatted in the following. I'm
w
Yu"
> To: mysql@lists.mysql.com
> Sent: Monday, 10 October, 2011 12:19:20 AM
> Subject: Why the same command have different results when it is in a bash
> script and when it is not?
>
> Hi,
>
> It is seems strange to me why the same command "mysql -hlocalhost
&
> It is seems strange to me why the same command "mysql -hlocalhost
> -uxxx" when it is run from the command line, it will show an error.
> When it is run in a bash script, it runs fine. I guess this might be
> described somewhere, but I'm yet to find the answer. D
Hi,
It is seems strange to me why the same command "mysql -hlocalhost
-uxxx" when it is run from the command line, it will show an error.
When it is run in a bash script, it runs fine. I guess this might be
described somewhere, but I'm yet to find the answer. Does anybody know
w
On Mon, 06 Jun 2011 18:54 +0200, "Johan De Meersman"
wrote:
> > Excluding 'performance_schema' appears to eliminate the error. And it
> > seems does NOT cause a reliability-of-the-backup problem.
>
> Hah, no, backing that up is utterly pointless.
that's a useful/final confirmation. thx.
> No,
- Original Message -
> From: ag...@airpost.net
>
> Excluding 'performance_schema' appears to eliminate the error. And it
> seems does NOT cause a reliability-of-the-backup problem.
Hah, no, backing that up is utterly pointless. Never noticed it doing that.
It's basically a virtual schem
On Mon, 06 Jun 2011 12:44 +0200, "Johan De Meersman"
wrote:
>
> I haven't bothered to look for the "bug", but it seems to me to be quite
> reasonable default behaviour to lock the whole lot when you're dumping
> transactional tables - it ensures you dump all tables from the same
> consistent vi
I haven't bothered to look for the "bug", but it seems to me to be quite
reasonable default behaviour to lock the whole lot when you're dumping
transactional tables - it ensures you dump all tables from the same consistent
view.
I would rather take this up with the ZRM people - it should "just
Am 05.06.2011 23:55, schrieb ag...@airpost.net:
> i still have no idea why this is necessary.
take it or not
it is a professional solution which works for
databses with 20 GB every day here with rsync
without interrupt/lock mysqld a second
and it is much faster
> there seems to be a but, prob
i still have no idea why this is necessary.
there seems to be a but, problem, misconfiguration, etc.
wouldn't it make some sense to try to FIX it, rather than setting up a
completely different server?
perhaps someone with an idea of the problem and its solution will be
able to chime in.
--
My
Am 05.06.2011 23:49, schrieb ag...@airpost.net:
>
> On Sun, 05 Jun 2011 23:29 +0200, "Reindl Harald"
> wrote:
>> i would use a replication slave and stop him for consistent backups
>> because dumb locks are not really a good solution independent
>> if this works "normally"
>
> unfortunately, i
On Sun, 05 Jun 2011 23:29 +0200, "Reindl Harald"
wrote:
> i would use a replication slave and stop him for consistent backups
> because dumb locks are not really a good solution independent
> if this works "normally"
unfortunately, i have no idea what that means.
something's apparently broken w
On Sun, 05 Jun 2011 23:30 +0200, "Reindl Harald"
wrote:
> BTW
> WHY is everybody ansering to the list AND the author of the last post?
> this reults in get every message twice :-(
Reply -> sends to ONLY the From == h.rei...@thelounge.net
Reply to all sends to BOTH the From == h.rei...@thelounge.n
ctadmin.com/forum/showthread.php?p=202053
>
> and one
>
>
> http://qa.lampcms.com/q122897/Can-t-backup-mysql-table-with-mysqldump-SELECT-LOCK-TABL-command
>
> claims a solution
>
> "Add --skip-add-locks to your mysqldump command"
>
> which, havi
i'd
> already referenced,
>
> http://www.directadmin.com/forum/showthread.php?p=202053
>
> and one
>
>
> http://qa.lampcms.com/q122897/Can-t-backup-mysql-table-with-mysqldump-SELECT-LOCK-TABL-command
>
> claims a solution
>
> "Add --skip-add-loc
fwiw, others are seeing this. e.g., in addition to the two bugs i'd
already referenced,
http://www.directadmin.com/forum/showthread.php?p=202053
and one
http://qa.lampcms.com/q122897/Can-t-backup-mysql-table-with-mysqldump-SELECT-LOCK-TABL-command
claims a solution
"Add --skip
the grant statements does nobody interest
maybe use phpmyadmin for a clearer display
mysql> select * from mysql.user where user='root' limit 1;
+---+--+---+-+-+-+-+-+---+
hi,
On Sun, 05 Jun 2011 22:24 +0200, "Reindl Harald"
wrote:
> have you checked you permissions-table if all privileges are active for root
i've got,
mysql> show grants for 'root'@'localhost';
+--
OR @ console,
>
> ...
> manual:backup:INFO: PHASE START: Creating raw backup
> manual:backup:INFO: Command used for raw backup is
> /usr/share/mysql-zrm/plugins/socket-copy.pl
> --mysqlhotcopy=/usr/bin --host="localhost" --port="3306&
xec of that backup cmd, i see an ERROR @ console,
...
manual:backup:INFO: PHASE START: Creating raw backup
manual:backup:INFO: Command used for raw backup is
/usr/share/mysql-zrm/plugins/socket-copy.pl
--mysqlhotcopy=/usr/bin --host="localhost"
a
is very large.
When I issue *repair table ac_src command *it take more than 20 hours
to complete and still running.
Accidently, server power got down & my command destroyed.
Today I got stuck to it because I want to use that table & insert data
in it. When I check my table it show
dump error 1064 for database Use command
Hi win.a,
I tried with another user the problem still persists. I am getting same
error for another user as well.
--
Regards,
Manasi Save
On Tue, 7 Sep 2010 11:41:35 0800, "win.a" wrote:
use another user and dump the data ,eg the root .
&
-al-databases >AllNew_Databases_20100904.sql
>
> All you best
>
> What we are struggling for ?
> The life or the life ?
>
>
>
>
> On Mon, Sep 6, 2010 at 8:33 PM, Manasi Save
> wrote:
> > Hi win.a,
> >
> > How am I suppos
e newly installed mysql on this server.
> >
> > mysql> Select version();
> > -
> > | version() |
> > -
> > | 5.1.22-rc-Debian_2~ppa5-log |
> > -
> >
>
the same command on Fedora-with same mysql version.
I could not possibly change the database name. There are quite a few
databases I have on the system.
--
Regards,
Manasi Save
Does it work when you dump only the database `1`?
--
Jangita | +256 76 91 8383 | Y! & MSN: jang...@yahoo.com
Skype:
Dear Nitin,
I have newly installed mysql on this server.
mysql> Select version();
+-+
| version() |
+-+
| 5.1.22-rc-Debian_2~ppa5-log |
+-+
Earlier I use to run the same command on Fed
name (of database in your case).
Hope that helps.
Regards,
Nitin
From: Manasi Save
To: "mysql@lists.mysql.com"
Sent: Sat, September 4, 2010 12:06:27 PM
Subject: mysqldump error 1064 for database Use command
Hi All,
I have 10 mysql databases all
Hi All,
I have 10 mysql databases all the tables use MyIsAm mysql storage
engine.
Database names are 1,2,3,4,...10.
When I use mysqldump command with --all-databases option. This gives me
following error:
mysqldump -u myuser -p --all-databases > AllNew_Databases_20100904.sql
ERROR MESS
In the last episode (Aug 25), Moon's Father said:
> Hi.
>For example, entering mysql command line client,
>mysql> pager more ( or pager md5sum and so on.)
>
>I want to know how many command the 'pager' follows? Any reply will
> be big appreciated.
I know, all the shell command can do this. Thanks.
2010/8/25 Moon's Father
> Hi.
>For example, entering mysql command line client,
>mysql> pager more ( or pager md5sum and so on.)
>
>I want to know how many command the 'pager' follows? Any reply will be
> big appreciated.
>
Hi.
For example, entering mysql command line client,
mysql> pager more ( or pager md5sum and so on.)
I want to know how many command the 'pager' follows? Any reply will be
big appreciated.
Hi all, I have upgraded a few test boxes and everything seems to work fine BUT
I
wanted to verify with the gurus if my syntax is correct so as to avoid any
future problems ;-)
The purpose is to dump all databases and users / user privileges from our
4.1.20
server and import it into our 5.1.49
Hi,
I want to check daily a large database. If I execute a "mysqlcheck", its
execution is longer the 8 minutes.
What is the best practice to check tables daily ? medium option? Fast
option?
Regards,
David
I'm not 100% sure I understand what you are wanting but if I do, the
INSERT ... ON DUPLICATE KEY UPDATE Syntax detailed here
http://dev.mysql.com/doc/refman/5.0/en/insert-on-duplicate.html
Will probably do what you want. For it to work you would have to have a
unique key on the three field
>-Original Message-
>From: Jerry Schwartz [mailto:jschwa...@the-infoshop.com]
>Sent: Wednesday, March 17, 2010 10:07 AM
>To: '??? '; 'John Oliver'
>Cc: mysql@lists.mysql.com
>Subject: RE: Trancate table from command line?
>
>Am I mis
ngton, CT 06032
860.674.8796 / FAX: 860.674.8341
www.the-infoshop.com
>-Original Message-
>From: ??? [mailto:ekilimc...@gmail.com]
>Sent: Wednesday, March 17, 2010 1:57 AM
>To: John Oliver
>Cc: mysql@lists.mysql.com
>Subject: Re: Trancate table from command line
John
I think you can do this way on shell:
mysql -h db_server -u user -pPASSWORD -e "truncate table
table1"
Carlos Eduardo Caldi
> Date: Tue, 16 Mar 2010 14:12:42 -0700
> From: joli...@john-oliver.net
> To: mysql@lists.mysql.com
> Subject: Trancate t
Hi
i am debutant in SQL and i am search to know if it's possible:
My SQL requets:
UPDATE Table_Logs_Summary SET
mails_recus=(mails_recus+1),mail_rbl=(mail_rbl+1) WHERE dom_id=4 AND
Date_Start="2010-03-16 06:00:00" AND Date_End="2010-03-16 06:59:59";
I wan't know if they have a optimised sql
a table as a
> one-off command from the command line?
>
> I have an issue with importing data from one database into another, but
> the second database might have columns that the first did not.
>
> On database 1, I use mysqldump to grab certain tables, and when I try to
> simply &
On Tue, Mar 16, 2010 at 02:12:42PM -0700, John Oliver wrote:
> Is there a way to use mysqladmin (or mysql) to truncate a table as a
> one-off command from the command line?
>
> I have an issue with importing data from one database into another, but
> the second database might ha
Is there a way to use mysqladmin (or mysql) to truncate a table as a
one-off command from the command line?
I have an issue with importing data from one database into another, but
the second database might have columns that the first did not.
On database 1, I use mysqldump to grab certain tables
Devart
Email: i...@devart.com
Web: http://www.devart.com
FOR IMMEDIATE RELEASE
CONTACT INFORMATION:
Julia Samarska
jul...@devart.com
26-Feb-10
Schema and Data Comparison and Synchronization Tools for MySQL Offer Command
Line Mode and Comparison Reports
MySQL database
does NOT work for
MySQL 4.x, however (I have another machine that only has MySQL
4.1.12).
For MySQL 4, the best I could do was this:
1 - Run the following "mysqlshow" command :
# mysqlshow database_name table_name -p > field_list.txt
2 - Open the "field_list.txt" in the
installed.
In that server, I have a database that has a table with many fields (around 60).
It would be convenient for me to get a list of those fields ordered by
field / column name. Unfortunately, a "DESC tablename ("DESCRIBE
tablename") command, in "MySQL monitor" (t
tablename") command, in "MySQL monitor" (the MySQL command line
client) returns a table with that table fields, but the fields appear
in a strange order. I'm guessing this strange order can be the order
given by the "CREATE TABLE" command that was used to create that
tabl
Hi,
After analysing slow query log i found that some queries are not using index
and so i used the force index command in query and test it and now it starts
using index properly.Accordingly i implemented the same query with force index
in my application code and regeneratet the slow query log
Hi,
> I am getting "Can't execute the given command because you have active locked
> tables or an active transaction" error when I am trying to truncate table. I
> am unable to understand the error as when I am using the mysql query browser
> then the same command is
Hi All,I am getting "Can't execute the given command
because you have active locked tables or an active transaction" error when
I am trying to truncate table. I am unable to understand the error as when I am
using the mysql query browser then the same command is working fine but whe
On 09/12/2009, at 5:10 PM, Jeetendra Ranjan wrote:
Hi,
After analysing slow query log i found that some queries are not
using index and so i used the force index command in query and test
it and now it starts using index properly.Accordingly i implemented
the same query with force index
Hi,
After analysing slow query log i found that some queries are not using index
and so i used the force index command in query and test it and now it starts
using index properly.Accordingly i implemented the same query with force index
in my application code and regeneratet the slow query log
the mysqldump binaries from its
> version,
> We tried to import this in 5.0.82 and we have the error.
>
> mysqldump Unknown command '\''.
>
> It seems the the extended import (multiple inserts) is somewhere too big
> since the single insert dump works but takes
We dumped a mysql 4.1.22 database using the mysqldump binaries from its
version,
We tried to import this in 5.0.82 and we have the error.
mysqldump Unknown command '\''.
It seems the the extended import (multiple inserts) is somewhere too big
since the single insert dump works
Thanks that worked.
I was trying -v from the help.
Gavin Towey
10/02/2009 05:30 PM
To
Lucas CTR Heuman/ACT/CNTR/f...@faa, "mysql@lists.mysql.com"
cc
Subject
RE: The Execute from the command line
Mysql -vv
See mysql --help for more info
Regards,
Gavin Towey
---
Mysql -vv
See mysql --help for more info
Regards,
Gavin Towey
-Original Message-
From: lucas.ctr.heu...@faa.gov [mailto:lucas.ctr.heu...@faa.gov]
Sent: Friday, October 02, 2009 2:20 PM
To: mysql@lists.mysql.com
Subject: The Execute from the command line
I am using
linuxmachine:/var
tName,TimeStamp,Ext,Status,Location,Expire,BadgeNum);"
and it works great, I just get no verification that anything has been
loaded in.. if I login it gives me back a little message saying it was
completed and how many are duplicated. How can I get this information from
the command line?
Wishing you the best you know you deserve,
On Wed, Jul 29, 2009 at 3:07 PM, Nathan Sullivan wrote:
> Carlos,
>
> I think this does what you want: (untested though)
>
> UPDATE identities
> SET email=replace(email, 'mail.', '')
> WHERE email like '%mail.iamghost.com'
That worked perfect!
UPDATE identities
-> SET email=replace(email, 'mail.'
sday, July 29, 2009 1:58 PM
To: mysql@lists.mysql.com
Subject: Properly Use Replace Command
I know this seems very basic and I checked Google before posting but
it appears that many of the manuals / guides online reference
something a bit more extreme than what I am looking for.
I am searching a ta
l'. Some people have the wrong email address
listed so I would like to replace the invalid entry
'u...@mail.iamghost.com' to the correct value 'u...@iamghost.com'
mysql> select email from identities where email like ('%mail.iamghost.com');
I ran the above com
Hello,
We are experience an estrange problem with mysql and we need help to debug
this properly.
We have a mysql server 5.0.67 on a ubuntu intrepid.
Sometimes we have one unique query that cannot be executed and we get this
error:
SELECT command denied to user 'user'@'local
> Date: Sun, 17 May 2009 14:25:55 +0800
> From: nathan.vorbei.t...@gmail.com
> To: mysql@lists.mysql.com
> Subject: how to add foreign key in alter command
>
> Hi guys
> Please tell me the command syntax, how to add a colmmen foreign key in
> alter syntax
> thanks
Hi guys
Please tell me the command syntax, how to add a colmmen foreign key in
alter syntax
thanks
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Innotop can satisfy you demand.
On Thu, Apr 16, 2009 at 4:36 PM, Hitesh Shah wrote:
> Hello,
> I'd like to know if there is a command line tool I can run to collect
> vital health information for a remote mysql server (just like
> mysqltop) for 5.0 - I often see mysql swapping
Hello,
I'd like to know if there is a command line tool I can run to collect
vital health information for a remote mysql server (just like
mysqltop) for 5.0 - I often see mysql swapping to disk and would like
to know what causes that.
Thanks
Hitesh
--
MySQL General Mailing List
For
On 3/11/09, Thomas Spahni wrote:
> > I am searching for a generic command to monitor that MySQL instance is
> > up and running. I don't have any know-how about the schema of the DB.
> What about 'mysqladmin ping' ?
Hi Thomas
thank you. That was the command
On Mon, 9 Mar 2009, Sven wrote:
Hi folks
I am searching for a generic command to monitor that MySQL instance is
up and running. I don't have any know-how about the schema of the DB.
kind regards
Sven Aluoor
Hi
What about 'mysqladmin ping' ?
Regards,
Thomas Spahni
--
MySQL
you may like to try "mytop"
or
watch -n10 mysql -BNA -e "show full processlist"
add user,host,databasename as needed
Sven schrieb:
> Hi folks
>
> I am searching for a generic command to monitor that MySQL instance is
> up and running. I don't have an
Hi folks
I am searching for a generic command to monitor that MySQL instance is
up and running. I don't have any know-how about the schema of the DB.
kind regards
Sven Aluoor
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysq
Micah Stevens wrote:
If you want to control the server process, you'll need to start the
server process with those options, this mysqld, and the command line
options are here:
http://dev.mysql.com/doc/refman/5.1/en/server-options.html
Thanks for the link, I am going through it.
For
1 - 100 of 1008 matches
Mail list logo
