Yeni Server için my.cnf ayarları

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
skip-locking
skip-innodb
query_cache_limit=8M
query_cache_size=256M
query_cache_type=1
max_connections=500
max_user_connections=20
interactive_timeout=20
wait_timeout=20
connect_timeout=6
thread_cache_size=128
key_buffer=16M
join_buffer=1M
max_allowed_packet=16M
table_cache=20000
open_files_limit=60000
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=4
myisam_sort_buffer_size=64M
#log-bin
server-id=1
key_buffer_size=32M
[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=32M
sort_buffer=32M
read_buffer=16M
write_buffer=16M

$sql = "SELECT blog_id, baslik FROM blog order by blog_id desc limit 5"; 
$query = mysql_query($sql); 
	
$tmp = array(); 
  
while( $veriler = mysql_fetch_object($query) )
$tmp[ $veriler->id ] = $veriler->baslik; 
  
$fd = fopen("bloglar.txt", 'w'); 
fwrite($fd, serialize($tmp) ); 
fclose($fd); 
return $tmp;

//txt'den verileri alma fonksiyonu
function getContents($cacheFile){ 
     $fd = fopen($cacheFile, 'r');  
     $contents = fread($fd, filesize($cacheFile) ); 
     fclose($fd); 
     return unserialize($contents);
} 

$veriler = getContents("bloglar.txt"); 
foreach ($veriler as $id2 => $baslik) 
{
echo $id2.$baslik;
}

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
skip-locking
skip-innodb
query_cache_limit=4M
query_cache_size=32M
query_cache_type=1
max_connections=500
thread_cache_size=128
key_buffer=256M
max_allowed_packet=16M
table_cache=20000
low_priority_updates=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=32M
sort_buffer=32M
read_buffer=16M
write_buffer=16M

<?php
$maxRows_sonyazilar = 10;
$pageNum_sonyazilar = 0;
if (isset($_GET['pageNum_sonyazilar'])) {
  $pageNum_sonyazilar = $_GET['pageNum_sonyazilar'];
}
$startRow_sonyazilar = $pageNum_sonyazilar * $maxRows_sonyazilar;

mysql_select_db($database_gece, $gece);
$query_sonyazilar = "SELECT * FROM yazilar ORDER BY RAND()";
$query_limit_sonyazilar = sprintf("%s LIMIT %d, %d", $query_sonyazilar, $startRow_sonyazilar, $maxRows_sonyazilar);
$sonyazilar = mysql_query($query_limit_sonyazilar, $gece) or die(mysql_error());
$row_sonyazilar = mysql_fetch_assoc($sonyazilar);

if (isset($_GET['totalRows_sonyazilar'])) {
  $totalRows_sonyazilar = $_GET['totalRows_sonyazilar'];
} else {
  $all_sonyazilar = mysql_query($query_sonyazilar);
  $totalRows_sonyazilar = mysql_num_rows($all_sonyazilar);
}
$totalPages_sonyazilar = ceil($totalRows_sonyazilar/$maxRows_sonyazilar)-1;

$queryString_sonyazilar = "";
if (!empty($_SERVER['QUERY_STRING'])) {
  $params = explode("&", $_SERVER['QUERY_STRING']);
  $newParams = array();
  foreach ($params as $param) {
    if (stristr($param, "pageNum_sonyazilar") == false && 
        stristr($param, "totalRows_sonyazilar") == false) {
      array_push($newParams, $param);
    }
  }
  if (count($newParams) != 0) {
    $queryString_sonyazilar = "&" . htmlentities(implode("&", $newParams));
  }
}
$queryString_sonyazilar = sprintf("&totalRows_sonyazilar22=11%d%s", $totalRows_sonyazilar, $queryString_sonyazilar);
do { 
?>
<li><a href="<?php echo $row_sonyazilar['id']; ?>_<?php echo str_replace($find, $replace, $row_sonyazilar['baslik']); ?>.html" title="<?php echo $row_sonyazilar['baslik']; ?>"><?php echo $row_sonyazilar['baslik']; ?></a></li>
<?php } while ($row_sonyazilar = mysql_fetch_assoc($sonyazilar)); ?>