how to avoid sub-query to gain performance
,Index_granularite,Index_Valeur_min', 'Index_granularite', '23', NULL, '389', 'Using where; Using temporary; Using filesort' '2', 'DERIVED', 'a', 'ALL', 'fk_agr_synthese_activite_media_fa_agent_centre_contact,fk_agr_synthese_activite_media_fa_agent_direction_contact,fk_agr_synthese_activite_media_fa_agent_file_attente,fk_agr_synthese_activite_media_fa_agent_media,fk_agr_synthese_activite_media_fa_agent_th_heure', NULL, NULL, NULL, '20903', 'Using where; Using join buffer' '2', 'DERIVED', 'cc', 'eq_ref', 'PRIMARY', 'PRIMARY', '4', 'reporting_acd.a.Id_Centre_Contact', '1', '' '2', 'DERIVED', 'f', 'eq_ref', 'PRIMARY', 'PRIMARY', '4', 'reporting_acd.a.Id_File_Attente', '1', '' '2', 'DERIVED', 'dc', 'eq_ref', 'PRIMARY', 'PRIMARY', '4', 'reporting_acd.a.Id_Direction_Contact', '1', 'Using where' '2', 'DERIVED', 'm', 'eq_ref', 'PRIMARY', 'PRIMARY', '4', 'reporting_acd.a.Id_Media', '1', 'Using where' *don't know it very clear, but i think is the problem of derived seems it take full scaning* * * *than i change all the sub-query to views(create view as select sub-query), and the result is the same* *thanks for any advice* -- - Lin Chun
do i have to restart the mysql server when i change some global variables?
hi as the title thanks -- - Lin Chun
Try to create a tunnel SSH to remote DB server, but with error Number 2013
hi As the DB server is behind bastion host, each time I have to connect to this host and then connect the DB server In order to connect the server from my pc windows, I use PuTTY to create a tunnel SSH, mapping 'remotserver:port' to 'localhost:6001' thought the bastion host After the configuration , the localhost is suceed listening port 6001 but when I try to connect the server in my pc , it shows MySQL error Number 2013 lost connection to Mysql server during query' Should I have to change some configuration in server to support this kind of connenction? Regards, -- - Lin Chun http://www.brainyquote.com/quotes/authors/f/fred_allen.html
Re: how to fetch and calculate data from remote database and insert into local database
Hi I think you mean that you want to get some results (by calculating the data in remote database) and then stock them in local database; so dosen't need to dump the db and transfer to local,but need to do some program to fetch the result and insert into the local database; In addition, like John said, you can try to use Talend or Kettle to avoid the coding part. On Thu, Jun 25, 2009 at 7:12 AM, Nathan Huang nathan.vorbei.t...@gmail.comwrote: Hello I want to fetch and calculate the data from remote database(for example Japan) and insert them into my local database(for example usa), does mysql have such function to do it, or do I have to write a script using perl or other language to help achieving it? thank you in advance nathan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=franks1...@gmail.com -- - Lin Chun
How can we stock the query result into a text file
Hi In mysql , how can we stock the query result into a text file the table is too large , i don't want to dump it , but select a part of it, i wrote a script perl to do this, but each time i have to change the parameters in the script to get another table, when i google it, i find the function in Oracle spool 'filenameandpath.txt' select ... from .. / spool off does Mysql has such function? -- - Lin Chun
Partition of Mysql
Hi I have a table that stores huge rows in 15 years, now we have to do some analysis about these row in Time dimension.To gain performance,at begining, i've extrait the data according to years from my DB to build my fact table. But since I have 15 fact tables, that complicate my olap cube.Today, i found that mysql surpport partition table since 5.1, i wanna know is it work well ? I mean that is it more efficace than table with-out partitions? I don't want to transformer the data again, as it takes too much time, is it possible to just alter my orignal table to add the partitions by years, excuse my poor english writing and thank you for your answers -- - Lin Chun
Re: I thin'k MySQL will be the 'Oracle Personal Edition'
XE store up to 4GB of user data, use up to 1GB of memory, and use one CPU on the host machine. On Wed, Apr 22, 2009 at 3:51 PM, Thomas Pundt mli...@rp-online.de wrote: José I. Merino schrieb: The main question is: Will Oracle permits a cheaper DB in his portfolio with almost the same reliability than his main and expensive DB? It already has, it's called Oracle Express Edition. Ciao, Thomas -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=franks1...@gmail.com -- - Lin Chun
Does mysql support materialized views?
Hi I am now working with Mondrian , and need tuning the database, as the materialized views can improve the performance and doesn't need to create the fact tables cheers -- - Lin Chun
Open source Data warehouse
Hi Anybody know some open source data warehouse product like Bizgres?
Re: IBM could buy Sun?
Sun only worth 6.5 billions? -- - Lin Chun