… the question is moving to better hardware, optimizing indexes or queries, tuning MySQL etc. which we can offload 80-90% from…
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
… thing that I really, really would like to know is howto track down where the bottleneck is… I’ve read Peter…’, ’83902401′ ‘Qcache_lowmem_prunes’, ’4314′ ‘Qcache_not_cached’, ’294363493′ ‘Qcache_queries_in_cache’, ’177′ ‘Qcache_total_blocks’, ’498′ ‘Questions’, ’1462755007′ ‘Rpl… log-bin=/var/log/mysql/log log-slow-queries=/var/log/mysql/slow-queries.log max_connections=650 open_files_limit=6144…
Post: Faster Point In Time Recovery with LVM2 Snaphots and Binary Logs
February 23, 2012 By 3 Comments
… that ‘Oops’ moment? Let me show you quickly how. This howto assumes that you already have a decent know how of… employees add column age smallint unsigned not null default 0; Query OK, 300024 rows affected (13.28 sec) Records: 300024 Duplicates…())-YEAR(birth_date)) – (RIGHT(CURDATE(),5)
Post: How does MySQL Replication really work?
January 9, 2013 By 9 Comments
… they are applied there. Note that this is NOT a HOWTO setup replication, but rather a howstuffworks type of thing. Replication… two types: Statement based – in which case these are write queries Row based – in this case these are changes to records… also want to look at diskstats or even do a query review for SQL thread to get a good picture. If…
