php - mysqld.exe huge memory usage (450 MB) immediately after start WAMP -

-

i'm using same wamp version several months , never saw mysqld.exe @ top of memory usage task manager list. (it's stuck on 442 664 k).

problem started today.

i didn't touch my.ini ever.

all did today changing php.ini, (adding xdebug stuff) turn changes , memory usage stuck on 442 mb.

my.ini (part of)

# mysql server [wampmysqld] port        = 3306 socket      = /tmp/mysql.sock key_buffer_size = 16m max_allowed_packet = 1m sort_buffer_size = 512k net_buffer_length = 8k read_buffer_size = 256k read_rnd_buffer_size = 512k myisam_sort_buffer_size = 8m   [mysqldump] quick max_allowed_packet = 16m   [isamchk] key_buffer = 20m sort_buffer_size = 20m read_buffer = 2m write_buffer = 2m  [myisamchk] key_buffer = 20m sort_buffer_size = 20m read_buffer = 2m write_buffer = 2m

php.ini (part made changes today , parts resources limits , memory mentions)

;;;;;;;;;;;;;;;;;;; ; resource limits ; ;;;;;;;;;;;;;;;;;;;   max_execution_time = 800 max_input_time = 600 max_input_vars = 2500 memory_limit = 512m  ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; ; error handling , logging ; ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;  report_memleaks = on   ;;;;;;;;;;;;;;;;;;;;;; ; dynamic extensions ; ;;;;;;;;;;;;;;;;;;;;;;  extension=php_bz2.dll extension=php_curl.dll extension=php_com_dotnet.dll extension=php_fileinfo.dll extension=php_gd2.dll extension=php_gettext.dll extension=php_gmp.dll extension=php_intl.dll extension=php_imap.dll ;extension=php_interbase.dll extension=php_ldap.dll extension=php_mbstring.dll extension=php_exif.dll       extension=php_mysql.dll extension=php_mysqli.dll ;extension=php_oci8.dll       ;extension=php_oci8_11g.dll    ;extension=php_opcache.dll ;zend_extension=php_opcache.dll zend_extension="c:\wamp\bin\php\php5.5.12\ext\php_opcache.dll" extension=php_openssl.dll ;extension=php_pdo_firebird.dll extension=php_pdo_mysql.dll ;extension=php_pdo_oci.dll ;extension=php_pdo_odbc.dll ;extension=php_pdo_pgsql.dll extension=php_pdo_sqlite.dll ;extension=php_pgsql.dll extension=php_shmop.dll ;extension=php_snmp.dll extension=php_soap.dll extension=php_sockets.dll extension=php_sqlite3.dll ;extension=php_sybase_ct.dll ;extension=php_tidy.dll extension=php_xmlrpc.dll extension=php_xsl.dll   ;;;;;;;;;;;;;;;;;;;;;; ; module settings    ; ;;;;;;;;;;;;;;;;;;;;;;     [mysql] mysql.cache_size = 2000  [opcache] opcache.memory_consumption=128 ;opcache.preferred_memory_model= ;opcache.protect_memory=0   ; xdebug extension   zend_extension = "c:/wamp/bin/php/php5.5.12/zend_ext/php_xdebug-2.2.5-5.5-vc11.dll" ;[xdebug] ; xdebug.remote_handler=dbgp ; xdebug.remote_mode=req ; xdebug.remote_host=127.0.0.1 ; xdebug.remote_port=9000 ; xdebug.idekey="netbeans-xdebug" xdebug.profiler_enable = off xdebug.profiler_enable_trigger = off xdebug.profiler_output_name = cachegrind.out.%t.%p xdebug.profiler_output_dir = "c:/wamp/tmp" xdebug.show_local_vars=0 xdebug.max_nesting_level=250 xdebug.var_display_max_depth = 5 xdebug.var_display_max_children = 256 xdebug.var_display_max_data = 1024

edit: after 2 days, in did not use mysql, mysqld.exe task use ~7mb. don't know cause, leave issue.

yes defaults used later versions of mysql did littel memory hungry,

i have used reduce memory requirements without obvious effects on speed, of either myisam or innodb databases.

edit my.ini , add line in [wampmysqld] section

[wampmysqld]  # reduce mem size myisam usage table_definition_cache = 600

oh , if using 64bit wampserver there littel bug, make sure [wampmysqld] section reads [wampmysqld64] adding above line, or have no effect.


Comments

Post a Comment

Popular posts from this blog

c++ - Delete matches in OpenCV (Keypoints and descriptors) -

-
i want check scene image against 2 train images. that, detect features , compute descriptors of both training images. before detecting, computing , matching scene image, delete matches of train1 , train2. because these matches won't facilitate matching of scene image train1 , train2. so, match train1 train2 , vector of matches trainidx , queryidx. how can delete these matches in keypoints-vector , descriptor matrix of train1 , train2? best regards, dwi i have done below: std::vector<cv::keypoint> keypoints[2]; cv::mat descriptor[2]; std::vector< cv::dmatch > matches; /* write code generate keypoints, descriptors , matches here... keypoint[0] -> train image 1 keypoints keypoint[1] -> train image 2 keypoints descriptor[0] -> train image 1 descriptors descriptor[1] -> train image 2 descriptors matches -> matched between train image 1 , 2 */ // logic keep unmatched keypoints , corresponding descriptor
Read more

java - Could not locate OpenAL library -

-
i writing game using slick2d library, uses lwjgl. lwjgl version 2.9.3. using netbeans 8. i tried adding sounds game, example music track on main menu. problem is, exception when run game, despite game still compiling , running except sound of course: sat mar 21 01:23:57 edt 2015 error:could not locate openal library. org.lwjgl.lwjglexception: not locate openal library. @ org.lwjgl.openal.al.create(al.java:156) @ org.lwjgl.openal.al.create(al.java:156) @ org.lwjgl.openal.al.create(al.java:102) @ org.lwjgl.openal.al.create(al.java:206) @ org.newdawn.slick.openal.soundstore$1.run(soundstore.java:295) @ java.security.accesscontroller.doprivileged(native method) @ org.newdawn.slick.openal.soundstore.init(soundstore.java:292) @ org.newdawn.slick.music.<init>(music.java:156) @ org.newdawn.slick.music.<init>(music.java:75) @ view.mainmenu.init(mainmenu.java:58) i didn't include rest of error states error happens in game code. the
Read more

sorting - opencl Bitonic sort with 64 bits keys -

-
i used nvidia sdk bitonic sort , works great me. 32 bits (uint) need ulong keys. have typically 2^14 keys @ time , power of 2. searched on not find kernel designed ulong. i tried modified nvidia sdk bitonic sort using ulong keys not work. kernel not crash after de call clenqueuendrangekernel got error : cl_invalid_command_queue can tell me how modify bitonic sort or radixsort, or can sort ulong keys? i running nvidia quadro 4000 opencl 1.1 cuda 6.5.20 full_profile used original nvidia sdk bitonicsort.cl i used"ulong" keys , value input , ouput instead of "uint" thanks helping i made work-around suit need. used 30 bits of key , 18 high bits of value sorting. changed comparators (2 lines): '#define mask 0xffffc000 // suit need from this: if( (*keya > *keyb) == dir ) this: if(((*keya > *keyb)||((*keya == *keyb)&&((*vala & mask)> (*valb & mask)))) == dir ) it works fine. but, still, it's work-a
Read more