-
TC Kimlik Numaranızı onaylayarak iyinet.com'dan tam olarak yararlanabilirsiniz. Konu açabilmek ve açılan konulara yazabilmek için lütfen Türkiye Cumhuriyeti Kimlik Numaranızı doğrulayın. Doğrulama ile ilgili hata alıyorsanız, kimlik ön yüzündeki Ad Soyad, Doğum yılı ve TC Kimlik numarası görünecek şekilde kimlik resmini bize gönderebilirsiniz.
ftp den /etc dosyasına girebilen varmı?
Winscp adlı programı kullanabilirsiniz.
Down: http://www.htservers.net/winscp382setup.exe
Down: http://www.htservers.net/winscp382setup.exe
http://forum.iyinet.com/veritabani-sql-mysql/52396-linux-te-mysql-optimizasyonu-icin-gerekenler.htmlftp den /etc dosyasına girebilen varmı? varsa nasıl oluyor , ben ws-Ftp kullanıyorum ve etc ye ulaşamıyorum , ulaşırsam "my.cnf" dosyasın burada yayınlayacağım
benim "my.cnf"
[mysqld]
set-variable=local-infile=0
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
[mysql.server]
user=mysql
basedir=/var/lib
[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
[mysqld]
set-variable=local-infile=0
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
[mysql.server]
user=mysql
basedir=/var/lib
[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
rapor :
Top
---------------------------------------------------
Sat Mar 31 01:17:49 EEST 2007
[H[2J[m(Btop - 01:17:50 up 3 days, 5:32, 1 user, load average: 1.72, 1.13, 1.91[m(B[39;49m[K
Tasks:[m(B[39;49m[m(B 95 [m(B[39;49mtotal,[m(B[39;49m[m(B 1 [m(B[39;49mrunning,[m(B[39;49m[m(B 94 [m(B[39;49msleeping,[m(B[39;49m[m(B 0 [m(B[39;49mstopped,[m(B[39;49m[m(B 0 [m(B[39;49mzombie[m(B[39;49m[K
Cpu(s):[m(B[39;49m[m(B 54.3% [m(B[39;49mus,[m(B[39;49m[m(B 8.0% [m(B[39;49msy,[m(B[39;49m[m(B 0.0% [m(B[39;49mni,[m(B[39;49m[m(B 37.4% [m(B[39;49mid,[m(B[39;49m[m(B 0.2% [m(B[39;49mwa,[m(B[39;49m[m(B 0.0% [m(B[39;49mhi,[m(B[39;49m[m(B 0.0% [m(B[39;49msi[m(B[39;49m[K
Mem: [m(B[39;49m[m(B 483476k [m(B[39;49mtotal,[m(B[39;49m[m(B 456728k [m(B[39;49mused,[m(B[39;49m[m(B 26748k [m(B[39;49mfree,[m(B[39;49m[m(B 28860k [m(B[39;49mbuffers[m(B[39;49m[K
Swap:[m(B[39;49m[m(B 1052248k [m(B[39;49mtotal,[m(B[39;49m[m(B 60872k [m(B[39;49mused,[m(B[39;49m[m(B 991376k [m(B[39;49mfree,[m(B[39;49m[m(B 194872k [m(B[39;49mcached[m(B[39;49m[K
[6;1H
[7m PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND [m(B[39;49m[K
[m(B11410 apache 15 0 34684 16m 4644 S 3.1 3.4 1:55.02 /usr/sbin/httpd [m(B[39;49m
[m(B21908 mysql 16 0 149m 38m 4048 S 1.6 8.2 44:44.70 /usr/libexec/mysqld[m(B[39;49m
[m(B16790 apache 15 0 34668 15m 4376 S 1.6 3.4 1:03.63 /usr/sbin/httpd [m(B[39;49m
[m(B19030 apache 15 0 34648 15m 4380 S 1.6 3.4 0:44.69 /usr/sbin/httpd [m(B[39;49m
[m(B20152 apache 15 0 34668 15m 4376 S 1.6 3.4 0:36.56 /usr/sbin/httpd [m(B[39;49m
[m(B21302 apache 15 0 34380 15m 4360 S 1.6 3.3 0:31.88 /usr/sbin/httpd [m(B[39;49m
[m(B[m(B23936 root 16 0 2360 880 692 R 1.6 0.2 0:00.02 top -c -n1 [m(B[39;49m
[m(B 1 root 16 0 2292 456 428 S 0.0 0.1 0:00.87 init [3] [m(B[39;49m
[m(B 2 root 34 19 0 0 0 S 0.0 0.0 0:00.04 [ksoftirqd/0] [m(B[39;49m
[m(B 3 root 5 -10 0 0 0 S 0.0 0.0 0:00.06 [events/0] [m(B[39;49m
[m(B 4 root 6 -10 0 0 0 S 0.0 0.0 0:00.01 [khelper] [m(B[39;49m
[m(B 5 root 15 -10 0 0 0 S 0.0 0.0 0:00.00 [kacpid] [m(B[39;49m
[m(B 19 root 5 -10 0 0 0 S 0.0 0.0 0:00.00 [kblockd/0] [m(B[39;49m
[m(B 38 root 15 0 0 0 0 S 0.0 0.0 0:02.28 [pdflush] [m(B[39;49m
[m(B 40 root 12 -10 0 0 0 S 0.0 0.0 0:00.00 [aio/0] [m(B[39;49m
[m(B 20 root 15 0 0 0 0 S 0.0 0.0 0:00.00 [khubd] [m(B[39;49m
[m(B 39 root 15 0 0 0 0 S 0.0 0.0 0:26.98 [kswapd0] [m(B[39;49m[6;1H[K[25;1H[?12l[?25h
my.cnf
---------------------------------------------------
Sat Mar 31 01:17:50 EEST 2007
[mysqld]
set-variable=local-infile=0
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
[mysql.server]
user=mysql
basedir=/var/lib
[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
show status
---------------------------------------------------
Sat Mar 31 01:17:50 EEST 2007
Top
---------------------------------------------------
Sat Mar 31 01:17:49 EEST 2007
[H[2J[m(Btop - 01:17:50 up 3 days, 5:32, 1 user, load average: 1.72, 1.13, 1.91[m(B[39;49m[K
Tasks:[m(B[39;49m[m(B 95 [m(B[39;49mtotal,[m(B[39;49m[m(B 1 [m(B[39;49mrunning,[m(B[39;49m[m(B 94 [m(B[39;49msleeping,[m(B[39;49m[m(B 0 [m(B[39;49mstopped,[m(B[39;49m[m(B 0 [m(B[39;49mzombie[m(B[39;49m[K
Cpu(s):[m(B[39;49m[m(B 54.3% [m(B[39;49mus,[m(B[39;49m[m(B 8.0% [m(B[39;49msy,[m(B[39;49m[m(B 0.0% [m(B[39;49mni,[m(B[39;49m[m(B 37.4% [m(B[39;49mid,[m(B[39;49m[m(B 0.2% [m(B[39;49mwa,[m(B[39;49m[m(B 0.0% [m(B[39;49mhi,[m(B[39;49m[m(B 0.0% [m(B[39;49msi[m(B[39;49m[K
Mem: [m(B[39;49m[m(B 483476k [m(B[39;49mtotal,[m(B[39;49m[m(B 456728k [m(B[39;49mused,[m(B[39;49m[m(B 26748k [m(B[39;49mfree,[m(B[39;49m[m(B 28860k [m(B[39;49mbuffers[m(B[39;49m[K
Swap:[m(B[39;49m[m(B 1052248k [m(B[39;49mtotal,[m(B[39;49m[m(B 60872k [m(B[39;49mused,[m(B[39;49m[m(B 991376k [m(B[39;49mfree,[m(B[39;49m[m(B 194872k [m(B[39;49mcached[m(B[39;49m[K
[6;1H
[7m PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND [m(B[39;49m[K
[m(B11410 apache 15 0 34684 16m 4644 S 3.1 3.4 1:55.02 /usr/sbin/httpd [m(B[39;49m
[m(B21908 mysql 16 0 149m 38m 4048 S 1.6 8.2 44:44.70 /usr/libexec/mysqld[m(B[39;49m
[m(B16790 apache 15 0 34668 15m 4376 S 1.6 3.4 1:03.63 /usr/sbin/httpd [m(B[39;49m
[m(B19030 apache 15 0 34648 15m 4380 S 1.6 3.4 0:44.69 /usr/sbin/httpd [m(B[39;49m
[m(B20152 apache 15 0 34668 15m 4376 S 1.6 3.4 0:36.56 /usr/sbin/httpd [m(B[39;49m
[m(B21302 apache 15 0 34380 15m 4360 S 1.6 3.3 0:31.88 /usr/sbin/httpd [m(B[39;49m
[m(B[m(B23936 root 16 0 2360 880 692 R 1.6 0.2 0:00.02 top -c -n1 [m(B[39;49m
[m(B 1 root 16 0 2292 456 428 S 0.0 0.1 0:00.87 init [3] [m(B[39;49m
[m(B 2 root 34 19 0 0 0 S 0.0 0.0 0:00.04 [ksoftirqd/0] [m(B[39;49m
[m(B 3 root 5 -10 0 0 0 S 0.0 0.0 0:00.06 [events/0] [m(B[39;49m
[m(B 4 root 6 -10 0 0 0 S 0.0 0.0 0:00.01 [khelper] [m(B[39;49m
[m(B 5 root 15 -10 0 0 0 S 0.0 0.0 0:00.00 [kacpid] [m(B[39;49m
[m(B 19 root 5 -10 0 0 0 S 0.0 0.0 0:00.00 [kblockd/0] [m(B[39;49m
[m(B 38 root 15 0 0 0 0 S 0.0 0.0 0:02.28 [pdflush] [m(B[39;49m
[m(B 40 root 12 -10 0 0 0 S 0.0 0.0 0:00.00 [aio/0] [m(B[39;49m
[m(B 20 root 15 0 0 0 0 S 0.0 0.0 0:00.00 [khubd] [m(B[39;49m
[m(B 39 root 15 0 0 0 0 S 0.0 0.0 0:26.98 [kswapd0] [m(B[39;49m[6;1H[K[25;1H[?12l[?25h
my.cnf
---------------------------------------------------
Sat Mar 31 01:17:50 EEST 2007
[mysqld]
set-variable=local-infile=0
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
[mysql.server]
user=mysql
basedir=/var/lib
[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
show status
---------------------------------------------------
Sat Mar 31 01:17:50 EEST 2007
- Yararlı