Database Tips - Revision history

Sichen at 21:09, 26 May 2010

2010-05-26T21:09:35Z

2009-12-02T23:40:55Z

‎PostgreSQL Tips

2009-03-19T10:07:22Z

2009-03-18T19:59:28Z

‎MySQL Tips

2008-11-12T18:00:16Z

2008-11-12T17:59:32Z

2008-11-12T17:59:11Z

‎General

2008-11-06T20:14:21Z

2008-11-06T19:50:28Z

2008-10-24T16:40:03Z

@@ Line 63: / Line 63: @@
 ===Lock Timeout===
 ==DB2 Tips==
@@ Line 100: / Line 115: @@
 In practice, most ERP-related uses of opentaps would not require CLOB's, so the first option should suffice.  Only with content management features would such field types be required, and those features would need to be rewritten for DB2 compatibility.

@@ Line 12: / Line 12: @@
 * [http://wiki.postgresql.org/wiki/Performance_Optimization PostgreSQL Wiki Article on Performance Optimization]
 * [http://www.phpbuilder.com/columns/smith20010821.php3 Optimizing PostgreSQL]
 ===Monitoring PostgreSQL Deadlocks===

← Older revision		Revision as of 10:07, 19 March 2009
Line 98:		Line 98:

	In practice, most ERP-related uses of opentaps would not require CLOB's, so the first option should suffice. Only with content management features would such field types be required, and those features would need to be rewritten for DB2 compatibility.		In practice, most ERP-related uses of opentaps would not require CLOB's, so the first option should suffice. Only with content management features would such field types be required, and those features would need to be rewritten for DB2 compatibility.
		+
		+	==Mysql Tips==
		+
		+	You must change [http://dev.mysql.com/doc/refman/5.0/en/innodb-parameters.html#sysvar_innodb_lock_wait_timeout innodb_lock_wait_timeout] parameter , else you might get error like these:
		+
		+	Lock wait timeout exceeded; try restarting transaction
		+
		+	You can add this line in your mysql config (Windows: [MYSQL_HOME]\my.ini, Linux: /etc/my.cnf)
		+
		+	<pre>
		+	#set lock timeout 300s, default is 50s
		+	innodb_lock_wait_timeout=300
		+	</pre>

← Older revision		Revision as of 19:59, 18 March 2009
Line 59:		Line 59:

	Note that it is not clear that my SQL supports case sensitive UTF-8 coalition at this point, although you may be able to [http://forums.mysql.com/read.php?103,156527,198794#msg-198794 use UTF-8 binary collation].		Note that it is not clear that my SQL supports case sensitive UTF-8 coalition at this point, although you may be able to [http://forums.mysql.com/read.php?103,156527,198794#msg-198794 use UTF-8 binary collation].
		+
		+	===Lock Timeout===

	==DB2 Tips==		==DB2 Tips==

@@ Line 12: / Line 12: @@
 * [http://wiki.postgresql.org/wiki/Performance_Optimization PostgreSQL Wiki Article on Performance Optimization]
 * [http://www.phpbuilder.com/columns/smith20010821.php3 Optimizing PostgreSQL]
-===Monitoring Deadlocks===
+===Monitoring PostgreSQL Deadlocks===
 You can monitor any database locks using the Entity SQL Processor in '''Webtools -> Entity SQL Processor''' with the following query,
@@ Line 25: / Line 25: @@
 This will show what kinds of locks are active on what entities.  If there is an exclusive lock on a table followed by a bunch of pids that are waiting for it, then you have a deadlock.
-===Checking Open Connections===
+===Checking Open PostgreSQL Connections===
 Run this query:

@@ Line 7: / Line 7: @@
 * [http://www.precisejava.com/javaperf/j2ee/JDBC.htm JDBC Best Practices]
 ===Monitoring Deadlocks===
@@ Line 28: / Line 33: @@
 If you are running out of connections, edit the file <tt>framework/entity/config/entityengine.xml</tt> and increase the number of connections available.
 ==MySQL Tips==

@@ Line 6: / Line 6: @@
 * [http://publib.boulder.ibm.com/infocenter/txformp/v5r1/index.jsp?topic=/com.ibm.txseries510.doc/aetgpw0055.htm Nested Transactions]
 * [http://www.precisejava.com/javaperf/j2ee/JDBC.htm JDBC Best Practices]
 ==PostgreSQL Tips==

← Older revision		Revision as of 16:40, 24 October 2008
Line 1:		Line 1:
	__TOC__		__TOC__
		+
		+	==General==
		+
		+	* [http://www.javaworld.com/jw-07-2000/jw-0714-transaction.html J2EE Transaction Management]
		+	* [http://publib.boulder.ibm.com/infocenter/txformp/v5r1/index.jsp?topic=/com.ibm.txseries510.doc/aetgpw0055.htm Nested Transactions]

	==MySQL Tips==		==MySQL Tips==