max_user_connections ومشكلة الصفحة البيضاء (مجاب)

[alahamdan]

???? ?????? :http://www.12allchat.com/forum
???? ??????? ?????????: ???? ?????? ? Dynamic Meta Tags ? ??? ?????? ??? ?????? ???????
?? ?????? ???? ??? ??????? 80 ?? ???????: ??
????? ??????: 3.0.4
????? PHP: 5.2.8
??? ????? ???????? ???????? ????????: MYSQL 5.0.22
?? ?? ????????: ??? ??? ?????? ????? ????? (Dedicated server)
??? ??? ?? ??? ?????? ? ??? ?? ????? ???? ?????: ????? ???????? ?? 3.0 ??? 3.0.4
?? ??? ?????? ????? ?? ????? ??? ? ???? ?: ??
?? ???? ?? ??????: ???
??? ??? ??? ? ???? ??????? ???? ???? ????: max_user_connections
??? ???? ??????? :

??????? ???? ?? ???? ????? :

1- ?????? ??? ????? ????? - Dedicated Server ? ??? ?? ??? ?????? ????? ???? ??? ???????.
2- ??????? ???? ????? ??? ??? ??????? ? ??????? QUAD CORE ?? ????? 4 ????.
3- ??? ???????? 15 ??? ????? ??? ??????? ?????????? ????? 120 ???. ???? ?????????? ?????? ??? 600 (????? ????).


??? ??????? :

???? ??? ??????? ?? ??? ????? ???? ????? ??? ?? ??? ???? ?? ??? ????????? ???? ???? ?? ?? :

max_connections
max_user_connections

??? 1000 ????? ??? ??? ???? ??? ???? ???? ?????? ????? ??? ???????? ??? ???? ??????? ?? ??? my.ini

???? ???? ????? ?? ?? ??????? ???? ????? ??????? ????? ?? ???? ??? ???? ? ????? ??? ?? ????? ? ??????? ?? ??? ???? ?????? (?? ?????? ?? ??? ??????) ?? ????? ??? ??? ?????? ??? ??????? ????? ????.

????? ???? ??????? ?????? ???? ?????? ?????? ? ??? ?????? ?????? ???????????????? ?? ?????? ???? ????????? ??? ?? ??? ??????? ?? ????? ? ?????? ???? ??? ???? ????? ??????? ???? ?????? ??? ?????? ?????? ???? ?? ????? ???? ????? ?????? ?? ??? ??????? (title) ? ???? ???? ???? ??? ????.

??? ?????? ??????? ?? ????? ????? ????? ?????? ?? ??? ??????? ??????? ????? ?? ???? ?? ????? ??? ???? ???? ????? ??? ???? ????? ????? ??????? ??????? ??? ??????? . (????? ???? ????????? ????? ???????).

??? ?????? ????? ????? ?????? ??????? ????? ? ???? ?????? ????????? ???? ??????? ?? ?????? ????????? ???????? ??? ???????? ?????? ???????? ???? ?? ??? ????? ?????.

??? ?????? ???? ???????? ??????? ?????? ??????? ???? ??????? ????? :

1- ??? ?????? ????? ?????????? ??? ????? ??? ???????? ??? ?????? ?? ????????? ????? ??? ?? ??????? ????? ?????? ???? ???? ????? ? ????????? ?? ??????? ??? ??????? ???? ??? ????? ????? ?? ???? ??? ?? ?????.

??? ?????? ?? ???????? ?? ??????? ??? ?????? ????? ?? ??? ???? ?????? ??????? ??? ???? ?????? Persistant
CONNECTIONS
??? ??? ????? ???? ??????? ??????? ??? ???? ????? ????????? ??????? ?? ?? ????? ???? ?????? ?????? ??? ????????? ?? ????????.

??? ???? ?????? ??? ????? ????? ???? ??????? ?? ????? ??? ????????? ?????? ??? ????????? ?? ????? MYSQL ???? ????? ???????? ?? ??????? ? ??? ??? ?? ??? ?????? ?? ????? ?????? ??? ??? ????? ?? ??? ?????? ???? ?????????.

