I posted a detailed description of a similar problem
one week ago to general and then later to internals
with no response to either (title "load index into
cache doesn't?").
Using load index into cache to preload a 1GB index
into a 2GB cache comes back in 0.0 seconds as 'done'.
But there is no di
> i struggled w/ this for a while, before learning
> that even though i had
> mysql 4.1 installed, php4 was being compiled w/ it's
> own built-in mysql
> libraries, which are pre-4.1, hence the error.
> compiling php5 will
> solve the problem, as it's included mysql libraries
> are apparently
Hi :) I'm having trouble using "LOAD INDEX INTO
CACHE". It isn't loading any index blocks!
I am using 4.1.7-standard, for pc-linux on i686 on a
redhat box.
mysqladmin debug reports this, before a LOAD INDEX:
Key caches:
default
Buffer_size: 2147483648
Block_size: 1024
Di
>
I guess you just need to take the rows from the people table, not from the epeople
table, and put the condition about the event id in the join, not the main where. Like
so:
select people.id, concat(lastname, ", ", firstname) as name from people
left join epeople on epeople.pid=people.id
s a table -- just to name a few of the *many* possibilities and
> >permutations thereof.
> >
>
> Depending on server load, it may be more reasonable to shut down MySQL
> or at least lock it solid with table locks before doing a backup to get
> it over with, but backing up
his really necessary? Does MySQL requires to be shutdown to generate
a good backup?
Any comments are welcome. Thanks a lot.
--
Clemente Zamora
GlobalReservas
(http://www.clementezamora.com)
-
Before posting, please chec
If you know the total number of amenities, n, then you could try this:
SELECT h.ID, count(*) as total
FROM AmenityLink al, Hotels h
where al.HotelID=h.ID
AND ShowHotel = 1
AND PostCode = '$postcode'
group by h.ID
having total=n
Hope it helps.
Cheers,
Clemente Zamora
GlobalRese