Sydney Puente schrieb:
Hello,
I want to log all sql queries made against a mysql db.
Googled and found I should add a line to my.cnf.
However I cannot find a my.cnf file
[r...@radium init.d]# ps -ef | grep mysql
root 13614 1 0 Sep24 ?00:00:00 /bin/sh /usr/bin/mysqld_safe
Please look in /etc/my.cnf
If not found create one. Of cause, MySQL can start and run without a 'my.cnf'
file that’s why you couldn't find one. In the absence of the my.cnf file,
MySQL will use default for every parameter .
Charles,
-Original Message-
From: walter harms
Guys,
That's a great response. Thanks.
I have copied /usr/share/doc/MySQL-server-community-5.1.39/my-huge.cnfto
/etc/my.cnf and restarted.
However I can no longer log on via the command line from the database box,
I can still log via a remote client
So I presume the problem is related to the
H I wouldn't use that my-huge.cnf file unless that machine is a
dedicated mysql server with plenty of ram and even then I wouldn't use it
without modification.
Are you sure you have the password correct? A % under host is a synonym
for 'any host'.
Regards
John
Guys,
That's a great
Yes I enter the password manually into the remote mysql client (actually
Oracle's SQL developer) when I login.
I thought I would restart mysql with the /etc/init.d/mysql script and go back
to the original default settings without any my.cnf present. Just to check it
was some setting in my.cnf
Hello everyone,
Is there a way to get the last bin pos of a write using the C API?
I'm wanting to use this for MASTER / SLAVE load balancing check.
For example:
M = Master
S = Slave
W = Write
Q = Query
W-M (get write bin pos).
Now right after insert go query that rec and try using S
Hey all,
I'm looking for a Mysql benchmarking/stresstesting tool that can generate a
workload based on standard Mysql full query log files. The idea is to verify
performance of real production loads on various database setups.
Does anyone know of such a tool, free or paying ?
Thx,
Johan
take a look at mysqlslap: http://dev.mysql.com/doc/refman/5.1/en/mysqlslap.html
Walter
On Fri, Nov 13, 2009 at 22:33, Johan De Meersman vegiv...@tuxera.be wrote:
Hey all,
I'm looking for a Mysql benchmarking/stresstesting tool that can generate a
workload based on standard Mysql full query
Johan,
The very latest version of mk-log-player can do that.
If you get the version from trunk:
wget http://www.maatkit.org/trunk/mk-log-player
mk-log-player --split Thread_id --type genlog
Cheers,
Ewen
On Fri, Nov 13, 2009 at 4:33 PM, Johan De Meersman vegiv...@tuxera.be wrote:
Hey all,
OK thanks to some help from this list I now have a blank my.cnf file in /etc
And I want to set up logging of all sql queries.
So I have tried:
SET GLOBAL general_log = 'ON';
and/or putting (only) /var/log/mysql/mysql.log
in my.cnf and doing a restart via /etc/init.d
(have a pid file now
I did :-) Maybe I missed it, but I didn't see any option that suggests
mysqlslap can easily replay a query log ?
On Fri, Nov 13, 2009 at 4:50 PM, Walter Heck - OlinData.com
li...@olindata.com wrote:
take a look at mysqlslap:
http://dev.mysql.com/doc/refman/5.1/en/mysqlslap.html
Walter
On
Ooo, shiny ! Thanks, mate :-)
On Fri, Nov 13, 2009 at 4:56 PM, ewen fortune ewen.fort...@gmail.comwrote:
Johan,
The very latest version of mk-log-player can do that.
If you get the version from trunk:
wget http://www.maatkit.org/trunk/mk-log-player
mk-log-player --split Thread_id --type
Sorry can't remember what version you said you were using; if you have a
version prior to 5.1.29 to log all queries enter the following in the
[mysqld] section of your my.cnf
log = /path/to/logfile/filename.log
Remembering that the path you specify must be writeable by the server.
If you are
Did you remove the my.cnf file and then run /etc/init.d/mysql stop? The my.cnf
probably had non-default paths for the pid file, so if you remove the config
file, now the startup script is looking in the wrong location.
Also for your password issue, please show use the exact command you're
Hi All,
Can anyone give me any input on How mysql create table write data into
system database and where it has been stored besides information_schema.
Is there any article on mysql System Databases anyone went through as I am
not able to find it on Google.
I want to write a table information
15 matches
Mail list logo