- ????? ????? ??????? ?? PHPMYADMIN ?? ???? Repair table ????? ??? ??? ??????? :

The storage engine for the table doesn't support repair

?? ??? ?? ?? Storage Engine ?? : InnoDB

- ??? ????? ???????? ??? 310 ???? ???????? ????? ?? ???? ??? ??? ????? ???????? ??? ?? ????? ?????? ????? ?????? ?? ????? ?? ????? ????.





?? ???? ????? ??? ???? ?? ???????? ?? ??? ??? ?????? ??? ???:

Error: SQL ERROR [ mysql4 ] User DATABASEUSER already has more than 'max_user_connections' active
connections [1203] An sql error occurred while fetching this page



???? ????? ??? ??????? :

????? : testtest
???? ???? : wwwwwwww

?? ?? ?????????? ?! ?????? ???? ???? ?????.

[saanina]

?????
?????? ?????? ????? ??????? ????? ??????? ?????? ??? ???? ??????? ( ?????? ???? ?? ????? ???? ??? ??????? ) ..

????? ?????? ??????? ??? ?????? ??? ????????? , ???? ??? ???? ??? ????? ???? ?????? ???? ???????
?? connect ? pconnect ???? ?? ??????? ??????? ?????? ??????? ????? ?? ??? .. ( ???? ?????? ?? ????? ????? ????? ?????? ???? ..) ..

???? ??? ?? ????? ???? ????? ?????? "???" ?? phpbb3 ????? ????? ?????????? ??? .. ??? ????? ?????? ??????? ?????? .. ????? ??? ?????? ??? ????????? .. ??? ?? ???? ?? ??? 600 ???? ??????? ? 1000 ????? ???????? ?? ?? ???? !!

[alahamdan]

????? ??? Saanina ??? ????

????? ??? ??? ?????? ??? ?????? ????? ???? ?? ???? ?? ????

?????? ?????? ????? ????? ?? ??? ????? ???? ??????? ????? ?????? ??????? ??? ????.

???? :

1- ?? ???? ?????? ???? ??????? ?? connect ? pconnect ??? ???? ??????? ??????? ??? ?? ?????? ?????? ?? ????? ??? ????????? ??????? ?????? ? 100 ????? ??? ???? ??? ??? ??? ?? ??????? ??? ?????

2- The storage engine for the table doesn't support repair ?? ??? ??????? ???????

????? ???????? ????? ???????? ??? ??? 100%? ??? ?????? ??? ?????? ??? ??????? ?? ??????? ???? ???? ???? ????? ???? ? ?????? ?? ????? ??? 1000? ????? ?? ???????.

????? ??? ???? ??? ??? ????? ????? ?????.

[saanina]

??????? ???????
http://www.phpbb.com/community/viewtopi ... 4#p1802314

??? ??? ????? ?? 1000 ??? ??? ?? 100 ?

?????? ?????? ???? ????? , ?????? ????? ??????? ..
???????? ?????? connect ? pconnect ??? ??? ?? .. ????? ?????? ????? ??? ..

[alahamdan]

??? ??? ???? 1000 ? ???? ????????

?????? ??????? ??? ????

?????

[alahamdan]

?????? ????? ??? ????

1- ????? ???????? ????? (???? 820 ?) ?? ???? ???? ??????? ? ?????? ???? ?????????? ?????? MYSQLDUMP ????? 330 ? ?????? ?? ??? ??????

2- ????? ??? ????? ?? ???? ?????? ??????? ???? ?? ??????? ???? ?????? ???? ??????? ?? ?????? ????? OPTIMIZE ???? ??????? ?? ???? Repair ???? ?????? ?? ???????? ???? ???? Optimize ?? ???? ??????? ???? ???? ?? ???????:

The command has completed and here are the results...

