…master server has an issue. At Groupon, our standard MySQL database configuration follows this … percona-playback –mysql-host 127.0.0.1 –mysql-username playback –mysql-password PaSSwOrd –mysql-schema schema_name –query-… expected everything to be cached if we warmed the cache with the exact same …
Post: Implications of Metadata Locking Changes in MySQL 5.5
February 1, 2013 By 9 Comments
… | Id | User | Host…cache lock | 0.000003 | | checking query cache for query | 0.000007 | | checking privileges on cached…tables’; +—————+——-+ | Variable_name | Value | +—————+——-+ | Open_tables | 30 …issue when the application was using MySQL…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…SaaS hosted …name | Value | +———————————–+———————-+ | Aborted_clients | 205174 | | Aborted_connects | 29 | | Binlog_cache_disk_use | 0 | | Binlog_cache… issue‘…mysql> show global variables like ‘%table_size%’; +———————+———–+ | Variable_name…
Comment: Is DNS the Achilles heel in your MySQL installation?
May 31, 2008 By 16 Comments
… also would note effects of host name resolve magnifies because of various bugs with host-cache in different MySQL versions which could cause more resolves… also make sense. Another related issue I should mention – I’ve seen some operating systems building MySQL with tcp wrappers – in this…
Post: Database problems in MySQL/PHP Applications
August 11, 2006 By 13 Comments
…$dbcon->query(“Select email from user where name=%s”,$name) – wrapper will detect query is being…formating, so database connection may become the issue. Caching should be good help in this case … with MySQL. There are many successful applications, using tens of thousands of tables per host and…
Post: Living with backups
November 6, 2008 By 28 Comments
…. The storage is handling reads issued by the system, but only…else? All modern systems usually use caching of whatever is being read …mysql | ssh backup@storage-host /root/backup-tools/write_backup.sh This will read /mnt/snapshot/mysql… the SCSI sub-system (devices named sda, sdb, sdc, etc.) that can …
Post: Content delivery system design mistakes
February 11, 2007 By 9 Comments
… performance problems (part MySQL related and part related to LAMP… has some of its own issues which need different treatment. …alive connections. Lighttpd is often named as faster alternative. It … Server side caching The benefit of server side caching is not …allows to configure different virtual host…
Comment: Database problems in MySQL/PHP Applications
August 11, 2006 By 13 Comments
… email from user where name=%s”,$name) – > wrapper will…database connection may become the issue. Caching should be > good help… > of tables per host and archiving great performance …cached lookup table however so you do > not have all these problems with loosing data etc. Read more in my > Why MySQL…
