Hi,
I am stuck in a very stupid problem and I have tried quite a few things but
it just doesnt work. The problem in short is that one of my queries is
taking TOO LONG in the 'sending state' and for no reason since there are
much more complex queries which don't take more than couple of secs.
Basic
That's impossible to say with the limited information you've provided; however,
try this script for some basic tuning suggestions. It should make sure you're
not doing anything crazy:
https://launchpad.net/mysql-tuning-primer
Regards,
Gavin Towey
-Original Message-
From: fa so [mailto
I need to log fairly large numbers of historical events relating to
mailing list activity on a per-recipient basis, a kind of audit trail
if you like. So for a given user, I might log the fact that they
subscribed to a list, that they were uploaded by someone, that they
were sent a message,
Hello MySQL users,
My company is planning to upgrade from MySQL 5.0.51a to a more
recent version. Which version of MySQL offers the best balance between
stability and currency? Is there a discussion of the tradeoffs involved between
different recent version that I could be direc
Dear MySQL users,
MySQL Community Server 5.1.36, a new version of the popular Open
Source Database Management System, has been released. MySQL 5.1.36 is
recommended for use on production systems.
For an overview of what's new in MySQL 5.1, please see
http://dev.mysql.com/doc/refman/5.1/en/my
Check your rights ;)
-Ursprüngliche Nachricht-
Von: jinava [mailto:jin...@gmail.com]
Gesendet: Mittwoch, 1. Juli 2009 14:52
An: mysql@lists.mysql.com
Betreff: Re: why different users get different count(*) from same table?
Hi experts,
Something strange here, use root and mysql (root and
Hi experts,
Something strange here, use root and mysql (root and mysql are user
accounts) to select count(*) from same table, but the result is different.
login as root:
mysql -uroot -p information_schema
mysql> select * from tables where table_name='tb_staff'\G
*** 1. r
I am getting "ERROR 1104 (42000): The SELECT would examine more than
MAX_JOIN_SIZE
rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET
SQL_MAX_JOIN_SIZE=# if the SELECT is okay" on the following query.
mysql> SELECT ord.*, pt.authorize_transaction_id FROM store_orders as
ord LEFT OUTER JOI
