*** grantc has joined #ingres | 00:49 | |
*** ChanServ sets mode: +o grantc | 00:49 | |
*** rossand has joined #ingres | 04:34 | |
*** ChanServ sets mode: +o rossand | 04:34 | |
*** Gerhard has joined #ingres | 04:45 | |
Gerhard | Hi all | 05:00 |
---|---|---|
grantc | hullo | 05:00 |
Gerhard | What are your experiences with virtualized Ingres servers running under VMware ESX? | 05:06 |
grantc | providing you have decent hardware it should be ok | 05:08 |
grantc | as with a physical server you will have bottlenecks especially IO | 05:09 |
Gerhard | Any guidelines from Ingres how to configure the VMware guests? | 05:10 |
grantc | i am not aware of any that would go beyond configuring Ingres in a standard, physical environment | 05:12 |
Gerhard | Like preallocating the space for the virtual hard disk or use dynamic growing disks? | 05:12 |
grantc | fair point | 05:13 |
Alex| | as dynamic growing always adds an overhead, I don't see why anyone would not recommend preallocation... | 05:14 |
Gerhard | better use virtual IDE disks or virtual SCSI disks? | 05:14 |
grantc | do you get the choice of IDE with ESX? | 05:14 |
Gerhard | Not sure, to be honest. Only have the free VMware products here for testing which allow both. | 05:15 |
grantc | regarding pre-alloc - i guess it would depend on how write intensive your system is but I would go with Alex|'s assesment | 05:15 |
grantc | yup vmware server (2.0) gives you the option | 05:15 |
grantc | the last time i setup a vm on esx i was given the choice of two different SCSI interfaces | 05:16 |
grantc | LSI and another one.. | 05:16 |
*** atrofast has joined #ingres | 05:18 | |
Gerhard | So one question is: which one is better for Ingres - LSI or the other one? I think it was BusLogic... | 05:30 |
grantc | that's the one... | 05:31 |
Gerhard | stumbled upon this: http://docs.ingres.com/Appliances/Database/Ingres%20Icebreaker%20Database%20Appliance%20Installation%20and%20Configuration%20Guide/create_configure_icebreaker_vm.htm | 05:32 |
grantc | @google vmware buslogic vs lsi | 05:33 |
ii_log | grantc: VMware Communities: BusLogic vs LSI Logic and vmscsi errors: <http://communities.vmware.com/thread/67148>; VMware Communities: LSI Logic vs.Buslogic: <http://communities.vmware.com/thread.jspa?messageID=51148&>; Storage Subsystem Performance in VMware ESX Server: BusLogic ...: <http://www.vmware.com/pdf/ESX2_Storage_Performance.pdf>; Storage Subsystem Performance in VMware ESX Server: BusLogic ...: (2 more messages) | 05:33 |
grantc | http://www.vmware.com/pdf/ESX2_Storage_Performance.pdf has some information, but is from 2006 | 05:34 |
Gerhard | Thanks for these hints. | 05:35 |
*** DarylM has joined #ingres | 06:03 | |
atrofast | In Ingres source code I keep seeing comments like "Created for Jupiter"... What the heck is/was Jupiter? :) | 06:12 |
DarylM | The Ingres 6.0 rewrite I believe | 06:16 |
DarylM | Completely new architecture. | 06:17 |
DarylM | And the upgrade from 5.X to 6.X was the stuff of legend (not a good legend either) | 06:17 |
*** Gerhard has quit IRC | 06:55 | |
atrofast | DarylM: Haha, I'd like to hear that legend :D | 07:06 |
* DarylM thinks atrofast has a sadistic streak.......... | 07:07 | |
* atrofast likes disaster movies | 07:08 | |
DarylM | lol | 07:08 |
atrofast | Thought that was an appropriate comment :P | 07:09 |
*** rossand has quit IRC | 07:12 | |
*** rossand has joined #ingres | 07:13 | |
*** ChanServ sets mode: +o rossand | 07:13 | |
*** rossand has quit IRC | 07:14 | |
*** thiagomz has joined #ingres | 07:24 | |
thiagomz | Guys, what means that "QUERY PLAN 15,1, timed out, of main query" I mean the time out ? | 07:38 |
DarylM | The optimizer discovered that the time to continue optimizing exceeded the total projected run time of the query itself. | 07:40 |
thiagomz | opf_timeout_abort ? | 07:41 |
thiagomz | default is 0 ? that means unlimited ? | 07:41 |
DarylM | It means the heuristics will be used rather than an exact timeout in milliseconds. | 07:43 |
thiagomz | tkz | 07:47 |
thiagomz | are there a way to change some ingres parameter without restart the instance ? | 07:48 |
DarylM | Not at this time. | 07:48 |
thiagomz | guys... how can i write a SQL to create a command, in oracle i do .. : select 'alter table ' || table_name || ' move tablespace XXX;' from user_tables; | 08:00 |
thiagomz | how do that on ingres ? | 08:00 |
DarylM | I don't understand the question. Ingres does not have "tablespaces" but the closest thing is either "locations" or the new partition scheme. | 08:04 |
Vroomfondle | I think he's asking about creating a dynamic SQL statement | 08:05 |
Vroomfondle | so that table_name will be filled out with a table name which is selected from the database, and then the resulting string will be executed as SQL | 08:05 |
Vroomfondle | I don't think that can be done in pure SQL in Ingres. It could be achieved via 4GL or a higher-level language, of course. | 08:06 |
grantc | you can do "select 'alter table ' + table_name +' ......' from ii_tables | 08:07 |
grantc | same idea different concat operator | 08:07 |
Vroomfondle | really? neat | 08:07 |
Vroomfondle | as in, it'll execute it? | 08:07 |
grantc | err no | 08:08 |
Vroomfondle | didn't think it would | 08:08 |
grantc | it will give you a table you can copy/paste from... | 08:08 |
grantc | in Oracle the above would execute? | 08:08 |
Vroomfondle | I presumed that was the point... maybe I assumed too much | 08:08 |
*** DarylM has quit IRC | 08:45 | |
*** zxiiro has joined #ingres | 08:46 | |
*** DarylM has joined #ingres | 08:59 | |
*** DarylM has quit IRC | 09:00 | |
*** DarylM has joined #ingres | 09:00 | |
*** mull has joined #ingres | 09:08 | |
*** DerMeister has joined #ingres | 09:29 | |
*** toumi01 has joined #ingres | 10:30 | |
thiagomz | grantc: tkz | 10:34 |
thiagomz | is that... dynamic SQL | 10:34 |
thiagomz | grantc: yes.. that works | 10:34 |
*** rossand has joined #ingres | 11:21 | |
*** ChanServ sets mode: +o rossand | 11:21 | |
*** grantc has quit IRC | 13:59 | |
*** DerMeister has quit IRC | 14:18 | |
*** zxiiro has quit IRC | 14:26 | |
*** zxiiro has joined #ingres | 14:26 | |
*** mull has quit IRC | 15:13 | |
*** atrofast has quit IRC | 15:54 | |
*** DarylM has quit IRC | 16:26 | |
*** toumi01 has quit IRC | 18:52 | |
*** rossand has quit IRC | 20:03 | |
*** mull has joined #ingres | 20:12 | |
*** NoeJeko has quit IRC | 21:07 | |
*** mull has quit IRC | 21:38 |
Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!