Hi
I want to delete the records which are older than two hours from a table.
Currently, I have scheduled a cron job script to delete the records every
one hour. I'm wondering if there is a more elegant way of doing this with
out the cron job script?
--
Hez
use event scheduler.
On Mon, Aug 1, 2011 at 12:00 PM, hezjing hezj...@gmail.com wrote:
Hi
I want to delete the records which are older than two hours from a table.
Currently, I have scheduled a cron job script to delete the records every
one hour. I'm wondering if there is a more elegant
Dear all,
I want to know how much time did it take to run a sample query.
In postgresql, we enable timing by \timing command.
Is there is any way to enable in Mysql
Thanks
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Usually, at the end of the query running it displays the time how much it
took.
Or else enable the profiling and run the query to check the exact time it
took for execution at all levels.
On Mon, Aug 1, 2011 at 12:11 PM, Adarsh Sharma adarsh.sha...@orkash.comwrote:
Dear all,
I want to know
On 7/31/2011 13:18, yavuz maslak wrote:
I don't want all records during 5 days ( 24*5days ) . Only I need records
at 5 days ago ( for instance 24 hours on 26 th July 2011) ?
How can I do that ?
Show us your table definition (the CREATE TABLE ... form, please),
tell us which column you
you can also use EXPLAIN, which will give you much more details.
http://dev.mysql.com/doc/refman/5.5/en/execution-plan-information.html
http://www.techiequest.com/mysql-visual-explain-hierarchical-view-of-query-execution-plan/
On Sun, Jul 31, 2011 at 11:45 PM, Suresh Kuna
- Original Message -
From: yavuz maslak mas...@ihlas.net.tr
I don't want all records during 5 days ( 24*5days ) . Only I need
records at 5 days ago ( for instance 24 hours on 26 th July 2011) ?
Which is what I gave you. You may want to read the fine documentation online
before
http://dev.mysql.com/doc/refman/5.1/en/query-log.html information on query
log may become useful for you in the future. Also, search the slow query
log, which also may help you in the future
On Mon, Aug 1, 2011 at 11:54 AM, Prabhat Kumar aim.prab...@gmail.comwrote:
you can also use EXPLAIN,
I'm not sure if this is the correct way to post, my apologies if it's not..
Anyway, I have a zabbix system on a mysql database where the ibdata1 file grew
to 93GB and filled up the disk. Restarting mysql results in:
/etc/init.d/mysql: ERROR: The partition with /var/lib/mysql is too full!
Quoting supr_star suprstar1...@yahoo.com:
This db is on its own partition, so I can't delete logs or anything
else to clear up space. So I moved ib_logfile0 and ib_logfile1
This is a really bad idea as will break all ur InnoDB databases. Do
you have space elsewhere on other partitions on
PS and put back the two log files you moved.
PPS if you don't have any space currently to do what I suggested then
at least softlink the log files from /tmp to their original locations.
Quoting a.sm...@ukgrid.net:
Quoting supr_star suprstar1...@yahoo.com:
This db is on its own partition,
11 matches
Mail list logo