…this application I can then compare using MySQL to using MySQL + Memcached, and then to other solutions … row in another table based on a text field ( called email address ). Seems simple enough …and yet others require lots and lots of memory allocated to memcached to be successful. This application …
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… just a MySQL server. The first step is to log into the machine via SSH and open up a text editor (gedit…-bit hardware, which is important if you want to allocate a lot of memory to mysqld. Next I look at a couple… information on the box’s hardware, including RAID controllers, installed memory, and so on in the boot output. In addition, at…
Post: MySQL Prepared Statements
August 2, 2006 By 19 Comments
… – query was sent as text and result returned back as text. For example number 123 would … notes: There is no statement cache – You can allocate multiple copies of same prepared statement and … forget to close prepared statements – Many memory leaks reported in MySQL Server turned out to be prepare …
Comment: COUNT(*) vs COUNT(col)
April 25, 2007 By 41 Comments
… memory allocated 589194920; in additional pool allocated 714496 Buffer pool size 32768 Free buffers 14104 Database pages 18664 Modified db pages 0 restart mysql… NULL default ’0000-00-00 00:00:00′, `comment_content` text NOT NULL, `comment_karma` int(11) NOT NULL default ’0… in set (1.19 sec) mysql> and the buffer pool usage: Total memory allocated 589194920; in additional pool allocated 721920 Buffer pool size 32768…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 17 Comments
…, InnoDB put first 768 chars of each text/blob in the page and will allocate some space outside of the page. However… using most of the system’s memory the kernel can decide (incorrectly) to swap out MySQL. There are two solutions here. Memlock… important parts of MySQL process. Q20: We’ve migrated to using INNODB so that it operates 100% out of memory. This way…
Comment: How much overhead is caused by on disk temporary tables
August 17, 2007 By 26 Comments
… memory using in memory table is better in most cases. I mainly did this comparison keeping in mind cases when BLOB/TEXT… converting this column to TEXT to see how long time changes) There is another reason – MySQL only allows you to … you can’t say how many resources you can allocate to given query.
Post: Thinking about running OPTIMIZE on your Innodb Table ? Stop!
December 9, 2010 By 13 Comments
… times larger than amount of memory I allocated for buffer pool: CREATE TABLE `a` …mysql> optimize table a; +——–+———-+———-+——————————————————————-+ | Table | Op | Msg_type | Msg_text | …
