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
3/7/08, [EMAIL PROTECTED] <[EMAIL PROTECTED]>
> wrote:
>
>> From: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
>> Subject: Re: a question...
>> To: "Daniel Brown" <[EMAIL PROTECTED]>
>> Cc: [EMAIL PROTECTED], mysql@lists.mysql.com
>> Date: Wedne
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]>
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
Thanks very much.
2008/5/21 Paul McCullagh <[EMAIL PROTECTED]>:
>
> On May 21, 2008, at 8:46 AM, Paul McCullagh wrote:
>
> On May 21, 2008, at 8:09 AM, Moon's Father wrote:
>>
>> Now I want to know which way you use to create index of a table.
>>> 1、ix_u (item_id,item_count)
>>>ix_item_coun
Thanks for your reply very much.
What I always use is the first way.
But I also want to know if the following way is proper when I search
"item_id AND item_count" and the column 'item_count'.?
ix_item_id (item_id)
ix_item_count (item_count)
2008/5/21 Paul McCullagh <[EMAIL PROTECTED]>:
>
>
On May 21, 2008, at 8:46 AM, Paul McCullagh wrote:
On May 21, 2008, at 8:09 AM, Moon's Father wrote:
Now I want to know which way you use to create index of a table.
1、ix_u (item_id,item_count)
ix_item_count (item_count)
This makes sense if you have queries which search "item_id AND
i
On May 21, 2008, at 8:09 AM, Moon's Father wrote:
Now I want to know which way you use to create index of a table.
1、ix_u (item_id,item_count)
ix_item_count (item_count)
This makes sense if you have queries which search "item_id AND
item_count", and queries which just search the column
[EMAIL PROTECTED] schrieb:
> I am running the 64 bit version of mysql server 5.1.18, and on the
> client side I am running python with the mysqldb module. While
> running a very large insert query I get the following error :
>
> 2013, 'Lost connection to MySQL server during query'
>
> I have --l
Hello.
Some information you can find here:
http://dev.mysql.com/doc/refman/5.0/en/innodb-parameters.html
http://dev.mysql.com/doc/refman/5.0/en/innodb-checkpoints.html
Have a look to innobase/log/log0log.c file in MySQL source distribution.
wangxu wrote:
> There are many information about di
Hello.
>If "default-character-set" can't set in "[client]"?
The comprehensive explanations you will find at:
http://bugs.mysql.com/bug.php?id=11673
"wangxu" <[EMAIL PROTECTED]> wrote:
>Follow is a part of my my.ini.
>--
"default-character-set" can't set in "[client]"?
- Original Message -
From: "sheeri kritzer" <[EMAIL PROTECTED]>
To: "wangxu" <[EMAIL PROTECTED]>
Cc:
Sent: Friday, November 18, 2005 5:44 AM
Subject: Re: a question of specifying Tim
What does your my.cnf configuration for mysql say? Check out:
http://dev.mysql.com/doc/refman/5.0/en/charset-connection.html
I think you want "character_set" as your variable, not "default_character_set".
Just my guess, not seeing any of your config files.
-Sheeri
On 11/16/05, wangxu <[EMAIL
Hello.
If you want to enable large pages in the Linux kernel, run a quick
search in Google. I've found these links (ignore the 'DB2'
and 'oracle' in the URL:)
http://www.linux.com/howtos/DB2-HOWTO/kernels.shtml
http://linux.inet.hr/oracle10g_on_debian.html
Íõ Ðñ wrote:
> I learn
Hello.
Very often PREPARED STATEMENTS are helpful in similar situations. For a pity,
they are disabled in the current release. See:
http://dev.mysql.com/doc/mysql/en/sqlps.html
Leonardo Javier Belén wrote:
> Hi all,
> I am wondering if I can construct a query string inside a stored
Yes you can do this using prepared statements inside stored proc.
Guess this helps.
http://forums.mysql.com/read.php?98,22770,31459
sujay
-Original Message-
From: Leonardo Javier Belén [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 06, 2005 9:47 PM
To: Ryan Stille; mysql@lists.mysq
Hello.
SERIALIZABLE is like REPEATABLE READ, but all plain SELECT statements are
implicitly converted to SELECT ... LOCK IN SHARE MODE. In REPEATABLE
READ statements like SELECT ... LOCK IN SHARE MODE that use a unique
index with a unique search condition lock only the index record found,
no
Selon [EMAIL PROTECTED]:
> Mathias <[EMAIL PROTECTED]> wrote on 06/28/2005 01:11:59 PM:
>
> > Selon [EMAIL PROTECTED]:
> >
>
> >
> > Thanks Shawn, but i'm not speaking about data consistency during
> > transaction and
> > isolation levels.
> > I spoke about what is seen in the data dictionary as
Mathias <[EMAIL PROTECTED]> wrote on 06/28/2005 01:11:59 PM:
> Selon [EMAIL PROTECTED]:
>
>
> Thanks Shawn, but i'm not speaking about data consistency during
> transaction and
> isolation levels.
> I spoke about what is seen in the data dictionary as num_rows an why
> it can not
> be used ev
Selon [EMAIL PROTECTED]:
> Mathias <[EMAIL PROTECTED]> wrote on 06/28/2005 06:13:08 AM:
>
> > Selon Behrang Saeedzadeh <[EMAIL PROTECTED]>:
> >
> > > Mathias,
> > >
> > > Thanks a lot!
> > >
> > > > I will not explain the same thing for sqlserver, sybase ..., but
> when
> > > > your RDBMs
> > > >
Mathias <[EMAIL PROTECTED]> wrote on 06/28/2005 06:13:08 AM:
> Selon Behrang Saeedzadeh <[EMAIL PROTECTED]>:
>
> > Mathias,
> >
> > Thanks a lot!
> >
> > > I will not explain the same thing for sqlserver, sybase ..., but
when
> > > your RDBMs
> > > have a data dictionnary, you don't need to exec
Selon Behrang Saeedzadeh <[EMAIL PROTECTED]>:
> Mathias,
>
> Thanks a lot!
>
> > I will not explain the same thing for sqlserver, sybase ..., but when
> > your RDBMs
> > have a data dictionnary, you don't need to execute count(*) :o) WITH
> > Updated
> > statistics of course.
>
> I'm a little bit
Mathias,
Thanks a lot!
I will not explain the same thing for sqlserver, sybase ..., but when
your RDBMs
have a data dictionnary, you don't need to execute count(*) :o) WITH
Updated
statistics of course.
I'm a little bit confused here. Why the count(*) is not transformed to a
select from
Selon Behrang Saeedzadeh <[EMAIL PROTECTED]>:
> Hi all
>
> I was reading the High Performance MySQL book (by O'Reilly) and there
> was mentioned that executing a count(*) is slower on the InnoDB
> engine compared to the MyISAM engine, because InnoDB tables do not keep
> track of the number of the
Hello.
Complete information about licensing policy you can receive
from [EMAIL PROTECTED]
"Behrang Saeedzadeh" <[EMAIL PROTECTED]> wrote:
> Hi
>
> We've developed a J2EE application for one of our customers. Currently,
> the system uses SQLServer as the backend database. The databse sy
Suggest you review the MySQL documentation
http://dev.mysql.com/doc/mysql/en/installing.html and in particular 2.3.13.
Testing The MySQL Installation and 2.3.14. Troubleshooting a MySQL Installation
Under Windows
Bob
-Original Message-
From: Terry Leung [mailto:[EMAIL PROTECTED]
Sent:
Thankyou,
That worked a treat! Thankyou so very much
--
David Scott
- Original Message -
From: "Michael Stassen" <[EMAIL PROTECTED]>
To: "Critters" <[EMAIL PROTECTED]>
Cc:
Sent: Tuesday, May 17, 2005 5:01 PM
Subject: Re: A question of joining...
Critters
Critters wrote:
Hi,
I am having problems with the JOIN function.
MESSAGES
memberID_1, memberID_2, Message
MEMBERS
id, name
I can only manage to replace the "memberID_1" in MESSAGES with the "name" in MEMBERS, I
can not replace both memberID_1 and memberID_2 with "name".
Please can someone tell me
[EMAIL PROTECTED] wrote:
Hi,
I have a query that returns a list of numbers ranging from -10 to +10
I would like to be able to have a 2nd column where a result of 5 is 5
but -5 is also 5, so in effect all the negative (and only the negative)
results are made positive to find the deviation from zero.
ABS(column) ?
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, September 01, 2004 6:59 AM
Subject: A question of negative numbers..
Hi,
I have a query that returns a list of numbers ranging from -10 to +10
I would like to be able to have a 2nd col
<[EMAIL PROTECTED]> wrote on 01/09/2004 11:59:58:
> is there a function to make negative
> numbers positive?
ABS(x)
See http://dev.mysql.com/doc/mysql/en/Mathematical_functions.html
Alec
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Found answer to my own question:
Returns the absolute value of X:
mysql> SELECT ABS(2);
-> 2
mysql> SELECT ABS(-32);
-> 32
This function is safe to use with BIGINT values.
MySQL Reference Manual (C) 2002 MySQL AB
abs()
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, September 01, 2004 12:59 PM
Subject: A question of negative numbers..
Hi,
I have a query that returns a list of numbers ranging from -10 to +10
I would like to be able to have a 2nd column whe
[mailto:[EMAIL PROTECTED]
Sent: Sunday, August 01, 2004 6:26 PM
To: bruce
Cc: [EMAIL PROTECTED]
Subject: Re: a question/issue...
On Sun, Aug 01, 2004 at 09:22:21AM -0700, bruce wrote:
> hi...
>
> i'm testing an app where i want a parent app to create the mysql db
> connection l
On Sun, Aug 01, 2004 at 09:22:21AM -0700, bruce wrote:
> hi...
>
> i'm testing an app where i want a parent app to create the mysql db
> connection link/handle, and basically pass this handle off to child
> procesess. is there any reason why this can't be done? are there any
> examples of this alr
;m inclined to believe that if you can create a db connection handle, then
> any other process should be able to use it, as long as the creating
> process/parent process is still alive/running
>
> -bruce
>
>
>
>
> -Original Message-
> From: Justin Swanhart [mailto:[EMAIL PR
On 02/25/2004 09:13 AM Frederic Wenzel wrote:
Now I am assigned to do the backup of a whole mysql database (version: 3.23.36). I want to make sure whether the following procedures are correct for database backup.
1. mysqldump -F --opt database_name > database_name.backup
In my opinion, you shou
on 02/27/2004 12:11 AM, Li, Lenny Yong Bo (Lenny) at [EMAIL PROTECTED]
wrote:
>
> 1. database backup.
> This is done on the standby one with the following command.
> mysqldump --opt --quote-names --flush-logs database_name > database.backup
How does this operations handle binary fields, password
t, R&D, Lucent Qingdao
[EMAIL PROTECTED] 86-532-8702000-5033
http://gdcsr60.gdc.lucent.com/~lennyli
> -Original Message-
> From: Frederic Wenzel [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, February 25, 2004 4:13 PM
> To: Li, Lenny Yong Bo (Lenny)
> Cc: [EMAIL PROTECTED
-
> From: Frederic Wenzel [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, February 25, 2004 4:13 PM
> To: Li, Lenny Yong Bo (Lenny)
> Cc: [EMAIL PROTECTED]
> Subject: Re: A question about mysql database backup.
>
>
> Li, Lenny Yong Bo (Lenny) wrote:
>
> > Now I am
Li, Lenny Yong Bo (Lenny) wrote:
> Now I am assigned to do the backup of a whole mysql database (version: 3.23.36). I
> want to make sure whether the following procedures are correct for database backup.
> 1. mysqldump -F --opt database_name > database_name.backup
In my opinion, you should gen
The parser does not execute the query before it parses it. Thus you
cannot do that. Use Code, and or have an idea what the INTERVAL UNIT is
prior to executing the query.
- Dathan Vance Pattishall
- Sr. Programmer and mySQL DBA for FriendFinder Inc.
- http://friendfinder.com/go/p40688
-->--
Li:
you have to link in the mysql library mysqlclient.a in your makefile
Here is my makefile which you may use for reference
# This assumes the MySQL software is installed in /usr/local/mysql
inc := /cygdrive/g/mysql/mysql-debug-4.0.12-pc-linux-i686/include
lib := /cygdrive/g/mysql/mysql-
j.random.programmer wrote:
> Hi:
>
> Firstly, I'd like to congratulate both MySQL AB and
> Mr. Mathews on making the JDBC driver an officialy
> supported download.
>
> I have a query though. Newer versions of the mm.mysql
> driver (now called connector/j) will be released *not*
> under the LGPL
On Monday 19 August 2002 07:21 am, Nicolas Ivering wrote:
Several things spring to mind here...
1st of all when you use JDBC, you're coding to the JDBC interface, not to any
proprietary interface (IE, your application could just as well call a
PostgreSQL JDBC driver and it would not need to be
I'm not from an official source but I would imagine the reason for the
change of license is to be able to charge for a non-GPL version of the
driver. With that in mind it wouldn't make much sence if you could use
the driver with a non-GPL program without making the program GLP also
(and thus a
Andrew,
Friday, April 26, 2002, 3:12:25 AM, you wrote:
AW> Hello, I am new to mysql - past the very basics - you may see a few silly
AW> questions - here is the first.
AW> I have a DELETE statement:
AW> delete bond_master,bond_data from bond_data where
AW> bond_master.cusip=bond_data.cusip an
On Fri, Sep 07, 2001 at 07:19:01AM -0700, Mike Wexler wrote:
>
> Jeremy Zawodny wrote:
> >
> > On Fri, Sep 07, 2001 at 12:07:07PM +0100, Basil Hussain wrote:
> > >
> > > I'm quite surprised that this level of performance is available from
> > > such standard (well, not standard as in 'common', b
Hi,
> > On the other hand though, it gives me some comfort that the hardware
> > being used in my operation will meet any future needs. We have
> > similar spec servers (P3-1Ghz dual-cpu, 512Mb RAM, 3x36Gb SCSI
> > RAID5). Maybe I should try out mysql-super-smack and see what kind
> > of numbers
Jeremy Zawodny wrote:
>
> On Fri, Sep 07, 2001 at 12:07:07PM +0100, Basil Hussain wrote:
> >
> > I'm quite surprised that this level of performance is available from
> > such standard (well, not standard as in 'common', but y'know what I
> > mean...) hardware. The last I heard, 1K+ queries/sec
Terje Kristensen wrote:
>
> I have a HP-UX server with Perl 5.005_03, MySQL 3.23.39 for hp-hpux11.00
> (hppa2.0w),
> Apache/1.3.20.
>
> The load are rather high, and "Queries per second avg: 94.859"
> This is an local B2B installation som we are really not getting any traffic
> between 4PM and
Basil Hussain writes:
> Hi,
>
> I'm quite surprised that this level of performance is available from such
> standard (well, not standard as in 'common', but y'know what I mean...)
> hardware. The last I heard, 1K+ queries/sec was only being done on extremely
> high-end Sun enterprise-level machin
On Fri, Sep 07, 2001 at 12:07:07PM +0100, Basil Hussain wrote:
>
> I'm quite surprised that this level of performance is available from
> such standard (well, not standard as in 'common', but y'know what I
> mean...) hardware. The last I heard, 1K+ queries/sec was only being
> done on extremely
Hi,
> > > About a year ago, I used mysql-super-smack and was able to hit
> > > 8,000 per second on our [then new] server. The highest I've
> > > recorded on an actual production application was around 5,000.
> > > But I don't watch the numbers closely very often...
> >
> > Just out of curiosity,
gure what it is ?
Thanks in advance,
Jerome
>>> -Message d'origine-
>>> De : Jeremy Zawodny [mailto:[EMAIL PROTECTED]]
>>> Envoye : vendredi 7 septembre 2001 11:05
>>> A : [EMAIL PROTECTED]
>>> Cc : [EMAIL PROTECTED]; [EMAIL PRO
Hello Terje,
Friday, September 07, 2001, 12:11:30 PM, you wrote:
TK> I have a HP-UX server with Perl 5.005_03, MySQL 3.23.39 for hp-hpux11.00
TK> (hppa2.0w),
TK> Apache/1.3.20.
TK> The load are rather high, and "Queries per second avg: 94.859"
TK> This is an local B2B installation som we are re
On Fri, Sep 07, 2001 at 09:54:35AM +0100, [EMAIL PROTECTED] wrote:
>
>
> > About a year ago, I used mysql-super-smack and was able to hit
> > 8,000 per second on our [then new] server. The highest I've
> > recorded on an actual production application was around 5,000.
> > But I don't watch the
> About a year ago, I used mysql-super-smack and was able to hit 8,000
> per second on our [then new] server. The highest I've recorded on an
> actual production application was around 5,000. But I don't watch the
> numbers closely very often...
Just out of curiosity, on what hardware? My nee
On Fri, Sep 07, 2001 at 10:11:30AM +0200, Terje Kristensen wrote:
>
> We have peeks where there is more than 1000 Queries per second.
> Does anyone have any experience with a higher number of queries pr
> second than this ?
About a year ago, I used mysql-super-smack and was able to hit 8,000
per
Davin Flatten wrote:
>
> Hello everyone,
>
> I have a quick question of performance. Which is
> faster with the Perl DBI:
>
> 1. One SQL query that retrieves a large amount of data
> and then lets Perl decide what to do with each row.
> i.e. this row is a "foo1" do this, this row is a
> "foo2"
63 matches
Mail list logo