chatforum.phpbb_acl_groups OK
chatforum.phpbb_acl_options OK
chatforum.phpbb_acl_roles OK
chatforum.phpbb_acl_roles_data OK
chatforum.phpbb_acl_users OK
chatforum.phpbb_attachments OK
chatforum.phpbb_banlist OK
chatforum.phpbb_bbcodes OK
chatforum.phpbb_bookmarks OK
chatforum.phpbb_bots OK
chatforum.phpbb_config OK
chatforum.phpbb_confirm OK
chatforum.phpbb_disallow OK
chatforum.phpbb_drafts OK
chatforum.phpbb_extension_groups OK
chatforum.phpbb_extensions OK
chatforum.phpbb_forums OK
chatforum.phpbb_forums_access OK
chatforum.phpbb_forums_track OK
chatforum.phpbb_forums_watch OK
chatforum.phpbb_groups OK
chatforum.phpbb_icons OK
chatforum.phpbb_lang OK
chatforum.phpbb_log OK
chatforum.phpbb_moderator_cache OK
chatforum.phpbb_modules OK
chatforum.phpbb_poll_options OK
chatforum.phpbb_poll_votes OK
chatforum.phpbb_posts OK
chatforum.phpbb_privmsgs OK
chatforum.phpbb_privmsgs_folder OK
chatforum.phpbb_privmsgs_rules OK
chatforum.phpbb_privmsgs_to OK
chatforum.phpbb_profile_fields OK
chatforum.phpbb_profile_fields_data OK
chatforum.phpbb_profile_fields_lang OK
chatforum.phpbb_profile_lang OK
chatforum.phpbb_ranks OK
chatforum.phpbb_reports OK
chatforum.phpbb_reports_reasons OK
chatforum.phpbb_search_results OK
chatforum.phpbb_search_wordlist OK
chatforum.phpbb_search_wordmatch
error : Lock wait timeout exceeded; try restarting transaction
status : Operation failed
chatforum.phpbb_sessions OK
chatforum.phpbb_sessions_keys OK
chatforum.phpbb_sitelist OK
chatforum.phpbb_smilies OK
chatforum.phpbb_styles OK
chatforum.phpbb_styles_imageset OK
chatforum.phpbb_styles_imageset_data OK
chatforum.phpbb_styles_template OK
chatforum.phpbb_styles_template_data OK
chatforum.phpbb_styles_theme OK
chatforum.phpbb_topics OK
chatforum.phpbb_topics_posted OK
chatforum.phpbb_topics_track OK
chatforum.phpbb_topics_watch OK
chatforum.phpbb_user_group OK
chatforum.phpbb_users OK
chatforum.phpbb_warnings OK
chatforum.phpbb_words OK
chatforum.phpbb_zebra OK

3- ?????? ?????? ????? ?? ?????? ?? ??? ????? ?? Optimize ??? ??? ??? ?????? ???????? ???????? ???? ?????? ????????? ? ???? ?????? ?? ????? ??????? ??????? ???? ???? ?? ??????? ??????? (?? ?????? ?? ????? ??? ?? ????????? ???? ????? ?????? ??? ????????? ??? ??????? ??????). ???? ??? ????? ??? ???? ???? ?????? ???????.

?? ?????? ??? ??? ????? ??? ????? ?? ????? ?????? ?? ??? ????? ?? ???? ??????? ????? ??????:

لاحظ كيف ان كلمة تاكيد تبقى موجوده بعد انتهاء عملية المزامنة - موجوده في زاوية المتصفح بالاعلى طبعا

phpbbarabia.PNG (13.9 KiB) تمت المشاهدة 8232 مرةً

???? ?????? ??? ?? ????? ???????? ?? ?????.

4- ??????? ?????? ??????? ???? ?? ??????? ??????? ???? ?? ??? ?????? ??????? ????? ????????? ?????? ?? ????? ????? ??? ??? ??????? ?? ??????? ??? ???? ???????? ????????? ????? ?? ?? ?????? ?????? ??? ?????? ??? ???? ?? ???? ????.

