At 03:59 AM 5/17/2004 -0700, you wrote:
On Intel - FreeBSD 4.9 STABLE
- using MySQL Ver 11.18 Distrib 3.23.55, for portbld-freebsd4.7 (i386)
On AMD64 - FreeBSD 5.2 CURRENT
- using Mysql Ver 14.3 Distrib 4.1.1-alpha, for portbld-freebsd5.2.1 (amd64)
I get the same compile error:
# make
make all-
"Brian Shearer" <[EMAIL PROTECTED]> wrote:
> I have a simple query:
> SELECT * FROM cart
> WHERE CartID=999 AND ProdID=333
>
> The primary key is made of both CartID and ProdID, both integers.
>
> The query will not return the record in question
>
> This returns the row:
> SELECT * FROM cart
> WHER
Hello all,
Using two tables :
R1 :
id
data
R2 :
id
pid
type
data
R2.pid reference R1.id
I would like to have a result set that is all the rows from R1 which are
not referenced by any row from R2, but all this only for a certain type
(R2.type)
I've done this :
SELECT R1.* from R1 left join R2
Jochen Kaechelin <[EMAIL PROTECTED]> wrote:
> Can somebody tell me what's wrong with this query:
>
> $sql="SELECT * INTO OUTFILE 'infoanforderung/$nameliste' FIELDS
> TERMINATED BY ';' LINES TERMINATED BY '\n' FROM net_contact WHERE
> nachname='Erbel'";
>
> I get no results! Without "INTO OUTFI
> SELECT R1.* from R1 left join R2 on (R1.id=R2.pid) where R2.id is NULL;
>
> The problem of such a statement is that the result set show me all the
rows
> from R1 which does not have ANY references in R2, and i would like to have
> all rows from R1, which does not have any rows of a certain type i
MySQL 4.0.18, Tru64 5.1B
The log partition filled up on one of our instances. RESET MASTER
fails with:
ERROR 1186: Binlog closed, cannot RESET MASTER
I deleted some older logs by hand, but RESET MASTER still fails.
FLUSH LOGS appears to succeed, but no binary logs are being written,
and RESET M
>> SELECT R1.* from R1 left join R2 on (R1.id=R2.pid) where R2.id is NULL;
>>
>> The problem of such a statement is that the result set show me all the
>rows
>> from R1 which does not have ANY references in R2, and i would like to
have
>> all rows from R1, which does not have any rows of a certain
Daniel Kasak wrote:
Andrew Barnes wrote:
When I run the "SHOW TABLE STATUS" query against a database with 4
tables, 3
of the tables come have the correct row count, but 1 table changes the
No of
rows every time I run the query. The correct row count for this table is
313, but the query returns an
I had similar problem on W2000 - the solution is not to use ... field
terminated by ';' ... but ...fields terminated by '\t'. I don't know why
semicolon causes this problem, but If I use \t then it works.
Jirka Matejka
- Original Message -
From: "Jochen Kaechelin" <[EMAIL PROTECTED]>
> >> SELECT R1.* from R1 left join R2 on (R1.id=R2.pid) where R2.id is NULL;
> What i need is to have a result that list only the R1 rows which does not
> have any references of type "D".
Aha, you have more than one record in R2 which is linked to R1.
Hmmm.. you can select the pid's from R2 which
>> >> SELECT R1.* from R1 left join R2 on (R1.id=R2.pid) where R2.id is
NULL;
>> What i need is to have a result that list only the R1 rows which does
not
>> have any references of type "D".
>
>Aha, you have more than one record in R2 which is linked to R1.
>
>Hmmm.. you can select the pid's from
Hi all,
I have a trouble with multiple-column indexes, I will try to describe it
with an example.
Suppose I have a table like the following one:
+++---+---+
| id_example | x_uno | x_due | x_desc|
+++---+---+
|
Hi,
is mysql the right kind of database for:
1) trying to add ~1 000 000 tiny rows per day (each row about 100 bytes
of data, about 20 bytes key)
2) adding only those rows which were not previously added on the same
day (some kind of UNIQUE index), leaving about 100 000 unique records
per day
3)
On Mon, May 17, 2004 at 08:43:44PM -0700, JG wrote:
>
> Has ANYONE been able to get super-smack-1.2 to compile as-is on FreeBSD?
>
> ./configure --with-mysql
> make
> make install
>
> Without errors?
No, it required various code changes. A colleague of mine made the
changes, I can probably get
Has anyone fooled around with LDAP and MySQL? Could the standard user table in mysql
be replaced with a LDAP binding? Have not done any research but I think I remeber
people talking about this some time ago. Or maybe I am mistaken ;). Anyone tried
something like this?
/Jonas
At 11:31 AM 5/18/2004 +0100, you wrote:
On Mon, May 17, 2004 at 08:43:44PM -0700, JG wrote:
>
> Has ANYONE been able to get super-smack-1.2 to compile as-is on FreeBSD?
>
> ./configure --with-mysql
> make
> make install
>
> Without errors?
No, it required various code changes. A colleague of mine m
On Tue, May 18, 2004 at 03:46:46AM -0700, JG wrote:
> At 11:31 AM 5/18/2004 +0100, you wrote:
> >On Mon, May 17, 2004 at 08:43:44PM -0700, JG wrote:
> >>
> >> Has ANYONE been able to get super-smack-1.2 to compile as-is on FreeBSD?
> >>
> >> ./configure --with-mysql
> >> make
> >> make install
> >>
Matt Mastrangelo <[EMAIL PROTECTED]> wrote:
> How can an InnoDB table be created with case sensitive collation? The
> example below creates two identical tables, one MyISAM and the other
> InnoDB. The InnoDB fails when inserting primary keys that differ in case
> only. What am I doing wrong?
Wh
Well, in order to enforce referential integrity, I converted the tables to
InnoDB. But referential integrity is still not being enforced. I use
mysql version 3-23-54-nt, and the tables are generated through the use of
dbdesigner (ver. 4.0.5.6 beta).
Here is a snippet of a "create" script:
==
I appologize if this is redundant for anyone who follows google
groups... Here's my post:
Via the tutorial at
http://www.analysisandsolutions.com/code/mybasic.htm,
I downloaded mySQL and have been running most things with sucess. In
case it is pertinent, I used the mysqld-max-nt --install command
I have to re-create a table every month with a section of data from the
main table. I suppose this would be an excellent situation to use views
for but being as how MySQL doesn't have view capability yet I'm stuck
with this. It's not a big deal but I just want to make sure that
Creating, populati
Hi Katherine,
Sometimes happens, unfortunately, things as this:
http://dev.mysql.com/doc/mysql/en/SHOW_WARNINGS.html:
Note that the framework for warnings was added in MySQL 4.1.0, at which
point many statements did not generate warnings. In 4.1.1, the situation is
much improved, with warnings g
Folks,
I have a couple of questions that I could not find the answer
at the MySQL docs or list archives. Hope you guys can help me.
We have a database with approximately 135 tables (MyISAM).
Most of them are small, but we have 5 tables, with 8.000.000
records. And that number is to incr
Philipp,
this is probably the bug that I fixed last night. It is present in all 3.23,
4.0 and 4.1 versions.
"
[EMAIL PROTECTED], 2004-05-18 01:53:06+03:00, [EMAIL PROTECTED]
mem0pool.c:
Fix a memory corruption bug: in 32-bit computers, every 4 billionth
malloc
outside innodb_additional_mem_
Hello,
I am working through a sql tutorial, and would like to perform this (written for
oracle) outer join using mysql.
SELECT A1.store_name, SUM(A2.Sales) SALES
FROM Georgraphy A1, Store_Information A2
WHERE A1.store_name = A2.store_name (+)
GROUP BY A1.store_name
I am reading the docs, bu
On Mon, May 17, 2004 at 04:07:53PM -0400, [EMAIL PROTECTED] wrote:
>
> SORRY
>
> My typo--- it is NOT ready for any kind of testing. At least I have not
> heard of anything
Heh :)
But do you know if anyone is already working on it?
Luis
I don't know of anyone yet. I don'
The (+) indicates an OUTER JOIN.
This should work:
SELECT A1.store_name, SUM(A2.Sales) SALES
FROM Georgraphy A1 LEFT JOIN Store_Information A2
ON A1.store_name = A2.store_name
GROUP BY A1.store_name;
Scott Purcell wrote:
Hello,
I am working through a sql tutorial, and would like to perform this (wr
Hi,
Before I go on, I know nothing about mysql, but my db admin is out of town
and I need to be pointed in the right direction please.
Running red hat 7.3, mysql-3.23.58-1.73, phpMyAdmin 2.5.0-rc2, in a virtual
hosting environment on Ensim webppliance-3.5.20-7.
When using phpMyAdmin and attempting
I'm using version 4.1.1-alpha, running on RedHat Linux 9.
Victoria Reznichenko wrote:
Matt Mastrangelo <[EMAIL PROTECTED]> wrote:
How can an InnoDB table be created with case sensitive collation? The
example below creates two identical tables, one MyISAM and the other
InnoDB. The InnoDB fails
"Ronnie Regev" <[EMAIL PROTECTED]> wrote:
> Hi,
> Before I go on, I know nothing about mysql, but my db admin is out of town
> and I need to be pointed in the right direction please.
> Running red hat 7.3, mysql-3.23.58-1.73, phpMyAdmin 2.5.0-rc2, in a virtual
> hosting environment on Ensim webppli
"Zachary Agatstein" <[EMAIL PROTECTED]> wrote:
> Well, in order to enforce referential integrity, I converted the tables to
> InnoDB. But referential integrity is still not being enforced. I use
> mysql version 3-23-54-nt, and the tables are generated through the use of
> dbdesigner (ver. 4.0
Hello everyone,
Is there a way to have the data in a table encrypted so that the MYD file
can't be opened with a text editor and read??? I need to encrypt or some
how make illegible numeric, date, text, and vchar fields.. Any idea???
Thanks for the help,
Tom T
--
MySQL General Mailing List
For
I've been to that page (http://dev.mysql.com/doc/mysql/en/SHOW_WARNINGS.html) and as
you said, there are supposed to be warnings now. Do you have any ideas why I can't
view them?
Kathy
>>> Renato Cramer <[EMAIL PROTECTED]> 05/18/04 9:30 AM >>>
Hi Kathy,
Excuse me for duplicity.
Renato.
I have set all privileges in the user table to yes, as follows:
Select_priv enum --Y
Insert_priv enum --Y
Update_priv enum --Y
Delete_priv enum --Y
Create_priv enum -- Y
Drop_priv enum --Y
Reload_priv enum --Y
Shutdown_priv
Hi!
InnoDB is a MySQL table type that provides FOREIGN KEY constraints,
transactions, row level locking and multiversioned concurrency control to
MySQL, as well as a commercial hot backup tool.
Release 4.0.20 is mainly a bugfix release, but there are also some important
functional changes. Releas
On Tue, 18 May 2004 10:38:25 -0400
Thomas Trutt <[EMAIL PROTECTED]> wrote:
> Hello everyone,
>
> Is there a way to have the data in a table encrypted so that
> the MYD file
> can't be opened with a text editor and read??? I need to encrypt or
> some how make illegible numeric, date,
On 18 May 2004, at 2:28 pm, RV Tec wrote:
Is MySQL able to handle such load with no problems/turbulences
at all? If so, what would be the best hardware/OS
configuration?
What is the largest DB known to MySQL community?
We regularly run databases with around 200 GB of data per instance,
Has anyone else experienced this bug?
http://bugs.mysql.com/bug.php?id=868
We've been seeing this problem on several of our servers (see the last
comment to the bug). MySQL just hangs occasionally, it happens about
3-4 times per month. We have 13 database servers, so that unfortunately
increas
I'm running version 4.1.1-alpha. The 3 select statements below on the
following test table produce inconsitent results:
create table test (test varchar(20)) charset latin1 collate
latin1_general_cs;
insert into test values ('abcField1');
insert into test values ('abcField2');
insert into test va
Mysql AB,
What is the roadmap for fully compliant GIS?
" The OpenGIS specification defines the following functions, which MySQL
does not yet implement. They should appear in future releases. When
implemented, they will provide full support for spatial analysis, not
just MBR-based support."
Tha
Hello
I am using MySQL v4.0.18. I am using the mysqldump program to do backups. I was
wondering how, if at all, does mysqldump preserver the auto_increment value?
When using phpmyadmin, there is an option to preserve the auto_increment value and the
resulting file has something like:
Gabe,
There are actually some problems caused by how auto increments are tracked
in the database. We do our backups by using mysqldump at night and
preserving all of the log files that were created during the day. The
problem occurs during recovery where auto increment values can be
incremented
At 09:15 AM 5/18/2004 -0700, you wrote:
does the myslqd user (probably mysql) have permissions to read the
/var/smack-data directory?
Cheers,
Trevor
JG wrote:
Trevor,
Yes & No.
I am doing a remote smack and super-smack is not installed on the remote
server.
(Should it be?)
On the local server,
At 11:53 -0400 5/18/04, Matt Mastrangelo wrote:
I'm running version 4.1.1-alpha. The 3 select statements below on
the following test table produce inconsitent results:
create table test (test varchar(20)) charset latin1 collate latin1_general_cs;
insert into test values ('abcField1');
insert into
I was wondering if there's a way to set a field to be a pattern of another
field in the same table, ie:
numberfile
1 xyz_1.jpg
2 xyz_2.jpg
3 xyz_3.jpg
.
.
nxyz_n.jpg
I'm achieving this through php but was curious to know if you could do it
James Tusini <[EMAIL PROTECTED]> wrote:
> I was wondering if there's a way to set a field to be a pattern of another
> field in the same table, ie:
>
> numberfile
> 1 xyz_1.jpg
> 2 xyz_2.jpg
> 3 xyz_3.jpg
> .
> .
> nxyz_n.jpg
>
>
> I'm ach
I'm looking for some queries or resources to help me create queries with
these date ranges. IE, I have a DB that I want to pull things out of if
they fall within this range.
Since the beginning of this week
Since the beginning of this business week
7 days from today
This month to date
Last Mont
At 18:07 +0100 5/18/04, James Tusini wrote:
I was wondering if there's a way to set a field to be a pattern of another
field in the same table, ie:
numberfile
1 xyz_1.jpg
2 xyz_2.jpg
3 xyz_3.jpg
.
.
nxyz_n.jpg
I'm achieving this through php but wa
Hi,
I am installing MySQL to a single board computer with the ARM7 processor
and 32M of RAM, running Linux.
I was able to successfully cross compile and now run the MySQL server,
but even with my-small.cnf and tweaking values down it consumes all but
a few megs of my RAM, and I need at least 15M
I am using mysql 4.0.12 max-nt on Windows XP.
I have a master table with an int column as a primary key (bom_id) and a
second table that has a foreign key reference to the master column and
uses it as part of a composite key (bom_id, fc_date). Example:
**
bom_mstr
p
Folks, Tim,
Oops! Forgot to mention that... we are running MySQL 4.0.18.
Thanks a lot!
Best regards,
RV Tec
On Tue, 18 May 2004, Tim Cutts wrote:
>
> On 18 May 2004, at 2:28 pm, RV Tec wrote:
>
> >
> > Is MySQL able to handle such load with no problems/turbulences
> > at all? If so, what
Steve Meyers wrote:
Has anyone else experienced this bug?
http://bugs.mysql.com/bug.php?id=868
We've been seeing this problem on several of our servers (see the last
comment to the bug). MySQL just hangs occasionally, it happens about
3-4 times per month. We have 13 database servers, so that un
I do a small web hosting company and one of the ongoing issues we have is
keeping mysql user's passwords in sync with ldap/local passwords. Right
now I have a script in place to try and keep things in sync when they
change their local ldap password but it doesn't always work and it feels
like
I would first see if an upgrade to a later version of InnoDB tables is
possible.
What is being written to the error log?
The ALTER TABLE statement subtly creates a new table, with new contraint
names that the child table is unaware of, and drops the original table. Have
you tried rebuilding the chi
MySQL manual Chapter 13 Section 5
-Original Message-
From: Charles King
To: [EMAIL PROTECTED]
Sent: 5/18/04 12:32 PM
Subject: Help with date queries
I'm looking for some queries or resources to help me create queries with
these date ranges. IE, I have a DB that I want to pull things out
Steve,
I have had this same problem exept the entire server does not hang, only
one thread which experiences a signficiat slowdown. This happens a
couple times a week for our 4 servers. I believe this is a thread
scheduling issue. The mysql support team suggests against using NPTL.
However, I u
Sasha Pachev said:
> Steve Meyers wrote:
>> Has anyone else experienced this bug?
>>
>> http://bugs.mysql.com/bug.php?id=868
>>
>> We've been seeing this problem on several of our servers (see the last
>> comment to the bug). MySQL just hangs occasionally, it happens about
>> 3-4 times per month
Heikki Tuuri wrote:
> Release 4.0.20 is mainly a bugfix release, but there are also some
> important functional changes. Release 4.0.19 was completely skipped
> over because Bug #3596 might have caused segmentation faults on some
> platforms. The changelog below lists all the changes since 4.0.18.
Here's my table:
CREATE TABLE 'data' (
'junk' char(10) NOT NULL default '',
PRIMARY KEY ('junk')
) TYPE=MyISAM;
There are about 1.7 million 10-character long strings. A query like this one
takes about 5 seconds:
SELECT junk FROM data WHERE junk='xx';
Subsequent queries for the same
Can you use the actual IP address and get it to work? If so, then ping
localhost and ping tux and make sure the IP that you believe it should be is
actually being returned.
Lou
- Original Message -
From: "Timothy Waters" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, May 18,
What is the cardinality of the `junk` column? What does an EXPLAIN Plan
show?
-Original Message-
From: Jacob Elder
To: [EMAIL PROTECTED]
Sent: 5/18/04 1:22 PM
Subject: Simple table, 1.7 million rows, very slow SELECTs
Here's my table:
CREATE TABLE 'data' (
'junk' char(10) NOT NULL de
> There are about 1.7 million 10-character long strings. A query like this
one
> takes about 5 seconds:
>
> SELECT junk FROM data WHERE junk='xx';
>
> Subsequent queries for the same string return right away.
That's because you have the mysql query cache enabled and mysql can return
the an
On Tue 18 May 02004 at 08:49:05PM +0200, Jigal van Hemert wrote:
> > There are about 1.7 million 10-character long strings. A query like this
> one
> > takes about 5 seconds:
> >
> > SELECT junk FROM data WHERE junk='xx';
> >
> > Subsequent queries for the same string return right away.
>
On Tue 18 May 02004 at 01:47:25PM -0500, Victor Pendleton wrote:
> What is the cardinality of the `junk` column? What does an EXPLAIN Plan
> show?
>
mysql> explain select junk from data where junk='xx';
+-+---+---+-+-+--+-+
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Mark wrote:
| Heikki Tuuri wrote:
|
|
|>Release 4.0.20 is mainly a bugfix release, but there are also some
|>important functional changes. Release 4.0.19 was completely skipped
|>over because Bug #3596 might have caused segmentation faults on some
|>pla
>From this explain plan it appears a full table scan will be done. What is
the cardinality of this index?
-Original Message-
From: [EMAIL PROTECTED]
To: Victor Pendleton
Cc: '[EMAIL PROTECTED] '
Sent: 5/18/04 1:54 PM
Subject: Re: Simple table, 1.7 million rows, very slow SELECTs
On Tue 18
Any particular reason to use 2.4.x vs 2.6.x from kernel for base?
2.6 has not been around long enough to prove itself, in my opinion. I know 2.4
will work well, but I cannot say the same about 2.6 with the same degree of
confidence.
--
Sasha Pachev
Create online surveys at http://www.surveyz.co
The error log shows nothing when the binary dies. I can't rebuild the
child table - anything that touches the child table after the alter
stops the binary.
-Original Message-
From: Victor Pendleton [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 18, 2004 2:07 PM
To: 'Rich Schramm '; '[EMAIL
On Tue 18 May 02004 at 02:03:55PM -0500, Victor Pendleton wrote:
> From this explain plan it appears a full table scan will be done. What is
> the cardinality of this index?
>
Actually, they are phone numbers. I wasn't sure how this list would feel
about this but I am wring a National Do-Not-Call
I am working on doing backups of a MySQl server that is running approx 20
databases. Our failover is to do a nightly scp of all /data directory from
one server to the backup. I know that replication or mysqldump would be
best, but I do not want to get into that.
My question is what is the bes
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Mark wrote:
| Heikki Tuuri wrote:
|
|
|>Release 4.0.20 is mainly a bugfix release, but there are also some
|>important functional changes. Release 4.0.19 was completely skipped
|>over because Bug #3596 might have caused segmentation faults on some
|>pla
Is that the only table in your MySQL installation?
MyISAM primary keys are put in a b-tree index, which is cached by MySQL
in memory in the key_buffer_size parameter. What is it set to on your
system (the my.cnf file, probably in /etc or /var)?
The second time you run it, the index is definately
Mysqlians,
I just discovered that a server has ft_min_word_len=4 when I want
ft_min_word_len=3 . Do I have to rebuild all the fulltext indicies so
that searches on three-letter words will work correctly?
Trevor
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
At 12:30 -0700 5/18/04, Trevor Price wrote:
Mysqlians,
I just discovered that a server has ft_min_word_len=4 when I
want ft_min_word_len=3 . Do I have to rebuild all the fulltext
indicies so that searches on three-letter words will work correctly?
Yes.
Question:
Did you find some place in
I have a site that is being hosted by an ISP which is running version
3.23.52. When I questioned why that downlevel version and not a 4.0
version (such as 4.0.18 or the just released 4.0.20), I was told
"Unfortunately, when versions change on MySQL, they also drop
features and change security s
In this case creating separate columns and making the values integers as
oppesed to varchar will increase your query speed.
-Original Message-
From: Jacob Elder
To: Victor Pendleton
Cc: '[EMAIL PROTECTED] '; ''[EMAIL PROTECTED] ' '
Sent: 5/18/04 2:11 PM
Subject: Re: Simple table, 1.7 mill
Can you mysqldump the table then rebuild the table from the dump file?
-Original Message-
From: Rich Schramm
To: 'Victor Pendleton'; [EMAIL PROTECTED]
Sent: 5/18/04 2:04 PM
Subject: RE: Alter table primary key and foreign keys
The error log shows nothing when the binary dies. I can't reb
Are you using only MyISAM or InnoDB tables? With the InnoDB tables you have
the possibility of data not yet being committed. Either way, unless you can
flush, lock and perform the dump and transfer all in one swoop you risk
incosistency using this method.
-Original Message-
From: Ben Rick
On Tue 18 May 02004 at 12:26:41PM -0700, David Griffiths wrote:
>
> Is that the only table in your MySQL installation?
Yes, and no one has access to it yet but me.
>
> MyISAM primary keys are put in a b-tree index, which is cached by MySQL
> in memory in the key_buffer_size parameter. What is
On Tue 18 May 02004 at 02:48:45PM -0500, Victor Pendleton wrote:
> In this case creating separate columns and making the values integers as
> oppesed to varchar will increase your query speed.
Okay, I'll give that a try. How do I set up my column types so that a
leading 0 won't be stripped off?
I believe all the tables are MyISAM...the DB is 3.2.x.
I know there will be an inconsistency as we only do nightly backups; any
transactions that occur before the scp will not be there. If we failover
before the backup, we can have up to 24 hours of data missing.
I am concerned that we will
At 15:46 -0400 5/18/04, Robert A. Rosenberg wrote:
I have a site that is being hosted by an ISP which is running
version 3.23.52. When I questioned why that downlevel version and
not a 4.0 version (such as 4.0.18 or the just released 4.0.20), I
was told "Unfortunately, when versions change on My
I just did an upgrade from 3.23.54a to 4.0.18 for 4 DB servers. It was a
piece of cake. Some hints:
1) Run through the docs on changes from previous versions. Someone who
understands the DBs you will be moving would be helpful to look at it as
well.
2) that stuff about "security settings" i
Hmm... I didn't have to upgrade our DBD drivers when we moved from
3.23.57 to 4.0.18. Strange you had to. Do you remember your old DBD
driver's version? Or was that only Win32 problem?
- Original Message -
From: "Mark" <[EMAIL PROTECTED]>
To: "Heikki Tuuri" <[EMAIL PROTECTED]>;
<[EMAIL P
If I am correct, the NUMERIC data type is a string representation and will
contain leading zeroes if input as a string.
...
CREATE TABLE numbersTest (numCol NUMERIC(3));
INSERT INTO numbersTest VALUES('212'), ('069'), ('070');
...
The values with leading zeroes should be returned.
...
Create an ind
Sorry, the variable is actually "key_buffer_size" (I don't use MyISAM);
I'm not sure what it defaults to, but the typical recommendation is 25%
of your memory.
You can tell if your cache is effective by looking at the key_reads and
key_read_requests (from the MySQL window, type "SHOW STATUS" wi
Jacob,
Don't worry about storing the leading the zeroes. Just left pad the
subscriber column to be 4 digits on output and you should be golden. MySQL
has a function just to generate left-padded numbers:
LPAD(subscriber,4,'0')
Yours,
Shawn Green
Database Administrator
Unimin Corporation - Spruce
Mihail Manolov wrote:
>>> Release 4.0.20 is mainly a bugfix release, but there are also some
>>> important functional changes. Release 4.0.19 was completely skipped
>>> over because Bug #3596 might have caused segmentation faults on some
>>> platforms. The changelog below lists all the changes sin
We have a MySQL server that is a backend processing server that in about 60
days will probably run out of disk space. The data cannot be archived off,
because it is always used and changed many times a day. The server
currently has 6 72 gig SCSI 15k drives in it. We have it raided with 2
drives
On Tue 18 May 02004 at 04:53:52PM -0400, [EMAIL PROTECTED] wrote:
>
> Jacob,
>
> Don't worry about storing the leading the zeroes. Just left pad the
> subscriber column to be 4 digits on output and you should be golden. MySQL
> has a function just to generate left-padded numbers:
>
> LPAD(subscr
I think I've got most of the basics of MySQL under
control now, and I'd like to ask a question about
formatting table data. I've learned to insert html in
my tables. For example, the following cell includes
the code for proper apostrophes and quotation marks:
Land of the Midnight Sun, The Last
Fro
Ben Ricker wrote:
I believe all the tables are MyISAM...the DB is 3.2.x.
I know there will be an inconsistency as we only do nightly backups; any
transactions that occur before the scp will not be there. If we failover
before the backup, we can have up to 24 hours of data missing.
I am concerned
When I query I don’t see the value of some primary
key, I don’t understand why, Can you tell me?
Thank You
Sid Taleb
Information
Technology Manager
Credico Marketing
100 Alexis-Nihon, Suite
650
Montréal, Québec
H4M 2P2, CANADA
Tel: 1-866-CREDICO
(1-866-273-3426) ext. 252
Local: (51
We have one query which takes approximately 2 minutes. MySql seems to be
unresponsive to any other threads until this query has completed.
Are there some settings that aid with this kind of problem?
TIA
Dan
Dear List:
I wonder if there exist a type of table which can allow for unlimited or at
least more than 1024 columns? I know MaxDB has 1024 max columns.
Please give me a hint if you could. Thanks in advance!
Hongyu
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
T
Hi, I need some help with an insert issue.
I have two tables, organizations and contacts.
Every contact relates back to an organization
Organizations has org_id, org_name, and org_address, etc
Contacts has contact_id, contact_name, contact_address and a foreign key
called c_org_id.
contact_id an
I was hoping to store some fairly large blocks of text
in a MySQL table, like brief accounts for all 50
states, such as this:
"South Dakota was long known as the Sunshine
State because it’s state motto, which was
depicted on the state flag, was “Sunshine
State.” In 1980, the motto, flag, and nickn
> I hear what you're saying about memory, but I really don't understand why
a
> btree lookup would be so dramatically slow compared to a linear search
with
> grep. Would something other than MyISAM be more appropriate here?
If you feel that a linear search is faster, why not try to let MySQL IGNOR
Use the blob/text, mediumblob/mediumtext or longblob/longtext types.
Since you are just storing text, use the text versions.
It sounds like when you say "text" what you really mean is the varchar()
type. If you declare a field as a text type, you can store 2^16
characters, or 65,536 characte
> I checked The Manual, which confirmed that 255
> characters is indeed the limit for text entries. But I
> wondered if there might be some workaround. If not,
> I'll just limit myself to smaller bytes!
At http://dev.mysql.com/doc/mysql/en/BLOB.html you can read about the BLOB
and TEXT column type
1 - 100 of 116 matches
Mail list logo
