Well, the command
sudo /usr/local/mysql/support-files/mysql.server stop
generates the error message:
ERROR! MySQL server PID file could not be found!
On the other hand,
sudo launchctl unload -F
/Library/LaunchDaemons/com.oracle.oss.mysql.mysqld.plist
stops the server and
sudo /usr/local/
On 12/3/2016 13:58, Martin Mueller wrote:
I was able to install a version of MySQL 5.6 on OS Sierra. It appears that the
“launchdaemon’ method works while the mysql.server start/stop method does not
work. In retrospect I should have seen that, but I also think that the
official documentation
On 12/2/2016 17:58, Martin Mueller wrote:
Alas, running the stop and start commands under sudo makes zero difference.
?! The cited page recommends more than sudo starts and stops, eg ...
|unset TMPDIR mysql_install_db |
Did you try that? Did you check the pid setting in my.cnf, eg
pid-file=/
2016/12/02 18:58 ... Martin Mueller:
Alas, running the stop and start commands under sudo makes zero difference.
This is a very frustrating problem, and I hope somebody in the MySQl
documentation department will take a look at it. It’s cleary a problem that
has been around for years because t
Alas, running the stop and start commands under sudo makes zero difference.
This is a very frustrating problem, and I hope somebody in the MySQl
documentation department will take a look at it. It’s cleary a problem that
has been around for years because the Web is full of complaints and tips.
On 12/2/2016 16:59, Martin Mueller wrote:
I have been trying repeatedly and in vain to install the community edition of
MySQL 5.7.16 on an iMac running OS sierra. I religiously followed the
instructions for uninstalling previous versions found at
http://community.jaspersoft.com/wiki/uninstall
ryan.esca...@gmail.com [mailto:ryan.esca...@gmail.com] On
> Behalf
> >>>> Of Ryan Escarez
> >>>> Sent: Friday, October 16, 2015 2:47 AM
> >>>> To: Ryan Coleman
> >>>> Cc: Dennis Ruiz; mysql-le...@lists.mysql.com
> >>>> Subject:
m [mailto:ryan.esca...@gmail.com] On Behalf
>>>> Of Ryan Escarez
>>>> Sent: Friday, October 16, 2015 2:47 AM
>>>> To: Ryan Coleman
>>>> Cc: Dennis Ruiz; mysql-le...@lists.mysql.com
>>>> Subject: Re: a
>>>>
>>>> c
...@gmail.com] On Behalf
Of Ryan Escarez
Sent: Friday, October 16, 2015 2:47 AM
To: Ryan Coleman
Cc: Dennis Ruiz; mysql-le...@lists.mysql.com
Subject: Re: a
c
On Fri, Oct 16, 2015 at 3:01 PM, Ryan Coleman
wrote:
b
On Oct 15, 2015, at 10:07 PM, Dennis Ruiz wrote:
a
signature.asc
Description
To: Ryan Coleman
>> Cc: Dennis Ruiz; mysql-le...@lists.mysql.com
>> Subject: Re: a
>>
>> c
>>
>> On Fri, Oct 16, 2015 at 3:01 PM, Ryan Coleman
>> wrote:
>>
>>> b
>>>
>>>> On Oct 15, 2015, at 10:07 PM, Dennis Ruiz
d
> -Original Message-
> From: ryan.esca...@gmail.com [mailto:ryan.esca...@gmail.com] On Behalf
> Of Ryan Escarez
> Sent: Friday, October 16, 2015 2:47 AM
> To: Ryan Coleman
> Cc: Dennis Ruiz; mysql-le...@lists.mysql.com
> Subject: Re: a
>
> c
>
> On F
c
On Fri, Oct 16, 2015 at 3:01 PM, Ryan Coleman wrote:
> b
>
> > On Oct 15, 2015, at 10:07 PM, Dennis Ruiz wrote:
> >
> > a
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:http://lists.mysql.com/mysql
> >
>
>
> --
> MySQL Gene
b
> On Oct 15, 2015, at 10:07 PM, Dennis Ruiz wrote:
>
> a
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/mysql
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Its called JDBC connector, please see the link:
http://dev.mysql.com/doc/connector-j/en/connector-j-usagenotes-connect-drivermanager.html
good luck.
On Wed, Dec 11, 2013 at 10:15 AM, wrote:
> I have MySQL 5.5.8 under Windows Vista, and I am minded to write Java
> programs to talk to the serve
ilto:h...@tbbs.net]
> Sent: Saturday, March 16, 2013 6:23 AM
> To: Reindl Harald
> Cc: mysql@lists.mysql.com
> Subject: Re: a little doubt on text about MySQL
>
> >>>> 2013/03/16 03:44 +0100, Reindl Harald >>>>
> what are you speaking about?
>
> yo
2013/03/16 03:44 +0100, Reindl Harald
what are you speaking about?
you can define it in my.cnf and YOU are responsible for
the configuration as you are also responsible the
develop php code with error_reporting = E_ALL
These SQL-modes that pertain to type-safety are really part
2013/03/15 12:43 -0300, Marcus Vinicius
Does anyone knows the author of this:
http://grimoire.ca/mysql/choose-something-else
Title: "Do Not Pass This Way Again"
Not I
--but, as to automatic type-conversion, I find me in agreement with the author.
When I first began to use MyS
Am 16.03.2013 01:51, schrieb h...@tbbs.net:
> He makes a point that had not come to me, that type-security somewhat depends
> on SQL_MODE, which belongs to the connection. It is, quite rightly, stored in
> saved program code, but not in any table. At least these affect table behavior
what are
Hi Rafael,
You can try using correlated subquery instead of outer join. This can be slow
with big tables though:
SELECT * FROM users WHERE accept_email = 1 and email not in (SELECT email FROM
sent_emails WHERE sent_emails
.email = users.email AND messageID NOT LIKE = ‘XX’)
OR OUTER JOIN as
> Date: Fri, 9 Mar 2012 13:43:11 +0100
> From: h.rei...@thelounge.net
> To: mysql@lists.mysql.com
> Subject: Re: A Blob That's a String??
>
> where is the difference of "binary" and "string" after fetch it from DB?
> the result IS a binary safe s
Am 09.03.2012 13:28, schrieb Jack Hatterly:
> Even when I hard code in the correct values I get this error. However, when I
> select * from pics, where there is only one longblob in the table, it prints
> out a tremendous load of data which indicates to me that a binary file has
> indeed been
On 13/02/2012 22:09, Haluk Karamete wrote:
Gary,
you've mentioned that the user would have had access to the sysobjects
No, there's a difference. *If* they had access to sysobjects then it
could've caused issues.
Ideally, you should have some level of segregation within your database.
That
Gary,
you've mentioned that the user would have had access to the sysobjects
Let's assume he did. The page that this attempt occurred is hard-wired
to display a single record in detail view. In the code, I have a bunch
of echo $row- wrote:
> On 13/02/2012 21:48, Haluk Karamete wrote:
>>
>> My l
sorry, i overlooked that this IS a mysql mailing-list and we are
running ms-sql in this particular case. good catch...
I'd appreciate any insight though.
On Mon, Feb 13, 2012 at 1:56 PM, Gary Smith wrote:
> On 13/02/2012 21:48, Haluk Karamete wrote:
>>
>> My logs shows that we have tried with a
On 13/02/2012 21:48, Haluk Karamete wrote:
My logs shows that we have tried with a SQL Injection attempt, but
our engine has detected and avoided it but I am just curious, what are
these SQL statements are intending to achieve?
SELECT * FROM lecturer WHERE recID='25 ' and exists (select * fro
I can understand your point, however, as stated, I am using a ppc
architecture and am not afforded the luxury of binaries in the most up to
date versions. I know using 5.1.59 isn't the most up to date, but I was also
having issues with the most current version. I might start with the most
current b
I can't help directly with the error message (the warning seems fairly
harmless), but may I inquire why you are building MySQL instead of using one
of the prepared binaries? Compiling under OS/X can be pretty harrowing.
- michael dykman
On Sat, Oct 8, 2011 at 2:49 AM, Peter Schrock wrote:
> I
Nice one Johan, thanks for the info.
On Tue, Oct 4, 2011 at 2:17 PM, Johan De Meersman wrote:
> As noted in the title, I'm messing about a bit with InnoDB compressed
> tables. As such, I found a rather glaring hole in the Internet: how the hell
> do you turn compression off again? :-D
>
> After m
Hi,
On 28-8-2011 4:08, shawn wilson wrote:
On Sat, Aug 27, 2011 at 17:33, Arthur Fuller wrote:
I agree 110%. It is completely pointless to index a column with that amount
of NULLs. In practical fact I would go further: what is the point of a
NULLable column?
A NULL 'value' is special in most
On Sat, Aug 27, 2011 at 17:33, Arthur Fuller wrote:
> I agree 110%. It is completely pointless to index a column with that amount
> of NULLs. In practical fact I would go further: what is the point of a
> NULLable column? I try to design my tables such that every column is NOT
> NULL. In practice
It is a general rule that indexes for columns with low cardinality are not
worth it, often making queries more expensive than they would be without
said index. binary columns all suffer from this.
- michael dykman
On Sat, Aug 27, 2011 at 4:52 PM, Dave Dyer wrote:
>
> The "innocuous change" w
I agree 110%. It is completely pointless to index a column with that amount
of NULLs. In practical fact I would go further: what is the point of a
NULLable column? I try to design my tables such that every column is NOT
NULL. In practice this is not realistic, but I try to adhere to this
principle
Hi,
On 27-8-2011 22:52, Dave Dyer wrote:
The "innocuous change" was to add an index for "is_robot" which is true
for 6 out of 20,000 records and null for the rest.
Not useful to add an index for that. I also wonder why the value is null
(meaning: unknown, not certain) for almost all records.
Hi,
On 27-8-2011 1:28, Dave Dyer wrote:
Can you post the EXPLAIN EXTENDED output for your before and after queries?
also, have you recently run an ANALYZE TABLE on the tables?
What was the result of ANALYZE TABLE?
What is the engine of the tables involved?
// before
Used keys:
p2.NULL,
>
>
>Can you post the EXPLAIN EXTENDED output for your before and after queries?
>also, have you recently run an ANALYZE TABLE on the tables?
// before
mysql> explain extended select
p1.player_name,g.score1,g.time1,g.color1,p2.player_name,g.score2,g.time2,g.color2,g.gamename,gmtdate
-> f
In the last episode (Aug 26), Dave Dyer said:
> This is a cautionary tale - adding indexes is not always helpful or
> harmless. I recently added an index to the "players" table to optimize a
> common query, and as a consequence this other query flipped from innocuous
> to something that takes infi
On Thu, March 31, 2011 12:33, mos wrote:
> At 11:20 AM 3/31/2011, you wrote:
>>At 07:29 AM 3/31/2011, you wrote:
>>>Thanks for your insight! But I'm still worried about the performance of
>>>IN ( big list of values ). Can you tell me how it is implemented?
>>>
>>>Suppose I have SELECT a FROM b WHER
At 11:20 AM 3/31/2011, you wrote:
At 07:29 AM 3/31/2011, you wrote:
Thanks for your insight! But I'm still worried about the performance of
IN ( big list of values ). Can you tell me how it is implemented?
Suppose I have SELECT a FROM b WHERE c IN (1, 4, 5, 117, 118, 119, ...,
387945)
1) If
- Original Message -
> From: "mos"
>
> The IN() clause is very inefficient because MySQL will NOT use the
> index.
> It will have to traverse the entire table looking for these values.
Has that still not been remedied ?
> It will get the information from the index and not have to acce
At 07:29 AM 3/31/2011, you wrote:
Thanks for your insight! But I'm still worried about the performance of IN
( big list of values ). Can you tell me how it is implemented?
Suppose I have SELECT a FROM b WHERE c IN (1, 4, 5, 117, 118, 119, ...,
387945)
1) If I put 200 values there, does it do
- Original Message -
> From: "Gregory Magarshak"
> I am guessing that the MySQL indexes map indexed fields (fb_uid) to the
> primary key (id) so I wouldn't have to touch the disk. Am I right
> about that?
Correct for InnoDB, but MyISAM maps every index straight onto records. That's
why
By the way, sorry ... I wanted to clarify one thing:
I am trying to FILTER by the unique index (fb_uid) in this case, but
JOIN on the primary key (id) and I don't need to use any other fields. I
am guessing that the MySQL indexes map indexed fields (fb_uid) to the
primary key (id) so I wouldn'
Thanks for your insight! But I'm still worried about the performance of
IN ( big list of values ). Can you tell me how it is implemented?
Suppose I have SELECT a FROM b WHERE c IN (1, 4, 5, 117, 118, 119, ...,
387945)
1) If I put 200 values there, does it do 200 individual SELECTs
internally
Hi Gregory,
Are you sure you'd like to do this using MySQL? What would happen if you
start using sharding?
Maybe you could consider using a stack (stored in a tool like Redis?).
Whenever some user adds some item, you add primary key of the new item
to the "network updates" stack of each frie
> Why not optimize the IN ( ... ) to do the same type of thing?
If the argument to IN() is a list of values, it'll be OK. If it's a
SELECT, in 5.0 it will be slower than molasses (see "The unbearable
slowness of IN()" at http://www.artfulsoftware.com/queries.php.
> I always tried to avoid joi
Yes, this would be fine. But often, the list of friends is obtained from
a social network like facebook, and is not stored internally. Basically,
I obtain the friend list in a request to facebook, and then see which of
those users have created things. So would I have to create a temporary
table
> How can I quickly find all the articles written by this user's
friends, and not just random articles?
Taking the simplest possible case, with table friends(userID,friendID)
where each friendID refers to a userID in another row, the friends of
userID u are ...
select friendID from user wher
Hi zhongtao,
thank you for reporting this bug. It has been filed as
http://bugs.mysql.com/bug.php?id=60279
Regards,
Roy
On 24.02.11 08.08, tanzhongt wrote:
create table t1(a int);
create table t2(b int);
PREPAREstmt FROM "select sum(b) from t2 group by b having b in (select b from
t1
Sorry...
One small correction to my above post..
'FLUSH TABLES' should be issued between steps 8 and 9.
My 200+ million record table completed in 71 minutes.
-Hank
mysql; query;
Would a compound index on both startnum and endnum be a better choice?
JW
On Tuesday, November 9, 2010, Aveek Misra wrote:
> Probably indexes need to be rebuilt using myisamchk after you changed the
> data type of the index columns. Apart from that I can't see why your query is
> not using the
On 11/8/2010 10:47 PM, wroxdb wrote:
> Hello,
>
> I have a query below:
>
> mysql> select * from ip_test where 3061579775 between startNum and endNum;
> +++-+--+--++
> | startNum | endNum | country | province | city | isp|
> +
Probably indexes need to be rebuilt using myisamchk after you changed the data
type of the index columns. Apart from that I can't see why your query is not
using the indexes. Is it possible that the cardinality of the column values is
so low that indexes are not being used? You could try and run
Thanks for the idea.
I have changed the datatype to bigint, the result is not changed.
mysql> desc select * from ip_test where startNum <= 3061579775 and
endNum >= 3061579775;
++-+-+--+-+--+-+--++-+
| id | select_type
I don't see how BETWEEN is not equivalent to (startNum <= and endNum >=). Of
course please try and let us know if that resolves the issue. But if it
doesn't, I suspect it is because the indexes are created on columns which are
floating point data type. That's because floating point numbers are a
在 2010年11月9日 下午3:51，Johan De Meersman 写道：
> Indexes typically only work on the left-hand-side. Rewrite as
> select * from ip_test where startNum <= 3061579775 and endNum >= 3061579775;
>
Thanks.
But this seems the same case happened:
mysql> desc select * from ip_test where startNum <= 30615797
Indexes typically only work on the left-hand-side. Rewrite as
select * from ip_test where startNum <= 3061579775 and endNum >= 3061579775;
Magic will happen.
2010/11/9 wroxdb
> Hello,
>
> I have a query below:
>
> mysql> select * from ip_test where 3061579775 between startNum and endNum;
> +-
Hello,
On Mon, Mar 22, 2010 at 12:55 PM, Wm Mussatto wrote:
>>
> First, what are the table types?
MyISAM
> Did you set --lock-tables? No
> That could cause the behavior you are seeing. I get a similar result when
> I do a repair table For transaction enabled table types try
> --single-trans
On Mon, March 22, 2010 11:08, Andres Salazar wrote:
> Hello,
>
> Everytime i run a mysqldump (mysql-server-5.0.77) all the other
> legitimate queries that are ocurring at that time pretty much sleep
> and build up in the processlist untill I either stop the dump or wait
> for it finish. The moment
+2
> -Original Message-
> From: Brent Baisley [mailto:brentt...@gmail.com]
> Sent: Friday, September 04, 2009 6:21 AM
> To: AndrewJames
> Cc: mysql@lists.mysql.com
> Subject: Re: a better way, code technique?
>
> You should store the current user id in a se
, you should look at how much code is already hidden from you in those few
functions! =P
Regards,
Gavin Towey
-Original Message-
From: Brent Baisley [mailto:brentt...@gmail.com]
Sent: Friday, September 04, 2009 6:21 AM
To: AndrewJames
Cc: mysql@lists.mysql.com
Subject: Re: a better way, code
You should store the current user id in a session variable. Then you
don't have to hit the database at all.
There really is no short way of doing it. Normally you would create a
function (i.e. runQuery) that you pass the query too. Then it handles
running the query, fetching the data, error checki
>-Ursprüngliche Nachricht-
>Von: AndrewJames [mailto:andrewhu...@gmail.com]
>Gesendet: Freitag, 4. September 2009 13:35
>An: Skoric, Majk; p...@computer.org; mysql@lists.mysql.com
>Betreff: Re: AW: Re: a better way, code technique?
>
>hahah thank-you, love the respons
hahah thank-you, love the responses here. you guys are awesome..
ps, where does the %s come from?
--
From:
Sent: Friday, September 04, 2009 9:11 PM
To: ;
Subject: AW: Re: a better way, code technique?
-Ursprüngliche Nachricht-
Von
-Ursprüngliche Nachricht-
Von: Per Jessen [mailto:p...@computer.org]
Gesendet: Freitag, 4. September 2009 13:05
An: mysql@lists.mysql.com
Betreff: Re: a better way, code technique?
AndrewJames wrote:
>> is there a better way (hopefully simpler) to code this?
>>
>>
AndrewJames wrote:
> is there a better way (hopefully simpler) to code this?
>
> i want to get the user id of the logged in user to use in my next
> statement.
>
> $q1 = sprintf("SELECT uid FROM users WHERE
> users.username='$username'");
The only "improvement" I can see is:
$q1 = sprintf("S
hi martin...
thanks for the reply.. but that still generates two separate rows as well...
-Original Message-
From: Martin Gainty [mailto:mgai...@hotmail.com]
Sent: Friday, June 12, 2009 12:04 PM
To: bruce Douglas
Subject: RE: a possible group issue???
mysql> select * f
Try with GROUP_CONCAT(ScriptName)
http://dev.mysql.com/doc/refman/5.0/en/group-by-functions.html#function_group-concat
2009/6/12 bruce
> Hi...
>
> I have the following...
>
> mysql> INSERT INTO ParseScriptTBL VALUES
> -> ('auburnCourse.py',40,1,1),
> -> ('auburnFaculty.py',40,2,2),
> -> ('uof
Okay, does anyone know of a hosting site that supports 'Image::Magick'?
(the Perl package). The salesrep at AwardSpace said they didn't have it.
P.S. This is probably getting a mite off-topic. So, feel free to reply to
me off-list, if you happen to know the answer.
Thanks,
- Mark
--
MySQL Gen
-Original Message-
From: Claudio Nanni [mailto:claudio.na...@gmail.com]
Sent: maandag 20 april 2009 22:29
To: Mark
Cc: mysql@lists.mysql.com
Subject: Re: A good US Hosting Site?
> Mark wrote:
> > Yeah, but a "Maximum file size limit 500 KB," what can you do with
>
Mark wrote:
Yeah, but a "Maximum file size limit 500 KB," what can you do with that??
Your average background image is bigger! Not to mention my MySQL
really? you use background images bigger than 500kb? lucky if you get a
second visit!
mysql database of course has nothing to do with that
I would recommend PilotPig << http://www.pilotpig.net/ >>
Good service, good support, reasonably priced, and integrity to boot.
David
-Original Message-
From: Claudio Nanni [mailto:claudio.na...@gmail.com]
Sent: maandag 20 april 2009 17:22
To: Mark
Cc: mysql@lists.mysql.com
Subject: Re: A good US Hosting Site?
> Well,
>
> not a joke for free hosting.
>
> But it is, for me, by far the best hosting site
I've been using www.host45.com for some years.
linux and they've always been reliable. :-)
--
unheralded genius: "A clean desk is the sign of a dull mind. "
-
Phil Jourdan --- p...@ptahhotep.com
http://www.ptahhotep.com
http://www.
I haven't had a problem with Hostgator yet. Prices are fair and
reasonable Also I've installed web apps through their portal and on my
own and haven't had a problem yet.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?u
dio.na...@gmail.com]
> Sent: maandag 20 april 2009 10:28
> To: p...@pwilson.net
> Cc: mysql@lists.mysql.com; Cameron Rogers; step...@kionic.com
> Subject: Re: A good US Hosting Site?
>
> > www.awardspace.com
> >
> > I have both free and paid hosting and it is really r
On Sun, Apr 19, 2009 at 23:42, Cameron Rogers wrote:
> Hi everyone. I am starting my first web site. I have a temporary contract
> with godaddy but know there are better options out there. The only problem
> is, I don't know reliable sources to research which hosting program to use.
> Any reco
-Original Message-
From: Claudio Nanni [mailto:claudio.na...@gmail.com]
Sent: maandag 20 april 2009 10:28
To: p...@pwilson.net
Cc: mysql@lists.mysql.com; Cameron Rogers; step...@kionic.com
Subject: Re: A good US Hosting Site?
> www.awardspace.com
>
> I have both free and paid ho
www.awardspace.com
I have both free and paid hosting and it is really really good, it has a lot
of tools.
Claudio
2009/4/20 Pete Wilson
>
>
> http://www.kionic.com
>
> I've been a very active and heavy customer for years and very satisfied.
>
> -- Pete Wilson
> http://www.pwilson.net/
>
>
>
http://www.kionic.com
I've been a very active and heavy customer for years and very satisfied.
-- Pete Wilson
http://www.pwilson.net/
--- On Sun, 4/19/09, Cameron Rogers wrote:
> From: Cameron Rogers
> Subject: A good US Hosting Site?
> To: mysql@lists.mysql.com
> Date: Sunday, Apri
Dreamhost is decent
Sent via BlackBerry from T-Mobile
-Original Message-
From: Cameron Rogers
Date: Sun, 19 Apr 2009 20:42:27
To:
Subject: A good US Hosting Site?
Hi everyone. I am starting my first web site. I have a temporary contract
with godaddy but know there are better opti
In the last episode (Mar 26), Riccardo Michele Filippone said:
> Hello! First of all sorry for my terrible english.
>
> Well I've a big problem with ibdata1, this damn file increase its size
> constantly.
>
> I tryed to use innodb_file_per_table... but:
>
> - MySQL create a lot of ibd files fo
Hi Riccardo,
I don't think you should need any other storage engine if you need foreign
keys.
InnoDB is by far the most used, standard, transactional, foreign
key-supporting MySQL storage engine.
No other valid option comes to my mind now.
But please share your needs and let's see if I am wrong
You can't!
it is part of the datafiles of InnoDB storage engine!
and It contains important data like the information schema.
So I would rather ask you, is it abnormally growing or is it just your
feeling?
You should be more precise to have good answers,
for instance how much megabytes per minu
Thanks lakshmi
On Wed, Jan 21, 2009 at 11:53 AM, lakshmi pathi wrote:
> Hi Krishna Chandra Prajapati,
>
> >How can i customize, to make it work on debian OS
>
> After months of search finally yesterday i got debian - Lastnight i
> tested giis binary with
> debian -- yes running binary version gav
Hi Krishna Chandra Prajapati,
>How can i customize, to make it work on debian OS
After months of search finally yesterday i got debian - Lastnight i
tested giis binary with
debian -- yes running binary version gave me an Error as "Floating Exception"
Then i tried to compile it from source it wor
Thanks, I will be waiting for your reply.
On Wed, Nov 19, 2008 at 10:22 AM, lakshmi pathi <[EMAIL PROTECTED]>wrote:
> Thanks for your comments :)
>
> > How can i customize, to make it work on debian OS.
>
> It should work for all ext3 Linux distros giis tested with Fedroa
> ,Redhat and Ubun
Thanks for your comments :)
> How can i customize, to make it work on debian OS.
It should work for all ext3 Linux distros giis tested with Fedroa
,Redhat and Ubuntu ...
I haven't tried it with debianso right now,i don't how to
customize it for debian...I'll try and check
with debian an
Hi,
It's a nice tool. Working for fedora. But not for debian.
How can i customize, to make it work on debian OS.
On Mon, Nov 17, 2008 at 12:25 PM, lakshmi pathi <[EMAIL PROTECTED]>wrote:
> Hi all,
> If you are using mysql in linux with ext3 file system,then this might help.
> I have written a
Yeah, it's really a nice tool for me.
Thanks.
On Tue, Nov 18, 2008 at 5:44 AM, Saravanan <[EMAIL PROTECTED]> wrote:
> really nice tool.
>
> Thanks,
> Saravanan
>
> --- On Mon, 11/17/08, lakshmi pathi <[EMAIL PROTECTED]> wrote:
>
> From: lakshmi pathi <[EMAIL PROTECTED]>
> Subject: A tool
> To: my
really nice tool.
Thanks,
Saravanan
--- On Mon, 11/17/08, lakshmi pathi <[EMAIL PROTECTED]> wrote:
From: lakshmi pathi <[EMAIL PROTECTED]>
Subject: A tool
To: mysql@lists.mysql.com
Date: Monday, November 17, 2008, 1:25 PM
Hi all,
If you are using mysql in linux with ext3 file system,then this
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
1 - 100 of 522 matches
Mail list logo
