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
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 aformentioned
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/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
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
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
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/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
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
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
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
12 matches
Mail list logo