MySQL: Ver 5.0.51a-24+lenny4-log for debian-linux-gnu on x86_64 ((Debian))
Hi, I am looking for alternate methods to rotate the query and slow query
logs. Currently we employ the following method, in psedu code:
sh# rename mysql.log mysql.log.foo
mysql> FLUSH LOGS;
sh# move mysql.log.foo /back
5/10 .. so whats the typical IO (rnd rw) that you
> archive/expect on high trafficked sites ?
>
> --- On Wed, 3/4/09, Baron Schwartz wrote:
>
> From: Baron Schwartz
> Subject: Re: MySQL Log and Data directories
> To: dbrb2002-...@yahoo.com
> Cc: mysql@lists.mysql.com
> Dat
Thanks Baron...
Also, curious question.. as you might have used what is called GOOD hw
configurarion with RAID 5/10 .. so whats the typical IO (rnd rw) that you
archive/expect on high trafficked sites ?
--- On Wed, 3/4/09, Baron Schwartz wrote:
From: Baron Schwartz
Subject: Re: MySQL Log
On Wed, Mar 4, 2009 at 1:22 PM, wrote:
> On a high read/write load.. is it good to split log (binlogs, innodb txn
> logs) and data (all tables, innodb tablespace) in different partitions ?
>
> Anybody had any experience ?
>
> For example; out of 25 disks array with 142GB 1rpm... I would like
Lets say HP Modular Storage/Smart Array..
http://h18006.www1.hp.com/storage/disk_storage/msa_diskarrays/san_arrays/index.html
From: Chaim Rieger
Subject: Re: MySQL Log and Data directories
To: "Michael Dykman"
Cc: dbrb2002-...@yahoo.com, mysql@lists.mysql.com
Date: Wednesday, March 4
Michael Dykman wrote:
On Wed, Mar 4, 2009 at 1:22 PM, wrote:
On a high read/write load.. is it good to split log (binlogs, innodb txn logs)
and data (all tables, innodb tablespace) in different partitions ?
Anybody had any experience ?
For example; out of 25 disks array with 142GB 1rpm.
On Wed, Mar 4, 2009 at 1:22 PM, wrote:
> On a high read/write load.. is it good to split log (binlogs, innodb txn
> logs) and data (all tables, innodb tablespace) in different partitions ?
>
> Anybody had any experience ?
>
> For example; out of 25 disks array with 142GB 1rpm... I would like
On a high read/write load.. is it good to split log (binlogs, innodb txn logs)
and data (all tables, innodb tablespace) in different partitions ?
Anybody had any experience ?
For example; out of 25 disks array with 142GB 1rpm... I would like to keep
few disks to logs and rest to data .. is
Method 1（install mysql）:
/usr/local/mysql/bin/：
./mysqladmin -u root password 'new_password'
Method 2
mysql>UPDATE user SET password=PASSWORD('new_password') WHERE user='root';
mysql>FLUSH PRIVILEGES;
Method 3:
mysql>SET PASSWORD FOR root=PASSWORD('new_password');
On Mon, Feb 23, 2009 at 11:38 A
You should have typed " ... set password = password('newpass')"
You've set root's password to the encypted value of some other string.
You ought to be able to get around this by starting mysql (the server
process, not the client) using the --skip-grant-tables option and resetting
the password.
O
Hi everyone,
I'm having some problems getting logged in to mysql to create a new
database.
I have to admit, my overall skill level with mysql is 'Entry level noob'.
I just haven't ever had much need to mess with it in general, so if you want
to laugh, feel free. I'll understand ;)
At any rate, as
Admin-Stress <[EMAIL PROTECTED]> wrote:
>
> How can I enable MySQL 4.0.16 log ?
>
> I just compiled and installed it in my RedHat 9.0 system, but I cant see any log
> files. I use
> default /etc/my.cnf from my-large.cnf.
>
Depends on what exactly logging you want to turn on (binary, update, g
How are you starting mysql? as a service? I dont think it keeps a log
file by default.
If you are not starting mysql as a service, start it with the
--log-error=/var/log/mysqld --log-warnings
flags. If you are starting it as a service, add those flags to your
mysql file inside /etc/rc.d/init.
Hello,
How can I enable MySQL 4.0.16 log ?
I just compiled and installed it in my RedHat 9.0 system, but I cant see any log
files. I use
default /etc/my.cnf from my-large.cnf.
Sorry, if this question is too newbie, but I cant understand clearly reading MySQL
manual.
Thanks for helping me :)
i was checking the system log file i found
" no mysqlpid file found.looked for
/var/lib/mysql/localhot.locatdomain.pid"
so how can i deal with a problem like that since mysql
does not start?
thanks
__
Do you Yahoo!?
The New Yahoo! Shopping
Opening a file access it by its inode.
Once it is opened, it can be renamed, or deleted, and this will have no
effect
for the process that has it open.
Flush logs will close the inode, and create a new log, which will assign
a new inode
to be opened.
File names are just handy pointers to inodes
in mysql docs, http://www.mysql.com/doc/L/o/Log_file_maintenance.html :
1) shell> cd mysql-data-directory
2) shell> mv mysql.log mysql.old
3) shell> mysqladmin flush-logs
What's happening if there is a query between line 2 and 3, is it logged ?
How could I rotate my files without a query not log
I don't know if this will help you but try this:
# mysqld --help | grep "dir:"
basedir: /
datadir: /var/lib/mysql/
tmpdir: /tmp/
So, you'll find mysql log files in your datadir (is this case,
/var/lib/mysql/).
my.cnf is usually at /etc/my.cnf
If you d
I installed following two files
MySQL-VERSION.i386.rpm
MySQL-client-VERSION.i386.rpm
but I can not fild my.cnf and mysql log files.
Why?
Thanks
Jianping Zhu
Department of Computer Science
Univerity of Georgia
Athens, GA 30602
Tel 706 5423900
I am looking for some suggestions for MySQL log management. Just some
people to respond to this message with their log rotation, and archival
methods. I am just curious to see what others are doing, and to possibly
suggest a method for myself to use.
Thanks,
Shon Stephens
mount.
-
Johnny Withers
[EMAIL PROTECTED]
p. 601.853.0211
c. 601.209.4985
-Original Message-
From: Peter M. Perchansky [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 13, 2001 2:55 PM
To: [EMAIL PROTECTED]
Subject: Can mySQL log files be located on another server?
Greetings:
Greetings:
http://www.mysql.com/doc/B/i/Binary_log.html
Is it possible to place this and the error log file generated by mySQLd on
the hard drive on another server?
If so, how?
Thank you.
Peter M. Perchansky, President/CEO
Dynamic Net, Inc.
He
Hi
How can I set up our mysql server to
write its logs into a log file?
Thanks in advance!
Regards
Istvan
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.my
My database log files are expanding very quickly - and when I look at them,
they are logging all of the select statements, not just the delete, insert,
update, etc. statements.
How do I specify for the logfiles to only log "update" statements and not
the selects?
Thanks,
Kim Albee
--
24 matches
Mail list logo
