>Description:
When creating an index with multiple text fields, `where' clause
isn't handled correctly. If no index is present, "a = 'foo' and
b = 'bar'" does work well. However, if an index is present,
"a = 'foo'" and "a = 'foo' and b != 'bar'" work correctly, but
NuSphere is cheaper, comes with a printed MySQL manual, and IMHO, installs
easier.
- Original Message -
From: "Frank J. Schmuck" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, January 24, 2001 6:45 AM
Subject: ArabiaSoft and NuSphere
> Any comments on the packages from Arab
NuSphere announced Gemini a few months ago and there is a press release on
our website if you want to see the official details at:
http://www.nusphere.com/releases/103000.htm
Gemini is a project that NuSphere is doing to add a new table type to MySQL
that will provide ACID transactions, row-lev
anthony ortega wrote:
>
> I recently upgraded to linux 7.0 which comes with mysql. Everytime that i try and
>start the mysql server it starts up then stops. when I try the mysql -user command it
>gives me a cant connect to mysql.sock error. any idea what is going wrong?
>
> Anthony Ortega
Anth
I recently upgraded to linux 7.0 which comes with mysql. Everytime that i try and
start the mysql server it starts up then stops. when I try the mysql -user command it
gives me a cant connect to mysql.sock error. any idea what is going wrong?
Anthony Ortega
(512)444-6238
6700 B. Deatonhill
Aust
I recently upgraded to linux 7.0 which comes with mysql. Everytime that i try and
start the mysql server it starts up then stops. when I try the mysql -user command it
gives me a cant connect to mysql.sock error. any idea what is going wrong?
Anthony Ortega
(512)444-6238
6700 B. Deatonhill
Aust
What the heck is gemini and innobase? and how will they
be used in mysql of the future?
--
Vincent [EMAIL PROTECTED]
Xaymaca Studios http://www.blendermania.com
-
Before posting, please check:
http://www.mysql.com/manual.php
>DescripWell, for some reason after a table is being automatically repaired
by mysql , some thread will be a suspended state. Mysqladmin will report
a "waiting for table" in the state column of those threads. A look at
the .err file showed me a "Warning: Checking table:" message.
I waited a while
Hi again Bob,
>>I know it's not 'proper' database design and I should have
>>normalized the one-to-many relationships to multiple tables.
>>However, it was fast and gave me a result which worked quickly
>>(and up against a mad deadline).
>
>I think you've just identified the most common use of th
How about
CREATE TEMPORARY TABLE tempbills SELECT billdesc, bpamount FROM bill_pay
Thanks,
James
NEBIS Tech.
http://www.nebis.com
-Original Message-
From: Matt Bailey [mailto:[EMAIL PROTECTED]]
Sent: Saturday, January 27, 2001 4:49 PM
To: [EMAIL PROTECTED]
Subject: Temporary tables
I
I'm using version 3.23.25, and am having trouble setting up a temporary
table. I have the following permanent table already set up:
bill_pay
(pbid int (8) default '0' not null auto_increment,
billdesc varchar(20),
bpamount int(8),
pbdate date,
budgetid int(8),
primary key (pbid), unique id (pbid)
Tor-Erik,
If 'I' was a language syntax interpreter, i'd see
"where not field like pattern" as
where (not(field) like pattern
and
"where field not like pattern" as
where (field !like pattern)
notice that not(field) probably returns 'False' so your first query is:
where False like pattern
wit
I'm using version 3.23.25, and am having trouble setting up a temporary
table. I have the following permanent table already set up:
bill_pay
(pbid int (8) default '0' not null auto_increment,
billdesc varchar(20),
bpamount int(8),
pbdate date,
budgetid int(8),
primary key (pbid), unique id (pbid
Why gamma??? Go to www.mysql.com and download a stable version of
mysql-3.23.31. It's official now!
On Saturday 27 January 2001 16:11, CheongMeng wrote:
=> Hi,
=> I failed to install mysql-3.23.30-gamma on bsdi4.2.
=> this is the err mesg I got:
=> Making all in myisam
=> make: don't know how t
"J.M. Roth" wrote:
>
> Hello,
>
> I just installed the newest MySQL (3.23.32) with PHP 4.0.4pl1 (shared
> module) on an Apache 1.3.12 (Linux).
>
> Some SQL syntaxes that worked before don't anymore.
> E.g.:
>
> $query = "SELECT * FROM $userstable ORDER BY when DESC LIMIT 0, 3";
> doesn't wor
* J.M. Roth <[EMAIL PROTECTED]> wrote on 28.01.01 02:05:
> I just installed the newest MySQL (3.23.32) with PHP 4.0.4pl1 (shared
> module) on an Apache 1.3.12 (Linux).
>...
> $query = "SELECT * FROM $userstable ORDER BY when DESC LIMIT 0, 3";
> doesn't work:
>From your query I think you upgraded
Hello,
I just installed the newest MySQL (3.23.32) with PHP 4.0.4pl1 (shared
module) on an Apache 1.3.12 (Linux).
Some SQL syntaxes that worked before don't anymore.
E.g.:
$query = "SELECT * FROM $userstable ORDER BY when DESC LIMIT 0, 3";
doesn't work:
Warning: Supplied argument is not a valid
Tested on the following versions of mysql: 3.22.32, 3.23.31 on Linux
Description:
"where not field like pattern" gives empty set, while
"where field not like pattern" return what i expect
How-To-Repeat:
create table testtabell(test varchar(10));
insert into testtabell values('test.com')
NuSphere offers a MySQL, PHP, Perl, & Apache distribution that includes the
manual (and 3 O'Reilly books) in a printed format. For $79 you can't go
wrong
- Original Message -
From: "Pak Tse" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, January 23, 2001 8:10 PM
Subject: MySQL
In the last episode (Jan 27), Artem Koutchine said:
> Interesting, how will MySQL benefit from using
> -async
> -noatime
> options for filesystem it is keeping its data on or from using
> SoftUpdates (for FreeBSD in particular).
Not much. Since you're constantly accessing the same small amount o
we are just getting started using mysql and want to develop an admin
password access section for our site using cold fusion & mysql.
Is thier a site with examples of this type of thing ?
Thanks,
Byron
-
Before posting, please
On Sat, Jan 27, 2001 at 09:58:23AM -0600, Thomas Katsampes wrote:
> Hello,
>
> I'm trying to figure out the correct syntax for requesting
> the database to
> remove all records older than 14 days. The mysql query that
> I am using (from within
> php4) is:
>
> //---update news so only last two w
Sir, your DELETE statement runs fine on my computer. The problem
appears to be in your PHP code. Post the problem to a PHP group with
all the relevant lines, not just the two shown below.
>Hello,
>
>I'm trying to figure out the correct syntax for requesting
>the database to
>remove all records
Hi,
I failed to install mysql-3.23.30-gamma on bsdi4.2.
this is the err mesg I got:
Making all in myisam
make: don't know how to make mi_test_all. Stop
*** Error code 1
Pls help
Thanks.
-
Before posting, please check:
htt
I just built from a src.rpm and installed 3.23.32 on an RedHat 7.0 box.
It installs with no errors and runs, but using the command line utility
"mysql" it does not show any of the databases (test, mysql, etc). The
databases are in the /var/lib/mysql directory, and I can create new
databases, they
Hope this works:
I'm VERY new to php and mysql - ANY information on setting up and running php scripts
with mysql are greatly appreciated.
V
Jez & Vlad
GothNetwork & The Underworld
http://www.gothicunderworld.com
http://www.gothnetwork.com
http://www.theblackpath.com
http://www.thewebchain.ne
Hi,
It may sound strange, but the fact is that I'm needing to share data between
one M$SQL7 and the MySQL. It's one business envoirnment that is migrating
from one to the other, and in the meantime (until the new system does have
all the features developed) I may still need to query the data in d
I have a pretty complete install of RH7, with MySQL 3.23.32 running well
and all.
The last time I was writing Perl programs was on an Alpha box, so I've
never actually ran them yet on this RH Linux box.
I'm going through Paul DuBois' MySQL book (so far, all good). Got to
Perl section, and en
Actually with gemini, the table handler will cache data in a mechanism that
is generally more efficient than a filesystem for very heavy update
workloads. Gemini has raw device support, but it will not be enabled in the
alpha release.
Britt...
NuSphere
-Original Message-
From: Dan Nelso
Interesting, how will MySQL benefit from using
-async
-noatime
options for filesystem it is keeping its data on
or from using SoftUpdates (for FreeBSD
in particular).
Anybody experimented?
Artem
- Original Message -
From: "Dan Nelson" <[EMAIL PROTECTED]>
To: "Nazeem Y" <[EMAIL PROTECTE
Adding another 192megs of ram or so would really boost performance.
When I increased the RAM on my PIII 450Mhz from 128 to 256Mb, performance
almost doubled for most queries on a 72k record table.
> > From a mysqldump:
> >
> > #
> > # Table structure for table 'names'
> > #
> > CREATE TABLE n
That would be more like DB2 or Oracle which would be more than happy to
setup their own table space on a raw drive. They build their own file
system and tables on the drive. Its very efficient and why a lot of large
databases reside on DB2 or Oracle.
Curtis
On Sat, 27 Jan 2001, Sander Pilon w
In the last episode (Jan 27), Nazeem Y said:
> Does MySQl syupport RAW devices ?
No, and since MySQL relies on the operating system to cache table data,
you would get horrible performance anyway (the OS does not cache raw
devices).
--
Dan Nelson
[EMAIL PROTECTED]
--
Hmm.. So ID is not PRIMARY KEY (not UNIQUE index)..
That makes it harder. A lot harder. A lot depends now
on how many records per ID you have there on average.
If you you have only, say, 50 ids then you'll be slower.
Basically the query you do MUST BE A SLOW QUERY.
What you can do is set arguments
> -Original Message-
> From: Nazeem Y [mailto:[EMAIL PROTECTED]]
> Sent: 27 January 2001 19:19
> To: [EMAIL PROTECTED]
> Subject: RAW Device support
>
>
> Does MySQl syupport RAW devices ?
>
> Thanks
You mean devices that can Read And Write?
Sure.
If you perhaps mean that it can address
>From a mysqldump:
#
# Table structure for table 'names'
#
CREATE TABLE names (
id int(10) unsigned DEFAULT '0' NOT NULL,
name varchar(80) DEFAULT '' NOT NULL,
KEY id (id)
);
The machine is an Intel Celeron 533Mhz, with 64 mb of RAM, with dual 10
GB EIDE hard drives (doing RAID), running
Well then, be so kind and tell us your index configuration
and your hardware configuration.
- Original Message -
From: "Manuel Capinha" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, January 27, 2001 9:10 PM
Subject: 3 million+ records problems.
> Hi!
>
> I've got a table w
Does MySQl syupport RAW devices ?
Thanks
Yes, that was the first thing i tried. The id column is indexed.
Scott Gerhardt wrote:
> Have you tried adding an index on id?
>
> > -Original Message-
> > From: taree [mailto:taree]On Behalf Of Manuel Capinha
> > Sent: January 27, 2001 12:10 PM
> > To: [EMAIL PROTECTED]
> > Subject: 3 m
Have you tried adding an index on id?
> -Original Message-
> From: taree [mailto:taree]On Behalf Of Manuel Capinha
> Sent: January 27, 2001 12:10 PM
> To: [EMAIL PROTECTED]
> Subject: 3 million+ records problems.
>
>
> Hi!
>
> I've got a table with 3 million+ records. This table has o
The were problems with gcc prior to 2.95.2 What version of gcc are you
using?
Make sure your using gcc 2.95.2 or greater.
--
Boyd Gerber <[EMAIL PROTECTED]>
ZENEZ 3748 Valley Forge Road, Magna Utah 84044
Office 801-250-0795 FAX 801-250-7975
-
Hi!
I've got a table with 3 million+ records. This table has only to
columns: an int and a varchar(80).
I need to periodically execute a statement like: "SELECT id,count(*)
FROM names GROUP bY id", which takes very long time to end.
I'm using perl (DBI) to access this table. When I do a select
On Sat, 27 Jan 2001, Marcelo wrote:
> Thanks for your help, but i needed a
> litle more help, I tried to do that and
> it almost worked bu i still got this
> error
>
> gcc -O2 -g -o mysql1
> mysql.c -L/usr/local/mysql/lib -lmysqlcl
> ient -lnsl -lgthreads -lz -lcrypt -lsock
> et -lm
You may need
Hello
I had the same problem compiling with cxx on Tru64 4.0F.
> Object file format error in: /usr/local/mysql/lib/mysql: read_curr_obj_info:
> File is not a regular file
I searched the archives and found on uvic.mlist.alpha-osf-managers that the same
problem had been reported for MySQL 3.23.
Greetings-
I have been experiencing an unusual issue with replication in 3.23.32. We
are using a dual-master setup on two FreeBSD4.2-STABLE machines. I am able
to initially set up the replication, and issue simple updates from one or
the other machine, but in certain circumstances we receive erro
RTFM on Replication or do develop own methods!
SEARCH THE LIST (start from www.mysql.com Documention/Mail lists)
- Original Message -
From: "Alexei Sh." <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, January 27, 2001 8:20 PM
Subject: (+)Help
> I have two mysql server with s
Thanks for the help Kent and the rest of the list,
Would be grateful for some help interpreting some mysql system
variables. Just to recap on what I am trying to achieve, I want
to load as much of a very large key file (224704512
mykeyfile.MYI) into RAM to improve selects.
I did a "show status;"
I have two mysql server with same tables
how can i synch. this tables
i'm mean if one table is updated second table is updated too !?
_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
-
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Mysql Bug ? (Can't Connect to Mysql Server on 192.9.200.2 (10055))
Description:
I am connecting from Visual Basic 6 to Mysql via
ODBC DSN. When i made 94 sleeped connection after 94 can't connect to a
server. It says : [TCX][MYODBC]Can't
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Mysql Bug ? (Can't Connect to Mysql Server on 192.9.200.2 (10055))
Description:
I am connecting from Visual Basic 6 to Mysql via
ODBC DSN. When i made 94 sleeped connection after 94 can't connect to a
server. It says : [TCX][MYODBC]Can't
Can someone tell me how i can get(or
can someone send me) the strip command
for SCO Open Server 5.0.5?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
Slight correction, for some reason the query below does NOT work on my
sample DB unless I quote the date values.
This should work now:
SELECT IP, Size, Date FROM your_table
WHERE Date BETWEEN '2001-02-01' AND '2001-05-01';
>
> so and i have Mysql table with
> IP | Size
I'm resending the e-mail again so it may be clearest...
First of all, before I forget it...
My MySQL is:
mysql Ver 9.38 Distrib 3.22.32, for pc-linux-gnu (i686)
I have a problem with mysql_fetch_row...
When I use it the system goes to 100% CPU usage and nothing else, I get
not rows...
The prob
> Update, which may be helpful:
>
> The number I'm getting back (which I said is vastly too high) is in
>fact the number of pictures multiplied by the number of ratings entries
>for that artist.
> I wanted to be able to get those two groupings separately. Is there a
>way I can d
Hello,
I'm trying to figure out the correct syntax for requesting
the database to
remove all records older than 14 days. The mysql query that
I am using (from within
php4) is:
//---update news so only last two weeks of news are
available---//
$sql2 = "delete from news where newsdate <
DATE_S
Hi-
I think you are getting tripped up by the same thing as I was when I
tried to install MySQL. When you are prompted "Enter password:", you do
NOT type the new password. You simply hit enter.
--Quentin
> Subject:
>
> Locked out of mySQL.
> From:
>
> "AJ Hawks" <[EMAIL PROTECTED]>
> Date:
>
>I think that is the wrong answer ... Standard-SQL and ANSI-SQL require that
>a column that is displayed
>and has no grouping function applied to it MUST also appear in the GROUP
>BY-clause!!!
Sir, every dialect of SQL has it's non-ANSI quirks. I've never heard
of Standard-SQL, but ANSI-SQL
Thanks for your help, but i needed a
litle more help, I tried to do that and
it almost worked bu i still got this
error
gcc -O2 -g -o mysql1
mysql.c -L/usr/local/mysql/lib -lmysqlcl
ient -lnsl -lgthreads -lz -lcrypt -lsock
et -lm
Undefined first
referenced
symbol
I really miss a function to retrieve the free disk space on a MySQL server.
Previously this was not a problem since a ran PHP and MySQL on the same server, but
for performance reasons i split them.
However, there seems no function to get the free disk space automatically via MySQL,
so a 'inte
You should ponder install mysql using
ports
eg
/usr/ports/database/mysql-server.xxx.xx
make install
make clean
This will put files in standard places for FreeBSD It will install any
dependencies for you automatically.
If you don't know how to insitall mysql using ports email me off the mysq
Eric,
Thank you for the information! It works fine! I did go to the page
below, but it was for Mathematical EQUATIONS, like syne,radius,
circum, etc... I looked under all of those pages and never really saw and
reference to simply pulling totals out.
I really appreciate it! It wor
Don't you think this has nothing specific to MySQL? Maybe you
should read some books on SQL and the manual for MySQL?
SELECT * FROM
tablename
WHERE
datefield>'2001-01-11' AND
datefied<'2001-02-12'
Don;t ask how to correctly call the query in perl, read
perldoc DBI
perldoc DBD::mysql
>Description:
if a column is defined as float(3,1) and your sql query
uses where in that particular column and the value has
decimals on it then you got empty set.
>How-To-Repeat:
($:~) mysql stuff
Reading table information for completion of table and column names
You ca
Ok I need help with this..
I have to values like
$dat1="2001-01-11";
$dat2="2001-02-12";
so and i have Mysql table with
IP | Size | Date|
--
213.32.44.11 | 3|2001-01-11-12|
--
213.32.44.11 | 3444
Hi!
I am having this weird problem that MySQL just dies with
signal 11 several time per day when loads get just a bit
hight (the load is very low, about 1 q/s and on some
export ops it gets a bit high two time per 24 hours).
Any way, FreeBSD 4.2 is not RELASE but STABLE
which is cvsupped pretty o
Hi!
On Jan 26, Steven Roussey wrote:
> Hi,
>
> There was a bug in 3.23.31 (I think) with fultext indexes. Was this fixed in
> 3.23.32?
>
> Sincerely,
>
> Steven Roussey
> Network54.com
> http://network54.com/?pp=e
>
Probably, yes.
I do remember some bugfixing between 3.23.31 and 3.23.32
and
Scott Gerhardt writes:
> I was just wondering what the "USAGE" privilege is good for and where it
> would be used?
>
> Pauls's book says that USAGE is a special "no privileges" privilege.
>
>
> ___
>
> Scott A. Gerhardt P.Geo.
> Gerhardt Information T
[EMAIL PROTECTED] writes:
> I am a customer to a web designer that I have since cut relations with.He
> left me high and dry and I am left to my own devices to ftp my web site to
> another hosting co. Is there a driver exclusively for ftp work that you can
> sell me; with step by step in
Hi!
Sorry for delay :-(
On Jan 24, Tibor Simko wrote:
> Hello
>
> I wrote:
>
> > > After upgrading to 3.23.31, FULLTEXT selects give often "error -1
> > > from table handler" for me. [...]
>
> Sergei Golubchik <[EMAIL PROTECTED]> wrote:
>
> > Thanks for a bug report! This would be fixed in
I really miss a function to retrieve the free disk space on a MySQL server.
Previously this was not a problem since a ran PHP and MySQL on the same server, but
for performance reasons i split them.
However, there seems no function to get the free disk space automatically via MySQL,
so a 'inte
Artem Koutchine writes:
>
> Could you point me in the direction where i coudl find that
> "Ken Manzel's info on FreeBSD 4.* patches."
>
> I am having the same problem with 3.23.32 on 4.2-stable (dies
> sporadically with sig 11).
>
> Regards,
> Artem
>
>
>
You can look at the ar
In the manual
First off, have you tried the following ...
6.15 Causes of Access denied Errors
If you encounter Access denied errors when you try to connect to the MySQL
server, the list below indicates some courses of action you can take to
correct the problem:
After installing MySQL
Hello,
I'm trying to learn mysql & PHP. I recently set up the mysql server (with
the file: mysql-3.23.32-pc-linux-gnu-i686.tar.gz)
My problem is this: I either forgot the password, or neglected to set up any
user accounts.
The documentation says to do this:
./bin/mysqladmin -u root -p pa
73 matches
Mail list logo
