June 19, 2013

Post: Different flavors of InnoDB flushing

January 13, 2011 By 9 Comments

… lists for flushing (writing pages from the Innodb buffer pool memory to disk): the LRU list and the flush list. YouÂ… strategy which will give the biggest benefit is: Install more memory or upgrade the I/O subsystem. If you are flush list…, and innodb_log_file_size are important for tuning. Also, upgrading to Percona Server, with a more advanced flushing algorithm, may…

Filed Under: Benchmarks, MySQL Tagged With: ,

Post: When would you use SAN with MySQL ?

March 9, 2009 By 18 Comments

… more reliable, same as server with multiple power supplies ECC memory kill-chip and RAID is more reliable than without these… solves the other big pain of semi-online MySQL/OS upgrades and Schema changes. Backups SAN has number of advantages for… should also evaluate external directly attached storage, SSDs, Increasing system memory as well as sharding and replication as a scaling solutions.

Filed Under: Hardware and Storage Tagged With:

Post: Three key things to know about moving MySQL into the cloud.

July 13, 2009 By 11 Comments

… do this. There’s no customization of the memory. The maximum amount of memory you can have is 15GB, so some users… store, it costs $2094 to upgrade an R900 from 4G memory to 64G (or $4378 to upgrade to 128G) which justifies that some problems are best solved by just throwing memory at…

Filed Under: Cloud and NoSQL Tagged With: , , ,

Post: Can't Create Thread: Errno 11 (A Tale of Two Ulimits)

February 4, 2013 By 10 Comments

… thread (errno 11); if you are not out of available memory, you can consult the manual for a possible OS-dependent… entirely (although it might get replaced by a future PAM upgrade). Add a new file in /etc/security/limits.d with… this restart came about as part of a MySQL version upgrade, we might incorrectly (but justifiably) think that we’d encountered…

Filed Under: Insight for DBAs, MySQL Tagged With: , ,

Post: Economics of Performance Optimization

March 13, 2008 By 9 Comments

… tuned applications when further tunings are expensive you may well upgrade hardware instead but as you grow further you’ve got… virtual) rented server which would usually have 1-2GB of memory may be couple of SATA hard drives – something one would… economic standpoint until you think about resources and risks – hardware upgrade is straightforward and can be done by operations and data…

Filed Under: Insight for Developers Tagged With:

Post: Heikki Tuuri answers to Innodb questions, Part II

November 4, 2007 By 13 Comments

… leveling is used for flash memories. I looked up some information on the web about flash memories, and noticed that random writes… come up with “Persistent DRAM” memory device, which would offer some small amount, say 512M memory which is battery backed up just… increase the amount of system memory. We just deployed a new Linux/Mysql server for a client, upgrading their main database (from…

Filed Under: Insight for Developers Tagged With:

Post: 128GB or RAM finally got cheap

August 4, 2008 By 14 Comments

… 32 memory slots, which allows to get 128GB of memory with 4GB of memory chips. This means upgrade to default configuration to 128GB of memory… systems are designed to have “working set to fit in memory” to perform well and such systems can avoid good consolidation… CPU sockets which means 16 fast cores and 128GB of memory becomes commodity – Quite a challenge for MySQL to take :) I…

Filed Under: Hardware and Storage Tagged With:

Comment: mysql_upgrade and Innodb Tables

May 16, 2010 By 8 Comments

Thanks a lot Peter, I’ve just upgraded to 5.1, to use RBR, and every day the … error HA_ERR_KEY_NOT_FOUND». The table was a MEMORY one, and by doing your check command, I’ve found… that if I replicate the MEMORY table using RBR, and restart one server, the data in-memory will be purged, and the…

Filed Under: Insight for DBAs, MySQL Tagged With: ,

Post: How Percona does a MySQL Performance Audit

November 24, 2008 By 17 Comments

… to know what the operating parameters are. Can we suggest upgrades, rewriting queries, or whatnot? Sometimes there are rigid constraints on… little load. I see that mysqld is using 10g of memory with 17g virtual size, and there’s practically nothing else… information on the box’s hardware, including RAID controllers, installed memory, and so on in the boot output. In addition, at…

Filed Under: Insight for Developers Tagged With:

Post: InnoDB Full-text Search in MySQL 5.6: Part 2, The Queries!

March 4, 2013 By 7 Comments

…_FT_DEFAULT_STOPWORD` ( `value` varchar(18) NOT NULL DEFAULT ” ) ENGINE=MEMORY DEFAULT CHARSET=utf8 The docs tell us that we need… that switching to InnoDB FTS is simply a matter of upgrading to 5.6 and running ALTER TABLE foo ENGINE=InnoDB… result of a major MySQL version upgrade before rolling it into production! Percona has tools (pt-upgrade and Percona Playback) that can…

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , ,
« Older Posts
Newer Posts »