Hi Joerg,
Thanks a lot for the info.
regards
anandkl
On 7/23/08, Joerg Bruehe [EMAIL PROTECTED] wrote:
Hi !
Ananda Kumar wrote:
Hi All,
I have setup slave db. The machine configuration details of this slave is
same as master.
OS=redhat
8 cpu
16GB RAM
key_buffer_size=3000M
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.
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 to
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
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
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
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...
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
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 understand your
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) |
+-+---+
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: Daniel
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;
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;
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)
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
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'
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()
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
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.
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?
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
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
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 that
23 matches
Mail list logo