Guys
my mysqlreport says :
Buffer used 205.00k of 16.00M %Used: 1.25
Current 2.04M%Usage: 12.76
Write hit 100.00%
Read hit 97.90%
__ Questions ___
Total 5.08k16.6/s
* Com_ 2.68k
In the last episode (Jul 23), Pedro said:
> I need to pass the user of my application pro bank. I want to log the
> user's application and value of new fields or fields updated. To then
> have audit of who did what.
>
> It is really necessary to create a trigger and a table of log for
> each table
How about: WHERE ( field1 LIKE '123,%' OR field1 LIKE '*,123,%' OR
field1 LIKE '%,123' OR field1 = '123' )
Note that this could that a long time on large tables. You'd be better
off to normalize your tables ;)
How can we normalize the tables? could you explain bit more?
Thanks,
Siva
Is there are a reason why this wouldn't work?
select upper( monarch.group_decode(lower(hg.alias)) ) from
nagios.nagios_hostgroups hg;
++
| upper( monarch.group_decode(lower(hg.alias)) ) |
++
| database
I need to pass the user of my application pro bank.
I want to log the user's application and value of new fields or fields
updated. To then have audit of who did what.
It is really necessary to create a trigger and a table of log for each
table that want to monitor?
What do you suggest me?
Sorry, not specified what I wanted to get inside the trigger. I would
pick who is running the operation.
Pedro Belmino escreveu:
I do a system log of their log everything that is done(INSERTS, UPDADES
and DELETES). Okay, can be done with trigger. But I need to know who
performed the operation.
You should be able to do this fine. It would help if you specified what
the error you were getting was.
Atle
On Tue, 22 Jul 2008, Jim Lyons wrote:
I recently installed 2 instances of mysql on the same server, using port
3307 for the second server, the normal 3306 for the first server. I fou
In the last episode (Jul 23), Pedro Belmino said:
> I do a system log of their log everything that is done(INSERTS, UPDADES
> and DELETES). Okay, can be done with trigger. But I need to know who
> performed the operation. How can I get get it inside the trigger?
Try the USER() or CURRENT_USER() fu
I do a system log of their log everything that is done(INSERTS, UPDADES
and DELETES). Okay, can be done with trigger. But I need to know who
performed the operation. How can I get get it inside the trigger?
Thank you,
Att,
--
'É um orgulho ter você como nosso cliente'
__
I just want to point out that public IPs are no longer given out as
Class A, B, and C networks, but based on CIDR. You can use rwhois to
figure out who has use of a certain subnet and what the range of it is.
Thank you,
Micah Gersten
onShore Networks
Internal Developer
http://www.onshore.com
D
Thanks Glyn,
What you have given me works. I have taken it so now I get anything
greater that one
select substring_index(ip,'.',3), count(*) from ips group by 1 having
count(*) > 1 order by 2 desc limit 10;
+---+--+
| substring_index(ip,'.',3)
On Wed, 2008-07-23 at 12:10 -0400, [EMAIL PROTECTED] wrote:
> Yes, sorry. I have a database that records ip of attacks on a customer
> server, what I like to do get a count so that I can see what subnet is
> doing the major of the attacks.
>
> select ip from ipslimit 10;
> +-+-
On Wed, Jul 23, 2008 at 12:10 PM, <[EMAIL PROTECTED]> wrote:
> Yes, sorry. I have a database that records ip of attacks on a customer
> server, what I like to do get a count so that I can see what subnet is
> doing the major of the attacks.
>
> select ip from ipslimit 10;
> +-+
I think you're after the SUBSTRING_INDEX(str,delim,count) function, so (I've
not tried this):
select substring_index(ip,'.',3) from ipslimit 10;
--- On Wed, 23/7/08, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> From: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
> Subject: Re: a question...
> To: "D
Yes, sorry. I have a database that records ip of attacks on a customer
server, what I like to do get a count so that I can see what subnet is
doing the major of the attacks.
select ip from ipslimit 10;
+-+---+
| ip | count(ip) |
+-+---+
On Wed, Jul 23, 2008 at 11:45 AM, <[EMAIL PROTECTED]> wrote:
> Guys,
>
> I have been fighting with mysql trying to get it to only show every after
> the last dot(.) on a ip. for example
>
> instead geting 10.0.0.0 only get 10.0.0
As pulled from a database row? Sorry, I didn't quite understan
Guys,
I have been fighting with mysql trying to get it to only show every after
the last dot(.) on a ip. for example
instead geting 10.0.0.0 only get 10.0.0
But what every I try doesn't work. Can someone pls point to a web page
where I can learn how to do it, of explain it here.
Thanks.
Payne
VeeJay wrote:
Hi there
I am going to make 2 Webserver at my work going to handle 50 mil hits per
month... They are using Linux already. But being a FreeBSD fan, I have
proposed MySQL and FreeBSD to my Boss convincing him that MySQL and FreeBSD
is more Fast and Secure solution for his needs... An
On Wed, 2008-07-23 at 17:05 +0300, Ali Deniz EREN wrote:
> Hi all,
>
> I have a problem as below:
>
> A text field -Lets call it 'field1'- contains datas seperated by
> commas(,) like this (123,5764,8795,9364,11,232,. and go on) And so
> my lines like these:
>
> id title filed1
> -
>A text field -Lets call it 'field1'- contains datas seperated by
commas(,)
> like this (123,5764,8795,9364,11,232,.
The solution is to normalise the data.
PB
Ali Deniz EREN wrote:
Hi all,
I have a problem as below:
A text field -Lets call it 'field1'- contains datas seperated by
comma
Hi all,
I have a problem as below:
A text field -Lets call it 'field1'- contains datas seperated by
commas(,) like this (123,5764,8795,9364,11,232,. and go on) And so
my lines like these:
id title filed1
-
1 title1
Hi Chaim
Contents are going to be dynamic...
I will go with Apache 2.2.9 and also PHP with ACP (accelator)
Any suggestions?
Regards
VJ
On Tue, Jul 22, 2008 at 10:18 PM, Chaim Rieger <[EMAIL PROTECTED]>
wrote:
> VeeJay wrote:
>
>> Hi there
>>
>> I am going to make 2 Webserver at my work going
I'm still using win2k mysql 5.1
With default databas encoding, I can do querys with bh English and Chinese GB.
But when database encoding is uft8, all the Chinese become question maks.
Any idea about how to mysql work unicode databa? Thanks a lot.
23 matches
Mail list logo
