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.
___
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
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 assummi
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 Pai
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
al
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 MySQL
What specific issues are you focusing on?
DownloadFAST.com wrote:
> More points about proposed wsSQL:
>
> 1. Another point is that any changes in a separate fork can always be
> integrated back into the main fork. Nothing is stopping that. I am just
> proposing some advantages as to why it
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
http://www.mysql.com/doc/I/n/Installing_
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 Develo
More points about proposed wsSQL:
1. Another point is that any changes in a separate fork can always be
integrated back into the main fork. Nothing is stopping that. I am just
proposing some advantages as to why it shouldn't be the minor fork's
responsibility to do that.
2. I would not decide
> 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
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
[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 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 als
> 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 referen
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
get_hos
> > 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 d
>
> 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
> h
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 control.
%% "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
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 performance
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 databa
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 apol
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-test
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
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.
Ye
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 c
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 arc
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 t
>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
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
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 mailto:[
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: lo
> 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
> $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:
ht
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:
>
>
>
> > > 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
On Fri, Nov 09, 2001 at 01:24:57AM +0100, Carsten H. Pedersen wrote:
> > > > But, it is all explaind in the manual :)
> > >
> > > Exactly where in the manual did you find that piece of information?
> >
> > 5.4.2 Get Your Data as Small as Possible
> ...
> >
> > But i read the advise literally so
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 to
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
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 ca
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
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 s
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:
http
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
> 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 f
> > 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 fro
> 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 nam
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 th
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 in
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
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
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 name
On Thu, Nov 08, 2001 at 04:16:50PM -0500, [EMAIL PROTECTED] wrote:
>
> Is there anyone out there who is successfully replicating between two MySQL
> 3.23.43 servers?
>
I have replication running between three .43 servers. All are InnoDB tables
and all seem to be working fine. Ask for more detai
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,
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 s
56 matches
Mail list logo
