'전체 글'에 해당되는 글 812건

# xe sr-create name-label="Local ISO" type=iso device-config:location=/root/ device-config:legacy_mode=true content-type=iso

# yum -y install nfs-utils

# systemctl enable nfs-server

/mnt/win7 *(ro,sync)

# systemctl start nfs-server

# firewall-cmd --permanent --zone=public --add-service=nfs

# firewall-cmd --reload

# showmount -e 도메인명

# mount -t nfs 192.168.1.2:/mnt/win7 /mnt/win7

# umount /mnt/win7

# mount -t iso9660 -o loop /root/Win_x64_dvd.iso /mnt/win7

mount: /dev/loop1 is write-protected, mounting read-only

[root@vps mnt]# ls -l win7/

total 1

-r-xr-xr-x 1 root root 135 Nov 21  2010 readme.txt

[root@vps mnt]# cd win7/

[root@vps win7]# ll

total 1

-r-xr-xr-x 1 root root 135 Nov 21  2010 readme.txt

[root@vps win7]# cat readme.txt

This disc contains a "UDF" file system and requires an operating system

that supports the ISO-13346 "UDF" file system specification.

# mount -t udf /root/Win_x64_dvd.iso /mnt/win7

mount: /dev/loop1 is write-protected, mounting read-only

show variables like 'innodb_flush_log_at_trx_commit';

set global innodb_flush_log_at_trx_commit = 2;

<?php

error_reporting(E_ALL);

ini_set('display_errors', TRUE);

ini_set('display_startup_errors', TRUE);

set_time_limit(0);

$db_addr = '127.0.0.1';

$db_user = 'user';

$db_pass = 'pass';

$table = 'test.benchmark_table';

benchmark($table, 100000);

function benchmark($table, $rows) {

  global $db_addr;

  global $db_user;

  global $db_pass;

  $table_innodb1 = $table."_innodb1";

  $table_innodb2 = $table."_innodb2";

  $table_innodb3 = $table."_innodb3";

  $table_myisam1 = $table."_myisam1";

  $table_myisam2 = $table."_myisam2";

  $table_myisam3 = $table."_myisam3";

  mysql_connect($db_addr, $db_user, $db_pass);

  mysql_query('drop table if exists '.$table_innodb1);

  mysql_query('drop table if exists '.$table_innodb2);

  mysql_query('drop table if exists '.$table_innodb3);

  mysql_query('drop table if exists '.$table_myisam1);

  mysql_query('drop table if exists '.$table_myisam2);

  mysql_query('drop table if exists '.$table_myisam3);

  mysql_query("CREATE TABLE $table_innodb1 (id int(11) AUTO_INCREMENT, str1 varchar(255), rint int(11), PRIMARY KEY (id)) ENGINE=INNODB");

  mysql_query("CREATE TABLE $table_innodb2 (id int(11) AUTO_INCREMENT, str1 varchar(255), rint int(11), PRIMARY KEY (id)) ENGINE=INNODB");

  mysql_query("CREATE TABLE $table_innodb3 (id int(11) AUTO_INCREMENT, str1 varchar(255), rint int(11), PRIMARY KEY (id)) ENGINE=INNODB");

  mysql_query("CREATE TABLE $table_myisam1 (id int(11) AUTO_INCREMENT, str1 varchar(255), rint int(11), PRIMARY KEY (id)) ENGINE=MyISAM");

  mysql_query("CREATE TABLE $table_myisam2 (id int(11) AUTO_INCREMENT, str1 varchar(255), rint int(11), PRIMARY KEY (id)) ENGINE=MyISAM");

  mysql_query("CREATE TABLE $table_myisam3 (id int(11) AUTO_INCREMENT, str1 varchar(255), rint int(11), PRIMARY KEY (id)) ENGINE=MyISAM");

  mysql_query("begin");

  for ($i=0; $i<$rows; $i++) {

    mysql_query("insert into $table_innodb1 values (0, 'benchmark test $i', rand() * $rows * 100)");

    mysql_query("insert into $table_innodb2 values (0, 'benchmark test $i', rand() * $rows * 100)");

    mysql_query("insert into $table_innodb3 values (0, 'benchmark test $i', rand() * $rows * 100)");

    mysql_query("insert into $table_myisam1 values (0, 'benchmark test $i', rand() * $rows * 100)");

    mysql_query("insert into $table_myisam2 values (0, 'benchmark test $i', rand() * $rows * 100)");

    mysql_query("insert into $table_myisam3 values (0, 'benchmark test $i', rand() * $rows * 100)");

  }

  mysql_query("commit");

  mysql_conn1($db_addr, $db_user, $db_pass, $table_innodb1);

  mysql_conn2($db_addr, $db_user, $db_pass, $table_innodb2);

  mysql_conn3($db_addr, $db_user, $db_pass, $table_innodb3);

  mysql_conn1($db_addr, $db_user, $db_pass, $table_myisam1);

  mysql_conn2($db_addr, $db_user, $db_pass, $table_myisam2);

  mysql_conn3($db_addr, $db_user, $db_pass, $table_myisam3);

}

function mysql_conn1($db_addr, $db_user, $db_pass, $table) {

  $i = 0;

  $start = get_time();

  $db = mysql_connect($db_addr, $db_user, $db_pass);

  $result = mysql_query('select * from '.$table, $db);

  while ($row = mysql_fetch_assoc($result)) { $i++; $test = $row; }

  mysql_close($db);

  echo 'rows : '.$i.' '.$table.' mysql '.round(get_time()-$start, 5)."<br>";

}

