Mysql InnoDB optimization


query_cache_size = 512M
query_cache_limit = 256M
tmp_table_size = 256M
key_buffer_size = 64M
read_buffer_size = 128M
read_rnd_buffer_size = 128M
bulk_insert_buffer_size = 64M
myisam_sort_buffer_size = 128M
myisam_max_sort_file_size = 128M
myisam_max_extra_sort_file_size = 128M
myisam_repair_threads = 2
myisam_recover
innodb_additional_mem_pool_size = 256M
innodb_log_buffer_size = 128M
innodb_log_file_size = 128M
innodb_log_files_in_group = 2
innodb_flush_log_at_trx_commit = 0
innodb_buffer_pool_size = 512M
innodb_data_home_dir = /var/lib/mysql/
innodb_data_file_path = ibdata1:256M:autoextend
innodb_autoextend_increment=32

max_allowed_packet = 16M
wait_timeout = 1800
connect_timeout = 120
Notice the above is adjusted for a DB dedicated server with 2GB of RAM.

Comments

Post a Comment

Popular posts from this blog

AIOMgr: Preparing flush failed with VERR_NOT_SUPPORTED, disabling async flushes

AIOMgr: Preparing flush failed with VERR_NOT_SUPPORTED, disabling async flushes If you get error like this while Installing Windows 8.1 as guest OS using Oracle VirtualBox /VirtualMachine Then check your RAM Allocation for the Guest OS. Example: First time i gave 5120 (5 GB) of RAM for Guest OS. while installing i got the error like this in log file AIOMgr: Preparing flush failed with VERR_NOT_SUPPORTED , disabling async flushes. Now i changed the RAM size to 4096(4 GB) , now the error gone, the guest OS installed successfully. My Suggestion is to set RAM size in EVEN  for this kind of errors.
Read more

Create Virtual Host in IIS Server

Image
1)  Open Command Prompt using Administrative Rights 2)  Flush the cache of ARP (Address resolution protocol) a) C:\Windows\system32> netsh interface ip delete arpcache b) C:\Windows\system32> arp -a 3)  Open IE (Internet Explorer) a)  Open Internet Options window from settings b)  Click on Connections Tab -> Click on LAN Settings button c)  Uncheck all checkbox but make sure to check the "Bypass proxy server for local address." 4)  Open Hosts file from C:\Windows\System32\drivers\etc Folder (Make sure is it have write permission) It will look like this # localhost name resolution is handled within DNS itself. # 127.0.0.1       localhost # ::1                 localhost Add these lines at bottom of this file (You can add multiple names) 127.0.0.1 mysite.com 127.0.0.1 maheshbokkisam.com 5)  Now check is these virtual host/domain names are working a)  Go to Command Prompt and run this commands 5.a.1)  ping mysite.c
Read more

The model type is invalid. please select an item from the list ( ASP.Net MVC)

Image
Hi, If any one face this problem, hear is one solution While creating/Add controller for Entity Framework in Asp.Net MVC3 OR MVC4 Example: As per this website Controller name:  MoviesController . (This is the default. ) Template:  Controller with read/write actions and views, using Entity Framework . Model class:  Movie (MvcMovie.Models) . Data context class:  MovieDBContext (MvcMovie.Models) . Views:  Razor (CSHTML) . (The default.) when we click on " Add" Button the application show one alert message "The model type is invalid. please select an item from the list " Before adding MoviesController we need to  built the project before proceed to this step. Click on Run Button to built the project and now add controller with above steps. I hope you problem will be solved.
Read more