Hello everyone,
I recently decided to perform an experiment. I was using Java to do
string comparison on sometimes large data sets (this would sometimes
take days). A friend of mine at work suggested that I use MySQL's full
text searching. I quickly made the change over and I've found that i
Which mysql username did you use to log in? I've not used mysql on Windows,
but I expect that if you simply ran mysqlshow on a new install, you'd
connect as the anonymous user. The anonymous user only has rights to the
test db, so that's all you'd see. Try
mysqlshow -u root
or, if you've s
> >
> >Ah, it's not part of the mysqld command itself. Got it.
>
> Right. It's a process-control aspect of how the shell itself works.
And it's also rather confusing! *s* I really thought it was just another part
of the command, not a structure like a pipe or a redirector.
Oh, these Windows
At 18:29 -0500 8/1/04, Whil Hentzen wrote:
> >I've been looking through the doc, the --help file, and the messages in
> the archives, and I can't find a reference to what this & character
> _means_.
>
The "&" tells bash to fork the process into the background so you get
your console / xterm
jeremy...
hey.. how's yahoo!! anyway, i know you should be able to do this... do you
have any examples of code or can you point me to an example that
demonstrates how to do it...
i've been trying to accomplish this with perl for 2-3 days now with no
luck.. so i know there must be something i'm mi
On Sun, Aug 01, 2004 at 01:42:24PM +0200, Marc wrote:
> I use Mysql with JBOSS as applicationserver.
>
> i have strange response-time differences, which i can't explain.
>
> 1) after reboot the computer, it takes about 300ms to read 12 entities (cmp,
> read ahead, 2 rows each entity) One entity i
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
At 12:55 PM 8/1/2004, Keith Thompson wrote:
Hey Mike,
Thanks again for your suggestions.
I understand (and agree) with your comments about a clean shutdown.
I'm always careful to do that. In this case, the mysql server has
only been shutdown a couple times and it was a clean shutdown in
each case.
> >I've been looking through the doc, the --help file, and the messages in
> > the archives, and I can't find a reference to what this & character
> > _means_.
> >
> The "&" tells bash to fork the process into the background so you get
> your console / xterm back. If you don't use the "&" at the e
hi...
within the linux/unix world, the '&' at the end of a shell/command normally
has meant to run the command as a background process
for further information, search google for '& background process linux'
etc...
-bruce
-Original Message-
From: Whil Hentzen [mailto:[EMAIL PROTECTE
Whil Hentzen wrote:
faild and locked up. I'm hoping it is no. 1 that happened. if so,
how do I get a command prompt after I start the server?
Did you end the command with a & character?
I've been looking through the doc, the --help file, and the messages in the
archives, and I can't fi
> >faild and locked up. I'm hoping it is no. 1 that happened. if so,
> >how do I get a command prompt after I start the server?
>
> Did you end the command with a & character?
I've been looking through the doc, the --help file, and the messages in the
archives, and I can't find a reference to wha
[note: This discussion went on off-list, but I thought the info might
be useful in list context, so I am "reposting" it to the list. Sorry
about the lack of individual messages. I wish gmail had an option to
automatically add an address to a reply when you are replying to a
message that has been
That won't work either. You cannot use an aggregate function in the WHERE
clause. The purpose of the WHERE clause is to determine which rows to look
at, but you won't know the MIN(price) until after you've looked at them.
You can use aggregate functions in the HAVING clause, but that filters r
Hey Mike,
Thanks again for your suggestions.
I understand (and agree) with your comments about a clean shutdown.
I'm always careful to do that. In this case, the mysql server has
only been shutdown a couple times and it was a clean shutdown in
each case.
You suggest running table checks daily.
I just set up another reeplication slave for one of my servers - it's not
something new to me. I'm using 4.1.3-beta on a new server which will
eventually take over as the master. I set up a server id, did change
master to... and started the slave - but the slave seems to perpetually stay
in a st
I've just downloaded 4.0.20 for windows
Installed on the D: drive. Set up an .ini pointing at D: drive
Ran D:\mysql\bin\mysqld
When I then ran mysqlshow I only had the test database, not the mysql database as the
documentation said I should.
I then deleted everything and installed again,
David Griffiths wrote:
Really? I had no idea. I am pretty sure that only Day will have a range.
Our index is currently, (yearmonth, day, stem_base), so I need to drop
and recreate it.
I think part of the slowness is the size of the table as well. We have
data going back years in there. I am thi
SELECT offerid, resellerid, price FROM A WHERE pricece = MIN(price) GROUP BY
resellerid;
- Original Message -
From: "Michael Stassen" <[EMAIL PROTECTED]>
To: "Daniel Lahey" <[EMAIL PROTECTED]>
Cc: "Haitao Jiang" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, July 30, 2004 7:33 PM
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 already being accomplished that you might provide???
as far as i can
Patrick Connolly wrote:
Somewhere about Sat, 31-Jul-2004 at 11:17AM -0400 (give or take), Michael Stassen
wrote:
|> With LOCAL, the *client* reads the file on the client's machine.
|> Without LOCAL, the *server* reeads the file on the server's
|> machine. Even though the client and server machine
At 01:21 AM 8/1/2004, Keith Thompson wrote:
Thanks Mike,
I've always ignored CHECK TABLE because I always thought it was
just for MyISAM.
I ran CHECK TABLE. It told me that my table was corrupt. I then
dumped the table with mysqldump and recreated it. After that
CHECK TABLE said it was OK (and i
- Original Message -
From: "John Berman" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, August 01, 2004 7:27 AM
Subject: Connectiing
> Hi
>
> Sorry if I'm off topic but I am a touch desperate
>
>
> We make use of a mysql 4.x hosted by a third party and we use ASP to
access
>
Hi
Sorry if I'm off topic but I am a touch desperate
We make use of a mysql 4.x hosted by a third party and we use ASP to access
this data
Our Connection string looks like this:
xDb_Conn_Str="DRIVER=org.gjt.mm.mysql.Driver;URL={jdbc:mysql://xxx/x
xx};uid=xxx;pwd=xx;"
This
I use Mysql with JBOSS as applicationserver.
i have strange response-time differences, which i can't explain.
1) after reboot the computer, it takes about 300ms to read 12 entities (cmp,
read ahead, 2 rows each entity) One entity is accessed by primary key, the
others by
foreign key.
2) when i r
Hi Sergei,
I did come from 4.0.17 to 4.1.3 with a complete dump/reload.
Then, all changes after that forward came via replication.
I didn't read anything about corruption problems as a replication
slave.
-keith
>Hi!
>On Aug 01, Keith Thompson wrote:
>> Thanks Mike,
>>
>> I've always ignored CH
Hi!
On Aug 01, Keith Thompson wrote:
> Thanks Mike,
>
> I've always ignored CHECK TABLE because I always thought it was
> just for MyISAM.
>
> Then, I decided to run CHECK TABLE on all my tables (which for the
> ones with 125 million rows will probably be running for a while).
> The problem now
Hi!
On Aug 01, Helge Jung wrote:
> >Description:
> When I start up my fresh compiled mysqld it crashes immediately, the
> error log file says:
It was reported just a few hours ago at bugs.mysql.com
(which is the recommended way to report bugs, by the way :)
you may follow the progress using
htt
Somewhere about Sat, 31-Jul-2004 at 11:17AM -0400 (give or take), Michael Stassen
wrote:
|> With LOCAL, the *client* reads the file on the client's machine.
|> Without LOCAL, the *server* reeads the file on the server's
|> machine. Even though the client and server machines are the same
|> in yo
29 matches
Mail list logo
