SPAM *** Audit feature in MySQL ***

2002-09-23 Thread Imro Benito STROK
Hi All, Due to security reasons we have to implement an audit functionality in our MySQL production databases. Q; Is there an audit feature in MySQL. If YES can someone send me the information how to implement this. Thanks, Imro Strok StarHub Pte Ltd Information Technology Phone: +65 6825 5703

Re: Speaking of DBI -v- Net::MySQL (Was: RE: first dbi accesswith perl and lost)

2002-09-23 Thread Paul DuBois
At 21:51 +0200 9/22/02, Thoenen, Peter Mr. EPS wrote: Following this conversation myself (also a perl db newbie :) ... before always just used php) and curious if you know definitely what db vendor you are going to be using (mysql in this case), any reason to use dbi; as opposed to just using

Re: Re: mysqlimport

2002-09-23 Thread Paul DuBois
sql,query HI sorry for the confusion. well.. I want to create a database where I can give *any* name (ofcourse, the database doesn't exist). Are you trying to say, I need to ask the root, to give me create privilege on database xxx, even before it exist, then only I can create the database

Re: Speaking of DBI -v- Net::MySQL (Was: RE: first dbi access with perl and lost)

2002-09-23 Thread Tatsuhiko Miyagawa
At Mon, 23 Sep 2002 22:35:03 -0500, Paul DuBois wrote: DBI is useless without at least one driver for connecting to a specific database. DBD::vendor is useless without DBI; Perl scripts don't communcate directly with DBD drivers. They communicate with DBI, which speaks to the database

RE: SPAM *** Audit feature in MySQL ***

2002-09-23 Thread Sqlcoders.com Programming Dept
Try http://www.mysql.com/doc/en/Query_log.html -Original Message- From: Imro Benito STROK [mailto:[EMAIL PROTECTED]] Sent: 23 September 2002 20:04 To: '[EMAIL PROTECTED]' Cc: '[EMAIL PROTECTED]'; Imro Benito STROK Subject: SPAM *** Audit feature in MySQL *** Hi All, Due to

OT: Report writer

2002-09-23 Thread Derek Scruggs
Hi All, This is a little OT, but I'm looking for a report writer/server for Apache/MySQL. There are lots of report writer/servers out there, but the ones I've found so far either 1) work only on Windoze or 2) cost a lot of money. I'm just looking for a basic tool that allows me to design

-march=k6?

2002-09-23 Thread Daniel Kasak
Hi all! I have built MySQL-4.0.3 with -march=k6 (gcc-2.95.3) in my CFLAGS (everything else was as recommended in the INSTALL instructions). I did a little testing before dumping our data into it, and it seemed OK :) However now MySQL is crashing on one particular query only (it has been fine

Copying to tmp table

2002-09-23 Thread Teh Chee Peng
hi, Does anyone has any idea to improve this situation? When I show my processlist, there is inner join query that having Copying to tmp Table state, and it takes quite long time to finish the query. Any idea to avoid Copying to tmp Table? I have tried to increase my tmp_table_size however it

Question about HEAP tables

2002-09-23 Thread hooker
Hi, I've got a problem with HEAP tables (undoubtedly the way that I'm using them). I'm running MySQL v.3.23.51 under Debian Linux with a 2.4.17 kernel. I've got a perl script which creates a HELP table and controls the maximum size via the 'max_rows=' option to 'create table'. When the script

Re: Copying to tmp table

2002-09-23 Thread Lars Heidieker
hi, on solaris it probably a good idee to change the tmp directory from /var/tmp - /tmp as /tmp is a ram disk that gives a good performance boost if tmp tables are involved. The sort_buffer variable the the one to look at try increasing it, as if the result fits into the sort buffer no tmptable

<    1   2