…) Percona Server for MySQL will now be shipped with the libjemalloc library. Benchmark showing the impact of memory allocators on MySQL performance can be… fixed #1015506 (Alexey Bychko). Percona Server for MySQL was missing help texts in the MySQL client because the help tables were missing. Bug…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
…) Percona Server for MySQL will now be shipped with the libjemalloc library. Benchmark showing the impact of memory allocators on MySQL performance can be… fixed #1015506 (Alexey Bychko). Percona Server for MySQL was missing help texts in the MySQL client because the help tables were missing. Bug…
Post: Impact of memory allocators on MySQL performance
July 5, 2012 By 11 Comments
MySQL server intensively uses dynamic memory allocation so a good choice of memory allocator is quite important for the proper utilization of CPU/RAM …, th { border-bottom: 1px solid #333333; padding: 6px 16px; text-align: right; } memory allocator mysqld RSS size grow(kbytes) mysqld VSZ size grow…
Post: MySQL-Memcached or NOSQL Tokyo Tyrant - part 1
October 15, 2009 By 16 Comments
…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: Full Text Search Webinar Questions Followup
August 24, 2012 By 5 Comments
…memory usage for these tests? No, I didn’t measure the memory usage for each test. I did allocate…ID` primary key column properly, MySQL crashed with an out of memory fatal error, and the Windows … is an important consideration for choosing a full-text solution, because updating the index can become …
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 21 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 45 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 19 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.
