List:General Discussion« Previous MessageNext Message »
From:Justin Date:September 4 2007 1:56pm
Subject:Re: servers full potential / FT searches locking tables
View as plain text  
Figure it out at 3am this morning while I was sleeping I remembered there 
was an rsync on the databases every 10 mins to replicate the files across 
the network.

I killed the rsync.. and all has been flawless!  =)

gotta love the dream world. answers are always there!



----- Original Message ----- 
From: "Baron Schwartz" <baron@stripped>
To: "Justin" <mysql@stripped>
Cc: <mysql@stripped>
Sent: Monday, September 03, 2007 4:42 PM
Subject: Re: servers full potential / FT searches locking tables


> Justin wrote:
>> lockup just happened again.. here's a innodb status.
>
> InnoDB status will be basically useless, as full-text is only applicable 
> to MyISAM, and indeed your status output shows only one transaction is 
> running (the one running 'show innodb status') and InnoDB has done zero 
> work since the server was started (look in the ROW OPERATIONS section).
>
> So your server isn't using InnoDB for any tables (at least none you've 
> queried since starting the server).
>
> But you're still allocating some memory and other resources to it.  If I 
> were you I'd put the following in your /etc/my.cnf just to ensure InnoDB 
> isn't interfering or complicating anything:
>
> skip_innodb
>
> Cheers
> Baron
>
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
>
> 

Thread
servers full potential / FT searches locking tablesJustin27 Aug
  • Re: servers full potential / FT searches locking tablesJay Pipes27 Aug
    • Re: servers full potential / FT searches locking tablesRolando Edwards27 Aug
      • Re: servers full potential / FT searches locking tablesJay Pipes27 Aug
        • Re: servers full potential / FT searches locking tablesJustin27 Aug
          • Re: servers full potential / FT searches locking tablesnigel wood27 Aug
    • Re: servers full potential / FT searches locking tablesJustin27 Aug
  • Re: servers full potential / FT searches locking tablesMathieu Bruneau28 Aug
    • Re: servers full potential / FT searches locking tablesJustin28 Aug
      • Re: servers full potential / FT searches locking tablesMichael Dykman28 Aug
        • Re: servers full potential / FT searches locking tablesJustin28 Aug
        • Re: servers full potential / FT searches locking tablesKen Peng29 Aug
          • Re: servers full potential / FT searches locking tablesMichael Dykman30 Aug
            • Re: servers full potential / FT searches locking tablesKen Peng30 Aug
              • Re: servers full potential / FT searches locking tablesMichael Dykman30 Aug
        • Re: servers full potential / FT searches locking tablesJustin1 Sep
          • Re: servers full potential / FT searches locking tablesJustin3 Sep
            • Re: servers full potential / FT searches locking tablesBaron Schwartz3 Sep
              • Re: servers full potential / FT searches locking tablesJustin4 Sep
                • Memory Issue would someone confirmJustin4 Sep
                  • Re: Memory Issue would someone confirmJustin4 Sep