Loosing one table [one data file] is less affecting than 10.
My view is that MySQL is good because it uses different data files. If one
data file gets corrupt, you will loose less information since it is only one
table [meaning one data file] that is affected.
I am not an expert though!!
Loosing one table [one data file] is less affecting than 10.
My view is that MySQL is good because it uses different data files. If one
data file gets corrupt, you will loose less information since it is only
one
table [meaning one data file] that is affected.
I am not an expert
Hi Mike,
I've asked this question a year ago on the Borland forums but didn't get
any replies. Do you know of any websites (non-programming related) that
are
using Interbase/Firebird for their primary webserver database? I don't
mean
programmer hangouts like www.mers.com or www.tamaracka.com
Hi,
Jerry,
Interbase/Firebird looks good on paper. But there are a
couple of
things to watch out for.
1) Check the Borland Interbase newsgroups for corruption to see if
it is
still an issue. I know from reading their newsgroups a few years back
,
there were quite a
On Dec 17, 2003, at 7:35 AM, Matthew Stanfield wrote:
Wouldn't it be great if all mailing lists and newsgroups were as
friendly and helpful as the mysql ones are.
shameless plug
I host a couple of lists: ProLinux and ProPython, which are for
developers that are new to Linux and Python, and
Jerry Apfelbaum wrote:
I have been tasked with evaluating open source databases for a large
upcoming project: e-commerce, B2B, high availability.
Jerry -- See what I meant when I said:
very active mailing lists where list subscribers are helpful and quick to
respond.
I think we all deserve a
Yes, Matthew, the response to my original query here has been almost overwhelming, far
surpassing what I had expected.
Yes, you certainly all deserve a pat on the back.
Thanks to everyone who took the time to respond. This has proven to be a useful short
cut to ascertaining some of strengths
Martijn,
I've asked this question a year ago on the Borland forums but didn't get
any replies. Do you know of any websites (non-programming related) that are
using Interbase/Firebird for their primary webserver database? I don't mean
programmer hangouts like www.mers.com or www.tamaracka.com
Looking at the facts, the number of files used to store your data is of
very little consequence at the end of the day. Looking
at the following:
* MS SQL Server stores database data in a single file and logs in another.
* Oracle and FoxPro both have a pretty large number of files, for very
Hi!
--cut
To be honest, the vast majority of database installations experience
problems in performance caused by poor query and schema design,
bad application logic or grossly underspecified hardware. A change in
the number of files used to store the data is extremely unlikely
to resolve
Dr. Frank Ullrich wrote:
Hi!
--cut
To be honest, the vast majority of database installations experience
problems in performance caused by poor query and schema design,
bad application logic or grossly underspecified hardware. A change in
the number of files used to store the data is extremely
Jeremy Zawodny wrote:
On Tue, Dec 16, 2003 at 12:01:55PM +0700, David Garamond wrote:
Sven K?hler wrote:
I was very disappointed by Interbase/Firebird. It seemed to me like a
MS-Access: a database-engine that works on regular files
Firebird seems simple, but it doesn't mean it's
Chris Nolan wrote:
Regarding mysqldump, it handles binary data through escaping the
required characters. pg_dump is similar if memory serves me correctly.
Thanks Chris.
So dumping binary data / large objects using myslqdump is fine. I looked up
if this is ok with pg_dump as well and it is but
Usually, i'll use enum('0','1') in place of a boolean type.
Curtis
For JDBC stuff, I've found that if you really want to call this a
shortcoming, then that's about as far as you can take it
- the MySQL JDBC driver makes the BIT field act just like a single-bit
field.
Regards,
Chris
Sure --
Matthew Stanfield wrote:
Usually, i'll use enum('0','1') in place of a boolean type.
Curtis
For JDBC stuff, I've found that if you really want to call this a
shortcoming, then that's about as far as you can take it
- the MySQL JDBC driver makes the BIT field act just like a
single-bit field.
To be honest, the vast majority of database installations experience
problems in performance caused by poor query and schema design,
bad application logic or grossly underspecified hardware. A change in
the number of files used to store the data is extremely unlikely
to resolve these
David Griffiths wrote:
To be honest, the vast majority of database installations experience
problems in performance caused by poor query and schema design,
bad application logic or grossly underspecified hardware. A change in
the number of files used to store the data is extremely unlikely
to
High-end database systems perfer more files, as they can be spread across
multiple (usually fast SCSI) disks. Most databases recommend logs be kept
on
seperate disks than database files.
Changes in the number of files can resolve problems if the problems are
the
result of low disk IO and
At 01:59 PM 12/14/2003, you wrote:
Hello.
I have been tasked with evaluating open source databases for a large
upcoming project: e-commerce, B2B, high availability.
The O/S is most likely to be Linux, although FreeBSD could possibly be used
(lower probability).
So far, it seems that MySQL,
Hi,
Many Thanks.
Jerry Apfelbaum
Toronto
Jerry,
Interbase/Firebird looks good on paper. But there are a couple of
things to watch out for.
1) Check the Borland Interbase newsgroups for corruption to see if it is
still an issue. I know from reading their newsgroups a few years
32-bit filesystem limits?
Looking at any modern Linux FS, your file size limits are not hindered
by 32-bit anything or even
the FS itself. On kernel 2.4, internal kernel structures limit the
maximum size of block devices to around 1 TB.
As a result, you can only have files of about that size
At 04:07 PM 12/16/2003, you wrote:
Hi,
Many Thanks.
Jerry Apfelbaum
Toronto
Jerry,
Interbase/Firebird looks good on paper. But there are a couple of
things to watch out for.
1) Check the Borland Interbase newsgroups for corruption to see if it is
still an issue. I know from
Hi,
So far, it seems that MySQL, MaxDB, PostgreSQL, and Interbase/Firebird
are
possible candidates.
Does anyone know why we should or should not use any of these? Does
anyone
know of other possibilities?
I was very disappointed by Interbase/Firebird. It seemed to me like a
So far, it seems that MySQL, MaxDB, PostgreSQL, and Interbase/Firebird are
possible candidates.
Does anyone know why we should or should not use any of these? Does anyone
know of other possibilities?
I was very disappointed by Interbase/Firebird. It seemed to me like a
MS-Access: a
It is a mystery to me how the PostGreSQL work. I cannot recomm to use
any feature discovered in PostGreSQL since some of the more uncommon
feature are broken.
Would you care to elaborate? I've used both PostgreSQL and mySQL, but
certainly not all features, and I'm curious about what issues
Huh? Not know how to backup a MySQL database? *sigh*
Every night, I do a backup of our MySQL database server that's holding
all of our mail and various other things (20GB+).
I set the isolation level to READ_REPEATABLE and use mysqldump | bzip2
to get the result. I've tested the restore and
I was very disappointed by Interbase/Firebird. It seemed to me like a
MS-Access: a database-engine that works on regular files
What gave you that idea? Firebird (and InterBase of course) use
a at least 1 file per database, but that's all. Can you define
regular files?
My idea of Firebird is the
Hi Sven,
I was very disappointed by Interbase/Firebird. It seemed to me like a
MS-Access: a database-engine that works on regular files
What gave you that idea? Firebird (and InterBase of course) use
a at least 1 file per database, but that's all. Can you define
regular files?
My
Sven Köhler wrote:
I was very disappointed by Interbase/Firebird. It seemed to me like a
MS-Access: a database-engine that works on regular files
What gave you that idea? Firebird (and InterBase of course) use
a at least 1 file per database, but that's all. Can you define
regular files?
My
Firebird/Interbase have all those nice things like row-level locking
(although it doesn't seem to have multiversioning like InnoDB,
PostgreSQL or Oracle), deadlock detection, prepared statements, views,
Yes it DOES have multi-versioning. Actually, I believe it was the
first (InterBase that is)
Martijn Tonies wrote:
Firebird/Interbase have all those nice things like row-level locking
(although it doesn't seem to have multiversioning like InnoDB,
PostgreSQL or Oracle), deadlock detection, prepared statements, views,
Yes it DOES have multi-versioning. Actually, I believe it was the
Hi Chris,
Firebird/Interbase have all those nice things like row-level locking
(although it doesn't seem to have multiversioning like InnoDB,
PostgreSQL or Oracle), deadlock detection, prepared statements, views,
Yes it DOES have multi-versioning. Actually, I believe it was the
first
I set the isolation level to READ_REPEATABLE and use mysqldump | bzip2
to get the result. I've tested the restore and it's fine!
So how does mysqldump handle binary data?
If it does embed the data into the SQL-statement somehow, that's crap,
since SQL-Statements are limited in length.
--
MySQL
Are they? Shoving in rows that are several meg in size didn't pose any
problems. The restore procedure looked like this:
bunzip2 dumpfile | mysql -u db_grunt -p projectdb
May I ask where the limitation you mentioned is documented? Maybe the
situations we were using it in didn't come close to
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Am Sonntag, 14. Dezember 2003 20:59 schrieb Jerry Apfelbaum:
Hello.
I have been tasked with evaluating open source databases for a large
upcoming project: e-commerce, B2B, high availability.
So, you should choose SapDB 7.3 or 7.4 due License
Sven Köhler wrote:
I set the isolation level to READ_REPEATABLE and use mysqldump |
bzip2 to get the result. I've tested the restore and it's fine!
So how does mysqldump handle binary data?
If it does embed the data into the SQL-statement somehow, that's crap,
since
Tobias Asplund wrote:
Sven Köhler wrote:
I set the isolation level to READ_REPEATABLE and use mysqldump |
bzip2 to get the result. I've tested the restore and it's fine!
So how does mysqldump handle binary data?
If it does embed the data into the SQL-statement somehow, that's
Hi,
I've used both PostgreSQL and MySQL on a Linux server and found both
setting up (using RPM) and maintaining them very easy (MySQL was slightly
easier to set up but I set it up after I was already proficient on
PostgreSQL, so perhaps comparing the ease of setup is unfair). Both are
well
Matthew Stanfield said:
Hi,
Usually, i'll use enum('0','1') in place of a boolean type.
Curtis
[snip]
well. The only annoying thing I can think of, from a programming
perspective, is MySQL's lack of a Boolean type - the manual says use
TINYINT(1) which works fine but is slightly
Hi,
Regarding backups, mysqlhotcopy locks all MyISAM tables named for backup
before copying the files. As a result, they are in a consistant state.
InnoDB and BDB tables need to be handled differently though, so you're
looking at 1 of 4 methods:
1. Shut the database down and copy the table
Curtis Maurand wrote:
Matthew Stanfield said:
Hi,
Usually, i'll use enum('0','1') in place of a boolean type.
Curtis
[snip]
For JDBC stuff, I've found that if you really want to call this a
shortcoming, then that's about as far as you can take it
- the MySQL JDBC driver makes the
On Tue, Dec 16, 2003 at 01:11:21AM +1100, Chris Nolan wrote:
To backup those funky sleek MyISAM tables, you could just issue a
LOCK TABLE statement or two (LOCK DATABASE?), do a FLUSH and copy
the files. If I recall correctly, (and I'm sure sirs DuBois and
Zawodny will find out where I live
I have only recently started these evaluations. BTW, my own background is
from the Oracle DBA world.
MySQL is certainly popular and seems to have very good performance, but I am
concerned that the lack of Triggers, Stored Procedures, User-Defined
Functions, and Views (to a lesser degree )
Sven Köhler wrote:
I was very disappointed by Interbase/Firebird. It seemed to me like a
MS-Access: a database-engine that works on regular files
Firebird seems simple, but it doesn't mean it's inferior or
[intentionally] crippled like MS-Access. SQL server also works on
regular files (db is
On Tue, Dec 16, 2003 at 12:01:55PM +0700, David Garamond wrote:
Sven K?hler wrote:
I was very disappointed by Interbase/Firebird. It seemed to me like a
MS-Access: a database-engine that works on regular files
Firebird seems simple, but it doesn't mean it's inferior or
[intentionally]
45 matches
Mail list logo