List:General Discussion« Previous MessageNext Message »
From:Reindl Harald Date:April 9 2012 11:17am
Subject:Re: Remote mysql too slow
View as plain text  

Am 09.04.2012 13:05, schrieb J. Bakshi:
> I have reset these two now
> 
> ` ` ` ` 
> key_buffer_size=200M
> innodb_buffer_pool_size=4G

[!!] InnoDB data size / buffer pool: 3.6G/8.0M

there did go something terrible wrong
what is the mysqld log saying at startup?
waht about post your complete my.cnf?

however, you will never get the same perfor,ance as
with a local mysqld if there are many small queries
because all of the queries must go over the wire and
answers back

i notice a hughe performance difference in the mailbackend
if i move the mailserver on the other vmware-host as the
web-backend is running even of gigabit ethernet





Attachment: [application/pgp-signature] OpenPGP digital signature signature.asc
Thread
Remote mysql too slowJ. Bakshi9 Apr
  • Re: Remote mysql too slowReindl Harald9 Apr
    • Re: Remote mysql too slowJ. Bakshi9 Apr
      • Re: Remote mysql too slowReindl Harald9 Apr
        • Re: Remote mysql too slowJ. Bakshi9 Apr
          • Re: Remote mysql too slowReindl Harald9 Apr
            • Re: Remote mysql too slowJ. Bakshi9 Apr
  • Re: Remote mysql too slowJohnny Withers9 Apr
    • Re: Remote mysql too slowNoel Butler9 Apr