List:General Discussion« Previous MessageNext Message »
From:Johnny Withers Date:September 3 2010 1:31pm
Subject:Re: Performance problems on MySQL
View as plain text  
Ok, so I'm stumped?

What kind of hardware is behind this thing?

-JW

On Fri, Sep 3, 2010 at 4:44 AM, Alexandre Vieira <nullpt@stripped> wrote:

> Hi Johnny,
>
> mysql> EXPLAIN SELECT * FROM clientinfo WHERE userid='911930694';
>
>
> +----+-------------+------------+-------+---------------+---------+---------+-------+------+-------+
> | id | select_type | table      | type  | possible_keys | key     | key_len
> | ref   | rows | Extra |
>
>
> +----+-------------+------------+-------+---------------+---------+---------+-------+------+-------+
> |  1 | SIMPLE      | clientinfo | const | PRIMARY       | PRIMARY | 23
> | const |    1 |       |
>
>
> +----+-------------+------------+-------+---------------+---------+---------+-------+------+-------+
> 1 row in set (0.53 sec)
>
> Thanks
>
> BR
> AJ
>
>
>

Thread
Performance problems on MySQLAlexandre Vieira2 Sep
  • Re: Performance problems on MySQLJangita2 Sep
    • Re: Performance problems on MySQLAlexandre Vieira2 Sep
      • Re: Performance problems on MySQLJangita3 Sep
  • RE: Performance problems on MySQLTravis Ard2 Sep
    • Re: Performance problems on MySQLAlexandre Vieira2 Sep
Re: Performance problems on MySQLAlexandre Vieira3 Sep
  • Re: Performance problems on MySQLJohnny Withers3 Sep
    • Re: Performance problems on MySQLAlexandre Vieira3 Sep
      • Re: Performance problems on MySQLJohnny Withers3 Sep
        • Re: Performance problems on MySQLAlexandre Vieira3 Sep
          • Re: Performance problems on MySQLJohnny Withers3 Sep
            • Re: Performance problems on MySQLAlexandre Vieira3 Sep
              • Re: Performance problems on MySQLJohnny Withers3 Sep
                • Re: Performance problems on MySQLAlexandre Vieira3 Sep
                  • Re: Performance problems on MySQLJohnny Withers3 Sep
                    • Re: Performance problems on MySQLMySQL)5 Sep
  • Re: Performance problems on MySQLmos6 Sep
    • Re: Performance problems on MySQLAlexandre Vieira6 Sep
      • Re: Performance problems on MySQLAlexandre Vieira6 Sep