Fetch rows_affected after each INSERT/UPDATE. Tally them in @variables, if you
like. The information is not (I think) available after COMMIT.
-Original Message-
From: Neil Tompkins [mailto:neil.tompk...@googlemail.com]
Sent: Tuesday, July 02, 2013 4:30 AM
To: [MySQL]
Subject: Get
ft_min_word_len=3
stopwords! IDIOT! I was testing using stop words! :)
let me change my test org name.
thanks
FULLTEXT (at least the MyISAM version) has 3 gotchas:
ft_min_word_len=4, stopwords, and the 50% rule
-Original Message-
From: shawn green [mailto:shawn.l.gr...@oracle.com]
We are on a quest to improve the overall performance of our database. It's
generally
working pretty well, but we periodically get big slowdowns for no apparent
reason. A
prime example today - in the command line interface to the DB, I tried to
update one
record, and got:
mysql update
On Wed, Jul 3, 2013 at 12:36 PM, Rick James rja...@yahoo-inc.com wrote:
I once found a slowlog called simply 1. But I did not track down the
cause. Possibly it was a not-so-correct configuration script.
SHOW VARIABLES LIKE '%dir%';
Nothing was set to 1
ibdata1 grows (never shrinks)
I once found a slowlog called simply 1. But I did not track down the cause.
Possibly it was a not-so-correct configuration script.
SHOW VARIABLES LIKE '%dir%';
ibdata1 grows (never shrinks) when data is added, ALTER is done, etc. It will
reuse free space within itself.
Hi all
I hope all are well.
I would like some assistance with something really strange.
We currently have a problem with a master slave setup running
mysql 5.0.
This is one of our legacy servers which are in the planning to
be upgraded, however in order for this to
-Original Message-
From: Larry Martell [mailto:larry.mart...@gmail.com]
Sent: Wednesday, July 03, 2013 11:29 AM
To: shawn green
Cc: mysql@lists.mysql.com
Subject: Re: 1 file
On Wed, Jul 3, 2013 at 9:51 AM, shawn green shawn.l.gr...@oracle.com
wrote:
Hello Larry,
On
On Wed, Jul 3, 2013 at 11:34 AM, Peterson, Timothy R
timothy_r_peter...@uhc.com wrote:
-Original Message-
From: Larry Martell [mailto:larry.mart...@gmail.com]
Sent: Wednesday, July 03, 2013 11:29 AM
To: shawn green
Cc: mysql@lists.mysql.com
Subject: Re: 1 file
On Wed, Jul 3, 2013
We recently changed from in memory files to InnoDB files. Today we
noticed that in every server's data dir there is file called '1' that
seems to get updated every time the iddata1 file gets updated. On some
servers it's comparable in size to the iddata1 file, on other servers
it's 10-15x larger,