Table of Contents
Recommended Version……………………………………………………………………………………………………………………………………..1
Connecting the LDAP Browser to the LDAP Server……………………………………………………………………………………………….2
Obtaining Information from the LDAP Server………………………………………………………………………………………………………..4
Using the LDIF File……………………………………………………………………………………………………………………………………………5
Using Information from the LDIF File to Modify the LDAP Filter…………………………………………………………………………….5
Sample LDIF File………………………………………………………………………………………………………………………………………………6
Recommended Version
The recommended version of the LDAP Browser is:
Databases
DAtabases, their systems, working literature, types of them , speeds and capacity information about them ,
godaddy servers mysql configuration file my.cnf
Variable Wert für diese Sitzung / Globaler Wert
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 |
auto increment increment 1 auto increment offset 1 automatic sp privileges ON back log 50 basedir /usr/local/mysql-5.0.92/ binlog cache size 32,768 bulk insert buffer size 8,388,608 character set client utf8 character set connection utf8 character set database utf8 character set filesystem binary character set results utf8 character set server utf8 character set system utf8 character sets dir /usr/local/mysql-5.0.92/share/mysql/charsets/ collation connection utf8_unicode_ci (Globaler Wert) utf8_general_ci collation database utf8_general_ci collation server utf8_general_ci completion type 0 concurrent insert 1 connect timeout 60 datadir /var/lib/mysql_data/3/ date format %Y-%m-%d datetime format %Y-%m-%d %H:%i:%s default week format 0 delay key write ON delayed insert limit 100 delayed insert timeout 300 delayed queue size 1,000 div precision increment 4 keep files on create OFF engine condition pushdown OFF expire logs days 0 flush OFF flush time 0 ft boolean syntax + -><()~*:""&| ft max word len 84 ft min word len 4 ft query expansion limit 20 ft stopword file (built-in) group concat max len 1,024 have archive YES have bdb NO have blackhole engine YES have compress YES have community features YES have profiling YES have crypt YES have csv YES have dynamic loading YES have example engine NO have federated engine YES have geometry YES have innodb YES have isam NO have merge engine YES have ndbcluster NO have openssl NO have ssl NO have query cache YES have raid NO have rtree keys YES have symlink YES hostname p3nlhdb5030-05.shr.prod.phx3.secureserver.net init connect init file init slave innodb additional mem pool size 10,485,760 innodb autoextend increment 8 innodb buffer pool awe mem mb 0 innodb buffer pool size 134,217,728 innodb checksums ON innodb commit concurrency 0 innodb concurrency tickets 500 innodb data file path ibdata1:10M:autoextend innodb data home dir /var/lib/mysql_data/3 innodb adaptive hash index ON innodb doublewrite ON innodb fast shutdown 1 innodb file io threads 4 innodb file per table ON innodb flush log at trx commit 0 innodb show locks held 10 innodb show verbose locks 0 innodb flush method O_DIRECT innodb force recovery 0 innodb lock wait timeout 50 innodb locks unsafe for binlog OFF innodb log arch dir innodb log archive OFF innodb log buffer size 8,388,608 innodb log file size 67,108,864 innodb log files in group 2 innodb log group home dir /var/lib/mysql_data/3 innodb max dirty pages pct 90 innodb max purge lag 0 innodb mirrored log groups 1 innodb open files 300 innodb rollback on timeout OFF innodb support xa OFF innodb sync spin loops 20 innodb table locks ON innodb thread concurrency 8 innodb thread sleep delay 10,000 innodb io capacity 200 innodb ibuf max size 67,108,864 innodb ibuf active contract 0 innodb ibuf accel rate 100 innodb flush neighbor pages 1 innodb read ahead both innodb enable unsafe group commit 0 innodb adaptive checkpoint none innodb read io threads 8 innodb write io threads 8 innodb use sys malloc ON innodb fast recovery OFF innodb thread concurrency timer based OFF innodb extra rsegments 0 innodb dict size limit 0 innodb io pattern trace 0 innodb io pattern trace running 0 innodb io pattern size limit 0 innodb use legacy cardinality algorithm ON interactive timeout 60 join buffer size 4,194,304 key buffer size 536,870,912 key cache age threshold 300 key cache block size 1,024 key cache division limit 100 language /usr/local/mysql-5.0.92/share/mysql/english/ large files support ON large page size 0 large pages OFF lc time names en_US license GPL local infile ON locked in memory OFF log OFF log bin ON log bin trust function creators OFF log error /var/lib/mysql_logs/3/error.log log queries not using indexes OFF log slave updates OFF log slow queries OFF log slow filter log slow rate limit 1 log slow verbosity microtime log warnings 1 long query time 10 low priority updates OFF lower case file system OFF lower case table names 0 max allowed packet 33,554,432 max binlog cache size 18446744073709547520 max binlog size 1,073,741,824 max connect errors 10,000 max connections 1,000 max delayed threads 20 max error count 64 max heap table size 16,777,216 max insert delayed threads 20 max join size 18446744073709551615 max length for sort data 1,024 max prepared stmt count 16,382 max relay log size 0 max seeks for key 18446744073709551615 max sort length 1,024 max sp recursion depth 0 max tmp tables 32 max user connections 200 max write lock count 18446744073709551615 min examined row limit 0 multi range count 256 myisam data pointer size 6 myisam max sort file size 9223372036853727232 myisam mmap size 18446744073709551615 myisam recover options FORCE myisam repair threads 1 myisam sort buffer size 134,217,728 myisam stats method nulls_unequal net buffer length 8,192 net read timeout 30 net retry count 10 net write timeout 60 new OFF old passwords OFF open files limit 65,535 optimizer prune level 1 optimizer search depth 62 pid file /var/run/mysql/3.pid plugin dir port 3,306 preload buffer size 32,768 profiling OFF profiling history size 15 profiling server OFF profiling use getrusage OFF protocol version 10 query alloc block size 8,192 query cache limit 1,048,576 query cache min res unit 4,096 query cache size 67,108,864 query cache type ON query cache wlock invalidate OFF query prealloc size 8,192 range alloc block size 4,096 read buffer size 4,194,304 read only OFF read rnd buffer size 4,194,304 relay log /var/lib/mysql_logs/3/p3nlhdb5030-05-relay-bin relay log index /var/lib/mysql_logs/3/p3nlhdb5030-05-relay-bin.index relay log info file /var/lib/mysql_data/3/relay-log.info relay log purge ON relay log space limit 0 rpl recovery rank 0 secure auth OFF secure file priv server id 1 skip external locking ON skip networking OFF skip show database OFF slave compressed protocol OFF slave load tmpdir /tmp/mysqltmp/ slave net timeout 3,600 slave skip errors OFF slave transaction retries 10 slow launch time 2 slow query log OFF slow query log file socket /var/run/mysql/3.sock sort buffer size 4,194,304 sql big selects ON sql mode sql notes ON sql warnings OFF ssl ca ssl capath ssl cert ssl cipher ssl key storage engine MyISAM sync binlog 0 sync frm ON system time zone MST table cache 10,000 table lock wait timeout 50 table type MyISAM thread cache size 100 thread stack 262,144 time format %H:%i:%s time zone SYSTEM timed mutexes OFF tmp table size 8,388,608 tmpdir /tmp/mysqltmp/ transaction alloc block size 8,192 transaction prealloc size 4,096 tx isolation READ-COMMITTED updatable views with limit YES userstat running OFF use global long query time OFF version 5.0.92-log version comment MySQL Community Server (GPL) version compile machine x86_64 version compile os unknown-linux-gnu wait timeout 60 |
Download my inc file
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 |
[mysqld] #datadir=/var/lib/mysql #socket=/var/lib/mysql/mysql.sock skip-locking skip-innodb query_cache_limit=1M query_cache_size=32M query_cache_type=1 max_connections=500 interactive_timeout=100 wait_timeout=100 connect_timeout=10 thread_cache_size=128 key_buffer=16M join_buffer=1M max_allowed_packet=16M table_cache=1024 record_buffer=1M sort_buffer_size=2M read_buffer_size=2M max_connect_errors=10 # Try number of CPU's*2 for thread_concurrency thread_concurrency=2 myisam_sort_buffer_size=64M log-bin 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 #safe-updates [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 |
PHP+MySQL’de Türkçe Karakter Problemini Önlemek
PHP+MySQL’de Türkçe Karakter Problemini Önlemek
Şimdi MySQL veritbanımızı oluşturalım.. Veritabanımızı oluştururken Karşılaştırma bölümünden utf8_turkish_ci yi seçmenizi öneriyorum. Böylelikle MySQL’de oluşturacağınız tüm tablo ve alanlar utf8 kodlamasına göre oluşturulacak. Artık MySQL’den veri girişi yaptığınızda Türkçe karakter problemi olmadan verilerinizi görebiliyor olmalısınız.
PHP kodlarıyla MySQL’e bağlanırken yapmamız gerekn bir şey daha var. SET NAMES utf8 kodunu çalıştırmak.. Bunu da şu şekilde yapıyoruz;
|
1 2 3 4 |
<?php mysql_connect("localhost","root","1234"); mysql_select_db("deneme"); mysql_query("SET NAMES UTF8"); ?> |
database character problem fixing
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 |
ch[u] = x; if (ch[u] == '·') { ch[u] = 'ş'; } else if (ch[u] == 'ğ') { ch[u] = 'Ş'; } else if (ch[u] == 'â') { ch[u] = 'Ğ'; } else if (ch[u] == 'ó') { ch[u] = 'ç'; } else if (ch[u] == '¨') { ch[u] = 'Ç'; } else if (ch[u] == '¦') { ch[u] = 'ö'; } else if (ch[u] == 'í') { ch[u] = 'Ö'; } else if (ch[u] == 'ü') { ch[u] = 'ü'; } else if (ch[u] == '®') { ch[u] = 'Ü'; } else if (ch[u] == '?') { ch[u] = 'ı'; } else if (ch[u] == 'Ì') { ch[u] = 'ğ'; } else if (ch[u] == 'ş') { ch[u] = 'İ'; } else if (ch[u] == '½') { ch[u] = 'ü'; } else { u++; break; } |
how to install mysql client on ubuntu
|
1 2 |
sudo apt-get install mysql-admin mysql-query-browser apt-get install mysql-workbench |
Both of these are desktop apps.
Mysql Connection my.cnf config file and explanations
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 |
[mysqld] socket=/path/to/mysql.sock datadir=/var/lib/mysql skip-locking skip-innodb # MySQL 4.x has query caching available. # Enable it for vast improvement and it may be all you need to tweak. query_cache_type=1 query_cache_limit=1M query_cache_size=32M # max_connections=500 # Reduced to 200 as memory will not be enough for 500 connections. # memory=key_buffer+(sort_buffer_size+read_buffer_size)*max_connections # which is now: 64 + (1 + 1) * 200 = 464 MB # max_connections = approx. MaxClients setting in httpd.conf file # Default set to 100. #max_connections=200 #interactive_timeout=180 interactive_timeout=100 #wait_timeout=180 #wait_timeout=100 # Reduced wait_timeout to prevent idle clients holding connections. #wait_timeout=30 wait_timeout=15 connect_timeout=10 # max_connect_errors is set to 10 by default #max_connect_errors=10 #table_cache=256 #table_cache=1024 # Checked opened tables and adjusted accordingly after running for a while. table_cache=512 #tmp_table_size=32M by default #thread_cache=128 # Reduced it to 32 to prevent memory hogging. Also, see notes below. thread_cache=32 # key_buffer=258M # Reduced it by checking current size of *.MYI files, see notes below. key_buffer=128M # Commented out the buffer sizes and keeping the default. # sort_buffer_size=2M by default. #sort_buffer_size=1M # read_buffer_size=128K by default. #read_buffer_size=1M # 1Mb of read_rnd_buffer_size for 1GB RAM -- see notes below. # read_rnd_buffer_size=256K by default. #read_rnd_buffer_size=1M # myisam_sort_buffer_size used for ALTER, OPTIMIZE, REPAIR TABLE commands. # myisam_sort_buffer_size=8M by default. #myisam_sort_buffer_size=64M # thread_concurrency = 2 * (no. of CPU) thread_concurrency=2 # log slow queries is a must. Many queries that take more than 2 seconds. # If so, then your tables need enhancement. log_slow_queries=/var/log/mysqld.slow.log long_query_time=2 [mysql.server] user=mysql basedir=/var/lib [safe_mysqld] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid open_files_limit=8192 [mysqldump] quick max_allowed_packet=16M [mysql] no-auto-rehash # Remove the next comment character if you are not familiar with SQL #safe-updates [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 [client] socket=/path/to/mysql.sock Below are notes on some of the important variables, I took down while tuning the config file. |
……>
query_cache_size:
MySQL 4 provides one feature that can prove very handy – a query cache. In a situation where the database has to repeatedly run the same queries on the same data set, returning the same results each time, MySQL can cache the result set, avoiding the overhead of running through the data over and over and is extremely helpful on busy servers.
……>
key_buffer_size:
The value of key_buffer_size is the size of the buffer used with indexes. The larger the buffer, the faster the SQL command will finish and a result will be returned. The rule-of-thumb is to set the key_buffer_size to at least a quarter, but no more than half, of the total amount of memory on the server. Ideally, it will be large enough to contain all the indexes (the total size of all .MYI files on the server).
A simple way to check the actual performance of the buffer is to examine four additional variables: key_read_requests, key_reads, key_write_requests, and key_writes.
If you divide the value of key_read by the value of key_reads_requests, the result should be less than 0.01. Also, if you divide the value of key_write by the value of key_writes_requests, the result should be less than 1.
……>
table_cache:
The default is 64. Each time MySQL accesses a table, it places it in the cache. If the system accesses many tables, it is faster to have these in the cache. MySQL, being multi-threaded, may be running many queries on the table at one time, and each of these will open a table. Examine the value of open_tables at peak times. If you find it stays at the same value as your table_cache value, and then the number of opened_tables starts rapidly increasing, you should increase the table_cache if you have enough memory.
……>
sort_buffer:
The sort_buffer is very useful for speeding up myisamchk operations (which is why it is set much higher for that purpose in the default configuration files), but it can also be useful everyday when performing large numbers of sorts.
……>
read_rnd_buffer_size:
The read_rnd_buffer_size is used after a sort, when reading rows in sorted order. If you use many queries with ORDER BY, upping this can improve performance. Remember that, unlike key_buffer_size and table_cache, this buffer is allocated for each thread. This variable was renamed from record_rnd_buffer in MySQL 4.0.3. It defaults to the same size as the read_buffer_size. A rule-of-thumb is to allocate 1KB for each 1MB of memory on the server, for example 1MB on a machine with 1GB memory.
……>
thread_cache:
If you have a busy server that’s getting a lot of quick connections, set your thread cache high enough that the Threads_created value in SHOW STATUS stops increasing. This should take some of the load off of the CPU.
……>
tmp_table_size:
“Created_tmp_disk_tables” are the number of implicit temporary tables on disk created while executing statements and “created_tmp_tables” are memory-based. Obviously it is bad if you have to go to disk instead of memory all the time.
Additional reference material: