MySQL tuning

2009-06-30 Thread fa so
Hi all, I have a MySQL server with 1.7 GB of RAM, Some of the tables in my database use MyISAM and others use InnoDB Do you think the following mysql configurations are Ok? or should I change something? innodb_buffer_pool_size =712M innodb_additional_mem_pool_size =20M innodb_log_buffer_size =8

[ANN] PBXT 1.0.08 RC2 Released!

2009-06-30 Thread Paul McCullagh
Hi All, The second Release Candidate of PBXT, version 1.0.08, has just been released. As I have mentioned in my previous blogs (http://pbxt.blogspot.com/2009/03/improving-pbxt-dbt2-performance.html and http://pbxt.blogspot.com/2009/03/solving-pbxt-dbt2-scaling-problem.html) , I did a lot t

Re: Custom agregate functions

2009-06-30 Thread Dan Nelson
In the last episode (Jun 30), Dainis Polis said: > Hi MySQL fans! > > Is there way to create subj ? http://dev.mysql.com/doc/refman/5.1/en/adding-functions.html http://dev.mysql.com/doc/refman/5.1/en/adding-udf.html http://dev.mysql.com/doc/refman/5.1/en/udf-aggr-calling.html -- Dan

MySQL University session on July 2: Starring Sakila - A Data Warehouse Mini-Tutorial

2009-06-30 Thread Stefan Hinz
Starring Sakila - A Data Warehouse Mini-Tutorial http://forge.mysql.com/wiki/Starring_Sakila_-_A_Data_Warehouse_Mini-Tutorial This Thursday (July 2nd, 13:00 UTC), Roland Bouman will will take the Sakila sample database and explain how to design and load a data warehouse for it, and how to use that

Custom agregate functions

2009-06-30 Thread Dainis Polis
Hi MySQL fans! Is there way to create subj ? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org