-
编辑 删除
sybase 12.5.4/sybase 15.0.2在redhat as5下srvbuildres出错解决
sybase 12.5.4/sybase 15.0.2 安装OS: redhat as5 32bit 64bit [@more@]srvbuildrs 时提示libXm.so.3无法找到：rpm -ivh openmotif-2.3.0-0.3.el5.i386.rpmrpm -ivh openmotif-2.3.0-0.3.el5.x86_64.rpm ln -s /usr/lib64/libXm.so.4 /usr/lib64/libXm.so.3 su - sybase在创建服务时提示：segmentation fault 用：export LD_POINTER_GUARD=0 Installing/Running ASE on systems with glibc 2.4.x (Fedora Core 5, etc)ASE (12.5.x, 15.x) will not run on a system with glibc 2.4.x (that’s Fedora Core 5 and later, among others). He
-
编辑 删除
Installing Oracle Databases on Linux
Installing Oracle Database 10g (32-bit/64-bit) on RHEL, Fedora Core, and Red Hat (x86/x86_64) Installing Oracle Database 10g on Novell SUSE Linux Enterprise Server (SLES) and on SUSE Linux Professional Installing Oracle 9i Database on Red Hat Enterprise Linux AS 4, 3, 2.1, and Red Hat 9, 8.0, 7.3, 7.2, 7.1 RAC: Installing Oracle Database 10g with Real Application Cluster (RAC) RHEL 3 RAC: Installing Oracle9i Real Application Cluster (RAC) on RHEL 2.1[@more@]
-
编辑 删除
Top 1000 SQL Performance Tips (mysql 优化 )
Top 1000 SQL Performance Tips [@more@]Specific Query Performance Tips (see also database design tips for tips on indexes): 1. Use EXPLAIN to profile the query execution plan 使用explain 查看查询执行的计划2. Use Slow Query Log (always have it on!) 使用Slow Query Log(慢查询日志)3. Don't use DISTINCT when you have or could use GROUP BY 当你能或正在使用GROUP BY 时不要使用 DISTINCT4. Insert performance 插入性能1. Batch INSERT and REPLACE 使用批量插入2. Use LOAD DATA instead of INSERT 用LOAD DATA 代替
