3.22.32 has known Join issues, the machine running that version should
be upgraded to the 3.23.32 STABLE release.
Adrian D'Costa wrote:
Hi,
I have been trying this on my localhost and this works
select special.contid, special.cityid, special.curr1, special.catalogo,
special.hf,
Err also, RAND() is a 3.23 feature ;-)
Adrian D'Costa wrote:
Hi,
I have been trying this on my localhost and this works
select special.contid, special.cityid, special.curr1, special.catalogo,
special.hf, special.curr2, special.vitofferta, special.fh, special.club,
special.stars,
On Mon, May 21, 2001 at 11:32:46AM +0530, Adrian D'Costa wrote:
Hi,
I have been trying this on my localhost and this works
select special.contid, special.cityid, special.curr1, special.catalogo,
special.hf, special.curr2, special.vitofferta, special.fh, special.club,
special.stars,
Hi,
- DAY) '$tdate' and city.id=special.cityid order by RAND() limit 1;
ERROR 1064: You have an error in your SQL syntax near 'RAND() limit 1' at
line 3
select version();
+---+
| version() |
+---+
| 3.22.32 |
+---+
What could be the problem
order by
Hi all,
I would like to try and create a database that can be used for
report/letter generation on both IBM and Macs, and eventually emails. I
have success on the IBM simply using ODBC and Office, and was wondering how
one would go about the same process on the Mac. The advantage of using
I can't manage to have an acces to my database with mysql installed on E: on a windows
Nt server.
What can I do ?
Thanks
Does anyone have comments about using HEAP tables to cache a real table from
a database ?
My HEAP tables has max 10 rows.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Hi,
I need to import data from tables writen in MS Word 97 into MySQL
under Linux:(( THe problem is that I don'w have windows box with MS
Office, and even if I have, I don't know to use Office. And the other
problem is that I data r writen using Serbian latinic letters which I have
to save
Hello,
I am trying to install mysql on my Windows 98 box as a standalone. I would like to
work on my computer only, testing, etc before sending stuff to my server; therefore I
would like to have a version of mysql that runs independently on my win98 box,
probably along with Apache once I get
thank you for your answer, but I ran mysql the way you explained
(safe_mysqld --basedir=/usr -u user -p password), but it doesn't change
anything.
Here is the log :
snip
basedir: /usr/
datadir: /var/lib/mysql/
tmpdir: /tmp/
language:/usr/share/mysql/english/
pid file:
We are currently running a website witch both takes care of the database and
the application.
We will buy a HP server, which will only be used as a db server.
It will probably be a dual PIII 800mhz with 512mb ram and 3 physical disks.
We have the option of changing this a bit.
What would give
Fayed Design wrote:
- Original Message -
From: Fayed Design
To: [EMAIL PROTECTED]
Sent: Friday, May 18, 2001 1:14 PM
Hello to all of you,
does anybody know how to connect an Java Applet with mySql.I am trying already since
weeks,no success.
It always response no suitable
Randy,
I did not receive any replies so any suggestions would be useful!. We are
using mysql with PHP and the problem may stem from PHP hogging the database,
but I cannot be sure.
Thanks,
David
Randy Johnson wrote:
Dave Did you get any replies?? I am having the same problem as you and it
hi there, from one day to another, my mysql in 2 machines with 2 different
mysql version crashed after a quite long query,
i've run mysql server with the log option, here are the details:
in hostname.err:
mysqld got signal 11;
The manual section 'Debugging a MySQL server' tells you how to
I wish it was! See my note below, the 7 box runs at about 0.5% but the 2.6 box
runs at 99%!
David
Simon Green wrote:
Is that not 98% idle and mysqld using 5% of the total CPU use! i.e. you are
looking at vary different things?
Simon
-Original Message-
From: David Allen
Hello again!
Do you know if there is any way I can see what the mysqld is doing? If it is
taking up 99% of the processor time, it is very busy doing something! I
installed the binary version and consequently only have the tools available
which came with that distribution.
Thanks,
David
Simon
Hi everybody,
I wonder if this has been reported before. After upgrading MySQL to the
version coming with SuSE 7.1 (3.23.33), I found that all writing operations
to the field right in my table Rights would fail.
Strangely enough, trying to fix the problem by enclosing the field name in
quotes
Hi,
I would like to know how to tell mysql to listen to specific foreign
address. I know I can use --bind-address to tell mysql to listen to
specific local address. But I need mysql to listen to specific foreign
address. HOW TO DO IT.
Thank you
Mark
-Original Message-
From: Chris Freeman [SMTP:[EMAIL PROTECTED]]
Sent: Monday, May 21, 2001 2:29 PM
To: DEVOS BASTIEN
Subject: Re: mysql start failed.
oops that was not quite right,
that was a mixture of starting the daemon and connecting to the server all
with one
On Mon, May 21, 2001 at 09:09:29PM +0800, Mark Lo wrote:
I would like to know how to tell mysql to listen to specific foreign
address. I know I can use --bind-address to tell mysql to listen to
specific local address. But I need mysql to listen to specific foreign
address. HOW TO DO
Hi!
I like to know how to retrieve the record id after an insert into query.
I have the table user containing two columns: UID (auto_increment) and
USERNAME. After I have added a new user (using insert into user (uid)
etc.) I like to know the UID of the new record.
I can set the record
It runs now.
I tried many things, so I'm not sure of what I did in order to make it run,
but I think these things where important
- always be sure that /var/lib/mysql is 'chowned -R mysql:mysql'
- run mysql_install_db to install base tables properly
- start manually mysql with : 'safe_mysqld
is there anyone who can help me with my problem i posted a earlier?
i know i shouldn't post this kind of requests, but i REALLY need help.
i am on a deadline and having major problems exporting tables from access
2000 to mysql.
please help
Hi, everybody:
I have received no answer to my question and I suppose it is because
no one has faced this problem before.
Could anyone of you check this benchmark and tell me wether it also
occurs in your environment or not?
That could help me when looking for the possible
Bonjour,
Solaris 2.8 on SPARC 4x64bit processor .
Mysql-3.23.37 with InnoDB
What I was doing : I was altering a lot of table, converting them
from InnoDB to MyISAM type (I don't know if this is the cause of my
problem ...)
Now, on the console here is what happens :
[4:52pm]#
Bonjour,
Sorry for the previous email. I had to check more. I had a program
of mine eating more than a giga of ram on the server :o(
so no problem with Mysql this time :o)
Regards,
Alex.
-
Before posting, please
Hi,
I have installed mysql on WIN NT4.0.By default ,will
mysql use ISAM as the default?
When to opt for BDB?
Regards,
Ravi
Do You Yahoo!?
Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk
or your free @yahoo.ie address at
Rodolfo Baselli wrote:
Gerald Clark wrote:
You don't use telnet or ftp to connect to the MySQL server.
You use the client mysql.
Yes, I know, I probably mispelled the problem.
Now, I can't telnet the telnet service and ftp the ftp service running
on the MySQL server when the MySQL
a == archive archie writes:
a any binary version for cobalt qube2 (mips processor) ??
a have mysql ever tested install at cobalt qube/raq ??
a how is it done?
There used to be a version on the cobalt ftp site in the contrib
area. Don't know what's there now, since they seem to be ignoring
Hi,
1.
Does mysql inherently implement locking implicitly?
2.
The following is the extract from mysql documentation:
In MySQL Version 3.23.7 and above, you can insert rows
into MyISAM tables at the same time other threads are
reading from the table. Note that currently this only
works if there
Well... I installed mysql in my D: drive (at home) and it works perfectly. I
set in the control panel/services to have mysql started automatically when
the server is started.
When I want to access it direct I just go to D:\Program Files\mysql\bin and
type mysql.
Yesterday I tested a cgi
2.
The following is the extract from mysql documentation:
In MySQL Version 3.23.7 and above, you can insert rows
into MyISAM tables at the same time other threads are
reading from the table. Note that currently this only
works if there are no holes after deleted rows in the
table at the
I usually create a txt file like the following (I used Oracle but you can
change to mysql stuffs):
jdbc.driver=oracle.jdbc.driver.OracleDriver
jdbc.driverType=jdbc:oracle:thin:@
jdbc.host=prokids
jdbc.port=1521
jdbc.sid=orcl
jdbc.username=scott
jdbc.password=tiger
Then I have a manager class
I am having a heck of a time here. Im running RH 7.0 kernel 2.2.16 on a
PII 300, 128meg RAM. Mysql 2.23.32, php 4.04. I have a DB set up that has 4
tables. 3 of the four only have a couple thousand records, but one table
will have somewhere between 80k to maybe as many as a million
Can you give more info on what type of system this is ??
Is this really a 'server' type machine, or an HP Vectra PC ?? (of the
'XU' series ?)
Does it have the onboard SCSI controller (what size drives, and are they
SCSI drives ?)
- If they're SCSI, you might want to get 4 drives, and
Do you 'refresh' your tables before each test ? If so, is it possible that
you're writing over the same disk space each time (which would point to a
drive surface problem). Is it possible that the larger runs of 'inserts'
are using more RAM than the smaller tests, and you're hitting a bad
hi,
i've upgraded mysql server with 3.23.38 from mysql, and i have the same
behaviour sinisa if you have some time i could give you access to one of the
machines. :/
--
WEBSOLUT - Soluções Internet
Emailto: [EMAIL PROTECTED]
Personal Info: http://websolut.net/people/rui.html
As
Rui Barreiros writes:
hi,
i've upgraded mysql server with 3.23.38 from mysql, and i have the same
behaviour sinisa if you have some time i could give you access to one of the
machines. :/
--
WEBSOLUT - Soluções Internet
Emailto: [EMAIL PROTECTED]
Personal Info:
Is there anyway to determine which part of the an sql query where blahblah
produced
the result?
ie. select Title from inv where Title LIKE '%Green' OR Title Like
'%Blue%'
I need to distinguish if the Title was like Green or Blue..
/mysql/bin/mysql_setpermission can also be handy
but if you do stuff manually don't forget to do a
/mysql/bin/mysqladmin flush-privileges
a bit of manual reading probably wouldn't go amiss either :-)
On Monday 07 May 2001 07:54, Daniel Goldin \(E-mail\) wrote:
I've had
HI, everyone,
I met a problem about setting up replication(master/slave) of mysql sever on unix
boxes.
Mysql servers are installed under /usr/local/ on master and slave and they can be
run under /usr/local/mysql/bin.
It seems to me that I have three choices where to put my configuration
In the manual, it states if Key_reads is big, then your key_cahce is
probably too small.so what exactly is BIG???
Same thing for opened_tables, it states if opened_tables is big then your
then your table_cache variable is probably too small. Can someone please
define
I am trying to see if I can communicate with a MySQL on Free BSD from the
MySQL GUI client on my Windows NT.
The GUI client cannot connect because the MySQL seems to be refusing this
connection. This does not seem to be server-related, but related to MySQL
itself, since, when I try to telnet in
What language are you using to prepare that query?
If it's perl, do something like if ($title =~ /Green/)
If it's php, do something like if (ereg(Green,$title))
If it's C, cycle the string finding that
This is a job for the client truthfully...but if you absolutly MUST do this
server side, here
Hi,
is it possible to get *one* quick result with the rowcount of each table in
one database, without knowing the column-names?
this does *not* work:
select count(t1.*), count(t2.*)
from table1 t1, table2 t2
Manual doesn't say anything about that.
Greetings,
Ansgar Becker
Eric,
I'm using php. The problem is that the where may have 100 or so conditions. I
was hoping that mysql had some built in function or variable that would return
this for me. I guess I'll have to code it in php.. argh.
Eric Fitzgerald wrote:
What language are you using to prepare that
Hi!
This is probably more of a C inadequacy than a MySQL problem. I'm playing
around with C with MySQL (I have to date only interfaced with it in
PHP) and I was curious if anyone had any example code which illustrates
how you would write functions which return mysql data.
For example, in PHP
I take it the Computer SQL Function is not support by MySQL and if not is
there a substitute for it?
If you are unfamiliar with the command it works like this:
SELECT type, price
FROM products
ORDER BY type
COMPUTE SUM(price)
You will get a summary of prices by type in your results.
Hello All,
Is there some way, when mysql server is running, to change an option? I want to
change skip_networking to OFF without doing a server restart.
Thanks,
Brian
Hi,
I wonder which of the following queries is faster :
$result=mysql_query(SELECT lastauteur FROM forum ORDER BY date DESC LIMIT 1);
or :
$max=mysql_query(SELECT max(date) FROM forum);
list($max)=mysql_fetch_row($max);
$result=mysql_query(SELECT lastauteur FROM forum WHERE date='max');
If you are using PHP (or anothe controlling language, you could take the
results of SHOW TABLES and loop through it either doing a single select for
each table or building a select statement that UNIONs the results together.
i.e.
Select 'Table1' as tableName, count(*) as rowCount from table1
-Original Message-
From: David Allen [mailto:[EMAIL PROTECTED]]
Sent: lunes, 21 de mayo de 2001 14:36
To: Simon Green; [EMAIL PROTECTED]
Subject: Re: CPU usage running mysql
Hello again!
Do you know if there is any way I can see what the mysqld is
doing? If it is
taking up
Any pointers on where to look?
That line says it all really. Your initiallizing connection as a pointer
(denoted by *), you have to treat it accordingly when passing it to
functions. Your function init would look something like this:
MYSQL_RES doquery (MYSQL *connection, char query[100]) {
Well ...
I don't know enough about mysql but it must allow you somehow to specify the
column by number as in Oracle and other DBs
SQL select count(*) from product;
COUNT(*)
--
10
SQL select count(1) from product;
COUNT(1)
--
10
Once you just want to
I would like to know the limitations of Mysql with extremely large tables. I
need to store 20+ million records. Each record would contain only 4-6 fields
and would not be longer than 128 bytes of information. The records could be
divided among several tables, but at what size is the performance
Hey,
We just got a new Dell Poweredge 6450 preloaded with redhat 6.2. Our intention
is to move the database off a smaller machine and load it into this one. We
currently have MySQL 3.23.38 using the innobase driver on redhat 6.2 with kernel
2.4.4. This is on a dual PIII650 with 1 gig of
Actually, as far as performance goes, it depends on table types. Most of
the MySQL table handlers keep an internal count of record numbers. Thus, a
select count(*) from table; is as fast as it gets.
- Original Message -
From: Siomara Pantarotto [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Okay I may have been a bit vague on my description.
SELECT location, date, type, price,
FROM products
ORDER BY location, type, date
Group By location, type
COMPUTE SUM(price)
Is there something similar for compute?
-Original Message-
From: Chris Bolt [mailto:[EMAIL PROTECTED]]
Sent:
my ISP firewall dosen't allow access to port 3306. How can I change this
port assignment? I saw this in the doc but I couldn't find the my.ini
file. What affect other than remote access will changing the port have? I
need to change it to port 21, or something.
mysql
Hmm. One way might be to use MacPerl to generate tab delimited files
that you could then use to create an Excel document, then mail merge
into your Word doc. I could have sworn that there was some kind of ODBC
setup with Mac Office, though..
Z
On Monday, May 21, 2001, at 02:17 AM, Ray Smith
Please strike previous message the query should be:
SELECT location, date, type, price,
FROM products
ORDER BY location, date, type
Group By location, date, type
COMPUTE SUM(price)
-Original Message-
From: Brandon Lewis [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 21, 2001 2:14 PM
To:
On Monday 21 May 2001 13:50, Cody Swanson wrote:
Hey,
We just got a new Dell Poweredge 6450 preloaded with redhat 6.2. Our
intention
is to move the database off a smaller machine and load it into this one. We
currently have MySQL 3.23.38 using the innobase driver on redhat 6.2 with
Hello,
Can someone here recommend a good Telnet program (with SSH) that I can use
to connect to my servers MySQL database?
Preferably something shareware/freeware - but if it must be purchased, I'm
not against that.
Thank you
-Tim
Cool but how about if you put a where clause to your select??
SQL select count(1) from product where productid 3;
COUNT(1)
--
7
Would count(*) show the same performance as count(1)???
Siomara
From: Eric Fitzgerald [EMAIL PROTECTED]
To: Siomara Pantarotto [EMAIL
go to www.ssh.com .. I beleieve there a few nice clients there.
Chad
-Original Message-
From: Tim Thorburn [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 21, 2001 3:21 PM
To: [EMAIL PROTECTED]
Subject: Telnet into MySQL
Hello,
Can someone here recommend a good Telnet program (with SSH)
CRT (www.vandyke.com)
Tim Thorburn wrote:
Hello,
Can someone here recommend a good Telnet program (with SSH) that I can use
to connect to my servers MySQL database?
Preferably something shareware/freeware - but if it must be purchased, I'm
not against that.
Thank you
-Tim
Well, let's do a test:
mysql CREATE TABLE testcount (product INT NOT NULL AUTO_INCREMENT PRIMARY
KEY, description VARCHAR(50));
Query OK, 0 rows affected (0.00 sec)
**Ran perl script here to populate the table**
mysql SELECT * FROM testcount LIMIT 10;
+-+---+
| product |
On Mon, May 21, 2001 at 03:21:10PM -0500, Tim Thorburn spake thusly:
*] Can someone here recommend a good Telnet program (with SSH) that I can use
*] to connect to my servers MySQL database?
*]
Tim,
You don't use telnet to connect to the MySQL database... You use the
mysql client
--
In ODBC documents some common error section is says
- If you are connecting to a server with a character set that isn't compiled
into the MySQL client library (the defaults are:
latin1 big5 czech euc_kr gb2312 gbk sjis tis620 ujis
) then you need to install the mysql character definitions
On Mon, May 21, 2001 at 05:13:44PM -0400, Peter L. Berghold wrote:
On Mon, May 21, 2001 at 03:21:10PM -0500, Tim Thorburn spake thusly:
*] Can someone here recommend a good Telnet program (with SSH) that I can use
*] to connect to my servers MySQL database?
*]
Seeing your mailclient
At 3:21 PM -0500 5/21/01, Tim Thorburn wrote:
Hello,
Can someone here recommend a good Telnet program (with SSH) that I
can use to connect to my servers MySQL database?
Preferably something shareware/freeware - but if it must be
purchased, I'm not against that.
Thank you
-Tim
Unless you're
Any good ones for the Windozes version..When I use just regular ol Telnet I get Smiley
and clovers and hearts and the version.
Cheers
-Original Message-
FROM: Eric Fitzgerald
TO: Angerer, Chad, 'Tim Thorburn', [EMAIL PROTECTED]
DATE: Mon 5/21/01 15:58
SUBJECT: Re: Telnet into MySQL
I
Hello Eric,
Tuesday, May 22, 2001, 12:23:24 AM, you wrote:
EF I really prefer SecureCRT from VanDyke software myself. Perfect blend of
EF features and simplicity for my needs. It has a shareware version that does
EF expire, but the license is cheap for it. Go to www.vandyke.com and download
In your original message, you said You will get a summary of prices by type
in your results. and that is what my query gives you. It returns the sum of
the price columns from any rows that are eliminated by the GROUP BY clause.
What do you want it to return?
Please strike previous message the
That's really cool
Thanks
siomara
From: Eric Fitzgerald [EMAIL PROTECTED]
To: Siomara Pantarotto [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: Re: count(*) on different tables
Date: Mon, 21 May 2001 14:08:00 -0700
Well, let's do a test:
mysql CREATE TABLE testcount (product INT NOT NULL
hahah
Check out SecureCRT it's a wonderful product and well worth the price.
[EMAIL PROTECTED] wrote:
Any good ones for the Windozes version..When I use just regular ol Telnet I get
Smiley and clovers and hearts and the version.
Cheers
-Original Message-
FROM: Eric
I vote for VanDyke's CRT as well -- lots of features and ~ $30 (US) for the
license.
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, May 21, 2001 3:04 PM
Subject: Re: Telnet into MySQL
Any good ones for the Windozes version..When I use just regular ol
At 4:04 PM -0600 5/21/01, [EMAIL PROTECTED] wrote:
Any good ones for the Windozes version..When I use just regular ol
Telnet I get Smiley and clovers and hearts and the version.
That's exactly why you don't Telnet to the MySQL server. You're seeing
information that's part of the binary
Hi,
Do someone have answers to these questions:
1.
Maximum table size myISAM type tabes can handle?
2.
Default maximum database size for a particular
database.
Your help will be highly appreciated.
Regards,
Ravi
Do You Yahoo!?
Get
Ahh come on.. I want to make things difficultG Normaly I never think about Telnet
but for Fun on a borring Monday I decided hmmm let's play.
If I do any thing it normaly through an ASTA Server and Client. Cool stuff.
Cheers
-Original Message-
FROM: Paul DuBois
TO: [EMAIL
As far as I know, they should be the same. The only case in which I can see
count(colname) would be slower is if it doesnt count rows that contain null
values for that column (this is only a guess, I dont know if count does that
or not).
ryan
Would count(*) show the same performance as
Hello list,
I have a table in a database that has a field named 'artist'. There are multiple
entries of the same artist/band. Example:
deftones
iggy pop
kiss
deftones
glassjaw
deftones
kiss
new found glory
kiss
There's 3 entries for deftones and 4 entries for kiss. What I need to do is
Before you listen to anyone else (and spend any money on a commercial SSH client)
download and try PuttySSH, which is a free 'telnet like' SSH client (it WILL
do straight telnet if you want it to) that works fabulously (at least for me at
home and work for the past year). You can also download
Hi,
I know this has been discussed a lot. I did read the mail archive and
found lots of interesting info. Although I have a problem. We're developing
a windows software that has to exchange sensitive data with a mySQL server.
I read about implementing a SSH tunnel. It works well, although I
Hi~~~
My SHOW PROCESSLIST's output
| 22 | unauthenticated user | 10.169.xxx.xxx || Connect | | login |
what 'unauthenticated user' means?
who is he?
anonymous user?
Thank you for your advanced answer!
database
--MIME Multi-part separator--
Okok, my bad!!
What I meant to say was that I needed a Telnet program with SSH so that I
could log into the shell of my web hosting provider and thereby access
MySQL from shell.
At 05:46 PM 5/21/2001 -0500, you wrote:
At 4:04 PM -0600 5/21/01, [EMAIL PROTECTED] wrote:
Any good ones for the
Shane Anderson wrote:
I would like to know the limitations of Mysql with extremely large tables. I
need to store 20+ million records. Each record would contain only 4-6 fields
and would not be longer than 128 bytes of information. The records could be
divided among several tables, but at
Jocelyn Fournier wrote:
Hi,
I wonder which of the following queries is faster :
$result=mysql_query(SELECT lastauteur FROM forum ORDER BY date DESC LIMIT 1);
or :
$max=mysql_query(SELECT max(date) FROM forum);
list($max)=mysql_fetch_row($max);
$result=mysql_query(SELECT
Jeff Shipman - SysProg wrote:
I have two databases that have identical table
structures. I would like to copy all data from
the 'tickets' and 'notes' in one db to the
'tickets' and 'notes' field in the other. How
could I do this?
You could try the lock/flush strategies employed
by the
VVM Ravikumar Sarma Chengalvala wrote:
Hi,
1.
How much memory does mysql allocate by default to a
database?Any default table wise memory limitations as
well?
Its doesn't allocated very much by default ( 10M ? ),
and there is no per table memory allocation.
2.
Is mysql's memory
Dear All
I am inputting data into a MySQL database where i have set the primary key as the ID
and it is auto-incrementing. I make sure that my input file contains a null or 0 value
where it should be auto- incrementing. While entering data using LOAD command, my
input file had an error with
Larry Hotchkiss wrote:
In the manual, it states if Key_reads is big, then your key_cahce is
probably too small.so what exactly is BIG???
Its all about ratios, you just want a hit cache hit, so that
your read_requests are a lot larger than your actual reads.
|
Using Windoze version, latest build.
My table has three fields two VCHAR and one BLOB. After inserting into the
table two names and two bmp files into the blobs, worked nice thanks to the
help I got from here, my table looks like this
Hello,
I am running MySQL (3.23.xx) on Linux RedHat 6.2 and plan to
increase volume of data in the near future. So, I would like to know some
db schema , total row and your SQL you used to protect my database.
Sommai Fongnamthip
At 20:56 21/5/2001 +0300, Sinisa Milivojevic wrote:
Is it possible to place the same table in multiple databases, by linking the MYD
file from one database to the next? I can see obvious problems with such a
technique, so I thought I'd ask here.
Thanks,
--
Scott F. Crosby
E-Mail : [EMAIL PROTECTED]
Web : http://www.skroz.net
It's some kind
Here is a link that I used to install MySQL on my machine running Win98
http://www.net-language.com/workshops/Default.asp?workshop=21
NOBBY
- Original Message -
From: Jason Rackley [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, May 21, 2001 6:13 PM
Subject: Win32 installation
limitation about space and speed according to DBMS featuring. since MySQL
still have not full SQL 92 feature (transaction, sub select... I think)
make it eat a fewer space than other DBMS (oracle or informix) and it can
speed up because it did not need to handle more condition. I did not
Hi,
I am running mysql 3.23.33 getting this error about once a day causeing
mysql to restart
mysqld got signal 11;
The manual section 'Debugging a MySQL server' tells
Thanks everyone - it now all goes !
The problem I think was due to using a precompiled binary release of Apache
that (I guess) had an exports file pointing to a library in the wrong place...
Anyway building everything from sources did the job.
Dave
At 23:36 20/05/01 -0400, you wrote:
Hmm.
I'm currently running MySQL with tables that contain ~10 million rows.
Each row has 50 columns and the table has 27 indexes. The data size of
what you're describing doesn't seem so big. There are some arithmatics
in the MySQL manual on how much disk space is used per row.
If the tables you
100 matches
Mail list logo
