Hello Heikki,
Tuesday, March 13, 2001, 1:31:04 AM, you wrote:
HT> Joshua,
>>I hope you can also use MySQL dump, in which case, you don't have to shut
>>down, right?
HT> yes, you can use mysqldump without shutting down. It did not come to my
HT> mind that actually mysqldump is a kind of online
Dear all,
I have downloaded the package mysql-3.23.34-pc-linux-gnu-i686.tar.gz
from www.mysql.com,but I can't gunzip it on linux , the following is error
message:
[test@linux owen]$ gunzip -c mysql-3.23.34-pc-linux-gnu-i686.tar.gz|tar -xvf
-
mysql-3.23.34-pc-linux-gnu-i686/
mysql-3.23.34-p
Greetings!
I am trying to compile MySQL in RedHat 6.0. what I did are:
tar -xvzf mysql-3.23.33.tar.gz
cd mysql-3.23.33
./configure --prefix=/usr/local/mysql
then it startx to work and inerrupt and says
testing gcc working: no
configure: error: installation or configure problem: c compiler can not
Yes, either that or plain text files that Informix dumps and MySQL reads in.
Jan
Curtis Maurand wrote:
>
> Perl DBI with the Mysql and the Informix drivers installed.
>
> Curtis
>
> - Original Message -
> From: "MArk Williams" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Mond
Hi,
> Ok, I'm out of ideas. The additional index should have sped things up,
not
> slowed them down. I've got some tables with 26,000 rows in it and I do 4
> joins (using a WHERE clause) with smaller tables without a hitch.
>
> Sorry I can't help.
But thanks a lot for trying. :) And thanks als
This is not what I meant.
I have a mysql DB running. I have a remote informix DB running.
I have DBI/DBD informix/mysql all setup and working.
I can access the remote informix database through perl scripts.
BUT what I want is my scripts to ONLY access the mysql DB, but to
somehow get the mysql DB
My OS is BSDI 4.1, and mysql server is 3.23.33
There happened a strange thing when I use mysql client to connect server over
network.
The first time it's normal.the second times it return an error "Lost connection to
MySQL server during query" when I connect server subsequently.
The third t
Hi,
I trying to install mysql from source on a RedHat 7 box,
mysql version 3.23.34a
output from uname -a: Linux webserver.tmxnm.cxm 2.2.16-22smp #1 SMP Tue Aug
22 16:39:21 EDT 2000 i686 unknown
Hardware is Compaq 5000 professional workstation
Compiler is gcc-2.96-54
When I run ./configure --
Hello,
if there is a MYSQL developer member (or guru), I would
like to ask if there is possible that another query modify
a field between the detection of a target row and the changes
made to it, by an update query.
Let me explain myself a little: suppose we have an update query, like
this:
UP
Hello,
Synopsis: Impossible to install DBD::mysql perl driver
Release: MySQL-3.22.32-5mdk.i386.rpm
Environment: Standard Linux Mandrake 7.0 distrib.
Description :
I have fully installed DBI.pm perl package with cpan command : "perl -MCPAN -e shell"
No problem.
When i connect manual
Hello Heikki,
Monday, March 12, 2001, 11:51:54 PM, you wrote:
HT> Hi Peter,
HT> and sorry that this response to your Big Mail comes some 12 days late.
HT> We have put together the release 3.23.34a and that has occupied
HT> my mind.
No Problem. At least the progress is going :) I'll try to test
>Description:
We are trying to run some fairly complex joins over large tables. The queries
can take up to a day or more to finish. We feel that there must be something
wrong with either the table structure, or the join query itself. There are two
tables involved, and the join requires each of the
I have tree columns: name,surname,age.
how can I order this columns first by age, then by name , at the and by
surname. like that:
NAMESURNAME AGE
zanna bond10
barbara astic 15
barbara bard40
barbara zard
That's what mysqldump does. Try using a SELECT statement with an outfile.
Check the manual, chapter 7, the part about SELECT for details.
Cal
http://www.calevans.com
-Original Message-
From: Gilles Dumangin [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 13, 2001 1:42 AM
To: [EMAIL PRO
Select * from table order by age, name, surname
Select * from table order by age, name, surname where age>11
Cal
http://www.calevans.com
-Original Message-
From: Rino Nucara [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 13, 2001 5:18 AM
To: MySQL mailing list
Subject: Help for a quit
Daren Cotter writes:
> Sorry to post AGAIN, but I have new info. I was monitoring the Error Log,
> and when I run the query that crashes MySQL, I get the following error:
>
>
> mysqld got signal 11;
> The manual section 'Debugging a MySQL server' tells you how to use a
> stack trace and/o
Hi!
Which table formats would you advise (Berkley DB, Gemini or Innobase) for
medium size web project. Need to add transactions over multiple tables in 2
places.
Thanks.
-- Oleh Khoma
[Email: [EMAIL PROTECTED]] [ICQ: 55191139]
[FIDO: 2:462/90.80][BrainBench: 504369]
-
Hi,
We're trying to "unify" the authentication system in our Linux.
PAM is the obvious solution and we thought LDAP will do well in
storing users attributes (including userids and passwds)
The only annoyance is that MySQL doesn't support PAM but Radius
instead... why Radius? Is there any other
If you're looking for PAM modules that authenticate from a mySQL
database, I know they exist - although I can't comment on them as I
haven't used them before.
regards,
P
On Tue, 13 Mar 2001, Roberto Meyer wrote:
> Hi,
>
> We're trying to "unify" the authentication system in our Linux.
>
> PA
"P.Peti" wrote:
>
> Hello,
>
> Thanx for the answers, I think I've got the point now. I
> have one more doubt though. You described me that this
> whole thing with the comparison not working with NULL
> values is obvious. Why did it work in 3.22.25 then?
>
> Thank you for the answers so far.
>
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of
> Martin Moss
> Sent: Wednesday 07 June 2000 16:03
> To: Perl-Win32-Users Mailing List; [EMAIL PROTECTED]
> Subject: Corruption of Database
>
>
> All,
>
> I have a problem with a mysql database.
>
Maybe you FTPed the file in text mode instead of binary?
[EMAIL PROTECTED] wrote:
>
> Dear all,
> I have downloaded the package mysql-3.23.34-pc-linux-gnu-i686.tar.gz
> from www.mysql.com,but I can't gunzip it on linux , the following is error
> message:
> [test@linux owen]$ gunzip -c my
I've got a nasty problem with my mysql-database.
On the following INSERT (and on others too and on some SELECTs) i get
the following error.
mysql> INSERT INTO hyperseek_keys SET
keyword='meiner_asiatinne',id='37647438380',price='0.01',xfactor='7.50';
ERROR 1030: Got error -1 from table handler
I
No.
MArk Williams wrote:
>
> This is not what I meant.
> I have a mysql DB running. I have a remote informix DB running.
> I have DBI/DBD informix/mysql all setup and working.
> I can access the remote informix database through perl scripts.
> BUT what I want is my scripts to ONLY access the mys
You can NOT use gcc-2.96.
The manual is clear on this, as are dozens of posts in the archives.
Kevin Price-Ward wrote:
>
> Hi,
>
> I trying to install mysql from source on a RedHat 7 box,
>
> mysql version 3.23.34a
>
> output from uname -a: Linux webserver.tmxnm.cxm 2.2.16-22smp #1 SMP Tue A
Hi,
PS> If you're looking for PAM modules that authenticate from a mySQL
PS> database, I know they exist - although I can't comment on them as I
PS> haven't used them before.
Nop. I'd like MySQL to authenticate their users through PAM.
I want to put userids and passwds on my LDAP server. It w
No, Daniel. This operation is atomic ( can not be separated into smaller
parts ).
This is the correct way to do updates without user locking.
The update thread will automatically lock the file during the update
so no other process can modify the data.
Daniel B I wrote:
>
> Hello,
> if there is
On Tue, Mar 13, 2001 at 12:00:57AM +0200, Heikki Tuuri wrote:
> >om scalar to scalar or to void type.
> >cc: "os0thread.c", line 69: error 1554: Indirection must be through a pointer.
> >cc: "os0thread.c", line 69: warning 563: Argument #2 is not the correct type.
> >cc: "os0thread.c", line 69: er
I've got a nasty problem with my mysql-database.
On the following INSERT (and on others too and on some SELECTs) i get
the following error.
mysql> INSERT INTO hyperseek_keys SET
keyword='meiner_asiatinne',id='37647438380',price='0.01',xfactor='7.50';
ERROR 1030: Got error -1 from table handler
I
The valid range for an 'int' data type (your "id" column) is -2147483648 to
2147483647. The value you are attempting to set (37647438380) is not within this
range.
--Greg Johnson
-Original Message-
From: Andreas Gietl [mailto:[EMAIL PROTECTED]]
on 3/13/01 12:41 AM, Gilles Dumangin at [EMAIL PROTECTED] wrote:
> I would like to extract the contents of a database to use it in a ASCII
> format. It is a addresses database and I want to use it in Excel. I have
> tried Mysqldump but it gives me the CREATE and INSERT statements all the
> time.
I do a mysql query as below
update table set something = something where onecolumn in ("a","b",etc);
It works well when the array ("a","b",etc) after in is less than 1000, but
when the array ("a","b",etc) contains more than 1000 element, it seem the
command doesn't work. I am not sure whether th
Hello!
I'm a beginner of the wonderful world of MySQL :-)
I'm planning to deploy MySQL for a project of my company but I've some
concern about real size limit of BLOBs.
situation: MySQL 3.23.33 on FreeBSD 4.2-stable, clients are near always
Win machines with MyODBC and proprietary software.
Does your query exceed the maximum packet size?
Xinkun Wang wrote:
>
> I do a mysql query as below
>
> update table set something = something where onecolumn in ("a","b",etc);
>
> It works well when the array ("a","b",etc) after in is less than 1000, but
> when the array ("a","b",etc) contains
In the last episode (Mar 13), Peter Zaitsev said:
> Well guys mysqldump have one serious problem - the speed.
>
> The backup speed is quite upsetting and loads system much, but the
> worst thing is recovery speed.
> In my case the data is added in realtime - most queries are inserts
> which utili
I've gathered more data on my problem here. We have recently made a few DNS
changes that I think have hosed mysql. See the error message below:
DBI->connect failed: Unknown MySQL Server Host 'myserver.com' (2) at
/home/httpd/test/stage2/cgi-bin/send_requests.cgi line 28
Can't call method "prepare
when you enter the unix command
hostname
what do you get ?
This had better be resolvable with your DNS.
Maybe you forgot to fix your hostname when the domain was changed.
"Weber, Jeff" wrote:
>
> I've gathered more data on my problem here. We have recently made a few DNS
> changes that I thin
>Description:
After completing the configure step, which went fine (using
the options recommended in the guide), the installation stopped when
using gnumake.
>How-To-Repeat:
The problem was traced to making the client components,
in particular mysql. The problem was that c++ com
If I pull the hostname, I don't get 'myserver.com', but this server never
was called 'myserver.com' to begin with.
The 'myserver.com' domain was expired for the last year or so, but I never
removed it from the DNS records until recently. So really, for the last
year, 'myserver.com' never refered
Lutz,
I think you have found the problem.
>Ok, let's try to narrow things down: I have switched to GCC for the time
>being and got a similar compile error:
>gcc -DHAVE_CONFIG_H -I. -I. -I.. -I../../include -I../include-O6 -DDBUG_OFF
>-DHPUX -I/opt/dce/include -DHAVE_BROKEN_SNPRINTF -c os0th
On Tue, Mar 13, 2001 at 06:42:19PM +0200, Heikki Tuuri wrote:
> >Ok, let's try to narrow things down: I have switched to GCC for the time
> >being and got a similar compile error:
> >gcc -DHAVE_CONFIG_H -I. -I. -I.. -I../../include -I../include-O6 -DDBUG_OFF
> >-DHPUX -I/opt/dce/include -DHAV
Hi,
> I read on Paul DuBois' excellent book that longblob are 2^32-1 wide,
> but actually the communication _protocol_ between clients and server
> limits to 24Mb the dimension of a single record.
>
> What workarounds could I use ?
A simple workaround is that you store the binary data as files o
If you block user access during the recovery, would it be faster w/o the
indexes and then add the indexes through alter table and then let the
user's in. This is the recommended solution for recovery for DB2. If you
have to do a recovery, its normally assumed that the database is locked
for s
Since upgrading to mysql 3.23 and using MYIAM tables, I'm experiencing a
problem which is becoming more and more common. When conducting queries
which take more than about 15 seconds to run (ie mass deletes, mysqldumps,
check table etc), I end up with corrupt tables. The database server is the
bac
I noticed that 'EXPLAIN TABLE' no longer shows the Privileges column, which
I think is a good thing as I'm never interested in it and it makes my
screen hard to read because it causes wrapping.
...but, mysqlshow still shows the Privileges column.
Is there any plan to make these two very simila
When a text with an apostrophe in it has a \' in it. How can I fix this?
example
randy's is stored in the DB as randy\'s
thanks
Randy
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Randy Johnson wrote:
>
> When a text with an apostrophe in it has a \' in it. How can I fix this?
>
> example
>
> randy's is stored in the DB as randy\'s
>
> thanks
>
> Randy
If you just want to fix that one instance just do
update set = 'randy\'s' where
-
I'm not sure if anyone cares but... here's my final post on this topic.
I believe my signal 11 problem was due to me installing the 3.23.34 rpms
from mysql.com on top of my Redhat 7.0 system. I had heard that the RPMs
on mysql.com are Redhat 6.2 based and thus may be expecting different
dynam
Friends.
people out in here are very afraid , when they hear Mysql does not support foreign
keys.
It really become difficult , why foreign keys are not enforced by mysql.
I wish , there was another way.
Anyways, can u please tell me does our favourite database support composite foreign
key..
Just realized, the query I sent you will remove ALL instances of \ inside
the field you specify, if that isn't your intent, and you only want to
remove \' then do this:
UPDATE tablename SET fieldname = REPLACE(fieldname,'\\\'','\'');
-
Hi,
I am trying to read the field types (as well as 1 row of data and the
field names), but I cannot seem to manage it. Any ideas on how?
M.
$sth = $dbh->prepare("SELECT * FROM $sqlTable WHERE id = $id");
$sth->execute;
my $hash_ref= $sth->fetchrow_hashref;
my @staffFields = keys(%{$hash_
Two things here.
First off, we had this problem spring up on us, and I think I may know why
it's doing it to you. If your using PHP, the more recent version
automatically escape out variables sent to the mysql driver. Thus randy's
is converted to randy's. HOWEVER, if you still have old code wh
Hi,
When reading field names (or a row of data) how does one read the
possible enum values, so I can put them in a drop down menu?
M.
--
He came from Econet - Oh no, I've run out of underpants :(
Home:- [EMAIL PROTECTED] http://www.wizdom.org.uk
Shadow:- [EMAIL PROTECTED] http://www
Hi!
> "Andrew" == Andrew Sitnikov <[EMAIL PROTECTED]> writes:
Andrew> Hello Michael,
Andrew> Crash with 'show variables;'
Andrew> configure:
Andrew> CC=gcc \
Andrew> CFLAGS="-O6 -fomit-frame-pointer" \
Andrew> CXX=gcc \
Andrew> CXXFLAGS="-O6 -march=i686 -fomit-frame-pointer -fno-exceptions
Remove unsubscribe
neither one of the 2 methods listed below for name remove seem to function
please remove me from this list ASAP...
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://
Lutz,
I looked at the pthread header file which is, by the way, 52000 lines long :).
It seems that pthread_attr_t and pthread_t are not pointers like in some
other Unixes, but structs of three fields:
struct {
field1; /* this is a pointer */
field2; /* a short int */
Title: Untitled
Dear Sir,
We are from Chennai, India.
We are holding one site constructed using JSP pages. We couldn't connect to
the mysql database using myodbc driver! The specified driver is not installed in
the virtual server the hosting company!
Do we have any otehr alternative?
Pleas
Try this.
http://www.microsoft.com/data/odbc/
- Original Message -
From: satish <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, March 12, 2001 8:02 AM
Subject: ODBC driver doumentation !!!
> Hello ,
>
> I am developing front end applications with backend mysql server in
>
Hi
I'm newbie in MySql. I'm trying to import an access MDB into MySql and access it with
PHP. Also have instaled MyODBC. When calling MySQLAdmin cant find a data
transformation service like MS SQL.
Any clue?
P.D. Be patient with my English.
Thanks
javier
[EMAIL PROTECTED]
this was true on php 4.01 but not on php 4.04pl1, i have to escape my
strings again. or it's some switch or conf setting i never
seen/heard/thought of...
i now use $var=addslashes($var) on php4.0.4pl1 redhat 7 where i do not have
to on a other system running php4.0.1 redhat 6.2 !
especially php
I'm getting a very strange results all of the sudden when dealing with BLOBs
in a mysql 3.23.32 on a Solaris 7 (SPARC) machine (inserts/deletes handled
with the JDBC driver from http://mmmysql.sourceforge.net/)
If I do the following:
1) Create a BDB table with a blob column:
CREATE TABLE test4(
> gnanas wrote:
>
> Dear Sir,
>
> We are from Chennai, India.
> We are holding one site constructed using JSP pages. We couldn't connect to the
>mysql database using myodbc driver! The
> specified driver is not installed in the virtual server the hosting company!
> Do we have any otehr alternat
Actually, I think it could work the other way around.
(Oops, this is off topic now.)
Informix (in version 9.2.something) has
what they call "virtual table interface"
and they provide an ODBC wrapper, I think.
So you might send your queries to Informix
and Informix could pass (parts of) them furt
select describe mytable ;
will return parseable data.
Mark Worsdall wrote:
>
> Hi,
>
> When reading field names (or a row of data) how does one read the
> possible enum values, so I can put them in a drop down menu?
>
> M.
>
> --
> He came from Econet - Oh no, I've run out of underpants :(
>
What's the SQL command to issue to list all of the tables that are contained
in a given MySQL database?
C. Duncan Hudson
Dynax Solutions, Inc.
Tel 216.292.8203
FAX 216.292.8273
EMail [EMAIL PROTECTED]
-
Before posting, p
We have also experienced the same exact behavior, also using the mm.mysql
driver, on Linux. However, our problem is intermittent. There are times
(though these times cannot be accurately predicted) where the data is
retrieved correctly, which implies that the data is stored correclty. We
have v
show tables;
Is your manual broken ?
Duncan Hudson wrote:
>
> What's the SQL command to issue to list all of the tables that are contained
> in a given MySQL database?
>
> C. Duncan Hudson
> Dynax Solutions, Inc.
>
> Tel 216.292.8203
> FAX 216.292.8273
> EMail [EMAIL PROTECTED]
>
> ---
On Tue, Mar 13, 2001 at 08:40:20PM +0200, Heikki Tuuri wrote:
> I looked at the pthread header file which is, by the way, 52000 lines long :).
When I sent it, it was a tar file with /usr/include/pthread.h and the
complete subdir /usr/include/dce. The orverall length of all files may
match the numb
show tables;
Duncan Hudson wrote:
> What's the SQL command to issue to list all of the tables that are contained
> in a given MySQL database?
>
> C. Duncan Hudson
> Dynax Solutions, Inc.
>
> Tel 216.292.8203
> FAX 216.292.8273
> EMail [EMAIL PROTECTED]
>
>
The following causes the mysql server to crash.
It works fine with 3.23.25-beta.
create table t ( a integer)
insert into t (a) values (0),(1),(2),(3),(4)
select * from t order by a limit 3
--Darrell Gallion
This Report was made using the WinMySQLadmin 1.0 Tool
3/13/2001 3:24:01 PM
Description :
I'm using 3.23.26-beta on FreeBSD 4.1.1-STABLE. I'm getting corruption in
the dump files in the form of "^A"'s showing up in strange places (they
mostly appear in table definitions, but also in the data that is close to
these definitions). The dump file cannot be used to restore if they are not
How exactly does the BEGIN/COMMIT/ROLLBACK transaction process work? The
examples I have seen are like:
BEGIN;
statement 1;
statement 2;
statement n;
COMMIT;
Does this imply that if any of the statements fail then a ROLLBACK will be
called, otherwise it will COMMIT?
--
I've done some rudimentary snooping around on both MySQL's site and on
google, trying to find out what status (if there is a status) on MySQL and
XML support.
If anyone could point me in the right direction, I'd really appreciate it.
I'd like to stay away from Oracle if I can manage, but it's XM
Check the archives, we had this argument 2 weeks ago.
Cal
http://www.calevans.com
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 13, 2001 2:36 PM
To: [EMAIL PROTECTED]
Subject: XML
I've done some rudimentary snooping around on both MySQL's
Dear gentleman,
I am running mysql over FreeBSD and when i issue a "show logs" query to
mysql, my connection is droped (cause the process is killed).
Take a closer look:
mysql> show logs;
ERROR 2013: Lost connection to MySQL server during query
mysql> select user();
ERROR 2006: MySQL server has
Please drop the stick and back away from the dead horse, it has been beaten
enough. :)
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, March 13, 2001 12:35 PM
Subject: XML
> I've done some rudimentary snooping around on both MySQL's site and on
> go
> "JSB" == Jamie S Buchanan <[EMAIL PROTECTED]> writes:
JSB> More specifically, I have two DateTime fields (A and B), in my creation
JSB> script I want to set the default value of B to the value of A so that
JSB> when I write a new record to the table the position of B can be left
what's wro
I can also verify that the data seems to be stored properly (from mysql's
command line tool). The problem seems most likely to occur with larger text
strings
Anyone else?
-Scott
-Original Message-
From: Stephen Faustino [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 13, 2001 2:
Thank you for this, I missed the information in the manual.
It would seem that I need to install gcc-2.95, this is prooving to be a bit
problematic, there seem to be all kinds of dependancies and conflicts
occuring while trying to remove 2.96 and install 2.95 packages using RPM, my
distribution
I'm using MySQL 3.23.29-1 on a Red Hat Linux 7.0 platform.
I've all patched the mysql-related bug fixes from Red Hat.
I'm using a pentiumiii 800mhz dual processor system.
I'm using mysql++ c++ api.
My program links well with the sqlplus library and
the mysqlclient library, but when I run the linke
OS: Solaris 7, Sparc
MySQL Version: 3.23.29a
Problem:
Sometimes when I do a mysqladmin shutdown on the command line mysql restarts
itself instead of shutting down.
>From the CLI:
elvis~ >mysqladmin -uadmin -pdevsqladmin shutdown
Terminated
010313 18:17:40 mysqld
Hi, I was wondering if anyone could help me with some SQL. I have a product
group table that has a link to itself to allow me to build a hierarchy of
products. Each Product has a link/relationship to its parent, so I have
PRODUCT GROUP
PRDGRP_TK Primary Key
P
Very situational
Let me lay out what I *think* your saying your, tell me if I'm right/wrong.
You have a table with 3 (or more, but irelevent) columns. A sample of the
data is as such:
Product | Group | Name
1 | 1 | Full product listing
2 | 1 | Computers
3 | 2 | Motherboards
4 | 2 | Monitor
Dave Hewlett wrote:
> To...
>
> I previously placed this as a comment on a seemingly similar situation.
> However no one noticed it. As it is a possible bug in mysql i have re-entered it.
>
> >
> > I had an experience the other day in a controlled test environment that appears
> > to be similar
Ok i know I've seen this somewhere but i can't find the specifications on
how much mysql can handle. I'm going to be developing a program for my
company which may require a rather large amount of records and i just need
to know the maximum capacity of mysql. Thanks for pointing me in the write
d
Or you can fix your php by turning off the magic_quotes_gpc flag. You then
won't need to change your code.
Check out http://www.php.net/manual/en/configuration.php on how to do this.
I have provided an example on how to do this with apache running on a linux
machine.
- Original Message
Almost, and sorry for the ambiguity. I have two tables, Product Group and
Product.
The product group only contains the 'Product Hierarchy' and the Product
table contains all the product information.
eg
Product Group
-
Prdgrp_idPrdprn_idName
1
Well, really it matters on hardware
Some OS's have limits to file sizes, check your OS documentation on that.
Other than that, it's all a matter of how much hardware you put behind
mysql.
- Original Message -
From: "Jason Hurst" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesd
Hello,
I didn't receive any responses, so I thought I would try
resending this.
I just installed mysql (from source) on three machines,
and I have encountered the same problem on all of them.
Everything appears to work fine (including the benchmark
tests), but when I attempt to run the test suit
It actually does support foreign keys but for compatibility only. It is
data integrity of foreign keys that's not supported. In any case, if you
program properly and test your work thoroughly test your work then there is
no need for foreign keys. This is also one reason why mysql is the fastes
Hello everyone,
I have a quick question:
the following table keeps a track of logged in users.
CREATE TABLE auth_lost_in_space (
sid varchar(32) NOT NULL,
count smallint(5) unsigned zerofill DEFAULT '1' NOT NULL,
date datetime DEFAULT '-00-00 00:00:00' NOT NULL,
PRIMARY K
Heres the query Im trying to run: takes about 2 minutes...both userid and usernum
columns have indexes...usernum is unique. Show keys follows.
mysql> explain SELECT usernum FROM client WHERE userid='Salty3' OR usernum =
4158774796;
++--+---+--+-+--+--
What's wrong with SUM?
select sum(count)
from table;
Does it get any simpler than that?
regards,
thalis
On Wed, 14 Mar 2001, Maxim Maletsky wrote:
>
> Hello everyone,
>
> I have a quick question:
>
> the following table keeps a track of logged in users.
>
>
> CREATE TABLE auth_lost_in_s
Hope this isnt a dupe post...I mailed before confirmation was received so I
think my post died.
Here is the issue I run the query below and it takes forever ( 1+ minutes ).
It uses 2 keys (one unique) in the where clause but still does a full table
scan.
mysql> SELECT usernum FROM client WHERE u
On 14-Mar-01 Bob Silva wrote:
>
> mysql> explain SELECT usernum FROM client WHERE usernum=4158774796;
> +-+
>| Comment |
> +-+
>| Impossible WHERE n
In the last episode (Mar 13), Bob Silva said:
> Hope this isnt a dupe post...I mailed before confirmation was
> received so I think my post died.
>
> Here is the issue I run the query below and it takes forever ( 1+
> minutes ). It uses 2 keys (one unique) in the where clause but still
> does a f
yup,
thanks, this is what I was looking for!
(just didn't know it)
Cheers,
Maxim Maletsky
-Original Message-
From: Thalis A. Kalfigopoulos [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 14, 2001 1:25 PM
To: Maxim Maletsky
Cc: [EMAIL PROTECTED]
Subject: Re: summarizing rows. an sql
On Mon, 12 Mar 2001 10:02:51 -0500
[EMAIL PROTECTED] wrote:
>
> I just upgraded from Mysql 3.23.28 to 3.23.34 and I'm now seeing mysql
> errors from my scripts that say "mysqld has gone away". The
> /var/lib/mysql/host.err log says this repeatedly:
same here.
Compiling with Innobase, and d
On Wed, Mar 14, 2001 at 02:42:30PM +0900, Tatsuhiko Miyagawa wrote:
>
> On Mon, 12 Mar 2001 10:02:51 -0500
> [EMAIL PROTECTED] wrote:
>
> >
> > I just upgraded from Mysql 3.23.28 to 3.23.34 and I'm now seeing mysql
> > errors from my scripts that say "mysqld has gone away". The
> > /var/lib/my
Further to your comment, I have had considerable benefits by creating an
index of both keys as well. So I define 3 indexes userid, usernum,
userid&usernum.
hope this helps.
len
-Original Message-
From: Dan Nelson [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, 14 March 2001 16:06
To: Bob
1 - 100 of 107 matches
Mail list logo
