1
database 討論版 / mysql記憶體問題
« 於: 2015-03-10 22:51 »
想請問有麼辦法可以在mysql設定限制它執行時可用的記憶體大小
謝謝
謝謝
這裡允許您檢視這個會員的所有文章。請注意, 您只能看見您有權限閱讀的文章。
<?php
header('Content-Type: text/xml; charset=utf-8');
require_once './include/common.inc.php';
$transition = array(
'<transition num="4" slicing="vertical" direction="down" shader="none" z_multiplier="4" />',
'<transition num="3" slicing="horizontal" direction="left" shader="phong" z_multiplier="2" />',
'<transition num="8" slicing="vertical" direction="up" shader="flat" delay="0.08" z_multiplier="1" />',
'<transition num="3" direction="right" shader="flat" delay="0.05" z_multiplier="2" />',
'<transition num="3" slicing="horizontal" direction="left" delay="0.05" />',
'<transition num="6" slicing="horizontal" direction="right" duration="0.8" delay="0.05" z_multiplier="5" />',
'<transition num="6" slicing="vertical" direction="down" shader="phong" delay="0.05" />',
'<transition num="4" direction="down" slicing="horizontal" z_multiplier="6" delay="0.1" />',
'<transition num="4" direction="up" z_multiplier="2.5" delay="0.03" />',
'<transition num="4" slicing="horizontal" direction="left" delay="0.05" />'
);
$i = 0;
@include SUEP_ROOT.'./cachedata/cache_slides.php';
foreach($_CACHE['slides'] as $slides) {
if($slides['endtime'] && $slides['endtime'] <= $timestamp) {
$db->query("DELETE FROM slides WHERE id='$slides[id]'");
updatecache('slides');
continue;
}
$xmlOutput .= "\t\t<slide>\n";
$xmlOutput .= "\t\t\t<url>slides/".$slides['filename']."</url>\n";
$xmlOutput .= $slides['link'] ? "\t\t\t<link target=\"_self\">".$slides['link']."</link>\n" : '';
$xmlOutput .= "\t\t</slide>\n";
$xmlOutput .= "\t\t".$transition[$i++]."\n";
}
echo '<?xml version="1.0" encoding="UTF-8"?>
<cu3er>
<settings>
<general slide_panel_width="960" slide_panel_height="361" slide_panel_horizontal_align="center" slide_panel_vertical_align="center" />
<auto_play>
<defaults symbol="circular" time="5" />
</auto_play>
<description>
<defaults heading_font="Trebuchet MS" paragraph_text_size="13" heading_text_margin="10, 25, 5, 25" round_corners="10, 10, 10, 10" />
</description>
<prev_button>
<defaults round_corners="5,5,5,5" />
<tweenOver tint="0xFFFFFF" scaleX="1.2" scaleY="1.2" />
<tweenOut tint="0x000000" />
</prev_button>
<prev_symbol>
<tweenOver tint="0x000000" />
</prev_symbol>
<next_button>
<defaults round_corners="5,5,5,5" />
<tweenOver tint="0xFFFFFF" scaleX="1.2" scaleY="1.2" />
<tweenOut tint="0x000000" />
</next_button>
<next_symbol>
<tweenOver tint="0x000000" />
</next_symbol>
</settings>
<slides>
'.$xmlOutput.
' </slides>
</cu3er>
';
?>