?? ?????? ?? ?????? ?? ??? ???? ??? ??? ?????? 3.0.4 .

?? ???? ?? ??????.?

????? ?????.

[saanina]

???? ?? ?????? ????? ??? ????? ??????? ??? ?????? ??? ??? ??????? "???? innodb" ???? ???
??? ?? ?????? ??? ??? ?????
???? innodb ?????? ????? ?? ????? ????? ????? , ???? ?????? ??????? ??? ?? ??????? ??? ?????? ???????
??? ???? ?? ???? ??? ???? ????? ??????? !!
?? ?????? ??? ?????? ???? ???? ??? ?????? ?? ???? ???????? ???????? ..

????????

[alahamdan]

??? ??????

????? ???????? ???????? ??? ???????:

1- ??????? ????? ???? ??? ??????? ? ??? ?? ??? ?? ?? ???? ??? ??? ?? ??????.

2- ?? InnoDB ??? ??? ??????? ? ???? ??? ???? ???? ????? ????? ?? ???? ???? ?????? ???? ????? ?? ??? ??????? ?? ???? ??????? ???? ??????? OPTIMIZE ??? ?????? ??????? ????????? ??? ????? ?? ??????? ??? ???? ?? ?????? (???? ?? ???? ??? ?? ???? ????? ???? ?? ????? MYSQL ???? ???????? ????? ??????? ???? ???????) ???? ??????? OPTIMIZE ????? ??? ?? ???? ????? ?? ??????? ????? ?? ?????.

??????? ???????:

??? ?????? ???????? ???????? ?? ??? ????? ?? ?????? ????????? ?????? ???? ???? ????? ??????? ???? ???? ????? ?? ???? ??????? ?? ??? ?? ????? ???????? ?? ????? ? ???? ???? ??? ?????? ???? ????????? ??? ??? ?? ???? ?????? ??? ???? ???? ????? ??? ???? ).

??? ????? ???????? ????? ??????? ? ???????? ???? ? ??? ???? ???????? ?? ????? ???? ???? ??? 6 ????!? ??? ?? ??????? ???? ?? ?????? ????? ????? ???????.

????

[saanina]

?? php.ini
memory_limit ?? ??????? ????? ..

[alahamdan]

??? ?????? ??????? ??? ????????? ?? 128 ??? 256 ??????? ????? ??? ?????? 512

??? ?????? max_execution_time ??????? ??? ?????? ?? ???.

?????? ???????? ???? ???? ?? ???? ??? ??????:

http://forums.mysql.com/read.php?22,34479,34709

??? ???? ?????? InnoDb ??? MyISAM ? ?? ????? ?? ??????? phpbb ?? ???? ????? ?????? MyISAM ????? ???????? ???? ??? ?? ?????? ??? ??? ??? ?????? ??? ???? ??? ???? ????? ??????? ????? ??? ??? ?? ????? ?????? ???? ???? ??? ??????? ??? ???? ?????? ??????? ??. ??? ?? ?????

????? ???????. ???? ????? ???.

[saanina]

??? ???? ?? ????? ?? ?????? ???? ?? ????? !
????? ?? InnoDb ???? ?? MyISAM ?? ??????? ????? ?????
???? ??? ???? ?? ???? ??? ????? ???????? ? 512 ???? ?????? ?? ???? ??? ?
??? ???? ?? ???? ???? ?? ??? ????? ????? ?????? ???? ???? ????? ?? ??? ??? ..

[alahamdan]

??? ??????

?? ???? ?????? ??????? ????

??? ??? ????? ?????? ?? ?????? ???? Plesk

?? ???? ????? PHP ?? MYSQL?

????

[alahamdan]

??? ??????

??? ?????? ?? Debug ?? ?? Config.php

???? ?? ??? ???????:

كود: تحديد الكل

