On 10/21/06, Dwight Tovey <[EMAIL PROTECTED]> wrote:
Hello all
Maybe it's been a long week, but I'm trying to do something that should be
simple and just not getting anywhere.
I have two tables:
accounts
acctid: int unique
acctowner: char
...
docs
docid: int unique
acctid: int
docti
On 10/16/06, kalin mintchev <[EMAIL PROTECTED]> wrote:
>
> but that will get you all records for that category not just the most
> recently updated.
>
that's the main problem, isn't it?
what i'm looking for is the last record for EACH of the categories in the
table. i'm aware of the aformentio
On 8/23/06, matt_lists <[EMAIL PROTECTED]> wrote:
We did not see this on 5.0.19, with 5.0.24 our backup jobs lock the
tables for selects
the backup takes 3 hours, so the site is down the whole time
I'm using this backup line
mysqldump -d -f --quote-names --skip-add-locks database > outfile
mys
On 8/23/06, matt_lists <[EMAIL PROTECTED]> wrote:
Not sure if this is a bug
we are updating a large table with replace delayed from our feeder
systems, 1000 records at a time using limit's on the input data pull
this works great when there's fast selects from the table, while the
insert is goi
On 8/23/06, Ratheesh K J <[EMAIL PROTECTED]> wrote:
Hello all,
I wanted to know why a select query takes ,say, 18 sec to execute the first
time I execute it and then for every successive execution it takes, say, 10 sec.
I have disabled Query Caching on the server. If its not Query Caching then
On 8/20/06, Ow Mun Heng <[EMAIL PROTECTED]> wrote:
I'm have a query like so
select
A,
index_A
from
tableA
join tableB
on tableB.indexA = tableA.indexA
select
A,
index_A
from
tableA
join tableB
on tableB.A = tableA.A
whcih would be more efficient? using the where clause which uses the
index or
On 8/19/06, balaraju mandala <[EMAIL PROTECTED]> wrote:
Hi Everybody,
I need small help from you. In my Linux box i have limitation of Size in
partition. I have only 5 GB space for /var. MySQL is installed in this
partition only. I want to give another path like /home, where i have 120GB
of spac
On 8/8/06, Yves Goergen <[EMAIL PROTECTED]> wrote:
Hello,
I was just trying out the mysql_upgrade script on my MySQL 5.0 server
but it shows an error message that makes me believe it doesn't know
where to find its own data.
Here's what I did:
mysql_upgrade --basedir=/usr/local/mysql5 --datadir
On 8/8/06, thomas Armstrong <[EMAIL PROTECTED]> wrote:
Hi.
My Linux server has just restarted due to memory problems.
Browsing mySQL logs, I've found out 5,000 lines like these in less
than one hour:
--
060808 1:27:39 [ERROR] /usr/sbin/mysqld: Can't open file:
'my_table.MYI' (errno
On 8/5/06, Karl Larsen <[EMAIL PROTECTED]> wrote:
I am using Linux called Fedora Core 4. I had no problem getting
mysql 4 working here and liked it a lot. But when I discovered 4 doesn't
have VIEW but 5 does I have tried several RPM sets of 5 that fail for
basic reasons. The reasons are the w
we are working on automotive traking solutions and insert our location records
into the mysql database v 4.1.20. If we want search for a particular record,
its taking too long time and mysql is identifying the queries as slow queries.
I have attached the queries.
You've posted this multiple t
Hi,
I'm sure this has been asked before, but I couldn't find it in the archives,
so here goes...
I want to setup a web server that also has MySQL on it, with several user
accounts, each user has their own home directory and a virtual host entry in
Apache for their website. I also want to have ea
12 matches
Mail list logo