| Key_blocks_used | 1687734 |
It won't seem to go over 1687734. I have constantly growing indexed
tables, so it's not a matter of all the keys being in memory. I've
restarted the server, and it still stops at that number. my.cnf has
key_buffer = 3072M, and indeed:
| key_buffer_size
I'm trying to learn how to join tables, but I'm doing
something wrong. I've found lots of examples that look
easy, but something isn't clicking.
I think part of the confusion stems from the dynamic
tables I was creating with Dreamweaver. I thought they
were a necessary part of the equation, when t
Jon,
an update statement is supposed to return the # of rows updated, so the
client must wait for a response, which means the client will wait if you
low_priority your updates. But if they are insert delayed then the
client gets a return immediately. This behavior limits the usefullness
of low
--- Randy Clamons <[EMAIL PROTECTED]> wrote:
"Primary key names start with pk_, unique indexes
start with uk_, other indexes start wiht ix_."
That's a good tip. What if just named the primary key
pk and the foreign key fk. Would you run into trouble
if you're working with two or three tables, and
John Mistler wrote:
Hmmm. The reason I asked was that the last column in the table is TEXT, and
might contain up to 5000 text characters. I'm trying to make the query as
efficient as possible, and I don't know if that much data will make a
noticeable speed difference?
Thanks,
John
on 5/14/04 2:31
Reiser is good for lots of small files. ext3 would is better for
large ones. At least that's what I get from the benchmark data that I've
seen posted in various places.
Curtis
--
Curtis Maurand
mailto:[EMAIL PROTECTED]
http://www.maurand.com
On Wed, 12 May 2004, Roy Butler wrote:
Jacob,
I'd go
On Fri, May 14, 2004 at 04:29:29PM -0500, Dan Nelson wrote:
> In the last episode (May 14), Jeremy Zawodny said:
> > On Fri, May 14, 2004 at 03:26:28PM -0500, Donny Simonton wrote:
> > > Actually, if you are using 4.1.1 optimize table does get passed to
> > > the slave. This is from the 4.1.1 chan
Hmmm. The reason I asked was that the last column in the table is TEXT, and
might contain up to 5000 text characters. I'm trying to make the query as
efficient as possible, and I don't know if that much data will make a
noticeable speed difference?
Thanks,
John
on 5/14/04 2:31 PM, Justin Swanh
--- John Mistler <[EMAIL PROTECTED]> wrote:
> Is there a SELECT statement, if I have a table with
> 50 columns, to select
> every column EXCEPT the last one? Can I do this
> without typing the name of
> all 49 columns?
>
> If so, then what if I want to exclude the last TWO
> columns?
>
> Thanks,
Yes.
> -Original Message-
> From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]
> Sent: Friday, May 14, 2004 4:26 PM
> To: Donny Simonton
> Cc: [EMAIL PROTECTED]; 'Jim'
> Subject: Re: OPTIMIZE TABLE and mySQL replication
>
> On Fri, May 14, 2004 at 03:26:28PM -0500, Donny Simonton wrote:
> > A
It surprised me at first, but then I was actually happy about it.
Donny
> -Original Message-
> From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]
> Sent: Friday, May 14, 2004 4:26 PM
> To: Donny Simonton
> Cc: [EMAIL PROTECTED]; 'Jim'
> Subject: Re: OPTIMIZE TABLE and mySQL replication
>
> O
In the last episode (May 14), Jeremy Zawodny said:
> On Fri, May 14, 2004 at 03:26:28PM -0500, Donny Simonton wrote:
> > Actually, if you are using 4.1.1 optimize table does get passed to
> > the slave. This is from the 4.1.1 change log.
> >
> > ANALYZE TABLE, OPTIMIZE TABLE, REPAIR TABLE, and FL
On Fri, May 14, 2004 at 03:26:28PM -0500, Donny Simonton wrote:
> Actually, if you are using 4.1.1 optimize table does get passed to the
> slave. This is from the 4.1.1 change log.
>
> ANALYZE TABLE, OPTIMIZE TABLE, REPAIR TABLE, and FLUSH statements are now
> stored in the binary log and thus re
At 15:57 -0400 5/14/04, Lou Olsten wrote:
Is there a way to set this dynamically?
The associated system variable is table_type, not default_table_type.
SET table_type = xxx;
SET SESSION table_type = xxx;
SET GLOBAL table_type = xxx;
Thanks,
Lou
--
Paul DuBois, MySQL Documentation Team
Madison, Wi
Jeremy Zawodny wrote:
On Fri, May 14, 2004 at 03:10:05PM -0400, Jim wrote:
Hi List,
What are some issues relating to using OPTIMIZE TABLE and replication?
Does running OPTIMIZE TABLE on a master DB cause the optimizations to be
passed on to the slaves?
It does not. The command doesn't replicate
Actually, if you are using 4.1.1 optimize table does get passed to the
slave. This is from the 4.1.1 change log.
ANALYZE TABLE, OPTIMIZE TABLE, REPAIR TABLE, and FLUSH statements are now
stored in the binary log and thus replicated to slaves. This logging does
not occur if the optional NO_WRITE_T
Is there a way to set this dynamically?
Thanks,
Lou
On Fri, May 14, 2004 at 03:10:05PM -0400, Jim wrote:
> Hi List,
>
> What are some issues relating to using OPTIMIZE TABLE and replication?
> Does running OPTIMIZE TABLE on a master DB cause the optimizations to be
> passed on to the slaves?
It does not. The command doesn't replicate.
--
Jerem
In the last episode (May 14), Dan Nelson said:
> In the last episode (May 14), Jim said:
> > What are some issues relating to using OPTIMIZE TABLE and
> > replication? Does running OPTIMIZE TABLE on a master DB cause the
> > optimizations to be passed on to the slaves?
>
> Yes, unless you add the
In the last episode (May 14), Jim said:
> What are some issues relating to using OPTIMIZE TABLE and
> replication? Does running OPTIMIZE TABLE on a master DB cause the
> optimizations to be passed on to the slaves?
Yes, unless you add the "LOCAL" flag to optimize.
http://dev.mysql.com/doc/mysql/
Hi List,
What are some issues relating to using OPTIMIZE TABLE and replication?
Does running OPTIMIZE TABLE on a master DB cause the optimizations to be
passed on to the slaves?
Thanks,
Jim
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://li
--- Sasha Pachev <[EMAIL PROTECTED]> wrote:
> Very possibly a bug. INNODB deadlocks itself during
> the operation, then detects
> the deadlock and aborts the transaction. If this is
> indeed a bug, I am sure
> Heikki would like to fix it ASAP.
There actually was a "create index" that was being
--- "PARTHA DUTTA, BLOOMBERG/ 499 PARK"
<[EMAIL PROTECTED]> wrote:
> Hello all, I would like to find out if anyone has
> implemented an architecture
> where a hardware load balancer is placed in front of
> some MySQL servers in a
> Multi-master replication scheme. I want to use the
> load balanc
You shutdown the server and copy the files back.
Jones, William (NIH/CIT) wrote:
I am evaluating mysql for use at our organization. One thing I have not
been able to determine from the documentation is -- once I've taken a backup
via mysqlhotcopy, how do I restore the database from that backup whe
I am evaluating mysql for use at our organization. One thing I have not
been able to determine from the documentation is -- once I've taken a backup
via mysqlhotcopy, how do I restore the database from that backup when
necessary?
William K. Jones
Chief, Database Systems Branch, DCSS, CIT
[EMAIL
There's a quick install guide on the MySQL site, which has most of what
you've listed:
http://dev.mysql.com/doc/mysql/en/Quick_install.html
The INSTALL-SOURCE doc which comes in the tarball covers the process in
great detail.
There may be others, those are two I've used.
Kamal Ahmed wrote:
All,
Hi list,
does MySQL accept a SELECT inside another SELECT, like this:
SELECT t.Trial_ID_Code AS Trial,
CONCAT(s.Site_Primary_Investigator_Title, " ",
s.Site_Primary_Investigator_Last_Name) AS 'Investigator',
CONCAT(sc.Site_ID_Number, "-", s.Site_ID_Code, "-", sc.Scanner_ID_Number)
AS Site,
s
--- Joshua Beall <[EMAIL PROTECTED]> wrote:
> AFAIK 112,249 is not an integer. It is a string.
> If you need to have the
> commas, you need to store it as a string.
I haven't got to strings yet. The table I'm making is
for display purposes, so I want visitors to be able to
see 10,212, rather t
At 10:17 -0700 5/14/04, David Blomstrom wrote:
--- Joshua Beall <[EMAIL PROTECTED]> wrote:
AFAIK 112,249 is not an integer. It is a string.
If you need to have the
commas, you need to store it as a string.
I haven't got to strings yet. The table I'm making is
for display purposes, so I want vis
Is there a SELECT statement, if I have a table with 50 columns, to select
every column EXCEPT the last one? Can I do this without typing the name of
all 49 columns?
If so, then what if I want to exclude the last TWO columns?
Thanks,
John
--
MySQL General Mailing List
For list archives: http:
--- Joshua Beall <[EMAIL PROTECTED]> wrote:
> AFAIK 112,249 is not an integer. It is a string.
> If you need to have the
> commas, you need to store it as a string.
I haven't got to strings yet. The table I'm making is
for display purposes, so I want visitors to be able to
see 10,212, rather th
Joshua Beall wrote:
Hi All,
MySQL 4.0.18-standard on RHEL3, 2.4.21-15.ELsmp kernel.
I have a table on one a moderate traffic site, and yesterday I had my client
notify me that some of the pages were not working. Note that most of the
page content is stored in a table called "pageContent".
Now, ab
Dear All,
Hello
is it advised not to do an upgrade on a Mysql 4.x to latest MySQL?
What if the 4.x version is installed at installation time of say, RHL8, can an upgrade
then be done afterwards to latest version?
Just looking for any recommendations, etc
Thanks in advance!~
Carlos
Hi All,
I'm reading "High Performance MySQL". In my humble opinion is an very good
book.
Congratulations to the authors.
In the chapter "Load Balancing and High Availability" is cited the Tony
Bourke's book "Server Load Balancing".
Someone read it? is one good reference font?
I need study this
Sorry - haven't had a chance to respond till now.
> > So "restore" == "apply-log", but one works on any computer, and the
other
> > only works on the computer that it's node locked to.
> --apply-log works also in any computer regardless of the hostname or the
> license expiration date.
I'm runn
"David Blomstrom" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> When I try to import my csv file in MySQL-Front, it
> appears to get hung up on every integer - or perhaps
> it's just every integer in the first integer field.
>
> When it cites an error, it only lists the numerals
> a
All,
I am looking for a stepwise installation of mysql-3.23.58 on Redhat 9.
and have a hard time finding it on the MySql web site. Could someone
e-mail me the steps, please.
There should also be a section on installing databases, in order to make
sure that MySql is running and is operational
Th
I have database Zope
I run following command and get error
myql> grant all on Zope.* to [EMAIL PROTECTED];
ERROR 1044: Access denied for user: '[EMAIL PROTECTED]' to database 'Zope'
mysql>
As a consequece I try to access Zope from a web, it also shows me the
error.
how can i fix this problem?
At 8:34 -0700 5/14/04, David Blomstrom wrote:
When I try to import my csv file in MySQL-Front, it
appears to get hung up on every integer - or perhaps
it's just every integer in the first integer field.
When it cites an error, it only lists the numerals
after the comma. For example, it says 249 for
In the last episode (May 14), David Blomstrom said:
> When I try to import my csv file in MySQL-Front, it appears to get
> hung up on every integer - or perhaps it's just every integer in the
> first integer field.
>
> When it cites an error, it only lists the numerals after the comma.
> For examp
When I try to import my csv file in MySQL-Front, it
appears to get hung up on every integer - or perhaps
it's just every integer in the first integer field.
When it cites an error, it only lists the numerals
after the comma. For example, it says 249 for this
sample from my csv file:
"112,249","al
Hi All,
MySQL 4.0.18-standard on RHEL3, 2.4.21-15.ELsmp kernel.
I have a table on one a moderate traffic site, and yesterday I had my client
notify me that some of the pages were not working. Note that most of the
page content is stored in a table called "pageContent".
Now, about half the page
Dathan Vance Pattishall wrote:
log-bin=/var/opt/mysql/db2-binlog
skip-innodb
log-error=/var/opt/mysql/db2-errlog
This is on a separate drive?
yes, the database is the only thing on the high speed RAID. everything
else is on the other drive (also a RAID but only RAID0 with 2 drives).
any ideas
> I'm thinking on the server with Apache I guess you would just compile
Apache with the mysql/php and in your php scripts just point to the hostname
of the mysql server? Making sure you can talk to port 3306.
>
It's not a very big problem (loads of people have done it before you).
- Make sure php
Just a thought - but do your web pages actually display all 150K records at once? YOu
may want to change how your page requests and do
limits, and just do grabs at 100 at a time, or so. UNless of course you are
processing all 150K in one big calculation of some sort - but then, I
wouldnt do t
Is there a good tutorial on installing Mysql on one machine and having Apache on
another?
I'm thinking on the server with Apache I guess you would just compile Apache with the
mysql/php and in your php scripts just point to the hostname of the mysql server?
Making sure you can talk to port 330
Dean,
Seems your database has a table with foreign key constraints. You need to delete
that table first and then you will be able to drop database successfully.
Hope that helps!!!
Raza
-Original Message-
From: Dean A. Hoover [mailto:[EMAIL PROTECTED]
Sent: Friday, May 14, 2004 4:13 A
MySQL 4.0.14
regards
--- Rhino <[EMAIL PROTECTED]> wrote: > What version
of MySQL are you running? The answer to
> your question depends
> on the version.
>
> Rhino
>
> - Original Message -
> From: "A Z" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Friday, May 14, 2004 9:00
On Fri, 14 May 2004 14:00:46 +0100 (BST)
A Z <[EMAIL PROTECTED]> wrote:
> Hi,
>
> How can I write this query?
>
> Insert into table1 (field1) select (a.field1) from
> table2 a where a.field1 not exists (select c.field1
> from table1 c)
http://dev.mysql.com/doc/mysql/en/Rewriting_subqueries.html
What version of MySQL are you running? The answer to your question depends
on the version.
Rhino
- Original Message -
From: "A Z" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, May 14, 2004 9:00 AM
Subject: Exists
> Hi,
>
> How can I write this query?
>
> Insert into table1
Hi,
How can I write this query?
Insert into table1 (field1) select (a.field1) from
table2 a where a.field1 not exists (select c.field1
from table1 c)
regards
Yahoo! Messenger - Communicate instantl
Hi,
I know this may not strictly be within the remit of this mailing list
but.
I am having problems with my web host, I need to use Innodb tables, however
my web host will not allow these table types (because of the obvious extra
overhead), can anybody out there recommend/currently use a
Hi.
- Original Message -
From: "Hans-Peter Grimm" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, May 14, 2004 2:53 AM
Subject: Comments/questions on "High Performance MySQL"
>
> Hi,
>
> I just finished reading "High Performance MySQL". Congratulations to the
> authors, it's a
Dear Sir,
As MySQL is included in this distribution. I install it together with
RedHat. Do you know what do I need to do to make it start and working? I
cannot find related document from www.mysql.com.
Thanks,
Joseph
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysq
Hello,
I am not a guru in mysql. Please somebody help me, Weather what I have
done is correct or not.
I created a replication cluster in mysql using two machines. machine A
replicates to Machine B
machine B replicates to Machine A. and heartbeat is used to give a
service ipaddress.
I tested it
On 14 May 2004, at 1:14 am, Dathan Vance Pattishall wrote:
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 13, 2004 4:03 PM
To: Dathan Vance Pattishall
Cc: 'Tim Cutts'; 'MySQL List'
Subject: Re: InnoDB filesystem
On Thu, May 13, 2004 at 04:51:27PM -0
version: mysql Ver 12.22 Distrib 4.0.18, for pc-linux (i686)
mysql> DROP DATABASE xxx;
ERROR 1217: Cannot delete or update a parent row: a foreign key
constraint fails
what is this all about? how the heck can I drop the database?
Dean Hoover
--
MySQL General Mailing List
For list archives: ht
On 14 May 2004, at 4:37 am, Roy Butler wrote:
Jacob,
>> I'd go with Reiser on SuSE.
>
> What about Reiser on Debian?
I'd choose SuSE since Reiser is their default filesystem and they have
been an early implementor of Reiser-related patches. If you use Linux
kernel 2.4.24 (or later) and the lat
58 matches
Mail list logo
