http://worldcommunity.com/opensource/utilities/mysql_backup.html
I've heard great things about this script and I'm just about to start using
it myself.
-Dan
-Original Message-
From: Scott Haneda [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 18, 2002 11:31 PM
To: MySql
Subject: Upd
Hello all, I have dug through the archives to no avail, the archives point
to many ways to back up your databases, I have found a way that works for
me, but it is no where near as automated as what I want it to be, so I
thought I would ask a few people here what the best approach would be.
To star
Is there any GUI for the server part of MySQL fro Windows. I mean not a
client for MySQL, like SQLyog OR MySqlFront.
Something better then the MySqlAdmin?
--
Sebastian Stan
[EMAIL PROTECTED]
###
D
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
> Is there a patch update from .3 to .4? So that I don't have to reinstall it
> on my win2k box? If I have to reinstall it do I need to first uninstall
> .3 first?
>
You have to reinstall. But that isn't a big problem - after new installation
copy th
Hi I'm Mere!
I've just installed mysql for use of bugzilla.I was logging well all the time
and suddenly my "super user" root can't access the databases especially mysql.In
short root can't access mysql even if I'm using the password I use to login
with.The surprise is that bugs as a user does lo
At 23:43 -0500 12/18/02, Dan Cumpian wrote:
Jeff,
Not if your outer loop is in a separate query. In that case, your query
is essentially a cursor and is static once OPENed. As you move from
record to record, what you are seeing is the records at the time the
query was opened. Now, if you were to
Frank,
I am using MySQL for a PC desktop application. It runs fine, but you
have to be careful how you structure your database because (depending on
how much data you will be storing and processing) be putting a lot of
stress on the PC the application and MySQL are running on.
I am using Delphi 6
Joseph,
I've noticed this as well. MySQL seems to do most types of queries
extremely well, but CERTAIN joins are very slow. I ended up having to
denormalize my data structures somewhat in order to maintain good
performance with MySQL. What I don't know, since I do not have access to
a Linux box, i
Dan wrote:
not attempting to write to the index field. I also attempted to have it skip
the entry with the SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1; command. This
command failed. It did not fail when I eliminated the GLOBAL word in the
command like so: SET SQL_SLAVE_SKIP_COUNTER=1; However, still n
Jeff,
Not if your outer loop is in a separate query. In that case, your query
is essentially a cursor and is static once OPENed. As you move from
record to record, what you are seeing is the records at the time the
query was opened. Now, if you were to update records that you haven't
processed yet
In the last episode (Dec 19), Joseph Dietz said:
> Someone helped me solve the problem with my slow query results! I was
> missing the index which I should have added to my cross reference
> tables.. AND I should have used the INNER JOIN clause instead of
> joining my table with the WHERE clause. I
i like mySQL, but it has a long way to go to
gain the level of 'confidence' that oracle, db2 or mssql or sybase
have when it comes to frontline mission
critical stuff. I think it will in time...thats why i stick with
it. besides, confidence is often just a synonym for 'knowledge'
select count(*)
Thanks for the information, I will try that in this situation, however, I
have done this in other select statements and it has worked fine. I will
follow-up in the PHP list if I still have problems.
Please note also that since I assumed this was a MySQL problem I posted it
to this group. Since the
I am using php and mysql to read a row from a table, store it as an array
called $user_data, then manipulate the array.
$id = 123;
$result = mysql_query(" SELECT * FROM users WHERE id='$id' ");
$user_data = mysql_fetch_assoc($result);
$user_data = ProcessData($user_data);
Now I want to save all t
Lenz,
Thanks, I downloaded it and it all works fine now, the whole bin directory
is statically linked.
Nickg
-Original Message-
From: Lenz Grimmer [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 18, 2002 2:46 PM
To: Nick
Cc: [EMAIL PROTECTED]
Subject: Re: MySQL 3.23.54-max GLIBC er
Hello.
For changing one table, the recommended way is
ALTER TABLE foo TYPE=MYISAM;
There is no built-in way to change several tables at once. I regulary
have the need to apply the same command to some tables. If you use
some UNIX shell, you can do something like this:
mysql your_db -t -e "S
Hey guys,
I followed the mysql replication instructions in the mysql manual to the
tee. http://www.mysql.com/doc/en/Replication_HOWTO.html However replication
immediately fails. I tailed the logs and noticed that it failed on an
insert query on key1, claiming "duplicate entry". Now I've read on
Currently I'm using 4.0.1 Alpha and I'm thinking of upgrading to 4.0.5
as I want to be able to issue UPDATE queries that span multiple tables.
Is there anything in particular I should know of or be aware of before
installing 4.0.5? What is the proper procedure for upgrading? Should I
first uninstal
- Original Message -
From: "Qunfeng Dong" <[EMAIL PROTECTED]>
>
> We are trying to develop a simple biology database to
> maintain some DNA Sequence information. My problem is
> coming from the following two tables:
Making indexes smaller will help. Does it need to be varchar(50)?
Also,
Is there a patch update from .3 to .4? So that I don't have to reinstall it
on my win2k box? If I have to reinstall it do I need to first uninstall
.3 first?
mysql.
-
Before posting, please check:
http://www.mysql.com/manual
I am proud to be a MySQL solid rock database engine user, I used it as my
backend data holder in any form. From traffic analysis to subscriber
administration. I never experienced downtime due to bug ever since. So if ur
planning to use the open source as your billing handler. U better make use
of y
Hi,
I think you'd better add an unique ID to both table defined as int
corresponding to each seq_ID, and then do the join on this ID rather than on
Seq_ID (join on varchar is far from the fastest solution :)) (unless seq_ID
could be converted into int directly ?)
(but it takes time, even for me (
Hey David,
> -Original Message-
> From: Lopez David E-r9374c [mailto:[EMAIL PROTECTED]]
>
> kees
>
> How do you measure spiked queries/s?
>
> All I see is average queries/s from the status command.
>
> I can see the calculation based on uptime in seconds and
> total queries in that time. B
Someone helped me solve the problem with my slow query results!
I was missing the index which I should have added to my cross reference
tables.. AND I should have used the INNER JOIN clause instead of joining my
table with the WHERE clause. In the future I will be far more careful
designing my q
kees
How do you measure spiked queries/s?
All I see is average queries/s from the status command.
I can see the calculation based on uptime in seconds and
total queries in that time. But that's average. My boss
wants avg and skipped on a web site.
David
> -Original Message-
> From: Ke
Two Ideas:
First of all, the DATESTAMP datatype automatically updates it's datestamp
with every modification to the row. You may want to use it to automatically
update the time of your update. Also, you may want to look into using the
TEMPORARY table type. Make a temporary table, fill it with the
Hi,
I am trying to compile MySQL 3.23 on HPUX 11.23 IPF.
I am using gcc 3.0. gcc 2.95 is not available on HPUX
11.23.
CC=gcc \
CXX=g++ \
CFLAGS="-D_HPUX_SOURCE -D__hpux__ -D_REENTRANT" \
CXXFLAGS="-D_HPUX_SOURCE -D__hpux__ -D_REENTRANT" \
CPPFLAGS="-D_HPUX_SOURCE -D__hpux__ -D_REENTRANT" \
LDFL
Hi,
You can use REPLACE...SELECT
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
- Original Message -
From: "Jeff Snoxell" <[EMAIL PROTECTED
At 15:31 + 12/18/02, Jeff Snoxell wrote:
Hi,
I've got that sussed now and am happily using the aquired ref to
subsequently play with the record etc. One other related problem and
I recon I'm sorted
How do I reset the auto-increment value?
I'm working with MySQL 3.23.36 so, according t
At 12:21 + 12/18/02, Jeff Snoxell wrote:
Hi,
I'm adding records to a db using the Perl DBI. Subsequent to adding
a record I need to know the value of the auto-incrementing 'Ref'
field so that I can place a copy of the relavent details into a log
file.
I could query for the "LAST_INSERT_ID
>Description:
The password function does not work as intended with latest 4.1 tree
(today's). It returns a string of LENGTH() = 45 starting with a *
(asterisk) and 44 alphanumeric characters /[a-z0-9]/
>How-To-Repeat:
Using latest 4.1 BK tree, SELECT PASSWORD('something');
>Fix:
Not kno
>Description:
with the latest 4.1 tree (from today) the PASSWORD() function returns random
alpha-numeric text /[a-f0-9]/
45 characters in length (which is too long for a password string). The string
always starts with a * (asterisk).
example:*95144feaa0f433f3f62c29
Csongor, Michael:
>> Maybe they're taking the MS route.
> I second this. These vulnerabilities are serious, they must be given
> more attention. Apache, PHP, RedHat and so on and so on are very careful
> with issues like this, all vulnerabilities/exploits are immediately
> published through all p
Here are my queries. I have an entity relationship diagram but I don't think
I can attach it here! Thank you for all your help. If you would like my
entity relationship diagram, please email me.
Sincerely,
Joseph
explain SELECT distinct Medias.pk_media_id, Organisms.common_name,
Tissues.type
At 21:40 +0200 12/18/02, Gelu Gogancea wrote:
Hi,
You can use REPLACE...SELECT
Not in the case described below. You cannot replace into the same
table from which you're selecting.
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail ad
-- Forwarded Message
From: Joseph D <[EMAIL PROTECTED]>
Date: Wed, 18 Dec 2002 13:55:47 -0800 (PST)
To: "R. Hannes Niedner" <[EMAIL PROTECTED]>
Subject: Re: Can MySQL handle 120 million records? - Impressive! How do you
guys do that?
thanks i actually can't post anything to the newsgroup beca
What you need to have is a _good_ install, and then MySQL is superb. But
to have a "good install" is not as easy as it sounds.
Can you list the elements of a good install?
Well...
One which does not make mysqld hang once in every hour (or minute).
Seriously speaking, this is what I m
At 18:58 + 12/18/02, John P wrote:
I have about 300 database tables that are mostly ISAM and some MyISAM
format. I would like to move them all into MyISAM - what's the
easiest/quickest way? I am running 3.23.54.
I was thinking of doing mysqldump, then using a search/replace in the file
CREATE
On Wed, Dec 18, 2002 at 02:37:14PM -0500, Michael T. Babcock wrote:
>
> Just for anyone who cares (or cares to do the same), when I reply to
> messages at my average 80wpm and hit send, I don't check if
> SQL,QUERY,etc. is in the message 90% of the time. Now, besides
> thanking the crew for adding
Allow postings from members only.
or
I think it's on the PHP lists, if a non-members sends a message he/she gets
a message back. After replying to that message the original one hits the
list..
mysql, query
B.
At 14:37 18-12-2002 -0500, Michael T. Babcock wrote:
Just for anyone who cares (or ca
I just did this sort of thing in the innodb direction. What I did was a
mysql dump, global search and replace of MyISAM to InnoDB in the dump ddl
file, dropped and recreated the database, then restored.
-
Chris Kulish
Systems Engineer
ING Advisors Network
Ph. (515) 698-7583
Fx. (515) 698-358
> -Original Message-
> From: Lenz Grimmer [mailto:[EMAIL PROTECTED]]
> Thanks for confirming! I will publish the binary right away. Sorry for the
> trouble.
Just a small thing I noticed:
version 3.23.54-max-log
missing the 'c' in the version string ;)
- kees
On Wed, 18 Dec 2002, Gerald Jensen wrote:
> Joe is right ... we switched from another SQL server to MySQL in 1999, and
> have never looked back.
>
> MySQL has been rock solid for our applications, the MySQL development team
> is great to work with, and our customers like it.
>
That's been my expe
Hi.
On Wed 2002-12-18 at 18:40:04 +, [EMAIL PROTECTED] wrote:
>
> PLATFORM: 3.23.52-max-nt with Windows 2000 professional (default table type)
>
> I have discovered a performace issue when joining several tables together.
> The performance is extremely poor when performing select queries us
Boy, you guys are die-hard MySQL fans :-) I think your
strong defending convinced us MySQL can handle 120
million records :-) But I know some ordinary users out
there like me who are not experts on tuning the MySQL
performance (they did send me private emails saying
they encountered the similar slo
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wed, 18 Dec 2002, Kees Hoekzema wrote:
> Maybe it is the version of glibc i'm using? it is unstable, the load spikes
> to +50 in 2 minutes.
> (it is the glibc package form Slackware 8.1)
I'm not sure. It also happens if I link against the default
Boy, you guys are die-hard MySQL fans :-) I think your
strong defending convinced us MySQL can handle 120
million records. But I know some ordinary users out
there like me who are not experts on tuning the MySQL
performance (they did send me private emails saying
they encountered the similar slow j
> From: Lenz Grimmer [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, December 18, 2002 9:43 PM
> OK, as I already assumed, the Max binary was not linked statically. Doh!
> Interesting, that this also causes the load to spike, even though it's not
> statically linked against an unpatched glibc.
Maybe
How suitable is mySQL for use in a desktop application i.e. one that would
be installed completely by the user and run on a standalone PC? My
application is written in Delphi and currently uses dBase files, but as
Delphi support for accessing dBase files is being phased out, I am looking
at possibl
SELECT * FROM my_table WHERE Age > 50 AND UPDATE Status = "OLD"
No. That's goofy anyway. Why wouldn't you just use a regular
UPDATE query?
UPDATE mytable Status = "OLD" WHERE Age > 50;
Cos I want to do a fairly long-winded process on the records of those who
are Age>50 and subsequently up
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Fri, 13 Dec 2002, Nick wrote:
> I am currently running MySQL3.23.53-max with no problems, well
> my_print_default complains about the same thing that MySQL-3.23.54
> complains about, but MySQLd runs fine. I am attempting to upgrade to
> MySQL3.23.
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wed, 18 Dec 2002, Kees Hoekzema wrote:
> Ok, here you go:
> # ldd /usr/local/mysql-max-3.23.54a-pc-linux-i686/bin/mysqld
> libdl.so.2 => /lib/libdl.so.2 (0x4002)
> libpthread.so.0 => /lib/libpthread.so.0 (0x40024000)
> l
Michael She wrote:
I guess you can say I'm a follower. Other DB systems have been in use
for years, so their reliability has been generally proven through
use. It's good to know that a lot of people have had success with
MySQL, but considering MySQL is the new comer, I'm still a little tep
I guess you can say I'm a follower. Other DB systems have been in use for
years, so their reliability has been generally proven through use. It's
good to know that a lot of people have had success with MySQL, but
considering MySQL is the new comer, I'm still a little tepid!
At 01:22 PM 12/18
Hey Lenz,
> Can you please try a "ldd /path/to/mysqld" and check, if it
> requires shared libraries or is a static binary?
Ok, here you go:
# ldd /usr/local/mysql-max-3.23.54a-pc-linux-i686/bin/mysqld
libdl.so.2 => /lib/libdl.so.2 (0x4002)
libpthread.so.0 => /lib/libpthread.so
That's the only thing wrong with Mysql is what it doesn't do.
Everything it does do it does fantastically.
> -Original Message-
> From: Michael T. Babcock [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, December 18, 2002 10:12 AM
> To: Michael She
> Cc: Qunfeng Dong; [EMAIL PROTECTED]; [EMA
Joseph Dietz wrote:
MediasMediaAuthorsAuthors
pk_media_id fk_media_id, fk_author_id pk_author_id
In your table definition, is there an index on each of your keys shown
above? What kind of performance 'degredation'? How many values are you
chec
Have you tried optimizing your query? It is more likely that the problem is
a poorly optimized query and/or poorly tuned server than it is mySQL. Joins
will be slow if you do not take the time to figure out the best way to do
what you are trying to accomplish. Forcing the table order can really
The real problem is the lack of a central knowledgebase. Is there one
that I'm not aware of? Even if there is, it should be very obvious off
the front page of the website.
> -Original Message-
> From: Csongor Fagyal [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, December 18, 2002 5:34 AM
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wed, 18 Dec 2002, Kees Hoekzema wrote:
> Recently I tried to upgrade MySQL to a newer version. I have
> 3.23.53a-max running but that is vulnarable to a bug. So I went to
> mysql.com and grabbed the .54a-max binary.
>
> First thing I noticed was th
Use "iostat -x" while the query is running. You are likely I/O bound doing a
table scan on the protected (BIG) table.
There has been alot of discussion about RAM and CPU on this thread regarding
performance, but nothing regarding disk I/O. If you're going to put tens of
millions of records in a da
Hello again,
I'm selecting a group of records from my database. I then loop through the
selected records and do some work based on what I find. But what I also
want to do as I interrogate each record is update some of its fields with
new values... but won't that screw up the outer loop? I mean
Joe Stump wrote:
Like previous posters have pointed out. If given the same freedom within
Oracle's online documentation you'd have to believe there would be horror
stories outlining loss of data.
The most significant factor I've ever seen in people liking Oracle for
their sites is the spee
Hello.
On Wed 2002-12-18 at 14:49:12 +, [EMAIL PROTECTED] wrote:
> Hi,
>
> I posted this a few days ago, but haven't seen a reply as yet, and I'm
> getting quite desperate now!!
You probably got no reply because there is no real solution to your
problem.
> I've managed to delete all the re
Michael Bacarella wrote:
We've never lost data. Our database server has crashed hard from OS failures
and suffered plenty of unclean shutdowns. MySQL/InnoDB always recovers
perfectly.
Running a slave off-site tops off crash recovery almost 100%. We run a
backup of our clients' data to mul
Hi!
I've just start to use MySQL on a Linux box. I didn't do any special,
just set it up via Webmin (create DB, add user). It is a RedHat 8.0 and
I use the MySQL inclued in the original distribution. From the Linux box
everything seems to work, but when I try to connect to the MySQL server
fro
At 13:05 12/18/2002, Csongor Fagyal, wrote:
>What you need to have is a _good_ install, and then MySQL is superb. But
>to have a "good install" is not as easy as it sounds.
Can you list the elements of a good install?
Start Here to Find It Fast!© -> http://www.US-Webmasters.com/best-start-page
Just for anyone who cares (or cares to do the same), when I reply to
messages at my average 80wpm and hit send, I don't check if
SQL,QUERY,etc. is in the message 90% of the time. Now, besides thanking
the crew for adding a couple more keywords to the filter, it still ticks
me off to get a bo
At 14:28 -0500 12/18/02, Michael T. Babcock wrote:
Paul DuBois wrote:
And take a look at the last few items in the list, pertaining to page
size, max number of pages, etc.
4 billion * 16kB = max table size = 64TB
Correct? Sounds pretty serious ;-)
That's what it looks like to me!
--
M
At 10:40 12/18/2002, Jocelyn Fournier wrote:
>Hi,
>
>I'm using MySQL on a database with 134 Millions of rows (10.9 GB) (some
>tables contains more than 40 millions of rows) under quite high stress
>(about 500 queries/sec avg). (using HEAP, MyISAM and InnoDB tables)
>I never experienced any losses
At 17:56 + 12/18/02, Jeff Snoxell wrote:
Hello again,
I'm selecting a group of records from my database. I then loop
through the selected records and do some work based on what I find.
But what I also want to do as I interrogate each record is update
some of its fields with new values... b
Qunfeng Dong wrote:
not-so-good performance (join on tables much smaller
than yours takes minutes even using index) and I seem
to read all the docs I could find on the web about how
to optimize but they are not working for me (I am
Have you stored a slow query log to run them through 'explai
On 12/18/02 9:48 AM, "Qunfeng Dong" <[EMAIL PROTECTED]> wrote:
> But I am indeed seeing
> not-so-good performance (join on tables much smaller
> than yours takes minutes even using index) and I seem
> to read all the docs I could find on the web about how
> to optimize but they are not working for
At 16:51 +0100 12/18/02, [EMAIL PROTECTED] wrote:
Hello
I have hade several problems with the character '-' (dash, minus, or
whatever you wan't to call it) the parser seems to regardles of quoting be
seen as an substraction operator.
Give us an example of where you use it within a quoted name a
At 10:10 -0500 12/18/02, Michael T. Babcock wrote:
Qunfeng Dong wrote:
Another thing, with some linux system, there is a size
limit for file. MySQL seems to store each of its table
as single file. You need to choose a file system
without that limit.
Just use InnoDB tables for these files and y
W. D. wrote:
At 10:40 12/18/2002, Jocelyn Fournier wrote:
Hi,
I'm using MySQL on a database with 134 Millions of rows (10.9 GB) (some
tables contains more than 40 millions of rows) under quite high stress
(about 500 queries/sec avg). (using HEAP, MyISAM and InnoDB tables)
I never experienced
I would like to create a web page that will extract the data from mysql so
it looks exactly like the form that the end user sees on their end.
Also a little bit off topic but I have a situation where it would be great
to have the web page form and it's data sent to an email address. I already
have
I believe I ran into this problem before, and I'm pretty sure that a back
tick will work.
NOTE: a backtick is not the same thing as a single quote
Using the backtick will also help you handle (and hopefully rename) tables
and so forth that accidentally or unknowingly use a reserved keyword.
usin
> From: Michael She [mailto:[EMAIL PROTECTED]]
> > > I have no problems using MySQL as a lightweight database
> for simple
> > > chores, but I'm a bit weary about putting into a mission critical
> > > environment.
> >
> >Why, exactly?
>
>
> Mainly for 2 reasons:
>
> 1. MySQL hasn't been "proven
I have about 300 database tables that are mostly ISAM and some MyISAM
format. I would like to move them all into MyISAM - what's the
easiest/quickest way? I am running 3.23.54.
I was thinking of doing mysqldump, then using a search/replace in the file
CREATE TABLE .. TYPE=, then recreating the dat
Lenz Grimmer wrote:
Sorry, but that would not be true. We actually *do* distribute most
binaries in gzipped tar archives. tar.gz is not limited to contain source
files only.
I posted a self-correction. I still think the download page is
unnecessarily misleading in some ways. Perhaps fixi
Joe is right ... we switched from another SQL server to MySQL in 1999, and
have never looked back.
MySQL has been rock solid for our applications, the MySQL development team
is great to work with, and our customers like it.
Gerald Jensen
- Original Message -
From: "Joe Stump" <[EMAIL PRO
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wed, 18 Dec 2002, Michael T. Babcock wrote:
> This binary/source confusion comes from the download page; it says
> "Binary packages (tar.gz)" for the source download and "Linux RPM
> packages (rpm)" for the binary package. Could someone please cha
PLATFORM: 3.23.52-max-nt with Windows 2000 professional (default table type)
I have discovered a performace issue when joining several tables together.
The performance is extremely poor when performing select queries using the
WHERE clause and joining the tables with the pk_media_id = fk_media_
Octavian Rasnita wrote:
Could you tell me if the following script is OK?
Note: It uses DBD::mysqlPP and not DBD::mysql, because only this module can
be used under Perl 5.8, but it should work the same.
I'm using DBD::mysql under PERL 5.8 right now ... FYI.
--
Michael T. Babcock
C.T.O., Fib
Hi,
I assume you are speaking about this comment :
"++--+--+--
+
| Table | Op | Msg_type |
Msg_text |
++--+--+--
+
| database.table_name | optimize | error | 28
when fixing table |
| da
1. MySQL hasn't been "proven" yet in the corporate environment
Is Yahoo! proven enough? Seriously, how many large corporations have to use
a DB in order for it to be "proven"? Is Access "proven" because every
company on the planet uses it at some level?
2. Some of the comments in the mySQL manual
> > > I have no problems using MySQL as a lightweight database for simple
> > > chores, but I'm a bit weary about putting into a mission critical
> > > environment.
> 1. MySQL hasn't been "proven" yet in the corporate environment
We run a periodic billing system backed with MySQL, in addition to
On Wed, Dec 18, 2002 at 12:16:00PM -0500, Michael She wrote:
> At 08:06 AM 12/18/2002 -0800, Jeremy Zawodny wrote:
>
> 1. MySQL hasn't been "proven" yet in the corporate environment
You mean in your corporate environment?
It works well in ours. :-) And we use it to store data that we serve
to mi
Michael She wrote:
2. Some of the comments in the mySQL manual... people losing data
doing routine stuff like table optimizations, adding keys, etc. If a
database is reliable, things like that shouldn't happen. Comments
like those in the MySQL manual scared me.
1) Do you believe this doe
> -Original Message-
> From: Joe Stump [mailto:[EMAIL PROTECTED]]
> We hit the 2gb file limit in Linux (NOT a MySQL problem) and
> moved to Solaris without incident.
This appears to have been largely fixed in Linux, too, if you use a recent
kernel and glibc. I recently tried creating
Previous hardware was a Bi PIII-733 with 786 MB of RAM, and 1 SCSI drive,
under Linux (kernel 2.4.18).
It worked fine, with sometimes some slowdown, mainly because of the hard
drive.
Now the server is Bi Athlon MP 2200+, 2 GB of RAM, and Maxtor Atlas 10K3
SCSI 320 (RAID-5) (still kernel 2.4.18)
The
Joe Stump wrote:
As Jeremy points out all DB's have their problems, shortcomings, etc. If you
have specific complaints fill out a feature request, if you've got problems
fill out a bug report, but don't knock MySQL as
There's a nice point on the MySQL site somewhere that if you really want
I am very encouraged to hear all these successful
proofs. I do want to stick to MySQL (we are using it
to develop a biology database). But I am indeed seeing
not-so-good performance (join on tables much smaller
than yours takes minutes even using index) and I seem
to read all the docs I could find
On Wed, 18 Dec 2002 16:36:15 +
ANGELO CARMO <[EMAIL PROTECTED]> wrote:
> When i try connect from WindowsXP machine to red hat 8.0 linux machine mysql
> server (4.05-max), I have the following message error:
>
> "ERROR 2013: Lost connection to mysql server during query".
>
> But, I can connec
heheh ... nice to see:
sql,query,queries,smallint
Re-clarification of my own message; the .tar.gz described as being a
binary is in fact a binary; my mistake. Again, since I found it
confusing, I'm assuming others will (and have) found it confusing. The
source distribution is at the very e
Hello all,
I'm trying to get a table from a text file with columns delimited by the "|"
sign and I can't do it right.
I've made a perl script that gets the file, parses it, and inserts the
variables into the table, but the problem is that the text contains
characters like " ' ?
I've tried using
At 08:06 AM 12/18/2002 -0800, Jeremy Zawodny wrote:
> I have no problems using MySQL as a lightweight database for simple
> chores, but I'm a bit weary about putting into a mission critical
> environment.
Why, exactly?
Mainly for 2 reasons:
1. MySQL hasn't been "proven" yet in the corporate
Is there anything on the books for implementing 'Views' both for read
and write, (esp. based on key relationships and joins?)
I know temporary tables give a form of view, but they aren't "live"
unless updated manually and one can't insert into them and have the
expected result.
-- Pseudo? SQL
Santiago Alba wrote:
I installed binary version (source distribution)... not with rpm
This binary/source confusion comes from the download page; it says
"Binary packages (tar.gz)" for the source download and "Linux RPM
packages (rpm)" for the binary package. Could someone please change
th
1 - 100 of 147 matches
Mail list logo
