Jump to content

ASTRAPI

Members
  • Posts

    1,638
  • Joined

  • Last visited

  • Days Won

    6

 Content Type 

Downloads

Release Notes

IPS4 Guides

IPS4 Developer Documentation

Invision Community Blog

Development Blog

Deprecation Tracker

Providers Directory

Forums

Events

Store

Gallery

Everything posted by ASTRAPI

  1. Hello I want the easiest way to convert my database from latin1 to utf8 and what other settings i must do to my system ex:php.ini , my.cnf to have full utf8? Thank you
  2. For me i think it works without any problems but when i was run : /usr/local/bin/searchd --config /usr/local/etc/sphinx_ipb.conf I got this : using config file '/usr/local/etc/sphinx_ipb.conf'... WARNING: key 'strip_html' is deprecated in /usr/local/etc/sphinx_ipb.conf line 14; use 'html_strip (per-index)' instead. WARNING: key 'index_html_attrs' is deprecated in /usr/local/etc/sphinx_ipb.conf line 16; use 'html_index_attrs (per-index)' instead. WARNING: key 'sql_group_column' is deprecated in /usr/local/etc/sphinx_ipb.conf line 37; use 'sql_attr_uint' instead. WARNING: key 'sql_group_column' is deprecated in /usr/local/etc/sphinx_ipb.conf line 38; use 'sql_attr_uint' instead. WARNING: key 'sql_group_column' is deprecated in /usr/local/etc/sphinx_ipb.conf line 39; use 'sql_attr_uint' instead. But i select the sphinx engine from the ACP and it works for me. Now i want to find a way if i am realy use this engine and what are those errors are plus greek characters support (i use utf-8 in acp) Also my users will be able to search titles only as i already set it as default in the default invision search? Any ideas? Forum v2.3.x Sphinx 0.9.8.1
  3. I will use also the sqltuner but i want some recomendations about my.cnf and php.ini :)
  4. Hello I found the Mod by Prolag about sphinx and i want to ask please about what is the newest version of sphinx that works for Ipb v2.3.x with that mod? Do i have to be care after installation to get it work without any problems? I want to use also the method live updates Delta runing every minute. Thank you
  5. Hello For a server: # 2x Intel Xeon Quad 5405 # 8192 MB FB DDR2 RAM # 500 GB 7.200 RPM 1.000 Mbit Unshared Centos 64Bit What settings i can use for my.cnf and php.ini? my.cnf: [mysqld] port = 3306 socket = /var/lib/mysql/mysql.sock skip-locking skip-innodb skip-bdb key_buffer = 10M max_allowed_packet = 1M table_cache = 1024 sort_buffer_size = 2M read_buffer_size = 1M read_rnd_buffer_size = 1M net_buffer_length = 2K thread_stack = 64K log-slow-queries = /var/log/mysql/mysql-slow.log server-id = 1 skip-networking [mysqldump] quick max_allowed_packet = 1M [mysql] no-auto-rehash safe-updates [isamchk] key_buffer = 10M sort_buffer_size = 2M [myisamchk] key_buffer = 10M sort_buffer_size = 2M My php.ini settings: max_execution_time = 30 ; Maximum execution time of each script, in seconds max_input_time = 60 ; Maximum amount of time each script may spend parsing request data memory_limit = 32M ; Maximum amount of memory a script may consume (32MB) [mSQL] ; Allow or prevent persistent links. msql.allow_persistent = On ; Maximum number of persistent links. -1 means no limit. msql.max_persistent = -1 ; Maximum number of links (persistent+non persistent). -1 means no limit. msql.max_links = -1 [PostgresSQL] ; Allow or prevent persistent links. pgsql.allow_persistent = On ; Detect broken persistent links always with pg_pconnect(). Need a little overhead. pgsql.auto_reset_persistent = Off ; Maximum number of persistent links. -1 means no limit. pgsql.max_persistent = -1 ; Maximum number of links (persistent+non persistent). -1 means no limit. pgsql.max_links = -1 ; Ignore PostgreSQL backends Notice message or not. pgsql.ignore_notice = 0 ; Log PostgreSQL backends Noitce message or not. ; Unless pgsql.ignore_notice=0, module cannot log notice message. pgsql.log_notice = 0 [Sybase] ; Allow or prevent persistent links. sybase.allow_persistent = On ; Maximum number of persistent links. -1 means no limit. sybase.max_persistent = -1 ; Maximum number of links (persistent + non-persistent). -1 means no limit. sybase.max_links = -1 ;sybase.interface_file = "/usr/sybase/interfaces" ; Minimum error severity to display. sybase.min_error_severity = 10 ; Minimum message severity to display. sybase.min_message_severity = 10 Thank you
  6. Hello I was wondering for huge forums do you use special partitioning on the disk for better performance and if the difference is very big. For example: /var 50gb /usr 50gb /root 50gb /tmp (/dev/shm : 10 GB) /swap 16gb /home the rest of the disk Or you use the disk with the default installation from Datacenter? Thank you
  7. When it takes 7 seconds for my index and 15 for any topic i got this from top: top - 20:26:37 up 23:26, 1 user, load average: 9.29, 11.03, 11.42 Tasks: 108 total, 5 running, 99 sleeping, 0 stopped, 4 zombie Cpu(s): 4.9%us, 18.6%sy, 22.0%ni, 38.8%id, 15.2%wa, 0.0%hi, 0.4%si, 0.0%st Mem: 3368496k total, 1879356k used, 1489140k free, 295264k buffers Swap: 2096472k total, 75024k used, 2021448k free, 1229356k cached PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 2093 mysql 21 6 391m 150m 3948 S 87.1 4.6 794:26.12 mysqld 28909 admunde 20 4 45944 17m 9808 S 15.8 0.5 0:00.08 php 28895 admunde 20 4 46192 18m 9468 S 13.9 0.6 0:00.12 php 28908 admunde 20 4 0 0 0 Z 13.9 0.0 0:00.07 php <defunct> 28904 admunde 20 4 45944 18m 9828 S 11.9 0.5 0:00.09 php 28906 admunde 23 4 41932 12m 7496 R 7.9 0.4 0:00.04 php 28278 nobody 21 4 287m 10m 2020 S 5.9 0.3 0:00.91 httpd 24115 nobody 21 4 288m 10m 2276 S 2.0 0.3 0:07.50 httpd 28736 nobody 21 4 285m 7556 2016 S 2.0 0.2 0:00.14 httpd Another one when things are worst: top - 21:11:03 up 1 day, 11 min, 1 user, load average: 29.45, 34.41, 25.35 Tasks: 203 total, 1 running, 202 sleeping, 0 stopped, 0 zombie Cpu(s): 4.8%us, 18.8%sy, 22.3%ni, 37.8%id, 15.8%wa, 0.0%hi, 0.5%si, 0.0%st Mem: 3368496k total, 2317904k used, 1050592k free, 64468k buffers Swap: 2096472k total, 74948k used, 2021524k free, 1092252k cached PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 2093 mysql 21 6 384m 147m 3948 S 102.4 4.5 823:00.08 mysqld 1506 root 0 -20 0 0 0 D 9.9 0.0 55:19.75 loop0 16458 admunde 21 4 41932 9960 5384 D 5.9 0.3 0:00.03 php
  8. I don't know. I am trying myself to handle it as my budget is low. 2280 mysql 21 6 126m 72m 3704 S 149.3 2.2 121:12.99 mysqld 1621 root 0 -20 0 0 0 R 11.4 0.0 1:47.02 loop0 20315 nobody 20 4 32024 15m 2876 S 2.3 0.5 0:01.69 httpd 20933 nobody 19 4 30136 14m 2844 S 2.3 0.4 0:00.45 httpd 20987 nobody 20 4 32692 16m 2848 S 2.3 0.5 0:00.51 httpd 20923 nobody 20 4 29076 13m 2840 S 2.0 0.4 0:00.56 httpd 21378 nobody 20 4 31520 15m 2772 S 2.0 0.5 0:00.11 httpd 20968 nobody 19 4 25044 9.8m 2844 S 1.6 0.3 0:00.38 httpd 20997 root 15 0 0 0 0 S 1.6 0.0 0:02.50 pdflush 21392 nobody 19 4 30020 14m 2708 S 1.6 0.4 0:00.05 httpd 384 root 10 -5 0 0 0 S 1.3 0.0 0:09.99 kjournald 21190 nobody 19 4 28300 12m 2844 S 1.3 0.4 0:00.22 httpd 21398 nobody 27 4 28648 12m 2716 S 1.3 0.4 0:00.04 httpd 21401 nobody 29 4 28648 12m 2740 S 1.3 0.4 0:00.04 httpd 19875 nobody 20 4 28336 12m 2844 S 1.0 0.4 0:01.43 httpd 20945 nobody 19 4 28252 12m 2796 S 1.0 0.4 0:00.32 httpd 20964 nobody 19 4 29884 14m 2848 S 1.0 0.4 0:00.90 httpd 20974 nobody 19 4 28252 12m 2836 S 1.0 0.4 0:00.52 httpd 21359 nobody 19 4 29288 13m 2828 S 1.0 0.4 0:00.13 httpd 21402 nobody 29 4 27896 12m 2708 S 1.0 0.4 0:00.03 httpd 21404 nobody 29 4 27892 11m 2712 R 1.0 0.4 0:00.03 httpd 1622 root 12 -5 0 0 0 S 0.7 0.0 0:08.14 kjournald 21189 nobody 19 4 30792 15m 2836 S 0.7 0.5 0:00.28 httpd 21376 nobody 19 4 24456 9372 2760 S 0.7 0.3 0:00.07 httpd 2670 root 29 4 23652 9272 3836 S 0.3 0.3 0:01.68 httpd 20242 nobody 20 4 29308 13m 2848 S 0.3 0.4 0:00.98 httpd 20299 nobody 19 4 29432 14m 3172 S 0.3 0.4 0:00.95 httpd 20873 nobody 19 4 29364 13m 2844 S 0.3 0.4 0:00.67 httpd 20887 nobody 20 4 32972 16m 2796 S 0.3 0.5 0:00.54 httpd 20941 nobody 19 4 30680 15m 2844 S 0.3 0.5 0:00.76 httpd 20952 nobody 19 4 29356 14m 3284 S 0.3 0.4 0:00.42 httpd 20953 nobody 19 4 29248 13m 2796 S 0.3 0.4 0:00.36 httpd 20982 nobody 19 4 30108 14m 2844 S 0.3 0.4 0:00.56 httpd 21184 nobody 19 4 24404 9404 2836 S 0.3 0.3 0:00.13 httpd 21185 nobody 19 4 26132 10m 2844 S 0.3 0.3 0:00.36 httpd 21381 nobody 20 4 29160 13m 2732 S 0.3 0.4 0:00.05 httpd 21384 root 15 0 2328 1096 796 R 0.3 0.0 0:00.01 top 1 root 15 0 2064 664 572 S 0.0 0.0 0:00.59 init 2 root RT -5 0 0 0 S 0.0 0.0 0:00.00 migration/0 3 root 34 19 0 0 0 S 0.0 0.0 0:00.00 ksoftirqd/0 4 root RT -5 0 0 0 S 0.0 0.0 0:00.00 watchdog/0 5 root RT -5 0 0 0 S 0.0 0.0 0:00.00 migration/1 6 root 34 19 0 0 0 S 0.0 0.0 0:00.00 ksoftirqd/1 7 root RT -5 0 0 0 S 0.0 0.0 0:00.00 watchdog/1 8 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 events/0 9 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 events/1 10 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 khelper 11 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 kthread 15 root 10 -5 0 0 0 S 0.0 0.0 0:00.12 kblockd/0 16 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 kblockd/1 17 root 14 -5 0 0 0 S 0.0 0.0 0:00.00 kacpid 88 root 14 -5 0 0 0 S 0.0 0.0 0:00.00 cqueue/0 89 root 14 -5 0 0 0 S 0.0 0.0 0:00.00 cqueue/1 No other sites pages only a IPS Shoutbox (10 seconds refresh rate) and Top 10 Ajax (30 seconds refresh rate).
  9. V2.3.6 I need more than 10 seconds to open a topic. How can i check this? Config in code boxes: [mysqld] local-infile=0 datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock skip-locking ## skip-innodb query_cache_limit=8M query_cache_size=4M query_cache_type=1 max_user_connections=240 max_connections=500 interactive_timeout=100 wait_timeout=60 connect_timeout=50 thread_cache_size=128 key_buffer=155M join_buffer=1M max_allowed_packet=16M table_cache=1024 record_buffer=1M sort_buffer_size=4M read_buffer_size=4M max_connect_errors=10 thread_concurrency=8 concurrent_insert=2 long_query_time=3 join_buffer_size=2M low_priority_updates=1 myisam_sort_buffer_size=64M skip-networking server-id=1 #[mysql.server] #user=mysql #basedir=/var/lib [safe_mysqld] err-log=/var/log/mysqld.log pid-file=/var/lib/mysql/mysql.pid open_files_limit=8192 #[mysqldump] #quick #max_allowed_packet=16M [mysql] no-auto-rehash [isamchk] key_buffer=64M sort_buffer=64M read_buffer=16M write_buffer=16M [myisamchk] key_buffer=64M sort_buffer=64M read_buffer=16M write_buffer=16M [mysqlhotcopy] interactive-timeout 2280 mysql 21 6 126m 72m 3704 S 149.3 2.2 121:12.99 mysqld 1621 root 0 -20 0 0 0 R 11.4 0.0 1:47.02 loop0 20315 nobody 20 4 32024 15m 2876 S 2.3 0.5 0:01.69 httpd 20933 nobody 19 4 30136 14m 2844 S 2.3 0.4 0:00.45 httpd 20987 nobody 20 4 32692 16m 2848 S 2.3 0.5 0:00.51 httpd 20923 nobody 20 4 29076 13m 2840 S 2.0 0.4 0:00.56 httpd 21378 nobody 20 4 31520 15m 2772 S 2.0 0.5 0:00.11 httpd 20968 nobody 19 4 25044 9.8m 2844 S 1.6 0.3 0:00.38 httpd 20997 root 15 0 0 0 0 S 1.6 0.0 0:02.50 pdflush 21392 nobody 19 4 30020 14m 2708 S 1.6 0.4 0:00.05 httpd Mysql Tunner results: [!!] Switch to 64-bit OS - MySQL cannot currently use all of your RAM [!!] InnoDB is enabled but isn't being used [!!] Total fragmented tables: 12 [!!] Allocating > 2GB RAM on 32-bit systems can cause system instability [!!] Maximum possible memory usage: 5.3G (164% of installed RAM) [!!] Query cache prunes per day: 60755 [!!] Sorts requiring temporary tables: 88% (96K temp sorts / 108K sorts) [!!] Table locks acquired immediately: 93% Tunining Primer for aql results: SLOW QUERIES The slow query log is NOT enabled. Current long_query_time = 3 sec. You have 2916 out of 1886723 that take longer than 3 sec. to complete Your long_query_time seems to be fine BINARY UPDATE LOG The binary update log is NOT enabled. You will not be able to do point in time recovery See http://dev.mysql.com/doc/refman/5.0/en/point-in-time-recovery.html WORKER THREADS Current thread_cache_size = 128 Current threads_cached = 117 Current threads_per_sec = 0 Historic threads_per_sec = 0 Your thread_cache_size is fine MAX CONNECTIONS Current max_connections = 500 Current threads_connected = 5 Historic max_used_connections = 121 The number of used connections is 24% of the configured maximum. Your max_connections variable seems to be fine. MEMORY USAGE Max Memory Ever Allocated : 1.39 G Configured Max Per-thread Buffers : 5.09 G Configured Max Global Buffers : 169 M Configured Max Memory Limit : 5.26 G Physical Memory : 3.21 G Max memory limit exceeds 90% of physical memory KEY BUFFER Current MyISAM index space = 162 M Current key_buffer_size = 155 M Key cache miss rate is 1 : 14493 Key buffer free ratio = 61 % Your key_buffer_size seems to be too high. Perhaps you can use these resources elsewhere QUERY CACHE Query cache is enabled Current query_cache_size = 4 M Current query_cache_used = 3 M Current query_cache_limit = 8 M Current Query cache Memory fill ratio = 99.06 % Current query_cache_min_res_unit = 4 K However, 44905 queries have been removed from the query cache due to lack of memory Perhaps you should raise query_cache_size MySQL won't cache query results that are larger than query_cache_limit in size SORT OPERATIONS Current sort_buffer_size = 4 M Current read_rnd_buffer_size = 256 K Sort buffer seems to be fine JOINS Current join_buffer_size = 2.00 M You have had 42 queries where a join could not use an index properly You should enable "log-queries-not-using-indexes" Then look for non indexed joins in the slow query log. If you are unable to optimize your queries you may want to increase your join_buffer_size to accommodate larger joins in one pass. Note! This script will still suggest raising the join_buffer_size when ANY joins not using indexes are found. OPEN FILES LIMIT Current open_files_limit = 2558 files The open_files_limit should typically be set to at least 2x-3x that of table_cache if you have heavy MyISAM usage. Your open_files_limit value seems to be fine TABLE CACHE Current table_cache value = 1024 tables You have a total of 163 tables You have 559 open tables. The table_cache value seems to be fine TEMP TABLES Current max_heap_table_size = 16 M Current tmp_table_size = 32 M Of 1464 temp tables, 17% were created on disk Effective in-memory tmp_table_size is limited to max_heap_table_size. Created disk tmp tables ratio seems fine TABLE SCANS Current read_buffer_size = 4 M Current table scan ratio = 2701 : 1 read_buffer_size seems to be fine TABLE LOCKING Current Lock Wait ratio = 1 : 14 You may benefit from selective use of InnoDB. Mysql s when i got ips driver error: Threads: 44 Questions: 2065042 Slow queries: 4298 Opens: 1056 Flush tables: 1 Open tables: 851 Queries per second avg: 30.721
  10. Hello I own a dedicated server: Processor : PE R200 Dual Core Xeon 3065 (2.33GHz, 4MB, 1333MHz FSB) Memory : 4GB (4x1GB Dual Rank DIMMs) 667MHz Harddisk : 500GB SATA (7,200rpm) 3.5inch Hard Drive (non hot-plug) 100Mbit Unshared Centos OS 32Bit One partition for the hard disk. Cpanel as Control panel. One partition for the hard disk. I have about 500.000 posts and about 30.000 users with daily 1000 new messages. Sql queries on index 11 and 1mb extra graphics. When i have the maximum for me 500 users per hour i can see about 900 sql connections using \s. My problem is that my forum is very very slow and sometimes i am getting IPS Error (the connection lost with the database) but i don't know why and what can i do to improve it. When i have 450 users and i need 10-20 seconds to open a topic i was try to restart the server and then i was able to have 500 users and super speed 1-2 seconds for openng a topic. So i was thinking as my Datacenter don't have a better hard disk to add more ram and 64bit OS Centos but how i must ask to be the partition? A configuration like this? This is my my.cnf: Top output: Now is it possible having there cpanel to use lihtttpd or nginx and xcache? Thank you
×
×
  • Create New...