Since the logistics etc. are stored on a different server I wouldn't have
any problems using this server as our main web-server (which is what I'm
going to do in 3 weeks). Restoring the whole server from total crash is
relativly easy, so a mysql bug wouldn't hurt much anyway
Check out this: http://www.mysql.com/doc/L/O/LOCK_TABLES.html
User 1 must do a 'write lock' on the table, before calling the insert
statement. Then User 2's qery will have to wait till User 1 calls Unlock.
USER 1 ===> WRITE LOCK
>
> USER 1 ===> INSERT
> STOP <== due to process sch
;m really open for suggestions here.
Currently the database files are around 3gb, but will probably grow to
around 4gb in a short time (transfering costumer info etc. from the old
system) and then grow continuously the rest of it's life.
Regards
Erlend Stromsvik
---
Here are some queries I did:
First one did not do what I wanted it to do... But no surprise, since I left
out the 'IN BOOLEAN MODE'
The second and third query did give me the wanted results, but not in the
way I want to construct these kinds of queries.
But is there a bug or something with the las
Since I didn't get any reply on my first 'mail' I'll try once more.
Any query I make with two or more words with a '+' infront, never return any
rows.
Like this query:
SELECT count(isbn) FROM DB_GNIST.varer WHERE MATCH (tittel) AGAINST
('+windows +excel' IN BOOLEAN MODE);
The above query should
Hi
Is it possible to have mysql load indexes into memory after a restart or
reboot?
The computer has 768mb memory, and after a reboot/restart I have like 700mb
of free memory.
Then when someone clicks a link on a page which runs a 'huge' query agains
the server you get a pretty long loading time
t one will still be
much faster.
Anyway, if I have missed something in the manual, please just tell me and
I'll go back reading it.
Erlend Stromsvik
-
Before posting, please check:
http://www.mysql.com/manual.php (th
m table2 and
from table3.
Would be nice to hear from someone who manages good sized databases.
Regards
Erlend Stromsvik
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mys
UE in either one of the two columns. <- Would this
be the 'right' way to do it? :)
This way I only have to retrieve the record from table1, check for TRUE
value in the two columns, if they are TRUE retrieve record from table2 and
from table3.
Would be nice to hear from someone who manages
