Hi!
Sinisa == Sinisa Milivojevic [EMAIL PROTECTED] writes:
Sinisa Adam Douglas writes:
I'm running MySQL v3.22.32. Here's my problem I run the following
select query and both CompanyRep and PostalCodeInfo tables are not
using my Indexing. Why? How can I get these two tables to use indexing
I downloaded, compiled, and installed the latest MySQL release from the
source code at www.mysql.com last night. I was running through the tests
documented in the INSTALL-SOURCE file, and I've found that mysqladmin -u
root shutdown does not work. I've done a ps and I can still see the
mysqld
Description:
binary test failed on Mac OS X Server 1.2 using mysql 3.23.40. Problem
appears with both binary distribution and built from source according to manual
instructions.
How-To-Repeat:
make test
Fix:
not known.
Submitter-Id: submitter ID
Originator:David Cake
I was watching the log for errors, but none occurred. I absolutely lost
at what this could be. I just did a mysql_install_db (and deleted the
old) thinking maybe a permission might be messed up. We'll see if that
helps.
Chris Hilbert
-Original Message-
From: Werner Stuerenburg
sarahana schrieb am Freitag, 3. August 2001, 03:07:31:
If mysql is shown when runnnig phpinfo() - does it mean that its installed,
and if yes, why this error?
this only shows that php is compiled with mysql support.
thanks, what needs to ben done?
I assume you work under win.
You need to
Hello,
I just checked the list for answer to this question and looks like there
hasn't been one. I have a similar problem, I want to delete a record
from a table where the value of the field is equal to the value of a
field in another table.
delete from table1 where table1.column =
On Sat, Aug 04, 2001 at 12:46:06AM -0700, Eric Fegraus wrote:
I just checked the list for answer to this question and looks like
there hasn't been one. I have a similar problem, I want to delete a
record from a table where the value of the field is equal to the
value of a field in another
On Fri, Aug 03, 2001 at 03:35:11PM -0700, L. S. wrote:
Is there Embedded SQL support for MySQL?
There is some embedded work goin on in the 4.0 (development) branch of
MySQL. The manual describes how to get access to the 4.0 tree if
you'd like to check it out.
Jeremy
--
Jeremy D. Zawodny,
Adam Douglas writes:
Ahh what do you mean all tables are not related with common columns? They
are not suppose to be related with a common columns. PostalCodeInfo and
Company table are completely two different things.
Yes that is correct, I've resolved the issue with PostalCodeInfo for
On Fri, Aug 03, 2001 at 03:42:28AM -0700, Van wrote:
Mario Witte wrote:
Memory or motherboard. How many sticks of RAM do you have in the machine? Are
they the same speed (p100/p133, etc.)? What kind of motherboard? Is updatedb
running at this time? (might be a hard-drive croaking while
What is better:
CREATE INDEX ix1(field1, field2, field3);
or
CREATE INDEX ix1(field1), ix2(field2), ix3(field3);
I have a large table of some 30,000,000 records and am wondering
which indexing gives better performance and why.
How do I optimize search on this table - I'm using lots of OR
Mario Witte wrote:
On Fri, Aug 03, 2001 at 03:42:28AM -0700, Van wrote:
Mario Witte wrote:
Memory or motherboard. How many sticks of RAM do you have in the machine? Are
they the same speed (p100/p133, etc.)? What kind of motherboard? Is updatedb
running at this time? (might be a
Well, sometimes I use all of the fields in the SELECT statement,
sometimes just one.
How about if I create both indexes?
How would it affect the performance? I don't care about update time as i
insert or update records at night only once a day.
Thanks for the answer
- Original Message -
Eric Fegraus writes:
Hello,
I just checked the list for answer to this question and looks like there
hasn't been one. I have a similar problem, I want to delete a record
from a table where the value of the field is equal to the value of a
field in another table.
delete from table1 where
Kevin X Lin writes:
Hi there,
I'm running into problems with functions floor/ceiling when I use
Visual Basic to talk to mySQL through myODBC.
My code looks like this:
sSQL = select floor(3.2)
Set rs = MySQL_conn.Execute(sSQL)
I got rs.eof = true after execution of the query. However
Nick Seidenman writes:
Apparentlly there's a 4 GB limit to a MyISAM file when the table it contains
has VARCHAR, TEXT, or BLOB columns. In order to get around this limitation I
was looking to switching to InnoDB table types. As this looks like a
relatively new subsystem I'm wondering
Charles Mégnin writes:
I am getting an error message
Can't connect to local MySQL server through socket '' (111)
trying to connect via mySQLgui on my Linux box running RH6.2
I do have a
/tmp/mysql.sock
with proper authorizations
and have no problem connecting to the serverwithout the
Nick:
What O/S are you running ... Windows?
To the best of my knowledge, MySQL doesn't impose file size limits ... that
is dictated by the O/S's file system. Switching to InnoDB wouldn't change
that.
Gerald Jensen
- Original Message -
From: Nick Seidenman [EMAIL PROTECTED]
To: [EMAIL
I have a reproducible but it's not easy to reproduce. It involves a complex
transaction that gets rolled back instead of committed.
Cal
Innobase: Assertion failure in thread 8201 in file trx0roll.c line 887
Innobase: we intentionally generate a memory trap.
Innobase: Send a bug report to [EMAIL
On Saturday 04 August 2001 09:25, Sinisa Milivojevic wrote:
Nick Seidenman writes:
Apparentlly there's a 4 GB limit to a MyISAM file when the table it
contains has VARCHAR, TEXT, or BLOB columns. In order to get around this
There is no 4 Gb limit in MyISAM with later 3.23 versions.
I an
Hi!
What InnoDB version you are using? A bad rollback
bug was fixed in version 3.23.39.
Regards,
Heikki
At 05:40 PM 8/4/01 +0300, you wrote:
Content-Type: message/rfc822
Content-Description: forwarded message
Content-Transfer-Encoding: 7bit
MIME-Version: 1.0
Content-Type: text/plain;
Description:
mysql refuses connection [local/unix-socket] when client is ran under GDB,
and linked with pthread library. It doesn't need to call any pthread_*()
function, it just fails when linked with it.
How-To-Repeat:
#include stdio.h
#include mysql/mysql.h
Hi,
Sorry to have bothered everyone. I was using .38. I just noticed that and
am currently building .40.
Cal
http://www.calevans.com
-Original Message-
From: Heikki Tuuri [mailto:[EMAIL PROTECTED]]
Sent: Saturday, August 04, 2001 9:59 AM
To: Sinisa Milivojevic; [EMAIL PROTECTED];
please,
i downloaded the mysql 3.23 from your site and i
made the unzip
and when i begin to make setup i found error:
missing setup.dll
what can i do?
please reply fast
[EMAIL PROTECTED]
yasmeen
-
Before posting, please
At 18:29 04/08/2001 +0300, Hiba Muhrez wrote:
Hi,
When you unzipped the 3.23.40 distribution file you should
have the following files:
02/08/2001 00:31 128 DATA.TAG
02/08/2001 00:31 11.535.662 data1.cab
30/05/1997 11:314.557 lang.dat
02/08/2001
On Sat, Aug 04, 2001 at 09:15:52AM -0500, Gerald R. Jensen wrote:
To the best of my knowledge, MySQL doesn't impose file size limits
... that is dictated by the O/S's file system. Switching to InnoDB
wouldn't change that.
But InnoDB would let you use multiple tablespaces to get around any
I have just subscribed to this list, so forgive me if my question has been
answered many times before but I was not sure where else to find this
information.
I am new to mysql and am going to be using it on a website that I maintain.
My question is, is there a program/utility or easy way to
there are a number of ways you could accomplish this.
depending on how large the database is, you may want to try exporting it
to csv (comma separated value) format, and then importing it into mysql,
using either the load command, or a third-party utility like phpmyadmin
(which is what i
Greetings ALL:
I am developing a database application using mySQL php for a client
that requires data entry (at least) to be in Arabic.
I am know that mySQL supports charsets, but it is not clear if it
supports charsets that are not left-to-right, such as Arabic.
If the answer to this is
On 04 Aug 2001 22:57:39 +0300, Khaled I. Hammouda wrote:
Greetings ALL:
I am developing a database application using mySQL php for a client
that requires data entry (at least) to be in Arabic.
I am know that mySQL supports charsets, but it is not clear if it
supports charsets that are
On 04 Aug 2001 16:25:14 +0300, Sinisa Milivojevic wrote:
There is no 4 Gb limit in MyISAM with later 3.23 versions.
This limit is imposed by a filesystem only.
and RAIDed table can help to build aby size tables if only index
file doesn't get too big.
Actually InnoDB is nice thing.
Is there a place that outlines the advantages/disadvantages of both
MyISAM and InnoDB?
Thanks,
Chris
-Original Message-
From: Tonu Samuel [mailto:[EMAIL PROTECTED]]
Sent: Saturday, August 04, 2001 2:34 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: Thinking of switching from
hi all...
i have a mysql query as follows:
SELECT *,
( if((description LIKE '%keyword_one%'), 1, 0)+
if((description LIKE '%keyword_two%'), 1, 0)+
if((description LIKE '%keyword_three%'), 1, 0)+
if((description LIKE '%keyword_four%'), 1, 0) ) as keyword_score,
FROM
If you want a MyISAM table to grow larger than 4GB you have to do
alter table tablename max_rows=1
or maybe its 'maxrows'...
Once you do that, you will be able to stuff the table as full as the OS will
let you.
Innobase will allow you to get around this by making a bunch of smaller
Hi everybody,
I got a problem with the mysqldump function.
I connect to mySql trough phpMyAdmin, select the database xyz, which
is the only database on the server.
Then I enter the following string into the text field Run SQL
query/queries on database xyz::
mysqldump xyz | mysql
Hello!
Let me introduce myself. My name is Mr. Rajesh Tavakari from
www.website-promotion-ranking-services.com, and you can contact
me at [EMAIL PROTECTED] or [EMAIL PROTECTED]
I enjoyed visiting your interesting site at http://www.mysql.com/documentation/. You
may know that having high
36 matches
Mail list logo