[phpBB Debug] PHP Notice: in file /includes/functions_display.php on line 465: Undefined variable: last_post_subject_substr
[phpBB Debug] PHP Notice: in file /includes/functions_display.php on line 465: Undefined variable: last_post_subject_substr
[phpBB Debug] PHP Notice: in file /includes/functions_display.php on line 465: Undefined variable: last_post_subject_substr
[phpBB Debug] PHP Notice: in file /includes/functions_display.php on line 465: Undefined variable: last_post_subject_substr
[phpBB Debug] PHP Notice: in file /includes/functions_display.php on line 465: Undefined variable: last_post_subject_substr
[phpBB Debug] PHP Notice: in file /includes/functions_display.php on line 465: Undefined variable: last_post_subject_substr
[phpBB Debug] PHP Notice: in file /includes/functions_display.php on line 465: Undefined variable: last_post_subject_substr
[phpBB Debug] PHP Notice: in file /includes/functions_display.php on line 465: Undefined variable: last_post_subject_substr
[phpBB Debug] PHP Notice: in file /includes/functions_display.php on line 465: Undefined variable: last_post_subject_substr
[phpBB Debug] PHP Notice: in file /includes/functions_display.php on line 465: Undefined variable: last_post_subject_substr
[phpBB Debug] PHP Notice: in file /includes/functions_display.php on line 465: Undefined variable: last_post_subject_substr
[phpBB Debug] PHP Notice: in file /includes/functions_display.php on line 465: Undefined variable: last_post_subject_substr
[phpBB Debug] PHP Notice: in file /includes/functions_display.php on line 465: Undefined variable: last_post_subject_substr
[phpBB Debug] PHP Notice: in file /includes/functions_display.php on line 465: Undefined variable: last_post_subject_substr
[phpBB Debug] PHP Notice: in file /includes/functions_display.php on line 465: Undefined variable: last_post_subject_substr
[phpBB Debug] PHP Notice: in file /includes/functions_display.php on line 465: Undefined variable: last_post_subject_substr
[phpBB Debug] PHP Notice: in file /includes/functions_display.php on line 465: Undefined variable: last_post_subject_substr
[phpBB Debug] PHP Notice: in file /includes/functions_display.php on line 465: Undefined variable: last_post_subject_substr
[phpBB Debug] PHP Notice: in file /includes/functions_display.php on line 465: Undefined variable: last_post_subject_substr
[phpBB Debug] PHP Notice: in file /includes/functions_display.php on line 465: Undefined variable: last_post_subject_substr
[phpBB Debug] PHP Notice: in file /includes/functions_display.php on line 465: Undefined variable: last_post_subject_substr
[phpBB Debug] PHP Notice: in file /includes/functions_display.php on line 465: Undefined variable: last_post_subject_substr
[phpBB Debug] PHP Notice: in file /includes/functions_display.php on line 465: Undefined variable: last_post_subject_substr
[phpBB Debug] PHP Notice: in file /includes/functions_display.php on line 465: Undefined variable: last_post_subject_substr
[phpBB Debug] PHP Notice: in file /includes/functions_display.php on line 465: Undefined variable: last_post_subject_substr
[phpBB Debug] PHP Notice: in file /includes/functions_display.php on line 465: Undefined variable: last_post_subject_substr
[phpBB Debug] PHP Notice: in file /includes/functions_display.php on line 465: Undefined variable: last_post_subject_substr
[phpBB Debug] PHP Notice: in file /includes/functions_display.php on line 465: Undefined variable: last_post_subject_substr
[phpBB Debug] PHP Notice: in file /includes/functions_display.php on line 465: Undefined variable: last_post_subject_substr
[phpBB Debug] PHP Notice: in file /includes/functions_display.php on line 465: Undefined variable: last_post_subject_substr
[phpBB Debug] PHP Notice: in file /includes/functions_display.php on line 465: Undefined variable: last_post_subject_substr
[phpBB Debug] PHP Notice: in file /includes/functions_display.php on line 465: Undefined variable: last_post_subject_substr
[phpBB Debug] PHP Notice: in file /includes/functions_display.php on line 465: Undefined variable: last_post_subject_substr
[phpBB Debug] PHP Notice: in file /includes/functions_display.php on line 465: Undefined variable: last_post_subject_substr
[phpBB Debug] PHP Notice: in file /includes/functions_display.php on line 465: Undefined variable: last_post_subject_substr
[phpBB Debug] PHP Notice: in file /includes/functions_display.php on line 465: Undefined variable: last_post_subject_substr
[phpBB Debug] PHP Notice: in file /includes/functions_display.php on line 465: Undefined variable: last_post_subject_substr
[phpBB Debug] PHP Notice: in file /includes/functions_display.php on line 465: Undefined variable: last_post_subject_substr
[phpBB Debug] PHP Notice: in file /includes/functions_display.php on line 465: Undefined variable: last_post_subject_substr
[phpBB Debug] PHP Notice: in file /includes/functions_display.php on line 465: Undefined variable: last_post_subject_substr
[phpBB Debug] PHP Notice: in file /includes/functions_display.php on line 465: Undefined variable: last_post_subject_substr
[phpBB Debug] PHP Notice: in file /includes/functions_display.php on line 465: Undefined variable: last_post_subject_substr
[phpBB Debug] PHP Notice: in file /includes/functions_display.php on line 465: Undefined variable: last_post_subject_substr
[phpBB Debug] PHP Notice: in file /includes/functions_display.php on line 465: Undefined variable: last_post_subject_substr
[phpBB Debug] PHP Notice: in file /includes/functions_display.php on line 465: Undefined variable: last_post_subject_substr
[phpBB Debug] PHP Notice: in file /includes/functions_display.php on line 465: Undefined variable: last_post_subject_substr
[phpBB Debug] PHP Notice: in file /includes/functions_display.php on line 465: Undefined variable: last_post_subject_substr
[phpBB Debug] PHP Notice: in file /includes/functions_display.php on line 465: Undefined variable: last_post_subject_substr
[phpBB Debug] PHP Notice: in file /includes/functions_display.php on line 465: Undefined variable: last_post_subject_substr
[phpBB Debug] PHP Notice: in file /includes/functions.php on line 3844: Cannot modify header information - headers already sent by (output started at /includes/functions.php:3187)
[phpBB Debug] PHP Notice: in file /includes/functions.php on line 3846: Cannot modify header information - headers already sent by (output started at /includes/functions.php:3187)
[phpBB Debug] PHP Notice: in file /includes/functions.php on line 3847: Cannot modify header information - headers already sent by (output started at /includes/functions.php:3187)
[phpBB Debug] PHP Notice: in file /includes/functions.php on line 3848: Cannot modify header information - headers already sent by (output started at /includes/functions.php:3187)
Return to previous page

????? ???? ?????? ???? ??? ?????? ??? ?????? ????????!
Mmeory Usage : 3.37
56 Queries
Time : 0.391s

?? ?????

** ????? : ??? ???? ??? ????? ???????? ??? ????? ???? ???? ?????? ??????? ????? ????? ????? ??? Debug ???? ?? ???? ?? ?????.

???? ????? ?? ???????? ???? ???? ??????? ??????? ???? ??????? ???? ????? ??? ???? ??? ???? ??? ??? ????????? ???????.

[saanina]

????? ??????? ??????? ?????? ???? ????? innodb ???? ??? ??? ???? ?? phpmyadmin ???? ?? ?? ??????? ??????? !

[alahamdan]

???? ??? ??? ??? ????

??? ????? ?? ??? ??? ????? ??? ???? ??????? ??? ???? ????? ???????? ?????

??? ?????? ??? ????? ???????? ???? ????? ??????? ?? ???? ?????? (870 ?)?? ????? ??? ????????? ?????? MYSQLDUMP ( 390 ?) ??? ??????

?? ???? ???? ?????? Dump ??????? ?????? ?????? ?????

????? ??? ????? ??? ????.