VPS in a small reduction in memory consumption of MySQL

2010-12-03  来源:本站原创  分类:Internet  人气:55 

#
# * Fine Tuning
#
key_buffer = 16M into 16K
changed to 1M max_allowed_packet = 16M
thread_stack = 192K into 64K
thread_cache_size = 8
# This replaces the startup script and checks MyISAM tables if needed
# The first time they are touched
myisam-recover = BACKUP
# Max_connections = 100
# Table_cache = 64 into 4, and enable
# Thread_concurrency = 10
#
# * Query Cache Configuration
#
query_cache_limit = 1M
query_cache_size = 16M

And add

sort_buffer_size = 64K
read_buffer_size = 256K
read_rnd_buffer_size = 256K
net_buffer_length = 2K

Also add
skip-innodb
skip-bdb
Because the two senior database file (BerkeleyDB) do not need, generally using MyISAM

After this adjustment, MySQL 100MB memory consumption will be reduced

相关文章
  • VPS in a small reduction in memory consumption of MySQL 2010-12-03

    # # * Fine Tuning # key_buffer = 16M into 16K changed to 1M max_allowed_packet = 16M thread_stack = 192K into 64K thread_cache_size = 8 # This replaces the startup script and checks MyISAM tables if needed # The first time they are touched myisam-rec

  • MySQL in a small VPS to reduce memory consumption 2010-12-03

    # # * Fine Tuning # key_buffer = 16M into 16K changed to 1M max_allowed_packet = 16M thread_stack = 192K into 64K thread_cache_size = 8 # This replaces the startup script and checks MyISAM tables if needed # The first time they are touched myisam-rec

  • . Net a Best Practice: Monitoring. Net code in high memory consumption function 2010-03-26

    . Net a Best Practice: Monitoring. Net code in high memory consumption function Introduction and objectives Result. NET code is an important factor in performance degradation is the memory consumption. Many developers is mainly used to determine the

  • Memory consumption: VSS / RSS / PSS / USS 2011-04-17

    Terms VSS - Virtual Set Size virtual memory consumption (including shared libraries occupy memory) RSS - Resident Set Size actual use of physical memory (the memory that contains the shared library) PSS - Proportional Set Size actual use of physical

  • How to create a memory table in mysql --- switch 2010-06-01

    How to create a memory table in mysql how to create a memory table --- turn? Create a memory table is very simple, just specify ENGINE = MEMORY you can: CREATE TABLE `tablename` (`columnName` varchar (256) NOT NUL) ENGINE = MEMORY DEFAULT CHARSET = l

  • linux View memory consumption 2010-05-01

    Transfer from http://www.51yu.cn/post/51/ Linux ps on the process used to sort the memory ps-eo pid, comm, vsz - sort vsz Then open file fd to view information ll / proc/19829/fd Also, if you want to see a process and implementation of the directory

  • Concurrent memory consumption on the nodeJs 2010-09-30

    10,000 concurrent connections takes about 45M of memory

  • [Transferred] to solve the optimization of memory consumption MyEclipse 2010-10-12

    1, always pop-up Quick update error, close the myeclipse's Quick Update Automatic Update feature Solution to this problem is to turn off automatic updates Windows> Preferences> MyEclipse Enterprise Workbench> Community Essentials, The option &quo

  • [Reprint] Dictionary, Object, Array memory consumption, read, write, test efficiency 2010-12-21

    http://bbs.9ria.com/viewthread.php?tid=70879&extra=page% 3D1% 26amp; orderby% 3Ddateline% 26amp; filter% 3D86400 package { import flash.display.Sprite; import flash.events.KeyboardEvent; import flash.sampler.getSize; import flash.utils.Dictionary; im

  • VPS (ubuntu server 10.04) to install Ubuntu + Nginx + Mysql + Php + Zend + eaccelerator, install wordpress 2011-05-14

    1. Install rz / sz, and SSH: sudo apt-get install lrzsz sudo apt-get install openssh-server 2.lucid (10.04) of the source, add the following: sudo vi /etc/apt/sources.list deb http://archive.ubuntu.com/ubuntu/ lucid main restricted universe multivers

  • On the VPS: Xen and OpenVZ performance test in the end one is better 2011-01-11

    In a VeryCD because of the recent site for the cottage, but there is this guy really 1G database, not wordpress, lacks popular discuz forums can compare this side dish, presumably, to a certain extent, test the performance of VPS. VPS before the elec

  • Choose to be a VPS or shared web space 2011-01-23

    They are doing fence net (http://liba.co), what to consider in the end use. Space or VPS A lot of space limitations, the basic login server will not let you go, your ftp problem-solving, management generally have a web console. Students engage in a s

  • To determine the memory usage under Linux and some of the methods described [turn] 2011-06-10

    Part I: View the memory usage Under Linux using the Top [Root @ itc-test9 ~] # top top - 17:08:01 up 12 days, 3:48, 2 users, load average: 0.01, 0.01, 0.00 Tasks: 95 total, 1 running, 94 sleeping, 0 stopped, 0 zombie Cpu (s): 0.0% us, 0.0% sy, 0.0% n

  • VPS optimization of mysql 2010-12-03

    MySQL is a great open source database engine, most of the website and blog are powered by MySQL. MySQL's default installation of large memory resources (as opposed to only 64MB of VPS is a) to optimize MySQL can reduce memory consumption, the more me

  • 10 iPhone Memory Management Tips 2012-04-08

    Memory management in the iPhone is a hot topic. And since tonight I'm talking about it on tonight's monthly meetup of the French-speaking Swiss iPhone Developers group, I might as well share some tips here from my own experience. I won't go dive thro

  • javascript how to avoid memory leak 2009-04-24

    Procedures are likely to happen any memory "leak" (ie, application of system memory and not released after the completion of job), and for the use of unmanaged language (unmanaged languages) (such as C language) of the developers, memory allocat

  • Java memory leak analysis and solution of 2010-03-29

    July 24, 2009 Friday, 00:17 Java memory leak that every Java programmer will be the problems encountered, the program is running in the local all normal, but there will be deployed to remote memory, unlimited growth, the final system paralyzed, then

  • Optimization into a worry: String.split caused by "memory leak" 2010-03-29

    Has been praised Sun rigorous and elegant treatment technologies (bless Sun). Sun JDK source code in the Java libraries, even the notes are clear and regulatory norms Fan, javadoc comment use was also a meticulous reading comfortably familiar. Thus,

  • java memory, thinking and summary 2010-03-29

    1. Java heap and the stack in In the Java program is running, there are six places can be used to save the data: (1) register. Save the fastest growing region, located inside the processor number is limited, it is allocated by the compiler as needed.

  • JAVA memory problems (Java Memory Problems) 2010-03-29

    Text, see: http://blog.dynatrace.com/2009/08/13/java-memory-problems/ Memory leaks and other memory related problem is the most JAVA significantly (prominent) performance and scalability issues. So we have ample reason to more in-depth discussion of