List:General Discussion« Previous MessageNext Message »
From:Baron Schwartz Date:September 3 2007 8:42pm
Subject:Re: servers full potential / FT searches locking tables
View as plain text  
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
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