Re: temp table and view/function/procedure dilemma

procedure output? I found it stated everywhere that it's not supported. About flexviews: Looks like a solution indeed. I will look into it! Thanks Bgs Peter Boros On 04/05/2011 08:15 PM, Bgs wrote: Hi all, I have a problem here and looking for a solution. I have a temporary table which

Re: temp table and view/function/procedure dilemma

On 04/06/2011 09:13 PM, Sándor Halász wrote: I have a temporary table which is a smaller table generated from a rather big one. The full table is too big to make real gimmicks on it, so I do need the temp table. Later I do several queries on the temp table. So my initial setup and needs are:

temp table and view/function/procedure dilemma

handle the result set within mysql (officially not supported) Any ideas how to solve this? Thanks in advance Bgs -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

problems with replication when db is changed

fly? Shouldn't they be executed just as the insert/update commands? Regards Bgs -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Mirror db to new name

n.com -> db=mydb db2.domain.com -> db=mydb mirror.domain.com -> mydb1 and mydb2 Thanks Bgs -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: LOAD DATA FROM MASTER stops unfinished with Query OK

It seems nobody has a clue here :( I've given up with MySQL replication... Hope it will work in 5.1 ... BTW: Any official info or estimate about the production release? Bgs wrote: Nope... pure myisam... sheeri kritzer wrote: yeah, I'd be willing to guess that you're mostl

Re: LOAD DATA FROM MASTER stops unfinished with Query OK

Nope... pure myisam... sheeri kritzer wrote: yeah, I'd be willing to guess that you're mostly innodb. LOAD DATA FROM MASTER only works for MYISAM. http://dev.mysql.com/doc/refman/5.0/en/load-data-from-master.html -Sheeri On 5/24/06, Dan Trainor <[EMAIL PROTECTED]> wrote: B

Re: LOAD DATA FROM MASTER stops unfinished with Query OK

No ideas? I tried playing around with read/write timeouts (even thought the replication is fast), all size limits are greater than the whole replicated db. The last table with accesses MYD and zero size is a small one (a couple of dozens kBs). Bgs wrote: Greetings, I played around with

LOAD DATA FROM MASTER stops unfinished with Query OK

that are on the slave in the end are exact copies of the master tables, but most MYD files are zero sized Any ideas? Thanks in advance Bgs -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Sort aborted

space got a bit even smaller... There must have been something in the query, but I cannot reproduce the error right now. I will look out for new occurences in the near future... Bye Bgs Gleb Paharenko wrote: Hello. What operating system do you use? `su` to mysql user (I think the less

Re: Sort aborted

Hi, There are no quotas at all. The server has been up since march. This is the first time we had this problem, but now it is consistent... I run the query and after a few seconds, with about 8-10kB written on the disk, I get the abort. Bye Bgs Gleb Paharenko wrote: Hello. Do you

Re: SCO issue

Here is the official link: http://www.sco.com/products/openserver6/mysql.html SCO states that they will distribute MySQL with a commercial license. According to this they do not plan to stick with GPL... Bye Bgs [EMAIL PROTECTED] wrote: __ Mirza <[EMAIL PROTEC

Sort aborted

and another mail with similar problems with 4.1.7 that had no answer... Does anybody have a clue, what might be the problem ? Thanks Bgs -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: repair table priv

Hi, I think you need to have root privileges (ALL) on the table to run REPAIR TABLE since this is a disaster recovery sql command. It works only for MyISAM tables in MySQL. I don't think it is supported for all tables. I need it because I got a server with big load that sometimes has db problem

Re: repair table priv

up Bgs wrote: Does this silence mean that nobody knows?!? :) I've been trying to find what privilege is needed to 'REPAIR TABLE'. I couldn't find any usefull hint on the net or in the archives. Could anyone help me out? -- MySQL General Mailing List For list archives: ht

Re: repair table priv

Does this silence mean that nobody knows?!? :) I've been trying to find what privilege is needed to 'REPAIR TABLE'. I couldn't find any usefull hint on the net or in the archives. Could anyone help me out? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscri

Re: multi period sum() selects

Thanks for the tips! I'll be playing with them tomorrow. I think with this method, the processing time will drop from Nx to between 1x-2x pass time. ('N' in my case is usually between 5 and 100). Regards Bgs -- MySQL General Mailing List For list archives: http://lists.mys

multi period sum() selects

'timestamp>P1 and timestampP2 and timestamp A trivial way would be to make a cycle for Pn but that takes a lot of time and as one search takes considerable time (10-20sec for 100-200MB db), this multiplies to a huge overall time. Any ideas how to solve this with possibly one db pass ? Th

repair table priv

Greetings, I've been trying to find what privilege is needed to 'REPAIR TABLE'. I couldn't find any usefull hint on the net or in the archives. Could anyone help me out? Thanks Bgs -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To