I would assume that it's slower because it gets put on the delay thread
anyway, and thus executes only whenever that thread gets some attention. I'm
not sure wether there are other influencing factors.
I should also think that not in use in this context means not locked
against inserts, so the
Hi,
I am trying to log slow queries into both file and table.
I had set as SET GLOBAL log_output =`TABLE,FILE`; But it isnt getting logged
into tables.
Can I know if I need to create table or am I missing anything ?
Thanks.
Regards,
Ram
HI Guys
I found some info regarding a method to upgrade mysql databases.
Currently the version is at mysql-5.0.51a (as installed via the
ubuntu-8.0.4 respository).
I downloaded the only version available from the web (5.1.53)
that will work on ubuntu [except for
I suspect you need to have the new version running instead of the old one,
for the mysql_upgrade script to work.
On Tue, Nov 30, 2010 at 11:23 AM, Machiel Richards machi...@rdc.co.zawrote:
HI Guys
I found some info regarding a method to upgrade mysql databases.
Currently the
Hi
Thank you for the response, after reading a bit more about this, I
suspect you are right.
From what I can gather I need to do the following in order to use
this installation method:
- create a full backup of the old database and put in a safe
place.
- create a
HI All
Just to let you know (if someone should be wondering)
I used the method below on a VM in order to test the methods of
upgrading before I do the actual systems.
I was able to do a successful upgrade with no errors as far as I
can see, using the method as described
Hi,
I have a very strange problem whereby one particular table in our
database is repeatedly (on average, every couple of days) generating
errors stating that the table is crashed and needs to be repaired.
Running a repair fixes it.
What makes it strange (and something that I've never
Maybe, the table in use must be a table that is inside cache now - SHOW OPEN
TABLES, controlled by table_cache, I mean.
Well, if the amount of data trasactioned is too small as a simple INSERT,
you don't have to be worried, I suggest. If you partition the table, we must
a benchmark to know the
No idea on the cause, but sitting with the exact same issue on 1 specific
MyISAM table on mysql-5.1.50
Since the table was created it never had any change in data structure, the
table is almost exclusively INSERTs and it is quite big in my instance
however. Table crashes on average every 2 to 3
Have a look on it:
mysql show variables like '%slow%';
+-+--+
| Variable_name | Value|
+-+--+
| log_slow_queries| OFF |
| slow_launch_time
Friends, I did a benchmark regarding to this subject.
Please, I am considering your comments.
= http://wbianchi.wordpress.com/2010/11/30/insert-x-insert-delayed/
Best regards.
--
WB
2010/11/30 Wagner Bianchi wagnerbianch...@gmail.com
Maybe, the table in use must be a table that is inside
Interesting, but I feel the difference is rather small - could you rerun
with, say, 50.000 queries ? Also, different concurrency levels (1, 100)
might be interesting to see.
Yes, I'm to lazy to do it myself, what did you think :-p
On Tue, Nov 30, 2010 at 4:01 PM, Wagner Bianchi
I'll provide it to, bear with me, pls...
Best regards.
--
WB
2010/11/30 Johan De Meersman vegiv...@tuxera.be
Interesting, but I feel the difference is rather small - could you rerun
with, say, 50.000 queries ? Also, different concurrency levels (1, 100)
might be interesting to see.
Yes,
Dear All,
My Mysql Table contain 5 column id,data,storage,bandwidth_sent,
bandwidth_received , like this : http://pastebin.com/ghXWMZ7V. The storage
and bandwidth information is accumulated one. I need to fetch my daily usage
from data bases. I need to subtract today's storage -yesterday
14 matches
Mail list logo
