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
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
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 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
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
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
- 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
>
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
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
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
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
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
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,
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
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.
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
[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
> >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
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
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
> >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
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.
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
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
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
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
> >
> >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
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
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
29 matches
Mail list logo
