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, a
On Wed, Jul 3, 2013 at 11:34 AM, Peterson, Timothy R
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 at 9:51
> -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
> wrote:
> > Hello Larry,
> >
> >
> > On 7/3/2013 11:
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
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.
innodb_file_per_tab
On Wed, Jul 3, 2013 at 12:36 PM, Rick James 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) when data is add
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 agen
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
