01/02/2012, 06:37
| |||
| |||
| Como modificar my.conf? Buenos días Acabo de realizar una instalación del mysql 5.5 y tengo el my.conf por defecto me gustaría modificarlo para que se ajuste a las características de mi servidor 64bits con un procesador de 8 núcleos con 8GB de ram y las bases de datos son InnoDB. Tengo aproximadamente 100 usuarios con cierto lag y el servidor esta en uso del 10% del procesador y 20% de memoria me gustaría sacarle mas provecho para mejorar el rendimiento. que elementos del my.conf debo cambiar y por otra parte creo que tengo desactivado el InnoDB # Example MySQL config file for medium systems. # # This is for a system with little memory (32M - 64M) where MySQL plays # an important part, or systems up to 128M where MySQL is used together with # other programs (such as a web server) # The following options will be passed to all MySQL clients [client] #password = your_password port = 3306 socket = /var/lib/mysql/mysql.sock # The MySQL server [mysqld] port = 3306 socket = /var/lib/mysql/mysql.sock #skip-locking key_buffer_size=1024M max_allowed_packet = 8M table_cache = 64 sort_buffer_size = 2M net_buffer_length=64 read_buffer_size = 128M read_rnd_buffer_size = 256M myisam_sort_buffer_size = 16M tmp_table_size = 512M join_buffer_size=512M #skip-networking # Disable Federated by default skip-federated skip-name-resolve #skip-external-locking skip-host-cache lower_case_table_names=1 # Uncomment the following if you are using InnoDB tables #innodb_data_home_dir = /var/lib/mysql/ #innodb_data_file_path = ibdata1:10M:autoextend #innodb_log_group_home_dir = /var/lib/mysql/ #innodb_log_arch_dir = /var/lib/mysql/ # You can set .._buffer_pool_size up to 50 - 80 % # of RAM but beware of setting memory usage too high innodb_buffer_pool_size = 512M innodb_additional_mem_pool_size = 128M # Set .._log_file_size to 25 % of buffer pool size #innodb_log_file_size = 5M #innodb_log_buffer_size = 8M #innodb_flush_log_at_trx_commit = 1 #innodb_lock_wait_timeout = 50 # The safe_mysqld script #The bigger you set this the less disk I/O is needed to access data in tables. On a dedicated database server you may set this parameter up to 80% of the machine physical memory size. Do not set it too large, though, because competition of the physical memory may cause paging in the operating system. innodb_buffer_pool_size=1024M #Enter a name for the query log file. Otherwise a default name will be used. log=/var/lib/mysql/registro/query_log.sql #Enter a name for the slow query log. Otherwise a default name will be used. log-slow-queries=/var/lib/mysql/registro/slow_query.sql #Log all queries that have taken more than long_query_time seconds to execute to file. long_query_time=10 #Don't log extra information to update and slow-query logs. log-short-format Muchas gracias por su ayuda se lo agradezco mucho.  Última edición por nany900; 03/02/2012 a las 08:47 |