function mysql_conn2($db_addr, $db_user, $db_pass, $table) {

  $i = 0;

  $start = get_time();

  $db = new mysqli($db_addr, $db_user, $db_pass);

  $result = $db->query('select * from '.$table);

  while ($row = $result->fetch_assoc()) { $i++; $test = $row; }

  $db->close();

  echo 'rows : '.$i.' '.$table.' mysqli '.round(get_time()-$start, 5)."<br>";

}

function mysql_conn3($db_addr, $db_user, $db_pass, $table) {

  $i = 0;

  $start = get_time();

  $db = new PDO('mysql:host='.$db_addr, $db_user, $db_pass);

  foreach ($db->query('select * from '.$table) as $row) { $i++; $test = $row; }

  $db = null;

  echo 'rows : '.$i.' '.$table.' pdo '.round(get_time()-$start, 5)."<br>";

}

function get_time() {

  $t = explode(' ', microtime());

  return ((float)$t[0] + (float)$t[1]);

}

?>

rows : 100000 redblue.benchmark_table_innodb1 mysql  0.39674
rows : 100000 redblue.benchmark_table_innodb2 mysqli 0.3815
rows : 100000 redblue.benchmark_table_innodb3 pdo    0.33571

rows : 100000 redblue.benchmark_table_myisam1 mysql  0.11391
rows : 100000 redblue.benchmark_table_myisam2 mysqli 0.11894
rows : 100000 redblue.benchmark_table_myisam3 pdo    0.12141

rows : 100000 test.benchmark_table_innodb1 mysql  0.2214
rows : 100000 test.benchmark_table_innodb2 mysqli 0.37862
rows : 100000 test.benchmark_table_innodb3 pdo    0.28196

rows : 100000 test.benchmark_table_myisam1 mysql  0.22379
rows : 100000 test.benchmark_table_myisam2 mysqli 0.19565
rows : 100000 test.benchmark_table_myisam3 pdo    0.28953

<?php

$db_addr = "127.0.0.1";

$db_name = "dbname";

$db_user = "user";

$db_pass = "pass";

$db_conn = "";

function DBOpen() {

global $db_conn;

global $db_addr;

global $db_name;

global $db_user;

global $db_pass;

if(!$db_conn) {

$connect = mysqli_connect($db_addr, $db_user, $db_pass, $db_name);

if(mysqli_connect_errno()) {

echo "Could not connect: " . mysqli_connect_error();

exit();

}

$db_conn = $connect;

}

return $db_conn;

}

function DBQuery($sql) {

$connect = DBOpen();

$result = mysqli_query($connect, $sql);

DBClose($connect);

return $result;

}

function DBQueryRow($sql) {

$connect = DBOpen();

$result = mysqli_query($connect, $sql);

if($result) {

$row = mysqli_fetch_row($result);

mysqli_free_result($result);

}

else {

$row = "";

}

DBClose($connect);

return $row;

}

function DBQueryRowName($sql) {

$connect = DBOpen();

$result = mysqli_query($connect, $sql);

if($result) {

$row = mysqli_fetch_array($result);

mysqli_free_result($result);

}

else {

$row = "";

}

DBClose($connect);

return $row;

}

function DBQueryArray($sql) {

$connect = DBOpen();

$result = mysqli_query($connect, $sql);

$table_result=array();

if($result) {

while($row = mysqli_fetch_assoc($result)){

$table_result[] = $row;

}

mysqli_free_result($result);

}

DBClose($connect);

return $table_result;

}

function DBQueryObject($sql) {

$connect = DBOpen();

$result = mysqli_query($connect, $sql);

if($result) {

$row = mysqli_fetch_object($result);

mysqli_free_result($result);

}

else {

$row = "";

}

DBClose($connect);

return $row;

}

function DBClose($connect) {

//mysqli_close($connect);

}

?>

ERROR 1135 (HY000): Can't create a new thread (errno 11); if you are not out of available memory, you can consult the manual for a possible OS-dependent bug

# ps aux | grep mysqld_safe | grep -v grep

root      3374  0.0  0.2 110268  1472 pts/0    S    10:35   0:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --socket=/var/lib/mysql/mysql.sock --pid-file=/var/run/mysqld/mysqld.pid --basedir=/usr --user=mysql

# cat /proc/3374/limits | grep processes

Max processes             1861                 1861                 processes

# vi /etc/security/limits.conf

*       -       nproc   4096

*       -       sigpending 4096

이슈:

인덱스 없는 조인이 너무 많습니다.

추천:

이는 조인시 전체 테이블 스캔이 일어난다는 것을 뜻합니다. 질의의 조인 컨디션에 사용되는 열들에 인덱스들을 추가함으로서 속도를 크게 개선할 수 있습니다.

인증:

테이블 조인 평균: 10.7 분당, 이 값은 시간당 1미만이어야 합니다.

사용된 변수 / 수식:

(Select_range_check + Select_scan + Select_full_join) / Uptime

테스트:

value * 60 * 60 > 1

Select full join 520

Select full range join 0

Select range 20.6 k

Select range check 0

Select scan 102.9 k

이슈:

쿼리 캐시의 80% 미만이 활용되고 있습니다.

추천:

This might be caused by query_cache_limit being too low. Flushing the query cache might help as well.

인증:

전체 쿼리 캐시 크기(Size)에서 남은 쿼리 캐시 메모리의 현재 비율은 10% 입니다. 80%보다 높아야 됩니다

사용된 변수 / 수식:

100 - Qcache_free_memory / query_cache_size * 100

이슈:

너무 많은 정렬로 인해 임시 테이블의 사용이 발생합니다.

추천:

시스템의 메모리 한계값에 따라 sort_buffer_size 나 read_rnd_buffer_size 값을 증가시키세요

인증:

임시 테이블 평균: 22.33 시간당, 이 값은 시간당 1보다 작아야합니다.

사용된 변수 / 수식:

Sort_merge_passes / Uptime

테스트:

value * 60 * 60 > 1