数据库提示:phpMyAdmin - 错误 #1040 - too many itemsconnections

解决wp2hibaidu插件不能同步到百度空间
1. 在插件中找到public function
login($blogurl,$user,$pass)函数方法把所有的&unset($this-&ch);&都注释掉,变成//unset($this-&ch);
2. 在插件中找到public function
send()函数方法把所有的&unset($this-&ch);&都注释掉,变成//unset($this-&ch);
3. 把public function send()中的前面两个改成:
//$creaturl="/".$blogurl."/creat/blog/";
$creaturl="/".$blogurl."/blog/creat";
//$posturl="/".$blogurl."/commit";
$posturl="/".$blogurl."/blog/submit/createblog";
用上面的代码替换掉就可以了。
原文sunnystone的解决方法地址为:
由于百度空间的改版,这个方法已经不可行了,可行方法正在寻找中。。。。。。。。。。
已投稿到:
以上网友发言只代表其个人观点,不代表新浪网的观点或立场。为什么打开网站的时候提示这样错误信息~_百度知道
为什么打开网站的时候提示这样错误信息~
Can not connect to MySQL serverTime:
12! info: &#47:21amScript..phpError: Too many connectionsEindexDiscuz: 1040Similar error report has been dispatched to administrator before
这个问题是需要我自己电脑上调试什么东西啊还是只有等待对方网站处理好~
info:不能连接MYSQL数据库服务器Time:21am时间.php错误脚本文件: &#47:
12;index.phpError.: 1040错误代码..: Can not connect to MySQL server信息.Script..: Too many connections错误:重复地址访问限制Errno:indexDiscuz:1040Similar error report has been dispatched to administrator before
这个问题是需要我自己电脑上调试什么东西啊还是只有等待对方网站处理好~
其他类似问题
错误信息的相关知识
按默认排序
其他2条回答
这是对方电脑的问题,他们数据库连接数量超过最大值了。只有等他们的网站自己修复好才能继续上网。和楼主无关
这个错误是无法连接到数据库,如果 楼主是打开自己做的项目,就检查数据库是否打开,或者数据库服务是否开启。如果楼主是打开别人的网站,那么就等别人修复吧,别人的网站自己是无法调试的。
等待您来回答
下载知道APP
随时随地咨询
出门在外也不愁3849人阅读
1、问题描述:连接数据库出现Too Many Connections &错误,
&2、问题定位步骤:
& & & & & &1、mysql -u root -p 进入不了,同样出现上述错误。
& & & & & &2、修改/etc/f(ubuntu系统,其他系统在/f
&[mysqld]&
port=3306&
#socket=MySQL&
skip-locking&
set-variable = key_buffer=16K&
set-variable = max_allowed_packet=1M&
set-variable = thread_stack=64K&
set-variable = table_cache=4&
set-variable = sort_buffer=64K&
set-variable = net_buffer_length=2K&
set-variable = max_connections=1000
3、重启mysql &/etc/init.d/mysql restart
4、还有一个方法就是直接 /etc/init.d/mysql restart 在做连接操作,呵呵,这个不好。
再次mysql -u root -p 进入系统 ,如下,大部分的连接其实已经Sleep了,那么如何控制释放这些空闲连接,
mysql的默认连接上只有100,也就是说连接数据超过100 就会有可能出现 Too Many Connections
修改my.cnf配置文件添加并需要重启:
wait_timeout = 600
interactive_timeout = 600
上面的意思是设置10分钟内该连接没有请求就断开,当然你也可以通过kill掉下面的process的。命令是 kill ${id} & &比如下面的19684 进程 kill 19684。
+-------+----------------------+-----------------------------+------+---------+------+-------+-----------------------+
| Command | Time | State | Info
+-------+----------------------+-----------------------------+------+---------+------+-------+-----------------------+
| 19684 | root
| AYa.local:59618 | fo
| 19691 | root
| AYa.local:59888 | mo
| 19709 | root
| AYa.local:60339 | fo
| 19708 | root
| AYa.local:60338 | fo
| 19710 | root
| 222.95.56.226:4883
| 19711 | root
| 222.95.56.226:4884
| 19712 | root
| 222.95.56.226:4885
| 19713 | root
| 222.95.56.226:4886
| 19714 | root
| 222.95.56.226:4887
| 19715 | root
| 222.95.56.226:4888
| 19716 | root
| 222.95.56.226:4889
| 19717 | root
| 222.95.56.226:4891
| 19718 | root
| 222.95.56.226:4899
| 19719 | root
| 222.95.56.226:4900
| 19720 | root
| 222.95.56.226:4901
| 19721 | root
| 222.95.56.226:4904
| 19722 | root
| 222.95.56.226:4909
| 19723 | root
| 222.95.56.226:4910
| 19724 | root
| 222.95.56.226:4912
| 19725 | root
| 222.95.56.226:4913
| 19726 | root
| 222.95.56.226:4914
| 19727 | root
| 222.95.56.226:4915
| 19728 | root
| 222.95.56.226:4916
| 19729 | root
| 222.95.56.226:4918
| 19730 | root
| AYa.local:60622 | mo
| 19731 | root
| AYa.local:60623 | fo
| 19732 | root
| AYa.local:60692 | fo
| 19733 | root
| AYa.local:60693 | fo
| 19734 | root
| AYa.local:60694 | fo
| 19735 | root
| AYa.local:60695 | fo
| 19736 | root
| AYa.local:60791 | mo
| 19737 | root
| AYa.local:60792 | mo
| 19738 | root
| AYa.local:60793 | fo
| 19739 | root
| AYa.local:60794 | fo
| 19756 | root
| AYa.local:60875 | mo
| 19755 | root
| AYa.local:60874 | mo
| 19758 | root
| AYa.local:60877 | fo
| 19757 | root
| AYa.local:60876 | fo
| 19759 | root
| AYa.local:60878 | fo
| 19771 | root
| AYa.local:60923 | mo
| 19772 | root
| AYa.local:60924 | mo
| 19773 | root
| AYa.local:60926 | fo
| 19774 | root
| AYa.local:60927 | fo
| 19775 | root
| AYa.local:60998 | mo
| 19776 | root
| AYa.local:60999 | mo
| 19777 | root
| AYa.local:32913 | mo
| 19778 | root
| AYa.local:32914 | mo
| 19779 | root
| AYa.local:32915 | mo
| 19780 | root
| AYa.local:32916 | mo
| 19781 | root
| AYa.local:32957 | mo
| 19782 | root
| AYa.local:32959 | moco | Sleep
| 19783 | root
| AYa.local:32958 | moco | Sleep
| 19784 | root
| AYa.local:32961 | moco | Sleep
| 19785 | root
| AYa.local:32962 | moco | Sleep
| 19786 | root
| AYa.local:32963 | moco | Sleep
| 19787 | root
| AYa.local:32964 | moco | Sleep
| 19788 | root
| AYa.local:32965 | moco | Sleep
| 19789 | root
| AYa.local:32966 | moco | Sleep
| 19790 | root
| AYa.local:32967 | moco | Sleep
| 19791 | root
| AYa.local:32968 | moco | Sleep
| 19792 | root
| AYa.local:32969 | moco | Sleep
| 19793 | root
| AYa.local:32970 | moco | Sleep
| 19794 | root
| AYa.local:32971 | moco | Sleep
| 19795 | root
| AYa.local:32972 | moco | Sleep
| 19796 | root
| AYa.local:32973 | moco | Sleep
| 19797 | root
| AYa.local:32974 | moco | Sleep
| 19798 | root
| AYa.local:32975 | moco | Sleep
| 19799 | root
| AYa.local:32976 | moco | Sleep
| 19800 | root
| AYa.local:32977 | moco | Sleep
| 19801 | root
| AYa.local:33110 | mo
| 19803 | root
| AYa.local:33112 | fo
| 19802 | root
| AYa.local:33111 | fo
| 19804 | root
| AYa.local:33113 | fo
| 19805 | root
| 222.95.56.226:8148
| 19806 | root
| 222.95.56.226:8147
| 19807 | root
| 222.95.56.226:8149
| 19808 | root
| 222.95.56.226:8150
| 19809 | root
| 222.95.56.226:8151
| 19810 | root
| 222.95.56.226:8153
| 19811 | root
| 222.95.56.226:8154
| 19812 | root
| 222.95.56.226:8155
| 19813 | root
| 222.95.56.226:8156
| 19814 | root
| 222.95.56.226:8159
| 19815 | root
| 222.95.56.226:8160
| 19816 | root
| 222.95.56.226:8161
| 19817 | root
| 222.95.56.226:8162
| 19818 | root
| 222.95.56.226:8163
| 19819 | root
| 222.95.56.226:8164
| 19820 | root
| 222.95.56.226:8167
| 19821 | root
| 222.95.56.226:8168
| 19822 | root
| 222.95.56.226:8169
| 19823 | root
| 222.95.56.226:8173
| 19824 | root
| 222.95.56.226:8174
| 19825 | root
| AYa.local:33342 | moco | Sleep
| 19826 | root
| AYa.local:33527 | moco | Sleep
| 19827 | root
| 222.95.56.226:8417
| 19828 | root
| 222.95.56.226:8416
| 19829 | root
| 222.95.56.226:8415
| 19830 | root
| 222.95.56.226:8418
| 19831 | root
| 222.95.56.226:8421
| 19839 | root
| AYa.local:33955 | moco | Sleep
| 19841 | root
| AYa.local:33957 | moco | Sleep
| 19840 | root
| AYa.local:33956 | moco | Sleep
| 19842 | root
| 222.95.56.226:8439
| 19844 | root
| 222.95.56.226:8440
| 19843 | root
| 222.95.56.226:8441
| 19845 | root
| 222.95.56.226:8442
| 19846 | root
| 222.95.56.226:8443
| 19847 | root
| 222.95.56.226:8451
| 19849 | root
| 222.95.56.226:8452
| 19851 | root
| 222.95.56.226:8453
| 19853 | root
| AYa.local:33981 | mo
| 19852 | root
| AYa.local:33980 | mo
| 19854 | root
| AYa.local:33982 | mo
| 19856 | root
| 222.95.56.226:8455
| 19857 | root
| AYa.local:33983 | fo
| 19858 | root
| 222.95.56.226:8462
| 19859 | root
| 222.95.56.226:8463
| 19860 | root
| 222.95.56.226:8464
| 19861 | root
| 222.95.56.226:8466
| 19869 | root
| 222.95.56.226:8491
| 19868 | root
| 222.95.56.226:8492
| 19870 | root
| 222.95.56.226:8490
| 19871 | root
| 222.95.56.226:8493
| 19872 | root
| 222.95.56.226:8494
| 19873 | root
| 222.95.56.226:8495
| 19874 | root
| 222.95.56.226:8496
| 19875 | root
| 222.95.56.226:8497
| 19877 | root
| 222.95.56.226:8499
| 19878 | root
| 222.95.56.226:8500
| 19879 | root
| 222.95.56.226:8501
| 19880 | root
| 222.95.56.226:8508
| 19881 | root
| AYa.local:34006 | fo
| 19882 | root
| AYa.local:34071 | moco | Sleep
| 19883 | root
| AYa.local:34072 | moco | Sleep
| 19884 | root
| AYa.local:34073 | moco | Sleep
| 19885 | root
| AYa.local:34074 | moco | Sleep
| 19886 | root
| AYa.local:34075 | moco | Sleep
| 19887 | root
| AYa.local:34076 | moco | Sleep
| 19889 | root
| AYa.local:34078 | moco | Sleep
| 19890 | root
| AYa.local:34079 | moco | Sleep
| 19888 | root
| AYa.local:34077 | moco | Sleep
| 19891 | root
| AYa.local:34080 | moco | Sleep
| 19892 | root
| AYa.local:34081 | moco | Sleep
| 19893 | root
| AYa.local:34083 | moco | Sleep
| 19894 | root
| AYa.local:34084 | moco | Sleep
| 19895 | root
| AYa.local:34085 | moco | Sleep
| 19896 | root
| AYa.local:34086 | moco | Sleep
| 19897 | root
| AYa.local:34087 | moco | Sleep
| 19898 | root
| AYa.local:34088 | mo
| 19899 | root
| localhost
| NULL | Query
| show full processlist |
| 19901 | unauthenticated user | 211.149.151.45:4090
| NULL | Connect | NULL | login | NULL
+-------+----------------------+-----------------------------+------+---------+------+-------+-----------------------+
查看mysql状态
+-----------------------------------+-----------+
| Variable_name
+-----------------------------------+-----------+
| Aborted_clients
| Aborted_connects
| Binlog_cache_disk_use
| Binlog_cache_use
| Bytes_received
| Bytes_sent
| Com_admin_commands
| Com_assign_to_keycache
| Com_alter_db
| Com_alter_db_upgrade
| Com_alter_event
| Com_alter_function
| Com_alter_procedure
| Com_alter_server
| Com_alter_table
| Com_alter_tablespace
| Com_analyze
| Com_backup_table
| Com_begin
| Com_binlog
| Com_call_procedure
| Com_change_db
| Com_change_master
| Com_check
| Com_checksum
| Com_commit
| Com_create_db
| Com_create_event
| Com_create_function
| Com_create_index
| Com_create_procedure
| Com_create_server
| Com_create_table
| Com_create_trigger
| Com_create_udf
| Com_create_user
| Com_create_view
| Com_dealloc_sql
| Com_delete
| Com_delete_multi
| Com_drop_db
| Com_drop_event
| Com_drop_function
| Com_drop_index
| Com_drop_procedure
| Com_drop_server
| Com_drop_table
| Com_drop_trigger
| Com_drop_user
| Com_drop_view
| Com_empty_query
| Com_execute_sql
| Com_flush
| Com_grant
| Com_ha_close
| Com_ha_open
| Com_ha_read
| Com_help
| Com_insert
| Com_insert_select
| Com_install_plugin
| Com_kill
| Com_load
| Com_load_master_data
| Com_load_master_table
| Com_lock_tables
| Com_optimize
| Com_preload_keys
| Com_prepare_sql
| Com_purge
| Com_purge_before_date
| Com_release_savepoint
| Com_rename_table
| Com_rename_user
| Com_repair
| Com_replace
| Com_replace_select
| Com_reset
| Com_restore_table
| Com_revoke
| Com_revoke_all
| Com_rollback
| Com_rollback_to_savepoint
| Com_savepoint
| Com_select
| Com_set_option
| Com_show_authors
| Com_show_binlog_events
| Com_show_binlogs
| Com_show_charsets
| Com_show_collations
| Com_show_column_types
| Com_show_contributors
| Com_show_create_db
| Com_show_create_event
| Com_show_create_func
| Com_show_create_proc
| Com_show_create_table
| Com_show_create_trigger
| Com_show_databases
| Com_show_engine_logs
| Com_show_engine_mutex
| Com_show_engine_status
| Com_show_events
| Com_show_errors
| Com_show_fields
| Com_show_function_status
| Com_show_grants
| Com_show_keys
| Com_show_master_status
| Com_show_new_master
| Com_show_open_tables
| Com_show_plugins
| Com_show_privileges
| Com_show_procedure_status
| Com_show_processlist
| Com_show_profile
| Com_show_profiles
| Com_show_slave_hosts
| Com_show_slave_status
| Com_show_status
| Com_show_storage_engines
| Com_show_table_status
| Com_show_tables
| Com_show_triggers
| Com_show_variables
| Com_show_warnings
| Com_slave_start
| Com_slave_stop
| Com_stmt_close
| Com_stmt_execute
| Com_stmt_fetch
| Com_stmt_prepare
| Com_stmt_reprepare
| Com_stmt_reset
| Com_stmt_send_long_data
| Com_truncate
| Com_uninstall_plugin
| Com_unlock_tables
| Com_update
| Com_update_multi
| Com_xa_commit
| Com_xa_end
| Com_xa_prepare
| Com_xa_recover
| Com_xa_rollback
| Com_xa_start
| Compression
| Connections
| Created_tmp_disk_tables
| Created_tmp_files
| Created_tmp_tables
| Delayed_errors
| Delayed_insert_threads
| Delayed_writes
| Flush_commands
| Handler_commit
| Handler_delete
| Handler_discover
| Handler_prepare
| Handler_read_first
| Handler_read_key
| Handler_read_next
| Handler_read_prev
| Handler_read_rnd
| Handler_read_rnd_next
| Handler_rollback
| Handler_savepoint
| Handler_savepoint_rollback
| Handler_update
| Handler_write
| Innodb_buffer_pool_pages_data
| Innodb_buffer_pool_pages_dirty
| Innodb_buffer_pool_pages_flushed
| Innodb_buffer_pool_pages_free
| Innodb_buffer_pool_pages_misc
| Innodb_buffer_pool_pages_total
| Innodb_buffer_pool_read_ahead_rnd | 611
| Innodb_buffer_pool_read_ahead_seq | 181
| Innodb_buffer_pool_read_requests
| Innodb_buffer_pool_reads
| Innodb_buffer_pool_wait_free
| Innodb_buffer_pool_write_requests | 190314
| Innodb_data_fsyncs
| Innodb_data_pending_fsyncs
| Innodb_data_pending_reads
| Innodb_data_pending_writes
| Innodb_data_read
| Innodb_data_reads
| Innodb_data_writes
| Innodb_data_written
| Innodb_dblwr_pages_written
| Innodb_dblwr_writes
| Innodb_log_waits
| Innodb_log_write_requests
| Innodb_log_writes
| Innodb_os_log_fsyncs
| Innodb_os_log_pending_fsyncs
| Innodb_os_log_pending_writes
| Innodb_os_log_written
| Innodb_page_size
| Innodb_pages_created
| Innodb_pages_read
| Innodb_pages_written
| Innodb_row_lock_current_waits
| Innodb_row_lock_time
| Innodb_row_lock_time_avg
| Innodb_row_lock_time_max
| Innodb_row_lock_waits
| Innodb_rows_deleted
| Innodb_rows_inserted
| Innodb_rows_read
| Innodb_rows_updated
| Key_blocks_not_flushed
| Key_blocks_unused
| Key_blocks_used
| Key_read_requests
| Key_reads
| Key_write_requests
| Key_writes
| Last_query_cost
| 10.499000 |
| Max_used_connections
| Not_flushed_delayed_rows
| Open_files
| Open_streams
| Open_table_definitions
| Open_tables
| Opened_files
| Opened_table_definitions
| Opened_tables
| Prepared_stmt_count
| Qcache_free_blocks
| Qcache_free_memory
| Qcache_hits
| Qcache_inserts
| Qcache_lowmem_prunes
| Qcache_not_cached
| Qcache_queries_in_cache
| Qcache_total_blocks
| Questions
| Rpl_status
| Select_full_join
| Select_full_range_join
| Select_range
| Select_range_check
| Select_scan
| Slave_open_temp_tables
| Slave_retried_transactions
| Slave_running
| Slow_launch_threads
| Slow_queries
| Sort_merge_passes
| Sort_range
| Sort_rows
| Sort_scan
| Ssl_accept_renegotiates
| Ssl_accepts
| Ssl_callback_cache_hits
| Ssl_cipher
| Ssl_cipher_list
| Ssl_client_connects
| Ssl_connect_renegotiates
| Ssl_ctx_verify_depth
| Ssl_ctx_verify_mode
| Ssl_default_timeout
| Ssl_finished_accepts
| Ssl_finished_connects
| Ssl_session_cache_hits
| Ssl_session_cache_misses
| Ssl_session_cache_mode
| Ssl_session_cache_overflows
| Ssl_session_cache_size
| Ssl_session_cache_timeouts
| Ssl_sessions_reused
| Ssl_used_session_cache_entries
| Ssl_verify_depth
| Ssl_verify_mode
| Ssl_version
| Table_locks_immediate
| Table_locks_waited
| Tc_log_max_pages_used
| Tc_log_page_size
| Tc_log_page_waits
| Threads_cached
| Threads_connected
| Threads_created
| Threads_running
| Uptime_since_flush_status
+-----------------------------------+-----------+
Aborted_clients 由于客户没有正确关闭连接已经死掉,已经放弃的连接数量。&
Aborted_connects 尝试已经失败的MySQL服务器的连接的次数。&
Connections 试图连接MySQL服务器的次数。&
Created_tmp_tables 当执行语句时,已经被创造了的隐含临时表的数量。&
Delayed_insert_threads 正在使用的延迟插入处理器线程的数量。&
Delayed_writes 用INSERT DELAYED写入的行数。&
Delayed_errors 用INSERT DELAYED写入的发生某些错误(可能重复键值)的行数。&
Flush_commands 执行FLUSH命令的次数。&
Handler_delete 请求从一张表中删除行的次数。&
Handler_read_first 请求读入表中第一行的次数。&
Handler_read_key 请求数字基于键读行。&
Handler_read_next 请求读入基于一个键的一行的次数。&
Handler_read_rnd 请求读入基于一个固定位置的一行的次数。&
Handler_update 请求更新表中一行的次数。&
Handler_write 请求向表中插入一行的次数。&
Key_blocks_used 用于关键字缓存的块的数量。&
Key_read_requests 请求从缓存读入一个键值的次数。&
Key_reads 从磁盘物理读入一个键值的次数。&
Key_write_requests 请求将一个关键字块写入缓存次数。&
Key_writes 将一个键值块物理写入磁盘的次数。&
Max_used_connections 同时使用的连接的最大数目。&
Not_flushed_key_blocks 在键缓存中已经改变但是还没被清空到磁盘上的键块。&
Not_flushed_delayed_rows 在INSERT DELAY队列中等待写入的行的数量。&
Open_tables 打开表的数量。&
Open_files 打开文件的数量。&
Open_streams 打开流的数量(主要用于日志记载)&
Opened_tables 已经打开的表的数量。&
Questions 发往服务器的查询的数量。&
Slow_queries 要花超过long_query_time时间的查询数量。&
Threads_connected 当前打开的连接的数量。&
Threads_running 不在睡眠的线程数量。&
Uptime 服务器工作了多少秒。
* 以上用户言论只代表其个人观点,不代表CSDN网站的观点或立场
访问:473612次
积分:7784
积分:7784
排名:第945名
原创:298篇
转载:58篇
评论:92条
Email : .cn weibo:
(1)(2)(2)(1)(1)(3)(4)(3)(26)(20)(11)(9)(4)(11)(5)(6)(10)(4)(14)(19)(15)(14)(4)(19)(18)(9)(18)(34)(48)(17)(3)(2)

我要回帖

更多关于 too many items 的文章

 

随机推荐