ALTER table performance and bugs...

I just posted two detailed issues WRT the perfomance of ALTER table and what I think are pretty significant issues. For the last few days I've been using MySQLs ALTER and REPAIR table functionality and its caused tons of countless problems and a great deal of lost sleep. The first problem I no

Re: Problems with mysqldump

At 16:03 -0600 10/16/04, C.F. Scheidecker Antunes wrote: Hello all, I have a remote server that has a harddrive almost full. Therefore I need to dump a huge table to my other host. OK, I've set the permissions so that I can log in to the server as root from my host. I've try to connect to it and

Re: Show databases shows all even if no rights;

At 10:02 -0400 10/16/04, Michael J. Pawlowsky wrote: I just noticed that a restricted user to only one database can still run "show databases;" and see all the names of the databases in MySQL. You would think that it would only return the databases that that user is allowed to connect to. Is th

query cache derived table

Based on may observations, derived tables (subselect) are not cacheable: select column1, column2 from (select SQL_CACHE * from MyTable) as b The second part is not inserted to QueryCache nor is it retrieved if already in cache. Also the file comments in sql_cache.cpp - Make derived tables cachabl

Re: date time functions don't return not null rows

Your tables aren't setup very well. You should google for normalization and 'boyce codd normal form' -Eric On Sat, 16 Oct 2004 22:27:51 +0200, owca <[EMAIL PROTECTED]> wrote: > I'm trying get current week, starting from monday to sunday: > > select UNIX_TIMESTAMP(day), g15, g16, g17, g18, g19,

Re: Can MySQL do this?

...snip > Is there a database generation system that would be able to handle this > task and generate a webpage as output? Try, AMP [Apache-MYSQL-PHP] See the tutorial, http://www.devarticles.com/c/a/Apache/Installing-PHP-under-Windows/ This tutorial is helpful. It's geared to MS Windows, s

Re: Can MySQL do this?

- Original Message - From: "Skip Taylor" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, October 16, 2004 5:08 PM Subject: Can MySQL do this? > Hello, > > I'm new to MySQL, SQL in general and even PHP which may be needed to do this. > My intention is to implement this on an

Problems with mysqldump

Hello all, I have a remote server that has a harddrive almost full. Therefore I need to dump a huge table to my other host. OK, I've set the permissions so that I can log in to the server as root from my host. I've try to connect to it and it works. I have to do the dump to the host because the r

date time functions don't return not null rows

I'm trying get current week, starting from monday to sunday: select UNIX_TIMESTAMP(day), g15, g16, g17, g18, g19, g20, g21, g22, id from tydzien where to_days(day) between to_days(now())- mod(to_days(now()),7)+2 /*some parameter setting a starting day*/ and (to_days(now())- mod(to_days(now()),7)

RE: Fulltext Search help

On Fri, 15 Oct 2004 20:05:57 -0400, "leegold" <[EMAIL PROTECTED]> said: > > On Fri, 15 Oct 2004 15:00:10 -0700, "Chris W. Parker" ... But maybe there's a better way? I > wish I could do *searchstring* in Fulltext even if the speed was slow as > molasass it's the spec the user wants. Of cours

RE: Transactions - working but unsure about steps

Thank you Osvaldo, That is what I was thinking. Sometimes when you try to learn from example or manual it's a bit unclear because they generally show a "simple" transaction (1 insert into 1 table) Stuart --- Osvaldo Sommer <[EMAIL PROTECTED]> wrote: > You have a problem, what if the first insert

RE: Transactions - working but unsure about steps

You have a problem, what if the first insert give a error, then you don't know. You have to check each statement for error and if no error if found in all the statements then issue a commit if not a rollback Osvaldo Sommer -Original Message- From: Stuart Felenstein [mailto:[EMAIL PROTECTE

Show databases shows all even if no rights;

I just noticed that a restricted user to only one database can still run "show databases;" and see all the names of the databases in MySQL. You would think that it would only return the databases that that user is allowed to connect to. Is there a way I can show only those databases that he has

Transactions - working but unsure about steps

My statements are all working but I'm not sure if things are set up correctly. I say this because at one point the first $query failed, yet the rest of inserts wre committed. Now I believe I need to set autocommit to 0 , yet the query failed due to a syntax error. Hence the rule about 0 records e

Re: INSERT .. ON DUPLICATE KEY UPDATE behaviour

Hi! On Oct 15, Jason McManus wrote: > Good afternoon, > > I have had reason to use the new (as of 4.1.1) INSERT .. ON DUPLICATE KEY > UPDATE syntax in MySQL. However, I am a bit confused as to the return > value. Issuing the INSERT .. ON DUP KEY UP statement, upon finding a > duplicate key and

RE: Fulltext Search help

Try to search in keyword table: select * from keywords WHERE MATCH(keyword_txt) AGAINST ('$radio_keyword' IN BOOLEAN MODE); If it works the problem is in the join. Santino $query = "SELECT page.* FROM `page` LEFT JOIN `keywords` USING (`page_id`) WHERE MATCH (`keywords`.`keyword_txt`) AGAINST ('$