-
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
Posts posted by ASTRAPI
-
-
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 -
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 -
I will use also the sqltuner but i want some recomendations about my.cnf and php.ini :)
-
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 -
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 -
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 -
admunde is my username on cpanel.
When top is running, hit the character 'C' and you will get more info where it says 'php'.
I got unknown command... -
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
Lines above mysqld on a CentOS system are like this:
6:18pm up 93 days, 13:11, 1 user, load average: 0.91, 0.87, 1.07 149 processes: 148 sleeping, 1 running, 0 zombie, 0 stopped CPU states: 14.3% user, 1.9% system, 0.0% nice, 83.7% idle Mem: 2075064K av, 1961744K used, 113320K free, 0K shrd, 187704K buff Swap: 2040244K av, 7656K used, 2032588K free 1244712K cached
Try and capture that when the server is slow, it will help us to help you. It gives us an idea whether the server is CPU bound or memeory bound or I/O bound.
It would also be useful to do the same output when the server is really fast. -
When I asked why YOU thought it was slow, I meant what you thought the cause (server load very high, no spare memory, no spare page memory, etc) might be, rather than the effect!(it takes 10 seconds for a page to appear)
I don't know.Surprised you cannot answer the questions about server load, memory occupancy and paging to disk when you run a dedicated server. Is it being managed for you, or are you expected to manage it yourself.
I am trying myself to handle it as my budget is low.Next time it goes really slow, run top and give us the lines above the mysqld line.
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
Finally, it's dedicated server, but are there any other scripts/sites running at the same time when your board goes slowly?
No other sites pages only a IPS Shoutbox (10 seconds refresh rate) and Top 10 Ajax (30 seconds refresh rate). -
What version of IPB are you running?
V2.3.6Why do YOU think it's slow?
I need more than 10 seconds to open a topic.Is it paging to disk and the memory is completely utilised, or is paging to disk and a lot of memory is unallocated, or is it not paging to disk at all?
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
-
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?/ - 50GB
swap - 16GB
/vz - the rest of the disk
/boot - 400 MB
A configuration like this?
This is my my.cnf:[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
Top output: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
Now is it possible having there cpanel to use lihtttpd or nginx and xcache?
Thank you
my.cnf and php.ini optimization
in Classic self-hosted technical help
Posted
any one ?