MySQL Forums
Forum List  »  Performance

Re: Time performance in query Inner Join
Posted by: angel rivero
Date: July 10, 2011 01:55PM

Sorry but I'm newbie... I hope you understand...

[SQL] SHOW CREATE TABLE _tbl1\G;
[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\G' at line 1


SHOW TABLE STATUS LIKE _tbl1\G;
[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '_tbl1\G' at line 2


EXPLAIN SELECT _tbl1\G;
[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\G' at line 3


SHOW VARIABLES LIKE '%buffer%';
Variable_name			Value
bulk_insert_buffer_size		8388608
innodb_buffer_pool_size		1677721600
innodb_log_buffer_size		2097152
join_buffer_size		131072
key_buffer_size			57671680
myisam_sort_buffer_size		72351744
net_buffer_length		16384
preload_buffer_size		32768
read_buffer_size		65536
read_rnd_buffer_size		262144
sort_buffer_size		262144
sql_buffer_result		OFF

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Time performance in query Inner Join
1713
July 10, 2011 01:55PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.