rror 1064
>
>
> On Wed, Jun 24, 2015 at 11:40 AM, Tomasz Chmielewski
> wrote:
>
> > Normal general log also logs everything including bad queries (i.e.
> SLCECT
> > BLAH BLAH;) - although does not say if it was an error (i.e. syntax) or
> not.
> >
> &
;"}}
error 1064
On Wed, Jun 24, 2015 at 11:40 AM, Tomasz Chmielewski
wrote:
> Normal general log also logs everything including bad queries (i.e. SLCECT
> BLAH BLAH;) - although does not say if it was an error (i.e. syntax) or not.
>
> Does the audit plugin log the actual error?
&
% for disk logging and
for remote syslog we found it is lower. It logs everything including
bad queries (eg. select fark from fark from fark fark fark from frak).
You should be able to write a JSON parser that extracts what you want
based on the log (eg. STATUS, COMMAND, NAME).
On Wed, Jun 24, 2015
The performance hit of the Percona Audit is 15% for disk logging and for
remote syslog we found it is lower. It logs everything including bad
queries (eg. select fark from fark from fark fark fark from frak). You
should be able to write a JSON parser that extracts what you want based on
the log
> From: "Singer X.J. Wang"
> Subject: Re: server-side logging of query errors?
> You could log all queries using the audit plugin, 15% hit..
Fair point, though: maybe one of the different audit plugins has the capability
to specifically log faulty requests. Have a look thro
pid, see Hanlon's razor) user could spam your server with
> >> malformed requests until the logging disk runs full, at which point
> >> the daemon would suspend operations until space is freed.
> >
> > I don't think it's a valid argument - the same is true
- Original Message -
> From: "Tomasz Chmielewski"
>> It would be a mild security risk; a malicious
>> (or just stupid, see Hanlon's razor) user could spam your server with
>> malformed requests until the logging disk runs full, at which point
>>
d security risk; a malicious
(or just stupid, see Hanlon's razor) user could spam your server with
malformed requests until the logging disk runs full, at which point
the daemon would suspend operations until space is freed.
I don't think it's a valid argument - the same is true righ
None that I'm aware of. It would be a mild security risk; a malicious (or just
stupid, see Hanlon's razor) user could spam your server with malformed requests
until the logging disk runs full, at which point the daemon would suspend
operations until space is freed.
Maybe one of t
Suppose I run a query which has a syntax error:
mysql> blah;
ERROR 1064 (42000): You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right
syntax to use near 'blah' at line 1
How can I get mysql server to log this error?
According to
We use host aliases to connect to MySQL all the time, never had an
issue before. Today we added a new alias, and we cannot connect to the
server using that one alias but only when we are on the local machine.
Here is the NIS entry for this host:
# ypmatch -k ubshp2 hosts
ubshp2 192.132.2.143u
Found the problem. There was cached DNS info on the host. Restarted
nscd and then it worked.
On Thu, Apr 18, 2013 at 10:59 AM, Larry Martell wrote:
> We use host aliases to connect to MySQL all the time, never had an
> issue before. Today we added a new alias, and we cannot connect to the
> serve
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%';
+---
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 VARIABLES
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
ptimizer's choice.
>
> ** **
>
> *From:* spameden [mailto:spame...@gmail.com]
> *Sent:* Monday, October 15, 2012 3:29 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
From: spameden [mailto:spame...@gmail.com]
Sent: Monday, October 15, 2012 3:29 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, forgot to say:
mysql> show variables lik
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
0.05 |
| statistics | 0.07 |
| preparing | 0.05 |
| executing | 0.01 |
| Sorting result | 0.03 |
| Sending data | 0.000856 |
| end| 0.03 |
| query end | 0.01 |
| freeing items | 0.15 |
| logging slow quer
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;
+---+
man
> > >>>
> > >>> I would assume that it's slower because it gets put on the delay
> thread
> > >>>> anyway, and thus executes only whenever that thread gets some
> > attention. I'm
> > >>>> not sure wether the
s "not
> locked
> >>>> against inserts", so the MyISAM insert-while-selecting at the end of a
> >>>> continguous table may well apply.
> >>>>
> >>>> No guarantees, though - I'm not that hot on this depth.
> >>>
n this context means "not locked
>>>> against inserts", so the MyISAM insert-while-selecting at the end of a
>>>> continguous table may well apply.
>>>>
>>>> No guarantees, though - I'm not that hot on this depth.
>>>>
>>>>
>
this context means "not locked
>>> against inserts", so the MyISAM insert-while-selecting at the end of a
>>> continguous table may well apply.
>>>
>>> No guarantees, though - I'm not that hot on this depth.
>>>
>>>
>>>
gt;> continguous table may well apply.
>>
>> No guarantees, though - I'm not that hot on this depth.
>>
>>
>>
>> On Tue, Nov 30, 2010 at 8:46 AM, WLGades wrote:
>>
>>> What I'm confused by though, is this line.
>>>
>>>
tinguous table may well apply.
>
> No guarantees, though - I'm not that hot on this depth.
>
>
>
> On Tue, Nov 30, 2010 at 8:46 AM, WLGades wrote:
>
>> What I'm confused by though, is this line.
>>
>> "Note that INSERT DELAYED is slower than a
that INSERT DELAYED is slower than a normal INSERT if the table is
> not
> otherwise in use." What's the definition of "in use"? Does a logging
> table
> do that given that it's pretty much append-only/write-only?
>
> Waynn
>
> On Mon, Nov 29, 20
What I'm confused by though, is this line.
"Note that INSERT DELAYED is slower than a normal INSERT if the table is not
otherwise in use." What's the definition of "in use"? Does a logging table
do that given that it's pretty much append-only/write-only?
Wayn
No, I think it's a good idea to do INSERT DELAYED here - it's only logging
application, and it's generally more important to not slow down the
application for that. It's only ever into a single table, so there's only
going to be a single delay thread for it anyway.
Archi
ing is INSERT
> (essentially an append-only table), with only very occasional SELECTs? In
> addition, the last time I took this approach for logging, it worked well
> until the table got to 65M+ rows, when it would crash every now and then.
> I
> know I can archive off the table on a per month/quarter basis as well.
>
> Waynn
>
t you need it.
Does that mean that I shouldn't use it if all I'm doing is INSERT
(essentially an append-only table), with only very occasional SELECTs? In
addition, the last time I took this approach for logging, it worked well
until the table got to 65M+ rows, when it would crash every n
Andy,
On Tue, Feb 9, 2010 at 10:27 AM, andy knasinski wrote:
> I've used the general and slow query log in the past, but I am trying to
> track down some queries from a compiled app that never seem to be hitting
> the DB server.
>
> My guess is that the SQL syntax is bad and never get executed, b
;t see any related queries in the general query log. Does the general
log include invalid SQL?
I've also tried to use the driver logging, but on Windows it overwrites
with the last SQL command so I cannot get a good capture as requests are
sent to the DB.
DB is MySQL 5.0.x
you can try MySQL prox
I'm not positive if the general log captures all invalid queries but
it does capture at least some.
I was asked the same question a few months back and checking to make
sure that manually issued invalid queries are logged (IIRC).
Could it be that the queries are never even making it to the database
Unfortunately, I'm using a commercial application and trying to debug
as to why some data does and does not get updated properly.
On Feb 9, 2010, at 2:57 PM, mos wrote:
I do something like that in my compiled application. All SQL queries
are sent to a single procedures and executed there.
;t see any related queries in the general query log. Does the
general log include invalid SQL?
I don't think it does.
I've also tried to use the driver logging, but on Windows it
overwrites with the last SQL command so I cannot get a good capture as
requests are sent to the DB.
DB is
query log. Does the
general log include invalid SQL?
I've also tried to use the driver logging, but on Windows it
overwrites with the last SQL command so I cannot get a good capture as
requests are sent to the DB.
DB is MySQL 5.0.x
Thanks
andy
--
MySQL General Mailing List
For list
nuary 06, 2010 11:43 AM
To: mysql@lists.mysql.com
Subject: RE: Binary Logging
Silly me sees that there is an 'expire_log_days' in the my.cnf
But again, if i was to purge everything but the last day or 2... running
this command i found:
PURGE BINARY LOGS BEFORE DATE_SUB(NOW(), INTERVAL 2
e-
> From: Steve Staples [mailto:sstap...@mnsi.net]
> Sent: January 6, 2010 2:35 PM
> To: mysql@lists.mysql.com
> Subject: Binary Logging
>
> Good afternoon.
>
> I am having a weird problem with the Binary Logging of my MySQL.
>
> For some reason, we have it on (still no
ginal Message-
From: Steve Staples [mailto:sstap...@mnsi.net]
Sent: January 6, 2010 2:35 PM
To: mysql@lists.mysql.com
Subject: Binary Logging
Good afternoon.
I am having a weird problem with the Binary Logging of my MySQL.
For some reason, we have it on (still not sure why) but when i look in
Good afternoon.
I am having a weird problem with the Binary Logging of my MySQL.
For some reason, we have it on (still not sure why) but when i look in the
/var/log/mysql/ folder, the oldest file is from the 2009-12-27. The MySQL
service has not been restarted since the server came back up 150
t; * In newer versions you can log the slow queries to tables for analysis;
>> * Ultimately, you can also try a patched version of mysqldumpslow I was using
>> for some time, explained here:
>> http://gpshumano.blogs.dri.pt/2009/07/04/analysing-mysql-slow-queries/
>>
>>
ow I was using
> for some time, explained here:
> http://gpshumano.blogs.dri.pt/2009/07/04/analysing-mysql-slow-queries/
>
> In the last two options you'll be logging to a table, so it will be easy to
> select a timed range of queries for consideration.
>
> Hope that helps,
&g
version of mysqldumpslow I was using
for some time, explained here:
http://gpshumano.blogs.dri.pt/2009/07/04/analysing-mysql-slow-queries/
In the last two options you'll be logging to a table, so it will be easy to
select a timed range of queries for consideration.
Hope that helps,
-NT
Quoti
mented Sphinx search, there's an
> existing drupal module for integration.
>
> There's lots more that was done, but I can't provide all that info because
> a) it's company internal, and b) because I'm not a developer and thus don't
> know half of it :-)
>
company internal, and b) because I'm not a developer and thus don't
know half of it :-)
Suffice it to say, I don't like drupal for high-traffic interactive sites.
Get away from it if you can.
I'm logging slow queries but is there a way to see when the
> slow queries t
ndric [mailto:mand...@gmail.com]
Sent: Friday, July 31, 2009 11:15 AM
To: mysql@lists.mysql.com
Subject: logging slow queries with time
Hello,
I'm serving a burly Drupal install and at some points throughout the
day the mysql threads go way up and iowait peaks. I'm not sure which
is causing w
this. I'm logging slow queries but is there a way to see when the
slow queries take place also? I'd like to know what queries are being
processed during this window of poor response time, usually around
noon local time.
Thanks in advance,
--
Milan
--
MySQL General Mailing List
For
As a followup, simply logging to stderr prints to the $host.err in the
mysql data directory, which is good enough for my purposes.
In case anyone else is curious, when experimenting I found I could use
my_printf_error to return errors to the console where I inserted the
bad data. But, that
Hello,
I've written a fulltext plugin for Mysql 5.1. The plugin works great
and I'm happy with it, but I would like to log an error when I
encounter some unexpected data. Do plugins have access to the Mysql
error log? If so, how do I write to it?
Thanks!
--
MySQL General Mailing List
For lis
Nigel/Marcus/Johann
mg>hopefully quick answer
>
> nigel wood wrote:
> >
> > Here's a rough table stucture. The indexes in events tables would be
> > TargetId.
mg>there would be need to be a 1:1 correspondence between
mg>TargetId index and Username..all of your other tables would need to know
nigel wood wrote:
Here's a rough table stucture. The indexes in events tables would be
TargetId. But problably TargetId+EventDate probably eventId+event date
as you found more uses/added paging.
Well that didn't format very well :-( The tables structures are:
User/Actor
===
TargetId
On Fri, Jul 3, 2009 at 12:09 PM, Marcus Bointon
wrote:
> On 3 Jul 2009, at 09:42, Johan De Meersman wrote:
>
> To be honest, this sounds like more of a filesystem thing, given that you
>> only ever need to select the full set of an individual user. Just build up
>> an FS structure with one file p
Marcus Bointon wrote:
"For the most part this is write-only and is only ever read very rarely,
but when I do, it will be to retrieve the details of a single user, and
all I need is the whole history, not individual events."
For your stated requirements the filesystem is probably most efficien
On 3 Jul 2009, at 09:42, Johan De Meersman wrote:
To be honest, this sounds like more of a filesystem thing, given
that you only ever need to select the full set of an individual
user. Just build up an FS structure with one file per user.
You really think so? Even though I'll need to initi
most part this is write-only and is only ever read
> very rarely, but when I do, it will be to retrieve the details of a single
> user, and all I need is the whole history, not individual events. At present
> I'm logging by appending to a text blob field for each recipient. This wo
, that they unsubscribed etc. For the most part
this is write-only and is only ever read very rarely, but when I do,
it will be to retrieve the details of a single user, and all I need is
the whole history, not individual events. At present I'm logging by
appending to a text blob fiel
Hi
Thanks for the response. In fact my main requirement is to track the
queries executed in the event we have some data which has been contaminated
in some way - which will help us with our investigations. Basically I've
designed a brand new back end office - and feel I need to record the querie
Hi
The purpose is really for auditing and constant performance analysis ? I
could save each query in my own user generated table. But thought maybe
best to use mysql's built in feature.
Neil
On Wed, May 27, 2009 at 5:22 PM, Baron Schwartz wrote:
> Neil,
>
> What is the purpose? Is it for au
Neil,
What is the purpose? Is it for auditing, performance analysis, ...?
Regards
Baron
On Wed, May 27, 2009 at 10:12 AM, Tompkins Neil
wrote:
> Hi,
>
> We've developed a new extranet system and feel that we need to record all
> queries performed. What is the best / recommended way to achieve
Enable mysql SQL logging in the configuration file.
[mysqld]
log
Cheers
Claudio
2009/5/27 Tompkins Neil
> Hi,
>
> We've developed a new extranet system and feel that we need to record all
> queries performed. What is the best / recommended way to achieve this.
>
> Thanks
> Neil
>
Hi, you can start mysql server with --log=/someplace/my_queries.txt and
every query the server runs is logged in that file. Keep in mind that if the
server runs another systems all queries are logged so you need to identify
the ones belong to your system. Also, if you system has a lot of query ca
: Logging SQL queries
Hi,
We've developed a new extranet system and feel that we need to record all
queries performed. What is the best / recommended way to achieve this.
Thanks
Neil
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Hi,
We've developed a new extranet system and feel that we need to record all
queries performed. What is the best / recommended way to achieve this.
Thanks
Neil
> I'm having a problem defining slow logging file in my.ini (Windows XP). I'm
> using MySQL 5.1.30.
>
> In the MySQL reference manual it says:
> As of MySQL 5.1.29, the --log-slow-queries option is deprecated and will be
> removed (along with the
> log_slow_queries s
Try putting in a full existing pathname the server has write access to
as opposed to just a file name.
Walter Heck
On Sun, May 17, 2009 at 12:13 PM, mos wrote:
> I'm having a problem defining slow logging file in my.ini (Windows XP). I'm
> using MySQL 5.1.30.
>
>
I'm having a problem defining slow logging file in my.ini (Windows XP). I'm
using MySQL 5.1.30.
In the MySQL reference manual it says:
As of MySQL 5.1.29, the --log-slow-queries option is deprecated and will be
removed (along with the
log_slow_queries system variable) in MySQL 7.
Help and much, thank you for the answer, I just want to know if there
is something specific to the purpose of the access log of users.
But the alternative is a good start :)
On Thu, Nov 27, 2008 at 3:06 PM, Andy Shellam <[EMAIL PROTECTED]> wrote:
> Hi Darvin,
>
> Does this not help?
>
> http://dev
Hi Darvin,
Does this not help?
http://dev.mysql.com/doc/refman/5.0/en/query-log.html
(replace 5.0 with 5.1 if you've already upgraded.)
"The general query log is a general record of what mysqld is doing. The
server writes information to this log when clients connect or
disconnect, and it log
I wonder if there is the possibility of registering the users' access
to the server Mysql.
Something similar to the command "last" of Unix-like systems.
Thanks.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTE
I want to find out why that happened. I'm running the mysql debian package
for etch (stable). It installs mysql 5.0. The default my.cnf says this:
# Be aware that this log type is a performance killer.
#log = /var/log/mysql/mysql.log
# Error logging goes to syslog. This is a Debian improv
Fan, Wellington wrote:
> > Given: MySQL 4.0.12, I need to implement a pageview log with a
resolution of 1 day.
If you want to brute-force it, I think I would go this route:
create table hits (
day date not null primary key,
hitcount int unsigned not null,
);
insert ignore into hits(day, hitc
> > Given: MySQL 4.0.12, I need to implement a pageview log with a
> > resolution of 1 day.
..
>
> Would the "REPLACE" method work?
>
> David
Hmmm...as I read the docs, the "LOCK IN SHARED MODE" seemed to be the
real key to this.
I created a test script and ran:
$ ab -n100 -c100 local
> Given: MySQL 4.0.12, I need to implement a pageview log with a
> resolution of 1 day.
>
> I propose this table:
>
> CREATE TABLE `pageviews` (
> `id` int(11) NOT NULL auto_increment,
> `date` date NOT NULL default '-00-00',
> `url` char(120) NOT NULL default '',
> `views` mediumint(9) NO
Hello Listies,
Given: MySQL 4.0.12, I need to implement a pageview log with a
resolution of 1 day.
I propose this table:
CREATE TABLE `pageviews` (
`id` int(11) NOT NULL auto_increment,
`date` date NOT NULL default '-00-00',
`url` char(120) NOT NULL default '',
`views` mediumint(9) N
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
We have general logging enabled on our mysql server via a my.cnf
setting. The log records an entry when the server restarts, but does not
record any queries. Is this a bug? or have I missed something.
In my.cnf
[mysqld]
log=query.log
Contents
is a sql log that you can enable in the config file.
>If you look at the config file now it will most likely only have one log
file,
>Look at MSQL manual and logging.
>I dont have the setting infront of me at the moment.
>If you cannot find give a yell.
On Wednesday 25 April 2007
There is a sql log that you can enable in the config file.
If you look at the config file now it will most likely only have one log file,
Look at MSQL manual and logging.
I dont have the setting infront of me at the moment.
If you cannot find give a yell.
On Wednesday 25 April 2007 10:06
Hello,
I am trying to debug another application and I need to enable logging of all
queries (temporary only) to MySQL (5.0.37). OS is FreeBSD 6.2. MySQL
installed from ports.
any Instructions, or pointers to documentation would be appreciated.
Thanks,
Ray
--
MySQL General Mailing List
For
It is noted in
http://dev.mysql.com/doc/refman/4.1/en/communication-errors.html:
The server increments the |Aborted_connects| status variable when the
following things happen:
*
A client doesn't have privileges to connect to a database.
*
A client uses an incorrect password
Joey wrote:
I wanted to confirm something as I am having a problem logging into mysql
from the network.
I have a server configured with a user showing host as % and the user with
it's appropriate privalages. It allows me to login from phpmyadmin as well
as via port 3306 to connect to t
I wanted to confirm something as I am having a problem logging into mysql
from the network.
I have a server configured with a user showing host as % and the user with
it's appropriate privalages. It allows me to login from phpmyadmin as well
as via port 3306 to connect to the DB with MySQ
Is it possible to have a transaction automatically write the IP
adress of the client
to a field of a record?
-
This sig is dedicated to the advancement of Nuclear Power
Tommy Nordgren
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Markus Fischer wrote:
> Before I re-invent the wheel I'ld like to know if there are tools/helper
> like this available ... ?
Being impatient and in need of this I've written my own version. Maybe
it is valuable to others.
http://markus.fischer.name/l
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
we've enabled /var/log/mysql.log on our server (5.0.24a on Debian
testing). However I only want to log commands from certain application,
or better say, certain users.
When I look at some log output, it looks like this:
060919 9:53:38
15945 Con
Hello,
I realize that this is a silly question, but I cannot figure it out. I
don't know why. Id really appreciate your help.
I cannot get mysql to do general logging. My my.ini reads like this:
--
#This File was made using the WinMySQLAdmin 1.4
I figured it out. Thanks for listening. I maybe just needed to vent.
-Original Message-
From: Josh Milane [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 08, 2006 12:46 PM
To: mysql@lists.mysql.com
Subject: query logging is making me mental!
Hello Everyone,
I am hoping that
lication
//bin/mysql using your name and password and issue an "show
variables like 'LOG';" command.
I tested in my own server here. Simply adding this:
[mysqld]
log
To my.cnf created an .log on my "data" directory logging
queries. Make sure that XAMPP is not overwrit
log OFF
log_bin OFF
log_bin_trust_function_creatorsOFF
log_error .\HomeDesktop-24.err
Why is my logging OFF?
How do I turn it ON?
I thought that as long as I had the log=hostname.log
using grep, but retrieving a little data from a large batch isn't the
issue. The issue is the overhead of logging ever single query to the
server when I only need a handful of tables. I know we can log
everything and retrieve from there, but logging everything is not an
option. I am looking f
Thanks. I could also get the same result with the existing query log
using grep, but retrieving a little data from a large batch isn't the
issue. The issue is the overhead of logging ever single query to the
server when I only need a handful of tables. I know we can log
everythin
bility to log to
a table instead of a file, not log access to a specific table.
David
On Jul 18, 2006, at 9:23 PM, Chris wrote:
> David Felio wrote:
>> Is it possible to have general query type logging on just a
>> specific database or table? I don't want all queries to all
>>
have general query type logging on just a
specific database or table? I don't want all queries to all
databases, I just need a log of accesses to a specific table. I
figure I can use stored procedures or a separate mysql instance as
a workaround if I need to, but would prefer to be able t
David Felio wrote:
Is it possible to have general query type logging on just a specific
database or table? I don't want all queries to all databases, I just
need a log of accesses to a specific table. I figure I can use stored
procedures or a separate mysql instance as a workaround if I
1 - 100 of 335 matches
Mail list logo