是不是在内存中建tempdbdev设备呀？
<h3><font><font face="Verdana,Arial,Helvetica" size="2"> Placing tempdb on a RAM disk</font></font><br/></h3><font face="Verdana,Arial,Helvetica" size="2">First, add RAM disk support to your kernel by setting CONFIG_BLK_DEV_RAM = 1.This can be done by running <i>make menuconfig</i> or <i>make xconfig</i>
in the /usr/src/linux directory and enabling <i>RAM disk support</i> in
the <i>Block Devices</i> section.<br/>
You need to rebuild your kernel for this to take effect.
</font><p>
<font face="Verdana,Arial,Helvetica" size="2"><a href="mailto:goebel@dsdi.de">Stefan Goebel</a> wrote this on
<a href="news://forums.sybase.com/sybase.public.sqlserver.linux">sybase.public.sqlserver.linux</a>:
</font></p><ul><font face="Verdana,Arial,Helvetica" size="2"><li>1. The default max size of a RAM disk is 20mb. You probably want to
increase this by setting <i>rd_size</i> in <i>drivers/block/rd.c</i> from
<b>204800</b> to <b>102400</b> (for a 100mb max size, for example).<p>
</p></li><li>2. Create the RAM disk, mount it, and then create the new Sybase device
for tempdb. Something like this should work to create the filesystem:
<pre> troll#>/sbin/mke2fs -q -m0 /dev/ram 52000 -F > /dev/null<br/> troll#>/bin/mount /dev/ram /opt/sybase/tempdb -t ext2 > /dev/null<br/> troll#>/bin/chown sybase:sybase /opt/sybase/tempdb<br/> troll#>/bin/touch /opt/sybase/tempdb/tempspace.dat<br/> troll#>/bin/chown sybase:sybase /opt/sybase/tempdb/tempspace.dat<br/></pre>
Now we need to move tempdb from master to this new file. So we need to
create a Sybase device, and then extend tempdb to this new device:
<pre> 1> disk init name="tempdbdev", physname="/opt/sybase/tempdb/tempspace.dat",<br/> vdevno=XX, size=26000<br/> (replace XX with the correct vdevno!)<br/> 2> go<br/></pre><a href="http://www.isug.com/Sybase_FAQ/ASE/section1a.html#1a.3"></a><p>
</p></li></font></ul>是不是在内存中建<span style="font-family: monospace;">tempdbdev设备呀？</span> 不是内存。要建在磁盘上的。
页:
[1]