MYSQL CPU kullanımı %356 - Sayfa 2

26-01-2015, 15:19:35

#10

16 gb ram var 2 çekirdek işlemci VDS makine. Ortalama 5-6k hit var makinede. Norma disk yapısandayım SSD kullanmıyoruz. Yüksek hitli sitem bulunmuyor.

26-01-2015, 15:23:26

#11

~~LineDatacenter~~

Üyeliği durduruldu

hasip adlı üyeden alıntı: mesajı görüntüle

16 gb ram var 2 çekirdek işlemci VDS makine. Ortalama 5-6k hit var makinede. Norma disk yapısandayım SSD kullanmıyoruz. Yüksek hitli sitem bulunmuyor.

merhaba

[mysqld]
local-infile=0
bind-address=127.0.0.1
skip-networking
key_buffer_size = 256M
myisam_sort_buffer_size = 64M
read_buffer_size = 1M
table_open_cache = 5000
thread_cache_size = 384
wait_timeout = 20
connect_timeout = 10
tmp_table_size = 256M
max_heap_table_size = 256M
max_allowed_packet=268435456
net_buffer_length = 16384
concurrent_insert = 2
read_rnd_buffer_size = 786432
bulk_insert_buffer_size = 8M
query_cache_limit = 5M
query_cache_size = 128M
query_cache_type = 1
query_prealloc_size = 262144
query_alloc_block_size = 65535
transaction_alloc_block_size = 8192
transaction_prealloc_size = 4096
innodb_buffer_pool_size = 7G
max_write_lock_count = 8
external-locking=FALSE
open_files_limit=100000

key_buffer = 384M
sort_buffer = 384M
read_buffer = 256M
write_buffer = 256M


key_buffer = 128M
sort_buffer = 128M
read_buffer = 128M
write_buffer = 128M

sort_buffer_size = 1M
join_buffer_size = 1M
thread_stack = 192K

26-01-2015, 15:35:24

#12

hasip

150126 15:33:26 mysqld_safe mysqld from pid file /var/lib/mysql/xxxx.net.pid ended
2015-01-26 15:33:26 6223 [Note] /usr/sbin/mysqld: Shutdown complete
2015-01-26 15:33:26 6223 [ERROR] /usr/sbin/mysqld: unknown variable 'write_buffer=256M'
150126 15:33:26 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
150126 15:33:25 mysqld_safe mysqld from pid file /var/lib/mysql/xxx.net.pid ended
2015-01-26 15:33:25 27045 [Note] /usr/sbin/mysqld: Shutdown complete

write_buffer=256M satırı hata verdi hocam

26-01-2015, 15:36:45

#13

~~LineDatacenter~~

Üyeliği durduruldu

hasip adlı üyeden alıntı: mesajı görüntüle

150126 15:33:26 mysqld_safe mysqld from pid file /var/lib/mysql/xxxx.net.pid ended
2015-01-26 15:33:26 6223 [Note] /usr/sbin/mysqld: Shutdown complete
2015-01-26 15:33:26 6223 [ERROR] /usr/sbin/mysqld: unknown variable 'write_buffer=256M'
150126 15:33:26 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
150126 15:33:25 mysqld_safe mysqld from pid file /var/lib/mysql/xxx.net.pid ended
2015-01-26 15:33:25 27045 [Note] /usr/sbin/mysqld: Shutdown complete

merhaba

mysql sürümünüz nedir?

[mysqld]
local-infile=0
bind-address=127.0.0.1
skip-networking
key_buffer_size = 512M
myisam_sort_buffer_size = 64M
read_buffer_size = 1M
table_open_cache = 5000
thread_cache_size = 384
wait_timeout = 20
connect_timeout = 10
tmp_table_size = 256M
max_heap_table_size = 256M
max_allowed_packet=268435456
net_buffer_length = 16384
concurrent_insert = 2
read_rnd_buffer_size = 786432
bulk_insert_buffer_size = 8M
query_cache_limit = 5M
query_cache_size = 128M
query_cache_type = 1
query_prealloc_size = 262144
query_alloc_block_size = 65535
transaction_alloc_block_size = 8192
transaction_prealloc_size = 4096
innodb_buffer_pool_size = 7G
max_write_lock_count = 8
external-locking=FALSE
open_files_limit=250000
[mysqld_safe]

[mysqldump]
quick
max_allowed_packet = 16M

[isamchk]
key_buffer = 384M
sort_buffer = 384M
read_buffer = 256M
write_buffer = 256M

[myisamchk]
key_buffer = 128M
sort_buffer = 128M
read_buffer = 128M
write_buffer = 128M

#### Per connection configuration ####
sort_buffer_size = 1M
join_buffer_size = 1M
thread_stack = 192K

bu şekilde güncelleyin düzelecektir.

26-01-2015, 15:40:59

#14

hasip

Log Messages:
150126 15:39:14 mysqld_safe mysqld from pid file /var/lib/mysql/xxx.pid ended
2015-01-26 15:39:14 7954 [Note] /usr/sbin/mysqld: Shutdown complete
150126 15:39:14 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
150126 15:38:42 mysqld_safe mysqld from pid file /var/lib/mysql/dedi373.7x24web.net.pid ended
2015-01-26 15:38:42 7468 [Note] /usr/sbin/mysqld: Shutdown complete
150126 15:38:42 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
150126 15:34:27 mysqld_safe mysqld from pid file /var/lib/mysql/xxxb.net.pid ended
2015-01-26 15:34:27 6865 [Note] /usr/sbin/mysqld: Shutdown complete

Merhaba hocam bu seferde böyle bir hata aldım.

26-01-2015, 15:44:02

#15

~~LineDatacenter~~

Üyeliği durduruldu

hasip adlı üyeden alıntı: mesajı görüntüle

Log Messages:
150126 15:39:14 mysqld_safe mysqld from pid file /var/lib/mysql/xxx.pid ended
2015-01-26 15:39:14 7954 [Note] /usr/sbin/mysqld: Shutdown complete
150126 15:39:14 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
150126 15:38:42 mysqld_safe mysqld from pid file /var/lib/mysql/dedi373.7x24web.net.pid ended
2015-01-26 15:38:42 7468 [Note] /usr/sbin/mysqld: Shutdown complete
150126 15:38:42 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
150126 15:34:27 mysqld_safe mysqld from pid file /var/lib/mysql/xxxb.net.pid ended
2015-01-26 15:34:27 6865 [Note] /usr/sbin/mysqld: Shutdown complete

Merhaba hocam bu seferde böyle bir hata aldım.

merhaba

mysql sürüm nedir.

26-01-2015, 15:50:12

#16

hasip

mysql uçtuğu için arayüze giremiyorum ssh ile nasıl bakabilirim hocam.

26-01-2015, 15:51:05

#17

~~LineDatacenter~~

Üyeliği durduruldu

hasip adlı üyeden alıntı: mesajı görüntüle

mysql uçtuğu için arayüze giremiyorum ssh ile nasıl bakabilirim hocam.

merhaba

mysql -V

26-01-2015, 15:55:03

#18

hasip

mysql Ver 14.14 Distrib 5.6.22, for Linux (i686) using EditLine wrapper

14.14 müş hocam.