t;> Subject: Re: How can I drop a table that is named “logs/#sql-ib203” and
>> appeared after MySQL crash?
>>
>> i know what happened but how get rid of these two bullshit files after
>> *three years* not touched and used by mysqld
>>
>> Am 20.06.2013 21:28,
If a crash occurs in the middle of an ALTER, the files may not get cleaned up.
> -Original Message-
> From: Reindl Harald [mailto:h.rei...@thelounge.net]
> Sent: Thursday, June 20, 2013 12:57 PM
> To: mysql@lists.mysql.com
> Subject: Re: How can I drop a table that is n
Hi Frank,
On 20/06/2013 05:00, Franck Dernoncourt wrote:
Hi all,
A table `logs/#sql-ib203` appeared after a MySQL crash due to disk space
shortage while deleting some attributes in a table in the `logs` database
and adding an index.
`USE logs; SHOW TABLES;` does not list the table `logs/#sql
12:19 PM
> To: mysql@lists.mysql.com
> Subject: Re: How can I drop a table that is named “logs/#sql-ib203” and
> appeared after MySQL crash?
>
>
>
> Am 19.06.2013 21:00, schrieb Franck Dernoncourt:
> > `USE logs; SHOW TABLES;` does not list the table `logs/#sql-ib203`
crash happened in the
> middle of the ALTER.
>
>> -Original Message-
>> From: Reindl Harald [mailto:h.rei...@thelounge.net]
>> Sent: Wednesday, June 19, 2013 12:19 PM
>> To: mysql@lists.mysql.com
>> Subject: Re: How can I drop a table that is named “lo
On Thu, Jun 20, 2013 at 3:28 PM, Rick James wrote:
> #sql files are temp tables that vanish when the ALTER (or whatever)
> finishes. If you find one sitting around, it sounds like a crash happened
> in the middle of the ALTER.
Yes the crash happened during an ALTER: the table `logs/#
On Thu, Jun 20, 2013 at 7:13 AM, Denis Jedig wrote:
>
> If you already tried enclosing the table name in backticks (DROP TABLE
> `#sql-ib203`) and using the DROP TEMPORARY TABLE syntax without success,
Yep, no success with:
DROP TEMPORARY TABLE `logs/#sql-ib203`;
DROP TEMPORARY TAB
This may be a naive question, but I'm not sure I can see you've covered
this: Have you tried "USE logs" before DROP TABLE `#sql-ib203` (without
the "logs/" bit)?
/ Carsten
On 19-06-2013 21:00, Franck Dernoncourt wrote:
Hi all,
A table `logs/#sql-ib203` appea
Franck,
Am 19.06.2013 21:00, schrieb Franck Dernoncourt:
A table `logs/#sql-ib203` appeared after a MySQL crash
the #sql-ib tables are temporarily created during an
ALTER TABLE operation for recovery purposes. Apparently these
temporary tables might stay in certain circumstances even after
Am 19.06.2013 21:00, schrieb Franck Dernoncourt:
> `USE logs; SHOW TABLES;` does not list the table `logs/#sql-ib203`, but
> when trying to `ALTER` the table that was being changed during the crash
> MySQL complains about the existence of the table `logs/#sql-ib203`:
>
>>
Hi all,
A table `logs/#sql-ib203` appeared after a MySQL crash due to disk space
shortage while deleting some attributes in a table in the `logs` database
and adding an index.
`USE logs; SHOW TABLES;` does not list the table `logs/#sql-ib203`, but
when trying to `ALTER` the table that was being
> -Original Message-
> From: Vikas Shukla [mailto:myfriendvi...@gmail.com]
> Sent: Thursday, May 30, 2013 7:19 PM
> To: Robinson, Eric; mysql@lists.mysql.com
> Subject: RE: Are There Slow Queries that Don't Show in the
> Slow Query Logs?
>
> Hi,
>
>
seconds to execute.
Sent from my Windows Phone From: Robinson, Eric
Sent: 31-05-2013 03:48
To: mysql@lists.mysql.com
Subject: Are There Slow Queries that Don't Show in the Slow Query Logs?
As everyone knows, with MyISAM, queries and inserts can lock tables
and force other queries to wait in a queue.
, 2012 1:54 PM
> To: Daevid Vincent; mysql@lists.mysql.com
> Subject: RE: Help with purging old logs for each customer ID
>
> If the 90 days is back from MAX(created_on) for a given customer...
>INDEX(customer_id, created_on)
> will probably be needed. And that should repla
.@daevid.com]
> Sent: Thursday, October 25, 2012 1:33 PM
> To: Rick James; mysql@lists.mysql.com
> Subject: RE: Help with purging old logs for each customer ID
>
> Well, the customer_id is relevant in that I want the last 90 days
> relative to each customer.
>
> customer_id
Well, the customer_id is relevant in that I want the last 90 days relative
to each customer.
customer_id = 123 might have logs from jan - mar
customer_id = 444 might have logs from feb - may
So it's a rolling log of THEIR last 90 days from their last log (most
recent) back 90 days from
y, October 25, 2012 11:46 AM
> To: mysql@lists.mysql.com
> Subject: Help with purging old logs for each customer ID
>
> I have a customer log table that is starting to rapidly fill up (we
> have hundreds of thousands of users, but many are transient, and use
> the service for a f
I have a customer log table that is starting to rapidly fill up (we have
hundreds of thousands of users, but many are transient, and use the service
for a few months, or use the free trial and quit, etc.)
CREATE TABLE `customers_log` (
`customer_log_id` bigint(20) unsigned NOT NULL auto_incremen
That's exactly what I thought when reading Michael's email, but tried
anyways, thanks for clarification :)
2012/10/16
> 2012/10/16 12:57 -0400, Michael Dykman
> your now() statement is getting executed for every row on the select. try
> ptting the phrase up front
> as in:
> set @ut= u
2012/10/16 12:57 -0400, Michael Dykman
your now() statement is getting executed for every row on the select. try
ptting the phrase up front
as in:
set @ut= unix_timestamp(now())
and then use that in your statement.
Quote:
Functions that return the current date or time each are
Interesting thought, but I get the same result.
# Query_time: 0.001769 Lock_time: 0.001236 Rows_sent: 0 Rows_examined: 0
use kannel;
SET timestamp=1350413592;
select * from send_sms FORCE INDEX (priority_time) where time<=@ut order by
priority limit 0,11;
the MySQL i'm using is 5.5.28 from dotd
your now() statement is getting executed for every row on the select. try
ptting the phrase up front
as in:
set @ut= unix_timestamp(now())
and then use that in your statement.
On 2012-10-16 8:42 AM, "spameden" wrote:
Will do.
mysql> SHOW GLOBAL VARIABLES LIKE '%log%';
+---
Will do.
mysql> SHOW GLOBAL VARIABLES LIKE '%log%';
+-+-+
| Variable_name | Value
|
+-+-+
| back_log
On 10/15/2012 7:15 PM, spameden wrote:
Thanks a lot for all your comments!
I did disable Query cache before testing with
set query_cache_type=OFF
for the current session.
I will report this to the MySQL bugs site later.
First. What are all of your logging settings?
SHOW GLOBAL VARIAB
Thanks a lot for all your comments!
I did disable Query cache before testing with
set query_cache_type=OFF
for the current session.
I will report this to the MySQL bugs site later.
2012/10/16 Rick James
> **Ø **My initial question was why MySQL logs it in the slow log if the
> quer
Ø My initial question was why MySQL logs it in the slow log if the query uses
an INDEX?
That _may_ be worth a bug report.
A _possible_ answer... EXPLAIN presents what the optimizer is in the mood for
at that moment. It does not necessarily reflect what it was in the mood for
when it ran
ber 15, 2012 3:23 PM
To: Rick James
Cc: mysql@lists.mysql.com
Subject: Re: mysql logs query with indexes used to the slow-log and not logging
if there is index in reverse order
Sorry, my previous e-mail was a test on MySQL-5.5.28 on an empty table.
Here is the MySQL-5.1 Percona testing table:
mys
f I turn it off - it's all fine
My initial question was why MySQL logs it in the slow log if the query uses
an INDEX?
And why it's not logging if I create an INDEX (time, priority) (but in the
query there is FORCE INDEX (priority,time) specified, so MySQL shouldn't
use newly creat
not a 3-digit integer, it is a full 32-bit integer (4 bytes).
> Perhaps you should have SMALLINT UNSIGNED (2 bytes).
>
> * BIGINT takes 8 bytes -- usually over-sized.
>
>
> > -Original Message-
> > From: spameden [mailto:spame...@gmail.com]
> > Sent: Monday, O
IGINT takes 8 bytes -- usually over-sized.
> -Original Message-
> From: spameden [mailto:spame...@gmail.com]
> Sent: Monday, October 15, 2012 1:42 PM
> To: mysql@lists.mysql.com
> Subject: mysql logs query with indexes used to the slow-log and not
> logging if there is
Hi, I've just checked on MySQL-5.5.28
it acts absolutely same.
I need to use (priority,time) KEY instead of (time, priority) because query
results in better performance.
With first key used there is no need to sort at all, whilst if using latter:
mysql> *desc select * from send_sms_test FORCE IN
Hi, list.
Sorry for the long subject, but I'm really interested in solving this and
need a help:
I've got a table:
mysql> show create table send_sms_test;
+---+
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?
Thansk,
Will try to turn on log_warnings.
-Mon
From: Nitin Mehta
To: monloi perez ; Ananda Kumar
Cc: mysql mailing list
Sent: Sun, September 5, 2010 12:03:45 PM
Subject: Re: Logs not working
I believe that will not be logged unless you have enabled
From: monloi perez
To: Ananda Kumar
Cc: mysql mailing list
Sent: Sat, September 4, 2010 11:37:42 AM
Subject: Re: Logs not working
on the db server? meaning the mysqld log right? THere is really no data for
teh
current error. The last error they said was too much connections and
list
Sent: Thu, September 2, 2010 6:14:26 PM
Subject: Re: Logs not working
Did u check the logs on the db server, to see what the issue was.
regards
anandkl
On Thu, Sep 2, 2010 at 6:25 AM, monloi perez wrote:
All,
>
>I'm not sure if this is the right mailing list since the speci
Did u check the logs on the db server, to see what the issue was.
regards
anandkl
On Thu, Sep 2, 2010 at 6:25 AM, monloi perez wrote:
> All,
>
> I'm not sure if this is the right mailing list since the specific mailing
> lists
> doesn't seem to meet my concern.
>
&g
All,
I'm not sure if this is the right mailing list since the specific mailing lists
doesn't seem to meet my concern.
For some reason mysql client stops logging to mysqd.log. We had an issue on Aug
20. But when I checked the log, the latest was on Aug 2.
Any idea on how to resolve this or what
Hi,
This is probably very simple for someone who has encountered the problem before
but I'm struggling to find how I can contain the MySQL error log from being
flushed at "FLUSH LOGS" command. This command is executed as part of the
database backup every night and simply move
Thanks Paul
you opened my eyes !!!
On Wed, Jun 9, 2010 at 2:27 PM, Paul DuBois wrote:
>
> On Jun 9, 2010, at 11:59 AM, Darvin Denmian wrote:
>
>> Hello !
>>
>> Is there some diference between : FLUSH LOCAL LOGS and FLUSH LOGS ?
>
>
> Yes. http://dev.mysql.c
On Jun 9, 2010, at 11:59 AM, Darvin Denmian wrote:
> Hello !
>
> Is there some diference between : FLUSH LOCAL LOGS and FLUSH LOGS ?
Yes. http://dev.mysql.com/doc/refman/5.1/en/flush.html says:
"
By default, FLUSH statements are written to the binary log so that they will be
Ok now
-Original Message-
From: Darvin Denmian [mailto:darvin.denm...@gmail.com]
Sent: Wednesday 09 June 2010 19:00
To: mysql@lists.mysql.com
Subject: FLUSH LOCAL LOGS
Hello !
Is there some diference between : FLUSH LOCAL LOGS and FLUSH LOGS ?
Thanks
--
MySQL General Mailing List
Hello !
Is there some diference between : FLUSH LOCAL LOGS and FLUSH LOGS ?
Thanks
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Hello there,
I am getting connected to MySQL through SSL.
I want to see the logs of SSL getting trigerred when someone access MySQL
database from any application or URL.
Where do I need to modify or edit the configuration, in order to see the SSL
logs?
I can only see the query logs as of now
Weitao,
On Sun, May 31, 2009 at 10:13 AM, Weitao Liu wrote:
> I had deleted some important data from my mysql server,who can tell how can
> I recover my data,I do not open the bin log,is there some other method?
If you are using InnoDB you may be able to recovery the data from the
pages if you d
Still thanks,I will remember how to avoide this if the feature!
O think not, did you make dumps of your database? If not you have to use
bin-log
-Ursprüngliche Nachricht-
Von: Weitao Liu [mailto:liuwt...@gmail.com]
Gesendet: Sonntag, 31. Mai 2009 10:13
An: mysql@lists.mysql.com
Betreff: Recover data without logs
I had deleted some important data
I had deleted some important data from my mysql server,who can tell how can
I recover my data,I do not open the bin log,is there some other method?
thanks a lot !
ers
Claudio
2009/4/17 Mihail Vetchinov
> Anybody can tell me about way which will force the mysqld write more
> information into logs (.err file)?
>
> My mysqld restarted every 20-30 minutes without reasonable info in log file
> and I dont understand why it occurs.
>
> I
Anybody can tell me about way which will force the mysqld write more
information into logs (.err file)?
My mysqld restarted every 20-30 minutes without reasonable info in log
file and I dont understand why it occurs.
I see only string "mysqld restarted" and nothing more! :(
Exam
We are running MySQL 5.0.45 on a Linux machine. I have enabled the general
query log and I notice that for some of the connections, the last command is
Quit but for some of the connections, the Quit command does not appear. What
do I have to do to ensure that the Quit command gets printed in t
You should keep it on in my opinion.
On Tue, May 13, 2008 at 6:04 PM, Nico Sabbi <[EMAIL PROTECTED]> wrote:
> Hi,
> I guess that when I'm using only Innodb and no replication I can
> safely disable mysql's (bin-) log files (that grow to no end) because
> Innodb has its own log files. Is it correc
1:02:32PM +0530, Ananda Kumar wrote:
>
> >I want to purge bin logs which are older than 4 days. I want to keep 4
> days
> >of bin logs so that in the event of any data issue, i can restore it from
> >bin logs. So, i tired to use
> >
> >PURGE MASTER LOGS BEFORE
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Sun, May 18, 2008 at 01:02:32PM +0530, Ananda Kumar wrote:
>I want to purge bin logs which are older than 4 days. I want to keep 4 days
>of bin logs so that in the event of any data issue, i can restore it from
>bin logs. So, i tir
Hi Juan,
I want to purge bin logs which are older than 4 days. I want to keep 4 days
of bin logs so that in the event of any data issue, i can restore it from
bin logs. So, i tired to use
PURGE MASTER LOGS BEFORE '2008-05-07 00:00:00';
But it did not work. Can you please help me on thi
Ananda,
Use, PURGE MASTER LOGS TO 'name of the last binary that you want leave in
your disk';
Regards
On Sat, May 17, 2008 at 8:56 AM, Ananda Kumar <[EMAIL PROTECTED]> wrote:
> Hi All,
> I using this command to purge binary logs on master, but i dont see the
> bi
Hi All,
I using this command to purge binary logs on master, but i dont see the
binary logs getting deleted. These binary logs are listed in index file.
I am using mysql version 5.0.41 community version. Can you please let me
know if any thing else need to be done for this to work.
log-bin is
2008 13:39:02
Assunto: MySQL purge logs
Hi
I am referring to
http://dev.mysql.com/doc/refman/5.0/en/purge-master-logs.html
whats the exact syntax to purge this MySQL Binary Logs
-rw-rw 1 mysql 701 1.1G May 5 07:39 host1-bin.000681
-rw-rw 1 mysql 701 1.1G May 5 09:09 host1-bin.000682
Hi,
I guess that when I'm using only Innodb and no replication I can
safely disable mysql's (bin-) log files (that grow to no end) because
Innodb has its own log files. Is it correct?
Thanks,
Nico
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
On May 11, 2008, at 11:39 AM, Kaushal Shriyan wrote:
Hi
I am referring to
http://dev.mysql.com/doc/refman/5.0/en/purge-master-logs.html
whats the exact syntax to purge this MySQL Binary Logs
It's as indicated on the page that you reference. For example,
to purge all logs before .0
Kaushal Shriyan
> Cc: mysql@lists.mysql.com; [EMAIL PROTECTED]
> Subject: Re: MySQL purge logs
>
> login MySQL with "root" and use:
> RESET MASTER
> that's all you need to do.
>
>
> Kaushal Shriyan wrote:
>> Hi
>>
>> I am referring to
>> http:
point is better.
>
>
>
>
>
> > -Original Message-
> > From: Dennis Yu [mailto:[EMAIL PROTECTED]
> > Sent: Sunday, May 11, 2008 6:10 PM
> > To: Kaushal Shriyan
> > Cc: mysql@lists.mysql.com; [EMAIL PROTECTED]
> > Subject: Re
RESET is not a good idea -- PURGE to some point is better.
> -Original Message-
> From: Dennis Yu [mailto:[EMAIL PROTECTED]
> Sent: Sunday, May 11, 2008 6:10 PM
> To: Kaushal Shriyan
> Cc: mysql@lists.mysql.com; [EMAIL PROTECTED]
> Subject: Re: MySQL purge logs
>
login MySQL with "root" and use:
RESET MASTER
that's all you need to do.
Kaushal Shriyan wrote:
Hi
I am referring to
http://dev.mysql.com/doc/refman/5.0/en/purge-master-logs.html
whats the exact syntax to purge this MySQL Binary Logs
-rw-rw 1 mysql 701 1.1G May 5
Hi
I am referring to
http://dev.mysql.com/doc/refman/5.0/en/purge-master-logs.html
whats the exact syntax to purge this MySQL Binary Logs
-rw-rw 1 mysql 701 1.1G May 5 07:39 host1-bin.000681
-rw-rw 1 mysql 701 1.1G May 5 09:09 host1-bin.000682
-rw-rw 1 mysql 701 1.1G May 5 10
This however is not an option at all when you run Apache in prefork
mode. Because the sum of your MaxClients will be equal to the
connections to your MySQL Server.
You can use connection pooling eg SQLrelay
--
Filip Krejci <[EMAIL PROTECTED]>
Linux - und Spass dabei!
--
MySQL General Ma
connections to your MySQL Server.
This rendered the module useless for me.
I do write my logs a MySQL statements to a file, that gets rotated every
day and I have another script, that reads the rotated log file and
writes to the database.
Regards,
Samy
--
MySQL General Mailing List
For list archives
On 9 Nov 2007 at 10:44, Shaun T. Erickson wrote:
> I pull Apache (combined format) logs, daily, from a number of mirrors,
> back to a central server for processing. I'd like to somehow load them
> in MySQL for analysis.
>
> 1) Does anyone know of a script that can parse th
I pull Apache (combined format) logs, daily, from a number of mirrors,
back to a central server for processing. I'd like to somehow load them
in MySQL for analysis.
1) Does anyone know of a script that can parse the logs and load them?
(I presume I can get the DB schema from it.)
2) Can
We have MySQL 5.0.27 running on about 10 different RedHat EL4 boxes,
all from the same RPMs. Every night we run mysqladmin flush-logs from
crontab (as well as some other things) on most of these servers.
One on server, mysqld is dying with signal 11 every single night right
during the mysqladmin
At 12:12 PM -0400 6/12/07, Ofer Inbar wrote:
We run a mysqladmin flush-logs from cron every night. This causes our
server to start a new binary log. However, the slow query log does
not get flushed - our server continues updating the same slow query
log file.
If I run mysql and then issue a
We run a mysqladmin flush-logs from cron every night. This causes our
server to start a new binary log. However, the slow query log does
not get flushed - our server continues updating the same slow query
log file.
If I run mysql and then issue a "flush logs" command, it flushes the
b
the ask lies in expire_logs_days. If you set this to optimal number of days,
logs older than the configured days will get purged.
~Alex
On 5/15/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> One question about this, is it safe to turn of log_bin?
i think, you can. the log is
; take some much disk space?
you can bzip old logs if you need them but don't want them to take so much
space :)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
What can I do to stop this kind of behavior? and is
its safe to delete all the files with a cronjob? and witch files are
recommend to delete if so?
just commet log-bin option of [mysqld] section in your my.cnf file
(/etc/my.cnf)
you can also remove these files manually -- it will not affect serve
> What can I do to stop this kind of behavior? and is
> its safe to delete all the files with a cronjob? and witch files are
> recommend to delete if so?
just commet log-bin option of [mysqld] section in your my.cnf file
(/etc/my.cnf)
you can also remove these files manually -- it will not affect
Hello,
I got a problem with the redo log from mysql.
my /var/log/mysql fills up with mysql-bin.0# files and a few moments ago it
was about 10Gb in size (after 2 weeks in production), so I decide to delete al
the files.
What can I do to stop this kind of behavior? and is its safe to delete a
Ashley M. Kirchner wrote:
Probably a silly question, but if I have my logs set to binary, how
can I read them and check on a query that's failing? I don't
necessarily want to switch to text logs because we'll want to do
replication soon here, so I want to keep it as a
Probably a silly question, but if I have my logs set to binary, how
can I read them and check on a query that's failing? I don't
necessarily want to switch to text logs because we'll want to do
replication soon here, so I want to keep it as a binary log. My problem
is
For disaster recovery, it's good to have copies of your database dumps
that you can easily & conveniently access, that are outside the data
center where the database lives. Since we do a weekly full dump and
use binary logs for "incrementals", I also wanted copies of our bina
On Fri, 2007-04-27 at 09:19 -0500, [EMAIL PROTECTED] wrote:
> So if one is doing a full mysqldump every night, all bin-logs can be
> deleted after this?
On the slave - Yes. In fact I would highly recommend it before
starting the slave processes again. This will reset the bin log'
So if one is doing a full mysqldump every night, all bin-logs can be
deleted after this?
If bin-logging is disabled, will master/slave syncing still occur?
David
> Issuing a 'reset master' will purge all of the logs as well. I wouldn't
> just rm them, as they are being
So, I take it since I do not have a slave at all, I could safely just
disable this feature altogether?
If I do not need point in time recovery, and the once every 12 hour dump I
do across all databases is ok with me, I suppose I can just disable said
feature? Heck, some of these boogers are a GB
Issuing a 'reset master' will purge all of the logs as well. I wouldn't
just rm them, as they are being tracked in the index file.
If you aren't running a slave, then these files are only good for data
recovery purposes. Say a DBA goes crazy and deletes all of the databas
m'. If
> you use PURGE MASTER LOGS BEFORE, it's a bit easier than cron because
> you can do it across all platforms easily. On UNIX of course, you'd use
> something like
>
> find /var/lib/mysql/data -name "*.bin" -mtime +7 -exec rm {} \
>
> (My fin
Hi Scott,
Scott Haneda wrote:
In the short term, see the manual page for PURGE MASTER LOGS. In the
long term, write a cron job.
innotop (http://sourceforge.net/projects/innotop) also has a new
feature, unreleased because I just wrote it a few hours ago, which will
help you figure out which
> In the short term, see the manual page for PURGE MASTER LOGS. In the
> long term, write a cron job.
>
> innotop (http://sourceforge.net/projects/innotop) also has a new
> feature, unreleased because I just wrote it a few hours ago, which will
> help you figure out which bin
?
In the short term, see the manual page for PURGE MASTER LOGS. In the
long term, write a cron job.
innotop (http://sourceforge.net/projects/innotop) also has a new
feature, unreleased because I just wrote it a few hours ago, which will
help you figure out which binlogs can be purged safely
Running mysql 4, just poked into data and see I have gigs and gigs of
hostname-bin.xxx log files.
How does one maintain these, can someone point me to relevant data on what
to do about drive space being lost to these?
thanks
--
-
Scott
Sachin Sharma a écrit :
>
> Hi,
>
> Is it possible to have logs for each database into differnt files ?
> Rather on single file with log=/var/log/mysqld.log.
It's not possible no... Maybe you should look at running different mysql
instance for each of them that need separate
Hi,
Is it possible to have logs for each database into differnt files ?
Rather on single file with log=/var/log/mysqld.log.
--
Sachin Sharma
Sr. Engineer Systems (Linux)
Net4India Ltd.
D-25
Sector 3
Noida-201301
INDIA
Tel: 0120-5323500
Fax: 0120-5323520
URL: http://www.net4.in
Hello,
I'm hitting a performance wall on my MySQL primarily I believe because
the bin log and the InnoDB logs are on the same volume group as
another MySQL server. In reality, I have four MySQL servers, two per
server (in Solaris Containers). All four are sharing the same volume
gro
http://dev.mysql.com/doc/refman/5.0/en/purge-master-logs.html
DÆVID
> -Original Message-
> From: George Law [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, October 10, 2006 11:56 AM
> To: mysql@lists.mysql.com
> Subject: purging bin logs
>
> Hi All,
>
> I have
Hi All,
I have a question on purging some old bin-logs.
whats the best way to do it?
This is a fairly old version - 4.0.18-standard-log. I have 128 1 GB
files out there, going back 8 months.
I think the correct syntax is :
PURGE BINARY LOGS TO 'mysql-bin.010';
but fro
Russbucket wrote:
I just check my install of mysql (version mysql-4.1.13-3.8 on SUSE 10.0) and
the socket is in /var/lib/mysql and the mysqld log is in /var/lib/mysql.
This is the mysql version that came with my 10.0 DVD. Did you use YAST to
install? I don't know if these locations changed with t
ing, but this doesn't appear to have had any
> effect (according to phpinfo()).
>
> Secondly, MySQL appears to be trying to write logs to /var/log/mysql
> (according to MySQL Administrator). This location does not exist. I'm
> getting no error messages, but presumably th
ntent:
[mysqld]
socket=/tmp/mysql.sock
[client]
socket=/tmp/mysql.sock
I added these entries in an attempt to get PHP to use the actual
location that MySQL is using, but this doesn't appear to have had any
effect (according to phpinfo()).
Secondly, MySQL appears to be trying to write lo
> in my.cnf and restarted my server. After that I see statements logged
> into the slow-log-file.
>
> But it seems that mysql logs too much into that file.
>
> When executing this statement:
>
> mysql> show variables like "%tx%";
> +-
I have specified
log-slow-queries
long-query-time=10
in my.cnf and restarted my server. After that I see statements logged
into the slow-log-file.
But it seems that mysql logs too much into that file.
When executing this statement:
mysql> show variables like &
1 - 100 of 320 matches
Mail list logo