lamp(Linux+Apache+MySQL+PHP)命令大全

[mysqld] default-storage-engine=innodb # 编码设定 default-character-set   = utf8    port                    = 3306 skip-locking # 关于软件缓冲区设定，注意，缓冲区的简单计算方式为： # key_buffer + (sort_buffer + read_buffer ) * max_connection # 但缓冲区不能大于总物理内存 # 128 + (2+2)*150 = 728MB key_buffer              = 128M sort_buffer_size        = 2M read_buffer_size        = 2M join_buffer_size        = 2M max_connections         = 150 max_connect_errors      = 10 read_rnd_buffer_size    = 4M max_allowed_packet      = 4M table_cache             = 1024 myisam_sort_buffer_size = 32M thread_cache            = 16 query_cache_size        = 16M tmp_table_size          = 64M # 连接超时时间，原本是 28800 (sec) ，约 8 小时，我改为 20 分钟！！ wait_timeout            = 1200 thread_concurrency      = 8 innodb_data_file_path = ibdata1:10M:autoextend innodb_buffer_pool_size = 128M innodb_additional_mem_pool_size = 32M innodb_thread_concurrency = 16   datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql symbolic-links=0 [mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid