I hope the former better.
Test with query plan output, though
Best Rgs,
Shafi AHMED
-Original Message-
From: Adarsh Sharma [mailto:adarsh.sha...@orkash.com]
Sent: Tuesday, August 02, 2011 12:12 PM
To: mysql@lists.mysql.com
Subject: Which is better
Dear all,
Just want to know which jo
Dear all,
Just want to know which join is better for querying data faster.
I have 2 tables A ( 70 GB ) & B ( 7 MB )
A has 10 columns & B has 3 columns.Indexes exist on both tables's ids.
select p.* from table A p, B q where p.id=q.id
or
select p.* from table B q , A p where q.id=p.id
Thank
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 :
This db is on its own partition, so I can't delete logs o
Quoting supr_star :
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 the server? If yes
mo
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!
Th
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 wrote:
> you can also use EXPLAIN, which will give you much
- Original Message -
> From: "yavuz maslak"
>
> 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 complaining :-)
-
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 wrote:
> Usually, at the
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 wa