Saturday, January 19, 2002, 9:21:04 AM, Jeremy Zawodny wrote:
> On Fri, Jan 18, 2002 at 10:38:43AM +0200, Dmitry Alyabyev wrote:
>> Hello
>>
>> Time to time I see strange overload of MySQL on dedicated
>> server. The server is powerful enough to handle ~ 500 req/s. MySQL
>> version is 3.23.40 an
Hello all,
I've been with MySQL for approx. a month now and have asked assistance with
several things, and;
I'm overwhelmed and acknowledge MySQl and the people of the mailing lists.
Thank you.
Kind regards
Emmanuel
-
Before
I really suggest you do a little homework and read the tutorials in both
the php and mysql manuals. They are really valuable and should give you
the examples you need.
Maintainer IPPlan (https://sourceforge.net/projects/iptrack/)
sql
Gary Lefko wrote:
> Can someone writ eme an example of ge
(food for ill-working-anti-spam-filters : database,sql,query,table)
Just wanted to thank everyone who got involved in this
(at times rather heated) discussion. You've given me
quite a few pointers to think about and stuff to concider
and take up with our project manager.
Cheers mates!
Markus
-
hi 2 all!
does anybody knows an good ODBC like mysql driver for an java
application on an win2k proffessiona OS?
thanks!
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mys
Hi,
In fact I have a compound index on (mot,date,numreponse,topic), so I assume
(mot,date,numreponse) is also optimised if I correctly understand how indexs
work ;)
Anyway, I just wanted to run this query once, so it's not really my priority
to make speed faster on this particular query (moreover
On Friday 18 January 2002 17:30, you wrote:
> > We've requested a database from different companies, and specifically
> > said we wanted MySQL or PostgreSQL because of the open source angle
> > and we're a library.
> > One company offered MS SQL as the platform and said that they can later
> > on
My experience (atleast with the 3.23 series) is that full text indexing is
not worth the hassle if you have an existing HUGE database... I let mysql
run for about a day or two on a 20gb database (dont remember exactly how
many rows it had) before giving up (note this was using 3.23.39). I found on
hello!
i'm with problem when i delete something from mysql, the table overhead a
few bytes
i'm running a sql query from a php page:
if($DEl && $cid && $sid && $did) {
$d0->query("SELECT id FROM crd_favorites WHERE did='$did' AND
uid='$uid'");
if($d0->num_rows()<1) {
Hi,
Surely, the having clause is not redundant ( I misread it as > 0).
Is it not the compound index (on mot,date,numresponse) which would
make the query fast instead of three single column indexes?
Thanks,
Anvar.
At 01:40 PM 19/01/2002 -0500, you wrote:
>Anvar had some very good explanations a
Hello Monty,
Thank you for your note and feedback.
After getting excellent assistance, I'm using JDBC setMaxRows rather than
LIMIT, which gives me portability.
I'll investigate SQL_CALC_FOUND_ROW option further. I notice I would need
to first upgrade to MySQL 4.x, though and then find / work o
> The machine that is available without additional cost is a
> dual Pentium
> classic 166 with 128mb memory, 1.2G hard drive.
For a single user system for learning this will be MORE than enough. More
disk space is nice to install more optional packags in addition to the
MySQL--
that way you wi
that's no problem!
--
Zu Zhihui <[EMAIL PROTECTED]>
- Original Message -
From: "Erv Young" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, January 21, 2002 11:56 AM
Subject: MySQL system requirements
> All,
>
> I have searched the online manual in vain for mySQL system
> requi
All,
I have searched the online manual in vain for mySQL system
requirements. Can anyone give me the precise URL? Is there one?
I want to play around with converting an existing FoxPro data base (about
65mb in all tables, 55mb in the largest table) to mySQL. And learning PHP
from square 1,
> So far I have successful set up tables in mysql
> InnoDB
> with primary and foriegn keys. Unfortunately I am
> having some difficulty in getting the proper results
> as I am new to sql and databases. I would be most
> grateful if someone took a minute and explained or
> helped with the follow
>
>
> Hi!
>
> I have forwarded your questions to the MySQL public email list, so
> that other people can benefit from my answer.
>
> If you have any more questions about MySQL, please send them to
> [EMAIL PROTECTED] instead directly to a MySQL developer or MySQL
> user.
>
> If you want to ha
> > So far I have successful set up tables in mysql
> > InnoDB
> > with primary and foriegn keys. Unfortunately I am
> > having some difficulty in getting the proper
> results
> > as I am new to sql and databases. I would be most
> > grateful if someone took a minute and explained or
> > helped
Pretty much as the subject states, I am not a member of this list yet, as I
am sure my mail server cant handle the amont of messeges that come through
so please reply directly at [EMAIL PROTECTED]
I need to limit the max size of a database in MySql that is created for a
user on a
few levels...
A couple of reasons why they might go this route is, one they might already have
something similar to your needs based on mssql that they can customize quick and easy
for a fast delivery ( hows their time table & their bid in comparison ). Or two they
just don't have the mysql expertise in whic
Okay, does anyone know how long this will take?
22 million records, fulltext index on a single field, first 40 chars.
record length 768 chars, variable.
It's been running for 2 days, processlist quotes time at around 10.
Index file still growing occasionally, up to 3Gb.
Should I let it conti
Perhaps you read the wrong part(s) of the manual:
http://www.mysql.com/doc/R/e/Reserved_words.html
On Sun, 20 Jan 2002 12:18:45 -0800 (PST), Dominique Plante wrote:
>I hope you can answer the following question. I am
>wondering how to create a table with a column named
>key. I have RTFMed an
Hi!
> "Emmanuel" == Emmanuel van der Meulen <[EMAIL PROTECTED]> writes:
Emmanuel> Hello Mark,
Emmanuel> Thank you for the note and feedback. BTW, it was not over a network. Both
Emmanuel> on local PC. So all the time went into building the resultset in memory.
Emmanuel> I'm surprised at
Hi!
I have forwarded your questions to the MySQL public email list, so
that other people can benefit from my answer.
If you have any more questions about MySQL, please send them to
[EMAIL PROTECTED] instead directly to a MySQL developer or MySQL
user.
If you want to have guaranteed MySQL suppo
Soory the last message wasn't explicit enough:
I'm writing an application in VB6 (SP5/ADO 2.1) using MyODBC 2.50.39. When
selecting more then 9 fields out of a specific table I get:
Runtime Error -2147467259 (80004005), ODBC Driver Manager: Function
Sequence Error.
It happens on the .Movefirst
I'm writing an application in VB6 (SP5/ADO 2.1) using MyODBC 2.50.39. When
selecting more then 9 fields out of a specific table I get:
Runtime Error -2147467259 (80004005), ODBC Driver Manager: Function
Sequence Error.
Can someone give me a clue or a direction where to look for.
Thanks in adva
Dominique,
On Sun, Jan 20, 2002 at 12:18:45PM -0800, Dominique Plante wrote:
> The following fails (after selecting a database):
>
> mysql> create table test (key varchar(255), value
> varchar(255));
>
You should be able to do this by using back-quotes around
the column name:
create table tes
I hope you can answer the following question. I am
wondering how to create a table with a column named
key. I have RTFMed and that didn't help. I'm using
3.23.47-max-debug.
The following fails (after selecting a database):
mysql> create table test (key varchar(255), value
varchar(255));
Wit
On Sun, Jan 20, 2002 at 01:08:04PM +0100, Henning Sprang wrote:
> >
> > Try using "localhost" instead of "my".local.hostname". Since you
> > didn't use the `-g' option for SSH, I wouldn't expect what you're
> > doing to work. See the SSH docs for why.
>
> hmm, that won't work at all, as there i
I have been reading 'MySQL' by Paul DuBois for some time now and have finally managed
to de-bug (or so I thought) the script called "edit_member.php" on page 378 - 385.
When I view the page in a browser I get the 'Member ID' & 'Password' fields displayed
as expected, however, nothing works even
Hi,
I have a while loop pulling information into an editing form. It labels
variables dynamically as so:
name="schooling
Where $counter is augmented each time through the loop. In order to then
insert these, I need to do an insert of $schooling$counter. Below is the
statement I've been trying to
I believe the correct command is LOCK TABLES with an 'S' at the end.
your quoted command says LOCK TABLE without the 'S'.
HTH
At 04:15 PM 1/20/2002 +, Arne Mueller wrote:
>Jeremy Zawodny wrote:
>>
>> On Sun, Jan 20, 2002 at 03:46:14AM +, Arne Mueller wrote:
>> > Hi All,
>> >
>> > I've j
Hi All,
Mysql-4.0.1-alpha crashes when updating privileges.
mysql> select * from user where user = 'bmm';
++--+--+-+-+-+-+-+---+-+---+--+---+---
Rownum exists of a sort with the limit clause.
Rowid does not exist all at.
Tony
- Original Message -
From: "Emmanuel van der Meulen" <[EMAIL PROTECTED]>
To: "MySQL Java List" <[EMAIL PROTECTED]>; "MySQL General List"
<[EMAIL PROTECTED]>; "Nick" <[EMAIL PROTECTED]>
Sent: Sunday, January
Jeremy Zawodny wrote:
>
> On Sun, Jan 20, 2002 at 03:46:14AM +, Arne Mueller wrote:
> > Hi All,
> >
> > I've just migrated from mysql-3.12 to 4.0.1 and despite a mysqld crash a
> > few minutes ago there is a strange problem I've never had in mysql
> > version 3:
> >
> > mysql> lock table .dev
Dear sir,
I used mysql-4.0.1 running on Solaris-2.5.1 and
compile with Gcc-2.95.3. (package from www.sunfreeware.com)
I used command below.
CC=gcc CFLAGS="-O3" \
CXX=gcc CXXFLAGS="-O3 -felide-constructors -fno-exceptions -fno-rtti" \
./configure --prefix=/usr/local/mysql --with-low-memory --e
Hello Dave,
Thank you. This works.
Kind regards
Emmanuel
> -Original Message-
> From: Adrian Monea [mailto:[EMAIL PROTECTED]]
> Sent: 20 January 2002 15:08
> To: 'Emmanuel van der Meulen'
> Cc: [EMAIL PROTECTED]
> Subject: RE: Understanding throughput with JDBC
>
>
> Why not try to u
Hello Nick,
Does ROWNUM exist in MySQL?
Kind reagrds
Emmanuel
> -Original Message-
> From: Nick [mailto:[EMAIL PROTECTED]]
> Sent: 19 January 2002 20:41
> To: Shankar Unni
> Cc: [EMAIL PROTECTED]
> Subject: [OT] Re: Understanding throughput with JDBC
>
>
>
> > With Oracle, the *only*
Jeremy Zawodny wrote:
> On Sun, Jan 20, 2002 at 12:01:29AM +0100, Henning Sprang wrote:
>> [...]
>>so fra , so good. Then doing
>>
>># ssh [EMAIL PROTECTED] -L 8:localhost:3306
>>
>>
>>and connecting to port 8 on my machine with telnet gives me
>>something like
>>
>>Trying ::1...
>>Conne
Hello Mark,
Thank you for the note and feedback. BTW, it was not over a network. Both
on local PC. So all the time went into building the resultset in memory.
I'm surprised at the time that takes.
Further to why I'm desirous to do this query, twofold. One I get the record
count (rows in the
Hello Mark,
Thank you for the note and feedback. BTW, it was not over a network. Both
on local PC. So all the time went into building the resultset in memory.
I'm surprised at the time that takes.
Further to why I'm desirous to do this query, twofold. One I get the record
count (rows in the
- Original Message -
From: "Richard Burgmann" <[EMAIL PROTECTED]>
To: "Markus Lervik" <[EMAIL PROTECTED]>
Sent: Sunday, January 20, 2002 9:53 PM
Subject: Re: Porting from MS SQL to MySQL
> Hi Markus,
> I'm an IT Consultant by trade and have been involved in lots of green
fields
> projec
Hello Jeremy,
Thank you for keeping correspondence.
Kind regards
Emmanuel
> -Original Message-
> From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]]
> Sent: 20 January 2002 08:22
> To: Emmanuel van der Meulen
> Cc: [EMAIL PROTECTED]
> Subject: Re: Version 4 Schedule RE: Roadmap
>
>
> On Sat
On Sun, Jan 20, 2002 at 12:01:29AM +0100, Henning Sprang wrote:
>
> Hy all,
>
> i am just trying to tunnel a mysql client connection via ssh. i am
> behind a firewall that doesn't let mysql connections through to the
> outer world.
>
> But i can do ssh to the host i want connect to. Tunneling ht
Dear Sirs and Madams,
I have installed mysqlgui-static on my PC. Please let me know how to start it, so that
I can use it.
2. Have you or anyone else developed any utility to make it easy to populate the
tables? The default method is too cumbersome. If so, kindly direct me to the links etc.
3. O
44 matches
Mail list logo
