On Thursday 08 November 2001 10:55 am, Paul DuBois wrote:
At 10:00 AM -0500 11/8/01, Tony wrote:
Does anyone know if putting (or grouping) varchar columns at the end of a
table provides any performance improvements? My indices are all integers,
but not have varchar columns in between several
At 5:46 PM -0500 11/8/01, Tony wrote:
On Thursday 08 November 2001 10:55 am, Paul DuBois wrote:
At 10:00 AM -0500 11/8/01, Tony wrote:
Does anyone know if putting (or grouping) varchar columns at the end of a
table provides any performance improvements? My indices are all integers,
but
Disclaimer: SQL/database newbie here.
Let's say I have a table of authors with columns for last name and first
name. Is there any general guideline re using a separate integer for the
primary key as opposed to a combination of the last and first names as the
key? I ask because by using the
Hi Jaska,
- Original Message -
From: Jaska A [EMAIL PROTECTED]
I'm interested in the subqueries, and thus interested in the schedule
of the
4.1. So, even if there is not (?) any precise information, what do
MySQL
developers/managers think that when will it be released?
The aim is
On Thu, Nov 08, 2001 at 05:46:35PM -0500, Tony wrote:
On Thursday 08 November 2001 10:55 am, Paul DuBois wrote:
At 10:00 AM -0500 11/8/01, Tony wrote:
Does anyone know if putting (or grouping) varchar columns at the end of a
table provides any performance improvements? My indices are all
That's not really true. You can use an auto_increment field as the primary
key and create a seperate UNIQUE index that combines both the firstname and
lastname fields that will be inforced for inserts.
Usually its easier to work with integers as primary keys, especially when
you reference them
Christian Stromberger wrote:
Disclaimer: SQL/database newbie here.
Let's say I have a table of authors with columns for last name and first
name. Is there any general guideline re using a separate integer for the
primary key as opposed to a combination of the last and first names as the
Disclaimer: SQL/database newbie here.
Nothing wrong with being a newbie :-)
Let's say I have a table of authors with columns for last name and first
name. Is there any general guideline re using a separate integer for the
primary key as opposed to a combination of the last and first names
So then is the real purpose of using varchars, to save disk space? ( I
realize this is probably a general database question, just
trying to learn).
+ your datafile will be smaller which saves disk IO. In the end, the extra
cost of the less efficient index as less than the gain from the
I mean a database is like a file.
a file in which there are written the rows in sequentially way.
for example:
NUMBER
2
65
...
45
5
If I tell to mysql to store these rows in order like:
NUMBER
1
4
...
55
99
NOTE: not ORDER BY but store in the database (or in file) in this way:
On Fri, Nov 09, 2001 at 12:46:33AM +0100, Carsten H. Pedersen wrote:
So then is the real purpose of using varchars, to save disk space? ( I
realize this is probably a general database question, just
trying to learn).
+ your datafile will be smaller which saves disk IO. In the end,
Hi,
Is MySQL 4.0 Alpha updated periodically with bugfixes? i.e. Is it worth
periodically re-downloading and re-installing MySQL 4.0 to ensure I have
the most stable version?
tnx,
~Mark.
-
Before posting, please check:
Hi
Is it possible to synchronize databases. Let me tell you the scenario. The
client lives out of town and wants to do point-of-sale at their place of
business. Internet connection is not very reliable. They already have a
comprehensive database that runs at an ISP in town.
I would like to
On Fri, Nov 09, 2001 at 12:46:33AM +0100, Carsten H. Pedersen wrote:
+ your datafile will be smaller which saves disk IO. In the end, the extra
cost of the less efficient index as less than the gain from the faster
access. So in the end you win speed.
huh?
With a variable record
When a new version is available it will have a new version number. The
current version is 4.0.0 but there will almost certainly be a 4.0.1
soon. If you look at the change history in the documentation, there have
already been changes put into 4.0.0.
If you need quicker access to changes, you
Question is there something wrong with this syntax when using the MYSQL
Update command in PHP , where I change the record by users editing the
fields on a web form then those are extracted to update a record in a
table.
Here's what I have tried I don't get any syntax errors with either of
these
Dear Noble X:
{I tried to email you but I failed, MISERABLY!! My AOL Screen Name, Cyberbean,
came with attachments, I hope this mail makes it through the border of all that is
good.
Please Help! Thanks!}
I am lost. I am a very VERY green newbie, and I am struggling on just how
So then is the real purpose of using varchars, to save disk space? ( I
realize this is probably a general database question, just
trying to learn).
+ your datafile will be smaller which saves disk IO. In the end, the extra
cost of the less efficient index as less than the gain from
I think there is a package on Window called PHPtriad that installs
Apache/MySQL/PHP all configured and everything for normal users (your case at
this level).
You should be able to find it trough download.com.
On Thursday 08 November 2001 04:26 pm, [EMAIL PROTECTED] wrote:
Dear Noble X:
$query1 = UPDATE Qusers SET $field_str WHERE UserName='$username';
$result2 = mysql_query($query1);
It should be:
update Qusers set field_name='$field_str' where username='$username';
-
Before posting, please check:
Question is there something wrong with this syntax when using the MYSQL
Update command in PHP , where I change the record by users editing the
fields on a web form then those are extracted to update a record in a
table.
Here's what I have tried I don't get any syntax errors with either of
Is this your email address? I can send you all the files you need.
Thank you,
Todd Williamsen, MCSE
home: 847.265.4692
Cell: 847.867.9427
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 08, 2001 6:27 PM
To: [EMAIL PROTECTED]
Subject:
Hello,
Are there any obvious reasons why
mysql -h localhost
works and
mysql -h 127.0.0.1
does not.
It says : ERROR 2003: Can't connect to MySQL server on '127.0.0.1'
(110)
/etc/hosts contain :
127.0.0.1 localhost
as a first line.
--
Best regards,
Alex
I am lost. I am a very VERY green newbie, and I am struggling on just how to
begin. Basically, I have
bought a book, entitled, PHP and MYSQL Web Development . , I have downloaded
mysql-3.23.43.tar.gz, the
install for windows document (yes I have not even made it passed the Install! Oh
I am writing a system that requires transactions. I understand that I need
to use Transaction-safe tables, such as BDB or InnoDB, but even when I do, I
get an error when I try to roll back my transaction.
Here is some SQL that illustrates my problem:
I create a table of type BDB (failure is
Please forgive the simplicity of the question, but I'm having
trouble reading between the lines regarding the JDBC interface.I
have the following simple code, which load the bridge driver, and then
attempts to connect to the driver. The system can't make the
connection. My question is
Anyone have a preferred JDBC for MySQL? I need a driver that will be
reliable under heavy load.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list
howdy.
i have a mysql backed php application.
has anyone ever come up with a (however kludgy) undo functionality for mysql in a php
app? based on keeping a history somewhere?
based on the update log?
i'm thinking of just making some innodb tables, using transactions, and forcing my
users to
Hi,
-Original Message-
From: Wally Flint [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 08, 2001 6:01 PM
To: Mysql mailing list
Subject: JDBC driver recommendatons
Anyone have a preferred JDBC for MySQL? I need a driver that will be
reliable under heavy load.
Yes. It is
Hi Michael,
-Original Message-
From: Michael Bitzko [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 08, 2001 5:57 PM
To: [EMAIL PROTECTED]
Subject: Simple JDBC Question
Please forgive the simplicity of the question, but I'm having
trouble reading between the lines
Hi~:
I do use a via chipset mother board.
Today I tried the option notail, it really works!!!
Thanks :)
Julian
PS: Do you have any idea about sgi's xfs?
From: George Eric R Contr AFSPC/CVYZ [EMAIL PROTECTED]
To: Z Julian [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: RE: run-all-tests
I just got back in from a nice day in the park with my kids and my parents.
All I can say to defend myself is that I'm sorry I did not bow to you thy King.
And I am sorry if I have my own opinions and personality. I will try to
conform asap to Big Brother's wishes.
And I am sorry that my
Jon,
It seems you are still in the planning stage. First, if you have good
documentation on the DB2 (i.e. ER Diagrams, schema etc.)
become familiar with those for the purpose of maintaining the logic
as you develop towards your MySQL sink. Know how applications
that run against the DB2
I have not read the MySQL license in detail.
Does it allow someone or a group to start another fork of the source that
is independent from the current developers?
If yes, is any one else interested in starting a fork in which the primary
goal would be to improve the smaller todos and
%% DownloadFAST.com [EMAIL PROTECTED] writes:
dc I have not read the MySQL license in detail.
MySQL is under the straight GPL.
--
---
Paul D. Smith [EMAIL PROTECTED] HASMAT--HA Software Mthds Tools
Please remain
So far, one developer of MySQL has emailed me and said he would help.
I propose we wait to see how many developers are interested, then take a
vote how to structure. If we don't get enough interested developers, then
I guess that means the proposal dies.
I am not interested in being in
It won`t alway give you better performance. But take a table like this:
(id int unsigned auto_increment,
emailadress char(255)
)
Suppose the average emailadress is 30 characters. If you have more than a
trivial amount of entrys you are wasting a lot of space. Space which all
has to be
Let's say I have a table of authors with columns for last name and first
name. Is there any general guideline re using a separate integer for the
primary key as opposed to a combination of the last and first names as the
key? I ask because by using the names, this would prevent
I'm looking for a programatic way to obtain the real FQDN of the myqld
server, not the one used to connect to the server. Here's the scenario,
several servers running mysqld are behind a virtual IP so when you connect
to mysqld you do not know which server you are really connected to. The
That's not really true. You can use an auto_increment field as the primary
key and create a seperate UNIQUE index that combines both the firstname and
lastname fields that will be inforced for inserts.
Usually its easier to work with integers as primary keys, especially when
you reference
I have not read the MySQL license in detail.
Does it allow someone or a group to start another fork of the source that
is independent from the current developers?
The MySQL source is under the GPL. Any fork must also be under the
GPL. You may sell your forked MySQL, but you must also
[snip]
The MySQL source is under the GPL. Any fork must also be under the
GPL. You may sell your forked MySQL, but you must also provide the
source code.
Thanks. No resistence from me about publishing source.
Even though I run a small site, I very much like the direction MySQL 4.0
is
I have been trying to write a client using Borland C++ 5.2 running on W2000.
The client needs to be text based not windows i.e. DOS!! (yeah yeah I
know...but this is required to run on an older slower machine with a very
large database). The problems are occuring at build time when I cannot seem
I think it would be more useful to work on the main branch and add extra
value to it, such as Heikki has done. That way all users of MySQL can
benefit from your fixes, etc.
IMHO I think this would be best too, I know I would like both the
newer/forthcoming features in the 4.x branch, but
Dear all
I have an application running in a small network where:
Machine 1 is the pdc for user authentication
Machine 2 is the mail Exchange server for emails/calendar/contacts
Machine 3 is the database server with (LDAP,Oracle, MSSQL and MYSQL)
MAchine 4 is the aplication + webserver for
Hi Shelby,
You wrote:
I would just want to be a contributor.
Excellent!
You, and anyone else, can be a contributor to MySQL development.
There is some special info in the manual about this:
http://www.mysql.com/doc/M/y/MySQL_internals.html
See also
Well I would try to leave that up to the people who want to be involved.
But I would say that a good place to start might be here:
http://www.mysql.com/doc/T/O/TODO_future.html
Speeding up the backlog of little things as priority over the major
structural changes, which IMHO are away from
Just so you know I am not blowing wind on possible speed enchancement,
please let me add that one of my former talents was assembler code. Not to
blow my own horn, but simply to state as fact relevant here, I was able to
speed up Painter's core paint routines by perhaps 30 - 50%. So although
On Thu, 2001-11-08 at 23:42, DownloadFAST.com wrote:
Just so you know I am not blowing wind on possible speed enchancement,
please let me add that one of my former talents was assembler code. Not to
blow my own horn, but simply to state as fact relevant here, I was able to
speed up
Hai,
We dont know exactly how to count spec hw (CPU+RAM) to handle
big database, the manual not cover it.
I mean everymonth always add complex data on several db,
than 1 year maybe handle 1 GB of data, how i count a
RAM and (or) CPU for speed. Any document or url where i
can read. We can
Steve I take your input very constructively and I personally will
definitely reconsider and contemplate more on your point.
In fact, I already emailed the developers yesterday, and asked if I could
pay to have the particular feature I wanted prioritized at this time. And
I don't think that was
MySQL crashes, when number of entries in table is
greater than some number 'X', in mf_radix.c file on
execution of a select query.
Optimization used: O2
Please suggest some approach to debug this crash.
It works fine with O0 optimization option.
52 matches
Mail list logo