On Tue, Jan 26, 2010 at 11:23 AM, Keith Murphy wrote:
> You absolutely *should not* convert the mysql database to InnoDB.
>
> Read the above sentence again :)
>
> All others, unless you had a specific reason not to do so, yes, I would
> convert them.
>
> keith
>
> On Tue, Jan 26, 2010 at 2:18 PM,
Daevid Vincent wrote:
-Original Message-
From: Dan Nelson [mailto:dnel...@allantgroup.com]
Sent: Monday, January 25, 2010 11:42 PM
To: Daevid Vincent
...snipped ...
People really use Windows for a mySQL server? Weird.
...
Yes, they do.
Not only is MySQL as cheap as the free versio
-Original Message-
From: Daevid Vincent
Sent: 26 January 2010 21:50
To: dnel...@allantgroup.com
Cc: mysql@lists.mysql.com
Subject: RE: Event feature already working in Server 5.1.37
> People really use Windows for a mySQL server? Weird.
I'm seem to remember reading somewhere that Wind
> -Original Message-
> From: Dan Nelson [mailto:dnel...@allantgroup.com]
> Sent: Monday, January 25, 2010 11:42 PM
> To: Daevid Vincent
>
> For a hosted environment (or a restricted corporate
> environment), it means you don't have to give your users
> shell accounts; they can schedule
You absolutely *should not* convert the mysql database to InnoDB.
Read the above sentence again :)
All others, unless you had a specific reason not to do so, yes, I would
convert them.
keith
On Tue, Jan 26, 2010 at 2:18 PM, John G. Heim wrote:
> Just to be clear, you're suggesting I convert a
Just to be clear, you're suggesting I convert all of the spamassassin,
drupal, and mediawiki tables to innodb too? Or just my own database? What
about the mysql database itself? I wouldn't convert those tables, would I?
- Original Message -
From: "Keith Murphy"
To:
Sent: Tuesday, Ja
Please forgive my ignorance. Going from update to replace and left the
'where' part of the statement. Definitely a "DOH!" moment.
--
John C. Nichel IV
System Administrator
KegWorks
http://www.kegworks.com
716.362.9212 x16
j...@kegworks.com
> -Original Message-
> From: John Nichel [mail
I have a query that is giving me fits, but I can't find where there
error is. I know its one of those things that I'll slap myself in the
forehead for not seeing, but after a half an hour, it's all a blur. ;)
If someone can spot it, I'd be most grateful.
REPLACE INTO product_dimensions SET `prod
Krishna Chandra Prajapati wrote:
Hi shawn,
As the data grows to 20 millions the insert rate will become very slow.
In such case i am getting 2000 insert/seconds only.
Therefore my objective is not achieved.
I cannot slow up the insert rate of 10,000/second. I am getting data
(inserted by us
spikerl...@gmx.de wrote:
Hello,
we want to set the global variable ft_min_word_len from the default "four" to the value
"three".
This is needed because we want to search for words with the max. length of
three characters in one application.
I've read that after setting ft_min_word_len to the
Philipp Maske [Location Bretagne] wrote:
Hi,
I just wanted to remark, that the Event feature is already working in server
version 5.1.37 (installed on Debian).
In tech resources is mentioned that this feature would be available since
version 5.1.6 (see
http://dev.mysql.com/tech-resource
Introduction to the Drizzle Microkernel
http://forge.mysql.com/wiki/Introduction_to_the_Drizzle_Microkernel
This Thursday (January 28th, 17:00 UTC), we'll be resuming our MySQL
University sessions with an Introduction to the Drizzle Microkernel by
Brian Aker. Brian is located on the US West coast,
♫
I would recommend the same to you about reading High Perf. MySQL as Baron,
et al wrote a great book about performance on MySQL. That being said, it has
been my experience that in 99% of client cases they don't really need to run
two different types of tables. If I were you, I would use InnoDB exc
Hello,
we want to set the global variable ft_min_word_len from the default "four" to
the value "three".
This is needed because we want to search for words with the max. length of
three characters in one application.
I've read that after setting ft_min_word_len to the new value, a "REPAIR TABLE
Get yourself a copy of the book High Performance MySQL 2nd Edition
Publisher: O'Reilly Media; 2 edition (June 18, 2008) Language: English
ISBN-10: 0596101716 ISBN-13: 978-0596101718
Here is a brief preview of the first edition:
http://books.google.ca/books?id=iaCCQ13_zMIC&printsec=frontcover&d
From: "Jaime Crespo Rincón"
Sent: Monday, January 25, 2010 5:30 PM
2010/1/25 John G. Heim :
I have a server with 16Gb of RAM and a dual-core 2Ghz processor. It is
running the latest mysql-server from debian lenny (5.0.1). I have
databases
for drupal, moodle, spamassassin, horde3, and a small
Yeah, Paul...
This is so clear...the auto_increment column may be indexed like:
- KEY();
- UNIQUE();
- PRIMARY KEY()
...when you create or alter a table.
--
Wagner Bianchi
2010/1/25 Paul DuBois
The requirement is that it be indexed. The index need not be a primary key.
>
> mysql> cre
On Tue, Jan 26, 2010 at 12:21 AM, Daevid Vincent wrote:
>
> * at
> * /etc/crontab
> * /var/spool/crontabs/root
> * /var/spool/crontabs/joeblow
> * /etc/cron.d/
> * /etc/cron.daily/
> * /etc/cron.hourly/
> * /etc/cron.monthly/
>
That entire list represents exactly two tools: at and cronta
On Mon, Jan 25, 2010 at 10:08 PM, Yong Lee wrote:
> yah, mysql only allows one auto increment field n that's used as the
> primary key in tables. I don't think it has to be the primary key as
> long as it is a unique key i think that's okay.
>
> so u should be able to do : create table (myid int
Daevid, all,
Daevid Vincent wrote:
> I don't "get it"... I mean, I get the concept -- it's a crontab; but why
> would someone opt to put these events here instead of in the God-given
> CRONTAB as everything else in the system uses? This just seems like one
> more place to forget about a query/cod
20 matches
Mail list logo
