这个mysql使用了2年多了,今天我修改了max_connections=3000,之后,我重启mysql,重启失败,后来我在任务管理器里面直接kill掉进程,然后从服务里面启动,但是还是连不上mysql,报告一个常见的错误
Can't connect to MySql server on 'localhost',现在公司的系统都断掉了,快疯了啊,谢谢各位帮忙
Can't connect to MySql server on 'localhost',现在公司的系统都断掉了,快疯了啊,谢谢各位帮忙
检查本机mysqld 是否在运行?"
090618 13:04:00 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown completeInnoDB: Error: log file .\ib_logfile0 is of different size 0 87031808 bytes
InnoDB: than specified in the .cnf file 0 10485760 bytes!
090618 13:08:24 [ERROR] Default storage engine (InnoDB) is not available
090618 13:08:24 [ERROR] Aborting090618 13:08:24 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown completeInnoDB: Error: log file .\ib_logfile0 is of different size 0 87031808 bytes
InnoDB: than specified in the .cnf file 0 10485760 bytes!
090618 13:09:58 [ERROR] Default storage engine (InnoDB) is not available
090618 13:09:58 [ERROR] Aborting090618 13:09:58 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown completeInnoDB: Error: log file .\ib_logfile0 is of different size 0 87031808 bytes
InnoDB: than specified in the .cnf file 0 10485760 bytes!
090618 13:10:34 [ERROR] Default storage engine (InnoDB) is not available
090618 13:10:34 [ERROR] Aborting090618 13:10:34 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown completeInnoDB: Error: log file .\ib_logfile0 is of different size 0 87031808 bytes
InnoDB: than specified in the .cnf file 0 10485760 bytes!
090618 13:10:39 [ERROR] Default storage engine (InnoDB) is not available
090618 13:10:39 [ERROR] Aborting090618 13:10:39 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete
InnoDB: than specified in the .cnf file 0 10485760 bytes!
090618 13:10:39 [ERROR] Default storage engine (InnoDB) is not available
你的服务中的命令是什么?检查一下MYSQL服务中命令带的参数。
你的cnf 文件中的ib_logfile0尺寸与实际不符,确认你没有用错 my.cnf 文件。
Conld not stop the mysql servise on Local Computer
Error 1053:The service did not respond
to the start or control request in a timely fashion
default-character-set=utf8[mysqld]# The TCP/IP Port the MySQL Server will listen on
port=3306
basedir="C:/Program Files/MySQL/MySQL Server 5.0/"datadir="C:/Program Files/MySQL/MySQL Server 5.0/Data/"
default-character-set=utf8wait_timeout=28800# The default storage engine that will be used when create new tables when
default-storage-engine=INNODB# Set the SQL mode to strict
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"max_connections=300query_cache_size=0table_cache=256tmp_table_size=52M
thread_cache_size=8myisam_max_sort_file_size=100Gmyisam_max_extra_sort_file_size=100Gmyisam_sort_buffer_size=103Mkey_buffer_size=85Mread_buffer_size=64K
read_rnd_buffer_size=256Ksort_buffer_size=256Kinnodb_additional_mem_pool_size=3469Kinnodb_flush_log_at_trx_commit=1innodb_log_buffer_size=2Minnodb_buffer_pool_size=165Minnodb_log_file_size=83Minnodb_thread_concurrency=8log-bin=localhost
log-slow-queries=localhost-slow
long_query_time=2
另外还好多localhost.000001,都很大,大小都不等
default-storage-engine=MyISAM