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 storag
I'll provide it to, bear with me, pls...
Best regards.
--
WB
2010/11/30 Johan De Meersman
> 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
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
wrote:
> Friends,
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
> Maybe, the table in use must be a table that is inside cache now - SHOW
> OPEN TABL
Have a look on it:
mysql> show variables like '%slow%';
+-+--+
| Variable_name | Value|
+-+--+
| log_slow_queries| OFF |
| slow_launch_time
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 d
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 per
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 encoun
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 earli
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 back
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 wrote:
> HI Guys
>
> I found some info regarding a method to upgrade mysql databases.
>
>Currently the version is at mys
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 source
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
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
14 matches
Mail list logo