daj create od ovih tabela
daj explain extended od ta dva upita
koja verzija mysql servera?

moram da bezim na neki sastanak tu sam za 5-6 sati pa aj da ti bacim sta jos da dodas

show status\G
select... -- tvoj upit prvi
show status\G
select.. -- tvoj upit drugi
show status\G

trebaju samo ovi show status rezultati i vremena upita, ne zanima me rezultat

ako je 55+ onda vidi da li je upaljen profiler, ako nije upali, i odradi sta treba imas opis ovde
http://dev.mysql.com/doc/refman/5.5/en/show-profile.html
daj dakle show profile ...

pa cemo videti dalje

Ok nije zurba, posto mi je sad kraj radnog vremena, sutra prepodne su da se iscimam da ovo isprobam pa kukam dalje tj saljem podatke. Hvala na brzoj reakciji!

opusteno evo i mene nazad pre nego sam ocekivao :D .. pokupi info pa baci pa da vidimo sta je ..

ovako na prvi pogled vidim da je razlika select k.uid vs select ckk.* ... prvi je izmedju ostalog brzi zato sto verovatno imas index po k.uid tako da on cita samo index, datu uopste ni ne gleda jer u indexu ima sve sto mu treba, drugi upit mora da dira datu te mora da bude sporiji .. e sad koilko je velika ckk tabela u sirinu i koliko je slogova u pitanju, sta je tebi "Brzo" vs "sporo" .. to cemo videti kad bacis ove ostale podatke :D

Zapravo ovaj k.uid je onaj koji je spor. ckk tabela ima par stotina entryja. Meni zapravo treba k.uid u rezultatu, ovaj drugi kveri sam upisao informativno pa sam bio zaprepascen razlikom

Evo podataka, verzija je doduse 5.1.62 tako da nista od ovog debuga

Pretpostavljam da je problem u sustini banalne prirode ali ja sam i dalje zbunjen :)

[code]

mysql Ver 14.14 Distrib 5.1.62, for pc-linux-gnu (x86_64) using readline 5.1

explain extended select k.uid from keywords k join groups g on g.uid = k.groupid join category_kwgroups ck using(category_kwgroupid) join category_kwgroupkw ckk using(category_kwgroupid) where g.codice_cat = 42050;
+----+-------------+-------+--------+----------------------+---------+---------+------------------------------+----------+----------+-------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
+----+-------------+-------+--------+----------------------+---------+---------+------------------------------+----------+----------+-------------+
| 1 | SIMPLE | k | ALL | groupid | NULL | NULL | NULL | 44774871 | 100.00 | |
| 1 | SIMPLE | g | eq_ref | PRIMARY,g_codice_cat | PRIMARY | 8 | pgclick.k.groupid | 1 | 100.00 | Using where |
| 1 | SIMPLE | ckk | ref | PRIMARY | PRIMARY | 8 | pgclick.g.category_kwgroupid | 3 | 100.00 | Using index |
| 1 | SIMPLE | ck | eq_ref | PRIMARY | PRIMARY | 8 | pgclick.g.category_kwgroupid | 1 | 100.00 | Using index |
+----+-------------+-------+--------+----------------------+---------+---------+------------------------------+----------+----------+-------------+

explain extended select ckk.* from keywords k join groups g on g.uid = k.groupid join category_kwgroups ck using(category_kwgroupid) join category_kwgroupkw ckk using(category_kwgroupid) where g.codice_cat = 42050;
+----+-------------+-------+--------+----------------------+---------+---------+------------------------------+--------+----------+-------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
+----+-------------+-------+--------+----------------------+---------+---------+------------------------------+--------+----------+-------------+
| 1 | SIMPLE | g | ALL | PRIMARY,g_codice_cat | NULL | NULL | NULL | 380553 | 100.00 | Using where |
| 1 | SIMPLE | ckk | ref | PRIMARY | PRIMARY | 8 | pgclick.g.category_kwgroupid | 3 | 100.00 | |
| 1 | SIMPLE | ck | eq_ref | PRIMARY | PRIMARY | 8 | pgclick.g.category_kwgroupid | 1 | 100.00 | Using index |
| 1 | SIMPLE | k | ref | groupid | groupid | 8 | pgclick.g.uid | 231 | 100.19 | Using index |
+----+-------------+-------+--------+----------------------+---------+---------+------------------------------+--------+----------+-------------+


CREATE TABLE `keywords` (
`clientid` bigint(20) unsigned NOT NULL DEFAULT '0',
`groupid` bigint(20) NOT NULL DEFAULT '0',
`uid` bigint(20) NOT NULL AUTO_INCREMENT,
`text` varchar(80) NOT NULL DEFAULT '',
`status` enum('Pending','Active','Deleted','ToBeDeleted','ToBeActivated','Not Active') NOT NULL DEFAULT 'Active',
`type` enum('Positive','Negative') DEFAULT 'Positive',
`matchType` enum('Broad+','Broad','Exact','Phrase') NOT NULL DEFAULT 'Broad',
`created` timestamp NULL DEFAULT NULL,
`modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`advertiserCompetitionScale` smallint(6) NOT NULL DEFAULT '0',
`searchVolumeScale` smallint(6) NOT NULL DEFAULT '0',
`checkedperfomance` timestamp NULL DEFAULT NULL,
`insertedBy` char(64) NOT NULL DEFAULT 'Source 1',
`blocked` tinyint(1) NOT NULL DEFAULT '0',
`kwdid` bigint(200) NOT NULL DEFAULT '0',
`category_type` varchar(20) NOT NULL DEFAULT 'CATEGORY',
PRIMARY KEY (`uid`),
KEY `clientid` (`clientid`),
KEY `groupid` (`groupid`),
KEY `status` (`status`),
KEY `competition` (`advertiserCompetitionScale`,`searchVolumeScale`,`checkedperfomance`),
KEY `text` (`text`),
KEY `keywords_kwdid` (`kwdid`)
) ENGINE=MyISAM AUTO_INCREMENT=483131359 DEFAULT CHARSET=utf8

CREATE TABLE `groups` (
`clientid` bigint(20) unsigned NOT NULL DEFAULT '0',
`uid` bigint(20) NOT NULL AUTO_INCREMENT,
`idprovincia` int(11) NOT NULL DEFAULT '0',
`codice_cat` varchar(20) NOT NULL DEFAULT '',
`category_kwgroupid` bigint(20) DEFAULT NULL,
`name` char(255) NOT NULL DEFAULT '',
`status` enum('Pending','Active','Paused','Deleted') NOT NULL DEFAULT 'Active',
`created` timestamp NULL DEFAULT NULL,
`modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`campaignid` bigint(20) NOT NULL DEFAULT '0',
`type` char(20) NOT NULL DEFAULT 'CATEGORY',
PRIMARY KEY (`uid`),
KEY `clientid` (`clientid`),
KEY `campaignid` (`campaignid`),
KEY `g_codice_cat` (`codice_cat`)
) ENGINE=MyISAM AUTO_INCREMENT=505480 DEFAULT CHARSET=utf8

CREATE TABLE `category_kwgroups` (
`categoryid` int(11) NOT NULL,
`category_kwgroupid` bigint(20) NOT NULL AUTO_INCREMENT,
`name` varchar(256) NOT NULL,
`maxCPC` decimal(17,2) DEFAULT '0.00',
`language` char(2) NOT NULL DEFAULT 'IT',
`created` timestamp NULL DEFAULT NULL,
`modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`category_kwgroupid`)
) ENGINE=MyISAM AUTO_INCREMENT=71 DEFAULT CHARSET=utf8

CREATE TABLE `category_kwgroupkw` (
`category_kwgroupid` bigint(20) NOT NULL,
`categorykwid` bigint(20) NOT NULL,
`status` varchar(32) NOT NULL DEFAULT 'Active',
`type` enum('Positive','Negative') NOT NULL DEFAULT 'Positive',
`matchType` enum('Broad','Exact','Phrase') NOT NULL DEFAULT 'Broad',
`blocked` tinyint(1) NOT NULL DEFAULT '0',
`created` timestamp NULL DEFAULT NULL,
`modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`category_kwgroupid`,`categorykwid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8


mysql> show status\G select k.uid from keywords k join groups g on g.uid = k.groupid join category_kwgroups ck using(category_kwgroupid) join category_kwgroupkw ckk using(category_kwgroupid) where g.codice_cat = 42050;
*************************** 1. row ***************************
Variable_name: Aborted_clients
Value: 2
*************************** 2. row ***************************
Variable_name: Aborted_connects
Value: 2
*************************** 3. row ***************************
Variable_name: Binlog_cache_disk_use
Value: 0
*************************** 4. row ***************************
Variable_name: Binlog_cache_use
Value: 0
*************************** 5. row ***************************
Variable_name: Bytes_received
Value: 2226
*************************** 6. row ***************************
Variable_name: Bytes_sent
Value: 97501
*************************** 7. row ***************************
Variable_name: Com_admin_commands
Value: 0
*************************** 8. row ***************************
Variable_name: Com_assign_to_keycache
Value: 0
*************************** 9. row ***************************
Variable_name: Com_alter_db
Value: 0
*************************** 10. row ***************************
Variable_name: Com_alter_db_upgrade
Value: 0
*************************** 11. row ***************************
Variable_name: Com_alter_event
Value: 0
*************************** 12. row ***************************
Variable_name: Com_alter_function
Value: 0
*************************** 13. row ***************************
Variable_name: Com_alter_procedure
Value: 0
*************************** 14. row ***************************
Variable_name: Com_alter_server
Value: 0
*************************** 15. row ***************************
Variable_name: Com_alter_table
Value: 0
*************************** 16. row ***************************
Variable_name: Com_alter_tablespace
Value: 0
*************************** 17. row ***************************
Variable_name: Com_analyze
Value: 0
*************************** 18. row ***************************
Variable_name: Com_backup_table
Value: 0
*************************** 19. row ***************************
Variable_name: Com_begin
Value: 0
*************************** 20. row ***************************
Variable_name: Com_binlog
Value: 0
*************************** 21. row ***************************
Variable_name: Com_call_procedure
Value: 0
*************************** 22. row ***************************
Variable_name: Com_change_db
Value: 0
*************************** 23. row ***************************
Variable_name: Com_change_master
Value: 0
*************************** 24. row ***************************
Variable_name: Com_check
Value: 0
*************************** 25. row ***************************
Variable_name: Com_checksum
Value: 0
*************************** 26. row ***************************
Variable_name: Com_commit
Value: 0
*************************** 27. row ***************************
Variable_name: Com_create_db
Value: 0
*************************** 28. row ***************************
Variable_name: Com_create_event
Value: 0
*************************** 29. row ***************************
Variable_name: Com_create_function
Value: 0
*************************** 30. row ***************************
Variable_name: Com_create_index
Value: 0
*************************** 31. row ***************************
Variable_name: Com_create_procedure
Value: 0
*************************** 32. row ***************************
Variable_name: Com_create_server
Value: 0
*************************** 33. row ***************************
Variable_name: Com_create_table
Value: 0
*************************** 34. row ***************************
Variable_name: Com_create_trigger
Value: 0
*************************** 35. row ***************************
Variable_name: Com_create_udf
Value: 0
*************************** 36. row ***************************
Variable_name: Com_create_user
Value: 0
*************************** 37. row ***************************
Variable_name: Com_create_view
Value: 0
*************************** 38. row ***************************
Variable_name: Com_dealloc_sql
Value: 0
*************************** 39. row ***************************
Variable_name: Com_delete
Value: 0
*************************** 40. row ***************************
Variable_name: Com_delete_multi
Value: 0
*************************** 41. row ***************************
Variable_name: Com_do
Value: 0
*************************** 42. row ***************************
Variable_name: Com_drop_db
Value: 0
*************************** 43. row ***************************
Variable_name: Com_drop_event
Value: 0
*************************** 44. row ***************************
Variable_name: Com_drop_function
Value: 0
*************************** 45. row ***************************
Variable_name: Com_drop_index
Value: 0
*************************** 46. row ***************************
Variable_name: Com_drop_procedure
Value: 0
*************************** 47. row ***************************
Variable_name: Com_drop_server
Value: 0
*************************** 48. row ***************************
Variable_name: Com_drop_table
Value: 0
*************************** 49. row ***************************
Variable_name: Com_drop_trigger
Value: 0
*************************** 50. row ***************************
Variable_name: Com_drop_user
Value: 0
*************************** 51. row ***************************
Variable_name: Com_drop_view
Value: 0
*************************** 52. row ***************************
Variable_name: Com_empty_query
Value: 0
*************************** 53. row ***************************
Variable_name: Com_execute_sql
Value: 0
*************************** 54. row ***************************
Variable_name: Com_flush
Value: 0
*************************** 55. row ***************************
Variable_name: Com_grant
Value: 0
*************************** 56. row ***************************
Variable_name: Com_ha_close
Value: 0
*************************** 57. row ***************************
Variable_name: Com_ha_open
Value: 0
*************************** 58. row ***************************
Variable_name: Com_ha_read
Value: 0
*************************** 59. row ***************************
Variable_name: Com_help
Value: 0
*************************** 60. row ***************************
Variable_name: Com_insert
Value: 0
*************************** 61. row ***************************
Variable_name: Com_insert_select
Value: 0
*************************** 62. row ***************************
Variable_name: Com_install_plugin
Value: 0
*************************** 63. row ***************************
Variable_name: Com_kill
Value: 0
*************************** 64. row ***************************
Variable_name: Com_load
Value: 0
*************************** 65. row ***************************
Variable_name: Com_load_master_data
Value: 0
*************************** 66. row ***************************
Variable_name: Com_load_master_table
Value: 0
*************************** 67. row ***************************
Variable_name: Com_lock_tables
Value: 0
*************************** 68. row ***************************
Variable_name: Com_optimize
Value: 0
*************************** 69. row ***************************
Variable_name: Com_preload_keys
Value: 0
*************************** 70. row ***************************
Variable_name: Com_prepare_sql
Value: 0
*************************** 71. row ***************************
Variable_name: Com_purge
Value: 0
*************************** 72. row ***************************
Variable_name: Com_purge_before_date
Value: 0
*************************** 73. row ***************************
Variable_name: Com_release_savepoint
Value: 0
*************************** 74. row ***************************
Variable_name: Com_rename_table
Value: 0
*************************** 75. row ***************************
Variable_name: Com_rename_user
Value: 0
*************************** 76. row ***************************
Variable_name: Com_repair
Value: 0
*************************** 77. row ***************************
Variable_name: Com_replace
Value: 0
*************************** 78. row ***************************
Variable_name: Com_replace_select
Value: 0
*************************** 79. row ***************************
Variable_name: Com_reset
Value: 0
*************************** 80. row ***************************
Variable_name: Com_restore_table
Value: 0
*************************** 81. row ***************************
Variable_name: Com_revoke
Value: 0
*************************** 82. row ***************************
Variable_name: Com_revoke_all
Value: 0
*************************** 83. row ***************************
Variable_name: Com_rollback
Value: 0
*************************** 84. row ***************************
Variable_name: Com_rollback_to_savepoint
Value: 0
*************************** 85. row ***************************
Variable_name: Com_savepoint
Value: 0
*************************** 86. row ***************************
Variable_name: Com_select
Value: 1
*************************** 87. row ***************************
Variable_name: Com_set_option
Value: 0
*************************** 88. row ***************************
Variable_name: Com_show_authors
Value: 0
*************************** 89. row ***************************
Variable_name: Com_show_binlog_events
Value: 0
*************************** 90. row ***************************
Variable_name: Com_show_binlogs
Value: 0
*************************** 91. row ***************************
Variable_name: Com_show_charsets
Value: 0
*************************** 92. row ***************************
Variable_name: Com_show_collations
Value: 0
*************************** 93. row ***************************
Variable_name: Com_show_column_types
Value: 0
*************************** 94. row ***************************
Variable_name: Com_show_contributors
Value: 0
*************************** 95. row ***************************
Variable_name: Com_show_create_db
Value: 0
*************************** 96. row ***************************
Variable_name: Com_show_create_event
Value: 0
*************************** 97. row ***************************
Variable_name: Com_show_create_func
Value: 0
*************************** 98. row ***************************
Variable_name: Com_show_create_proc
Value: 0
*************************** 99. row ***************************
Variable_name: Com_show_create_table
Value: 0
*************************** 100. row ***************************
Variable_name: Com_show_create_trigger
Value: 0
*************************** 101. row ***************************
Variable_name: Com_show_databases
Value: 1
*************************** 102. row ***************************
Variable_name: Com_show_engine_logs
Value: 0
*************************** 103. row ***************************
Variable_name: Com_show_engine_mutex
Value: 0
*************************** 104. row ***************************
Variable_name: Com_show_engine_status
Value: 0
*************************** 105. row ***************************
Variable_name: Com_show_events
Value: 0
*************************** 106. row ***************************
Variable_name: Com_show_errors
Value: 0
*************************** 107. row ***************************
Variable_name: Com_show_fields
Value: 99
*************************** 108. row ***************************
Variable_name: Com_show_function_status
Value: 0
*************************** 109. row ***************************
Variable_name: Com_show_grants
Value: 0
*************************** 110. row ***************************
Variable_name: Com_show_keys
Value: 0
*************************** 111. row ***************************
Variable_name: Com_show_master_status
Value: 0
*************************** 112. row ***************************
Variable_name: Com_show_new_master
Value: 0
*************************** 113. row ***************************
Variable_name: Com_show_open_tables
Value: 0
*************************** 114. row ***************************
Variable_name: Com_show_plugins
Value: 0
*************************** 115. row ***************************
Variable_name: Com_show_privileges
Value: 0
*************************** 116. row ***************************
Variable_name: Com_show_procedure_status
Value: 0
*************************** 117. row ***************************
Variable_name: Com_show_processlist
Value: 0
*************************** 118. row ***************************
Variable_name: Com_show_profile
Value: 0
*************************** 119. row ***************************
Variable_name: Com_show_profiles
Value: 0
*************************** 120. row ***************************
Variable_name: Com_show_slave_hosts
Value: 0
*************************** 121. row ***************************
Variable_name: Com_show_slave_status
Value: 0
*************************** 122. row ***************************
Variable_name: Com_show_status
Value: 2
*************************** 123. row ***************************
Variable_name: Com_show_storage_engines
Value: 0
*************************** 124. row ***************************
Variable_name: Com_show_table_status
Value: 0
*************************** 125. row ***************************
Variable_name: Com_show_tables
Value: 1
*************************** 126. row ***************************
Variable_name: Com_show_triggers
Value: 0
*************************** 127. row ***************************
Variable_name: Com_show_variables
Value: 0
*************************** 128. row ***************************
Variable_name: Com_show_warnings
Value: 0
*************************** 129. row ***************************
Variable_name: Com_slave_start
Value: 0
*************************** 130. row ***************************
Variable_name: Com_slave_stop
Value: 0
*************************** 131. row ***************************
Variable_name: Com_stmt_close
Value: 0
*************************** 132. row ***************************
Variable_name: Com_stmt_execute
Value: 0
*************************** 133. row ***************************
Variable_name: Com_stmt_fetch
Value: 0
*************************** 134. row ***************************
Variable_name: Com_stmt_prepare
Value: 0
*************************** 135. row ***************************
Variable_name: Com_stmt_reprepare
Value: 0
*************************** 136. row ***************************
Variable_name: Com_stmt_reset
Value: 0
*************************** 137. row ***************************
Variable_name: Com_stmt_send_long_data
Value: 0
*************************** 138. row ***************************
Variable_name: Com_truncate
Value: 0
*************************** 139. row ***************************
Variable_name: Com_uninstall_plugin
Value: 0
*************************** 140. row ***************************
Variable_name: Com_unlock_tables
Value: 0
*************************** 141. row ***************************
Variable_name: Com_update
Value: 0
*************************** 142. row ***************************
Variable_name: Com_update_multi
Value: 0
*************************** 143. row ***************************
Variable_name: Com_xa_commit
Value: 0
*************************** 144. row ***************************
Variable_name: Com_xa_end
Value: 0
*************************** 145. row ***************************
Variable_name: Com_xa_prepare
Value: 0
*************************** 146. row ***************************
Variable_name: Com_xa_recover
Value: 0
*************************** 147. row ***************************
Variable_name: Com_xa_rollback
Value: 0
*************************** 148. row ***************************
Variable_name: Com_xa_start
Value: 0
*************************** 149. row ***************************
Variable_name: Compression
Value: OFF
*************************** 150. row ***************************
Variable_name: Connections
Value: 124
*************************** 151. row ***************************
Variable_name: Created_tmp_disk_tables
Value: 0
*************************** 152. row ***************************
Variable_name: Created_tmp_files
Value: 14
*************************** 153. row ***************************
Variable_name: Created_tmp_tables
Value: 2
*************************** 154. row ***************************
Variable_name: Delayed_errors
Value: 0
*************************** 155. row ***************************
Variable_name: Delayed_insert_threads
Value: 0
*************************** 156. row ***************************
Variable_name: Delayed_writes
Value: 0
*************************** 157. row ***************************
Variable_name: Flush_commands
Value: 1
*************************** 158. row ***************************
Variable_name: Handler_commit
Value: 0
*************************** 159. row ***************************
Variable_name: Handler_delete
Value: 0
*************************** 160. row ***************************
Variable_name: Handler_discover
Value: 0
*************************** 161. row ***************************
Variable_name: Handler_prepare
Value: 0
*************************** 162. row ***************************
Variable_name: Handler_read_first
Value: 0
*************************** 163. row ***************************
Variable_name: Handler_read_key
Value: 1920164
*************************** 164. row ***************************
Variable_name: Handler_read_next
Value: 61
*************************** 165. row ***************************
Variable_name: Handler_read_prev
Value: 0
*************************** 166. row ***************************
Variable_name: Handler_read_rnd
Value: 0
*************************** 167. row ***************************
Variable_name: Handler_read_rnd_next
Value: 44774988
*************************** 168. row ***************************
Variable_name: Handler_rollback
Value: 0
*************************** 169. row ***************************
Variable_name: Handler_savepoint
Value: 0
*************************** 170. row ***************************
Variable_name: Handler_savepoint_rollback
Value: 0
*************************** 171. row ***************************
Variable_name: Handler_update
Value: 0
*************************** 172. row ***************************
Variable_name: Handler_write
Value: 114
*************************** 173. row ***************************
Variable_name: Innodb_buffer_pool_pages_data
Value: 841
*************************** 174. row ***************************
Variable_name: Innodb_buffer_pool_pages_dirty
Value: 0
*************************** 175. row ***************************
Variable_name: Innodb_buffer_pool_pages_flushed
Value: 94
*************************** 176. row ***************************
Variable_name: Innodb_buffer_pool_pages_free
Value: 141
*************************** 177. row ***************************
Variable_name: Innodb_buffer_pool_pages_misc
Value: 42
*************************** 178. row ***************************
Variable_name: Innodb_buffer_pool_pages_total
Value: 1024
*************************** 179. row ***************************
Variable_name: Innodb_buffer_pool_read_ahead_rnd
Value: 14
*************************** 180. row ***************************
Variable_name: Innodb_buffer_pool_read_ahead_seq
Value: 1
*************************** 181. row ***************************
Variable_name: Innodb_buffer_pool_read_requests
Value: 2479028
*************************** 182. row ***************************
Variable_name: Innodb_buffer_pool_reads
Value: 546
*************************** 183. row ***************************
Variable_name: Innodb_buffer_pool_wait_free
Value: 0
*************************** 184. row ***************************
Variable_name: Innodb_buffer_pool_write_requests
Value: 178
*************************** 185. row ***************************
Variable_name: Innodb_data_fsyncs
Value: 94
*************************** 186. row ***************************
Variable_name: Innodb_data_pending_fsyncs
Value: 0
*************************** 187. row ***************************
Variable_name: Innodb_data_pending_reads
Value: 0
*************************** 188. row ***************************
Variable_name: Innodb_data_pending_writes
Value: 0
*************************** 189. row ***************************
Variable_name: Innodb_data_read
Value: 15962112
*************************** 190. row ***************************
Variable_name: Innodb_data_reads
Value: 675
*************************** 191. row ***************************
Variable_name: Innodb_data_writes
Value: 147
*************************** 192. row ***************************
Variable_name: Innodb_data_written
Value: 3110912
*************************** 193. row ***************************
Variable_name: Innodb_dblwr_pages_written
Value: 94
*************************** 194. row ***************************
Variable_name: Innodb_dblwr_writes
Value: 19
*************************** 195. row ***************************
Variable_name: Innodb_log_waits
Value: 0
*************************** 196. row ***************************
Variable_name: Innodb_log_write_requests
Value: 21
*************************** 197. row ***************************
Variable_name: Innodb_log_writes
Value: 26
*************************** 198. row ***************************
Variable_name: Innodb_os_log_fsyncs
Value: 44
*************************** 199. row ***************************
Variable_name: Innodb_os_log_pending_fsyncs
Value: 0
*************************** 200. row ***************************
Variable_name: Innodb_os_log_pending_writes
Value: 0
*************************** 201. row ***************************
Variable_name: Innodb_os_log_written
Value: 21504
*************************** 202. row ***************************
Variable_name: Innodb_page_size
Value: 16384
*************************** 203. row ***************************
Variable_name: Innodb_pages_created
Value: 0
*************************** 204. row ***************************
Variable_name: Innodb_pages_read
Value: 841
*************************** 205. row ***************************
Variable_name: Innodb_pages_written
Value: 94
*************************** 206. row ***************************
Variable_name: Innodb_row_lock_current_waits
Value: 0
*************************** 207. row ***************************
Variable_name: Innodb_row_lock_time
Value: 0
*************************** 208. row ***************************
Variable_name: Innodb_row_lock_time_avg
Value: 0
*************************** 209. row ***************************
Variable_name: Innodb_row_lock_time_max
Value: 0
*************************** 210. row ***************************
Variable_name: Innodb_row_lock_waits
Value: 0
*************************** 211. row ***************************
Variable_name: Innodb_rows_deleted
Value: 0
*************************** 212. row ***************************
Variable_name: Innodb_rows_inserted
Value: 10
*************************** 213. row ***************************
Variable_name: Innodb_rows_read
Value: 820632
*************************** 214. row ***************************
Variable_name: Innodb_rows_updated
Value: 10
*************************** 215. row ***************************
Variable_name: Key_blocks_not_flushed
Value: 0
*************************** 216. row ***************************
Variable_name: Key_blocks_unused
Value: 6976
*************************** 217. row ***************************
Variable_name: Key_blocks_used
Value: 6420
*************************** 218. row ***************************
Variable_name: Key_read_requests
Value: 8832739
*************************** 219. row ***************************
Variable_name: Key_reads
Value: 8878
*************************** 220. row ***************************
Variable_name: Key_write_requests
Value: 264
*************************** 221. row ***************************
Variable_name: Key_writes
Value: 262
*************************** 222. row ***************************
Variable_name: Last_query_cost
Value: 167218744.888297
*************************** 223. row ***************************
Variable_name: Max_used_connections
Value: 5
*************************** 224. row ***************************
Variable_name: Not_flushed_delayed_rows
Value: 0
*************************** 225. row ***************************
Variable_name: Open_files
Value: 128
*************************** 226. row ***************************
Variable_name: Open_streams
Value: 0
*************************** 227. row ***************************
Variable_name: Open_table_definitions
Value: 162
*************************** 228. row ***************************
Variable_name: Open_tables
Value: 64
*************************** 229. row ***************************
Variable_name: Opened_files
Value: 2129
*************************** 230. row ***************************
Variable_name: Opened_table_definitions
Value: 65
*************************** 231. row ***************************
Variable_name: Opened_tables
Value: 94
*************************** 232. row ***************************
Variable_name: Prepared_stmt_count
Value: 0
*************************** 233. row ***************************
Variable_name: Qcache_free_blocks
Value: 0
*************************** 234. row ***************************
Variable_name: Qcache_free_memory
Value: 0
*************************** 235. row ***************************
Variable_name: Qcache_hits
Value: 0
*************************** 236. row ***************************
Variable_name: Qcache_inserts
Value: 0
*************************** 237. row ***************************
Variable_name: Qcache_lowmem_prunes
Value: 0
*************************** 238. row ***************************
Variable_name: Qcache_not_cached
Value: 0
*************************** 239. row ***************************
Variable_name: Qcache_queries_in_cache
Value: 0
*************************** 240. row ***************************
Variable_name: Qcache_total_blocks
Value: 0
*************************** 241. row ***************************
Variable_name: Queries
Value: 4338
*************************** 242. row ***************************
Variable_name: Questions
Value: 104
*************************** 243. row ***************************
Variable_name: Rpl_status
Value: NULL
*************************** 244. row ***************************
Variable_name: Select_full_join
Value: 0
*************************** 245. row ***************************
Variable_name: Select_full_range_join
Value: 0
*************************** 246. row ***************************
Variable_name: Select_range
Value: 0
*************************** 247. row ***************************
Variable_name: Select_range_check
Value: 0
*************************** 248. row ***************************
Variable_name: Select_scan
Value: 3
*************************** 249. row ***************************
Variable_name: Slave_open_temp_tables
Value: 0
*************************** 250. row ***************************
Variable_name: Slave_retried_transactions
Value: 0
*************************** 251. row ***************************
Variable_name: Slave_running
Value: OFF
*************************** 252. row ***************************
Variable_name: Slow_launch_threads
Value: 0
*************************** 253. row ***************************
Variable_name: Slow_queries
Value: 1
*************************** 254. row ***************************
Variable_name: Sort_merge_passes
Value: 0
*************************** 255. row ***************************
Variable_name: Sort_range
Value: 0
*************************** 256. row ***************************
Variable_name: Sort_rows
Value: 0
*************************** 257. row ***************************
Variable_name: Sort_scan
Value: 0
*************************** 258. row ***************************
Variable_name: Ssl_accept_renegotiates
Value: 0
*************************** 259. row ***************************
Variable_name: Ssl_accepts
Value: 0
*************************** 260. row ***************************
Variable_name: Ssl_callback_cache_hits
Value: 0
*************************** 261. row ***************************
Variable_name: Ssl_cipher
Value:
*************************** 262. row ***************************
Variable_name: Ssl_cipher_list
Value:
*************************** 263. row ***************************
Variable_name: Ssl_client_connects
Value: 0
*************************** 264. row ***************************
Variable_name: Ssl_connect_renegotiates
Value: 0
*************************** 265. row ***************************
Variable_name: Ssl_ctx_verify_depth
Value: 0
*************************** 266. row ***************************
Variable_name: Ssl_ctx_verify_mode
Value: 0
*************************** 267. row ***************************
Variable_name: Ssl_default_timeout
Value: 0
*************************** 268. row ***************************
Variable_name: Ssl_finished_accepts
Value: 0
*************************** 269. row ***************************
Variable_name: Ssl_finished_connects
Value: 0
*************************** 270. row ***************************
Variable_name: Ssl_session_cache_hits
Value: 0
*************************** 271. row ***************************
Variable_name: Ssl_session_cache_misses
Value: 0
*************************** 272. row ***************************
Variable_name: Ssl_session_cache_mode
Value: NONE
*************************** 273. row ***************************
Variable_name: Ssl_session_cache_overflows
Value: 0
*************************** 274. row ***************************
Variable_name: Ssl_session_cache_size
Value: 0
*************************** 275. row ***************************
Variable_name: Ssl_session_cache_timeouts
Value: 0
*************************** 276. row ***************************
Variable_name: Ssl_sessions_reused
Value: 0
*************************** 277. row ***************************
Variable_name: Ssl_used_session_cache_entries
Value: 0
*************************** 278. row ***************************
Variable_name: Ssl_verify_depth
Value: 0
*************************** 279. row ***************************
Variable_name: Ssl_verify_mode
Value: 0
*************************** 280. row ***************************
Variable_name: Ssl_version
Value:
*************************** 281. row ***************************
Variable_name: Table_locks_immediate
Value: 5140
*************************** 282. row ***************************
Variable_name: Table_locks_waited
Value: 0
*************************** 283. row ***************************
Variable_name: Tc_log_max_pages_used
Value: 0
*************************** 284. row ***************************
Variable_name: Tc_log_page_size
Value: 0
*************************** 285. row ***************************
Variable_name: Tc_log_page_waits
Value: 0
*************************** 286. row ***************************
Variable_name: Threads_cached
Value: 0
*************************** 287. row ***************************
Variable_name: Threads_connected
Value: 4
*************************** 288. row ***************************
Variable_name: Threads_created
Value: 123
*************************** 289. row ***************************
Variable_name: Threads_running
Value: 1
*************************** 290. row ***************************
Variable_name: Uptime
Value: 20628
*************************** 291. row ***************************
Variable_name: Uptime_since_flush_status
Value: 20628
291 rows in set (0.00 sec)


mysql> show status\G select ckk.* from keywords k join groups g on g.uid = k.groupid join category_kwgroups ck using(category_kwgroupid) join category_kwgroupkw ckk using(category_kwgroupid) where g.codice_cat = 42050;
*************************** 1. row ***************************
Variable_name: Aborted_clients
Value: 2
*************************** 2. row ***************************
Variable_name: Aborted_connects
Value: 2
*************************** 3. row ***************************
Variable_name: Binlog_cache_disk_use
Value: 0
*************************** 4. row ***************************
Variable_name: Binlog_cache_use
Value: 0
*************************** 5. row ***************************
Variable_name: Bytes_received
Value: 2443
*************************** 6. row ***************************
Variable_name: Bytes_sent
Value: 105783
*************************** 7. row ***************************
Variable_name: Com_admin_commands
Value: 0
*************************** 8. row ***************************
Variable_name: Com_assign_to_keycache
Value: 0
*************************** 9. row ***************************
Variable_name: Com_alter_db
Value: 0
*************************** 10. row ***************************
Variable_name: Com_alter_db_upgrade
Value: 0
*************************** 11. row ***************************
Variable_name: Com_alter_event
Value: 0
*************************** 12. row ***************************
Variable_name: Com_alter_function
Value: 0
*************************** 13. row ***************************
Variable_name: Com_alter_procedure
Value: 0
*************************** 14. row ***************************
Variable_name: Com_alter_server
Value: 0
*************************** 15. row ***************************
Variable_name: Com_alter_table
Value: 0
*************************** 16. row ***************************
Variable_name: Com_alter_tablespace
Value: 0
*************************** 17. row ***************************
Variable_name: Com_analyze
Value: 0
*************************** 18. row ***************************
Variable_name: Com_backup_table
Value: 0
*************************** 19. row ***************************
Variable_name: Com_begin
Value: 0
*************************** 20. row ***************************
Variable_name: Com_binlog
Value: 0
*************************** 21. row ***************************
Variable_name: Com_call_procedure
Value: 0
*************************** 22. row ***************************
Variable_name: Com_change_db
Value: 0
*************************** 23. row ***************************
Variable_name: Com_change_master
Value: 0
*************************** 24. row ***************************
Variable_name: Com_check
Value: 0
*************************** 25. row ***************************
Variable_name: Com_checksum
Value: 0
*************************** 26. row ***************************
Variable_name: Com_commit
Value: 0
*************************** 27. row ***************************
Variable_name: Com_create_db
Value: 0
*************************** 28. row ***************************
Variable_name: Com_create_event
Value: 0
*************************** 29. row ***************************
Variable_name: Com_create_function
Value: 0
*************************** 30. row ***************************
Variable_name: Com_create_index
Value: 0
*************************** 31. row ***************************
Variable_name: Com_create_procedure
Value: 0
*************************** 32. row ***************************
Variable_name: Com_create_server
Value: 0
*************************** 33. row ***************************
Variable_name: Com_create_table
Value: 0
*************************** 34. row ***************************
Variable_name: Com_create_trigger
Value: 0
*************************** 35. row ***************************
Variable_name: Com_create_udf
Value: 0
*************************** 36. row ***************************
Variable_name: Com_create_user
Value: 0
*************************** 37. row ***************************
Variable_name: Com_create_view
Value: 0
*************************** 38. row ***************************
Variable_name: Com_dealloc_sql
Value: 0
*************************** 39. row ***************************
Variable_name: Com_delete
Value: 0
*************************** 40. row ***************************
Variable_name: Com_delete_multi
Value: 0
*************************** 41. row ***************************
Variable_name: Com_do
Value: 0
*************************** 42. row ***************************
Variable_name: Com_drop_db
Value: 0
*************************** 43. row ***************************
Variable_name: Com_drop_event
Value: 0
*************************** 44. row ***************************
Variable_name: Com_drop_function
Value: 0
*************************** 45. row ***************************
Variable_name: Com_drop_index
Value: 0
*************************** 46. row ***************************
Variable_name: Com_drop_procedure
Value: 0
*************************** 47. row ***************************
Variable_name: Com_drop_server
Value: 0
*************************** 48. row ***************************
Variable_name: Com_drop_table
Value: 0
*************************** 49. row ***************************
Variable_name: Com_drop_trigger
Value: 0
*************************** 50. row ***************************
Variable_name: Com_drop_user
Value: 0
*************************** 51. row ***************************
Variable_name: Com_drop_view
Value: 0
*************************** 52. row ***************************
Variable_name: Com_empty_query
Value: 0
*************************** 53. row ***************************
Variable_name: Com_execute_sql
Value: 0
*************************** 54. row ***************************
Variable_name: Com_flush
Value: 0
*************************** 55. row ***************************
Variable_name: Com_grant
Value: 0
*************************** 56. row ***************************
Variable_name: Com_ha_close
Value: 0
*************************** 57. row ***************************
Variable_name: Com_ha_open
Value: 0
*************************** 58. row ***************************
Variable_name: Com_ha_read
Value: 0
*************************** 59. row ***************************
Variable_name: Com_help
Value: 0
*************************** 60. row ***************************
Variable_name: Com_insert
Value: 0
*************************** 61. row ***************************
Variable_name: Com_insert_select
Value: 0
*************************** 62. row ***************************
Variable_name: Com_install_plugin
Value: 0
*************************** 63. row ***************************
Variable_name: Com_kill
Value: 0
*************************** 64. row ***************************
Variable_name: Com_load
Value: 0
*************************** 65. row ***************************
Variable_name: Com_load_master_data
Value: 0
*************************** 66. row ***************************
Variable_name: Com_load_master_table
Value: 0
*************************** 67. row ***************************
Variable_name: Com_lock_tables
Value: 0
*************************** 68. row ***************************
Variable_name: Com_optimize
Value: 0
*************************** 69. row ***************************
Variable_name: Com_preload_keys
Value: 0
*************************** 70. row ***************************
Variable_name: Com_prepare_sql
Value: 0
*************************** 71. row ***************************
Variable_name: Com_purge
Value: 0
*************************** 72. row ***************************
Variable_name: Com_purge_before_date
Value: 0
*************************** 73. row ***************************
Variable_name: Com_release_savepoint
Value: 0
*************************** 74. row ***************************
Variable_name: Com_rename_table
Value: 0
*************************** 75. row ***************************
Variable_name: Com_rename_user
Value: 0
*************************** 76. row ***************************
Variable_name: Com_repair
Value: 0
*************************** 77. row ***************************
Variable_name: Com_replace
Value: 0
*************************** 78. row ***************************
Variable_name: Com_replace_select
Value: 0
*************************** 79. row ***************************
Variable_name: Com_reset
Value: 0
*************************** 80. row ***************************
Variable_name: Com_restore_table
Value: 0
*************************** 81. row ***************************
Variable_name: Com_revoke
Value: 0
*************************** 82. row ***************************
Variable_name: Com_revoke_all
Value: 0
*************************** 83. row ***************************
Variable_name: Com_rollback
Value: 0
*************************** 84. row ***************************
Variable_name: Com_rollback_to_savepoint
Value: 0
*************************** 85. row ***************************
Variable_name: Com_savepoint
Value: 0
*************************** 86. row ***************************
Variable_name: Com_select
Value: 2
*************************** 87. row ***************************
Variable_name: Com_set_option
Value: 0
*************************** 88. row ***************************
Variable_name: Com_show_authors
Value: 0
*************************** 89. row ***************************
Variable_name: Com_show_binlog_events
Value: 0
*************************** 90. row ***************************
Variable_name: Com_show_binlogs
Value: 0
*************************** 91. row ***************************
Variable_name: Com_show_charsets
Value: 0
*************************** 92. row ***************************
Variable_name: Com_show_collations
Value: 0
*************************** 93. row ***************************
Variable_name: Com_show_column_types
Value: 0
*************************** 94. row ***************************
Variable_name: Com_show_contributors
Value: 0
*************************** 95. row ***************************
Variable_name: Com_show_create_db
Value: 0
*************************** 96. row ***************************
Variable_name: Com_show_create_event
Value: 0
*************************** 97. row ***************************
Variable_name: Com_show_create_func
Value: 0
*************************** 98. row ***************************
Variable_name: Com_show_create_proc
Value: 0
*************************** 99. row ***************************
Variable_name: Com_show_create_table
Value: 0
*************************** 100. row ***************************
Variable_name: Com_show_create_trigger
Value: 0
*************************** 101. row ***************************
Variable_name: Com_show_databases
Value: 1
*************************** 102. row ***************************
Variable_name: Com_show_engine_logs
Value: 0
*************************** 103. row ***************************
Variable_name: Com_show_engine_mutex
Value: 0
*************************** 104. row ***************************
Variable_name: Com_show_engine_status
Value: 0
*************************** 105. row ***************************
Variable_name: Com_show_events
Value: 0
*************************** 106. row ***************************
Variable_name: Com_show_errors
Value: 0
*************************** 107. row ***************************
Variable_name: Com_show_fields
Value: 99
*************************** 108. row ***************************
Variable_name: Com_show_function_status
Value: 0
*************************** 109. row ***************************
Variable_name: Com_show_grants
Value: 0
*************************** 110. row ***************************
Variable_name: Com_show_keys
Value: 0
*************************** 111. row ***************************
Variable_name: Com_show_master_status
Value: 0
*************************** 112. row ***************************
Variable_name: Com_show_new_master
Value: 0
*************************** 113. row ***************************
Variable_name: Com_show_open_tables
Value: 0
*************************** 114. row ***************************
Variable_name: Com_show_plugins
Value: 0
*************************** 115. row ***************************
Variable_name: Com_show_privileges
Value: 0
*************************** 116. row ***************************
Variable_name: Com_show_procedure_status
Value: 0
*************************** 117. row ***************************
Variable_name: Com_show_processlist
Value: 0
*************************** 118. row ***************************
Variable_name: Com_show_profile
Value: 0
*************************** 119. row ***************************
Variable_name: Com_show_profiles
Value: 0
*************************** 120. row ***************************
Variable_name: Com_show_slave_hosts
Value: 0
*************************** 121. row ***************************
Variable_name: Com_show_slave_status
Value: 0
*************************** 122. row ***************************
Variable_name: Com_show_status
Value: 3
*************************** 123. row ***************************
Variable_name: Com_show_storage_engines
Value: 0
*************************** 124. row ***************************
Variable_name: Com_show_table_status
Value: 0
*************************** 125. row ***************************
Variable_name: Com_show_tables
Value: 1
*************************** 126. row ***************************
Variable_name: Com_show_triggers
Value: 0
*************************** 127. row ***************************
Variable_name: Com_show_variables
Value: 0
*************************** 128. row ***************************
Variable_name: Com_show_warnings
Value: 0
*************************** 129. row ***************************
Variable_name: Com_slave_start
Value: 0
*************************** 130. row ***************************
Variable_name: Com_slave_stop
Value: 0
*************************** 131. row ***************************
Variable_name: Com_stmt_close
Value: 0
*************************** 132. row ***************************
Variable_name: Com_stmt_execute
Value: 0
*************************** 133. row ***************************
Variable_name: Com_stmt_fetch
Value: 0
*************************** 134. row ***************************
Variable_name: Com_stmt_prepare
Value: 0
*************************** 135. row ***************************
Variable_name: Com_stmt_reprepare
Value: 0
*************************** 136. row ***************************
Variable_name: Com_stmt_reset
Value: 0
*************************** 137. row ***************************
Variable_name: Com_stmt_send_long_data
Value: 0
*************************** 138. row ***************************
Variable_name: Com_truncate
Value: 0
*************************** 139. row ***************************
Variable_name: Com_uninstall_plugin
Value: 0
*************************** 140. row ***************************
Variable_name: Com_unlock_tables
Value: 0
*************************** 141. row ***************************
Variable_name: Com_update
Value: 0
*************************** 142. row ***************************
Variable_name: Com_update_multi
Value: 0
*************************** 143. row ***************************
Variable_name: Com_xa_commit
Value: 0
*************************** 144. row ***************************
Variable_name: Com_xa_end
Value: 0
*************************** 145. row ***************************
Variable_name: Com_xa_prepare
Value: 0
*************************** 146. row ***************************
Variable_name: Com_xa_recover
Value: 0
*************************** 147. row ***************************
Variable_name: Com_xa_rollback
Value: 0
*************************** 148. row ***************************
Variable_name: Com_xa_start
Value: 0
*************************** 149. row ***************************
Variable_name: Compression
Value: OFF
*************************** 150. row ***************************
Variable_name: Connections
Value: 124
*************************** 151. row ***************************
Variable_name: Created_tmp_disk_tables
Value: 0
*************************** 152. row ***************************
Variable_name: Created_tmp_files
Value: 14
*************************** 153. row ***************************
Variable_name: Created_tmp_tables
Value: 2
*************************** 154. row ***************************
Variable_name: Delayed_errors
Value: 0
*************************** 155. row ***************************
Variable_name: Delayed_insert_threads
Value: 0
*************************** 156. row ***************************
Variable_name: Delayed_writes
Value: 0
*************************** 157. row ***************************
Variable_name: Flush_commands
Value: 1
*************************** 158. row ***************************
Variable_name: Handler_commit
Value: 0
*************************** 159. row ***************************
Variable_name: Handler_delete
Value: 0
*************************** 160. row ***************************
Variable_name: Handler_discover
Value: 0
*************************** 161. row ***************************
Variable_name: Handler_prepare
Value: 0
*************************** 162. row ***************************
Variable_name: Handler_read_first
Value: 0
*************************** 163. row ***************************
Variable_name: Handler_read_key
Value: 3840328
*************************** 164. row ***************************
Variable_name: Handler_read_next
Value: 122
*************************** 165. row ***************************
Variable_name: Handler_read_prev
Value: 0
*************************** 166. row ***************************
Variable_name: Handler_read_rnd
Value: 0
*************************** 167. row ***************************
Variable_name: Handler_read_rnd_next
Value: 89549860
*************************** 168. row ***************************
Variable_name: Handler_rollback
Value: 0
*************************** 169. row ***************************
Variable_name: Handler_savepoint
Value: 0
*************************** 170. row ***************************
Variable_name: Handler_savepoint_rollback
Value: 0
*************************** 171. row ***************************
Variable_name: Handler_update
Value: 0
*************************** 172. row ***************************
Variable_name: Handler_write
Value: 114
*************************** 173. row ***************************
Variable_name: Innodb_buffer_pool_pages_data
Value: 841
*************************** 174. row ***************************
Variable_name: Innodb_buffer_pool_pages_dirty
Value: 0
*************************** 175. row ***************************
Variable_name: Innodb_buffer_pool_pages_flushed
Value: 98
*************************** 176. row ***************************
Variable_name: Innodb_buffer_pool_pages_free
Value: 141
*************************** 177. row ***************************
Variable_name: Innodb_buffer_pool_pages_misc
Value: 42
*************************** 178. row ***************************
Variable_name: Innodb_buffer_pool_pages_total
Value: 1024
*************************** 179. row ***************************
Variable_name: Innodb_buffer_pool_read_ahead_rnd
Value: 14
*************************** 180. row ***************************
Variable_name: Innodb_buffer_pool_read_ahead_seq
Value: 1
*************************** 181. row ***************************
Variable_name: Innodb_buffer_pool_read_requests
Value: 2488719
*************************** 182. row ***************************
Variable_name: Innodb_buffer_pool_reads
Value: 546
*************************** 183. row ***************************
Variable_name: Innodb_buffer_pool_wait_free
Value: 0
*************************** 184. row ***************************
Variable_name: Innodb_buffer_pool_write_requests
Value: 184
*************************** 185. row ***************************
Variable_name: Innodb_data_fsyncs
Value: 100
*************************** 186. row ***************************
Variable_name: Innodb_data_pending_fsyncs
Value: 0
*************************** 187. row ***************************
Variable_name: Innodb_data_pending_reads
Value: 0
*************************** 188. row ***************************
Variable_name: Innodb_data_pending_writes
Value: 0
*************************** 189. row ***************************
Variable_name: Innodb_data_read
Value: 15962112
*************************** 190. row ***************************
Variable_name: Innodb_data_reads
Value: 675
*************************** 191. row ***************************
Variable_name: Innodb_data_writes
Value: 154
*************************** 192. row ***************************
Variable_name: Innodb_data_written
Value: 3243520
*************************** 193. row ***************************
Variable_name: Innodb_dblwr_pages_written
Value: 98
*************************** 194. row ***************************
Variable_name: Innodb_dblwr_writes
Value: 20
*************************** 195. row ***************************
Variable_name: Innodb_log_waits
Value: 0
*************************** 196. row ***************************
Variable_name: Innodb_log_write_requests
Value: 21
*************************** 197. row ***************************
Variable_name: Innodb_log_writes
Value: 28
*************************** 198. row ***************************
Variable_name: Innodb_os_log_fsyncs
Value: 47
*************************** 199. row ***************************
Variable_name: Innodb_os_log_pending_fsyncs
Value: 0
*************************** 200. row ***************************
Variable_name: Innodb_os_log_pending_writes
Value: 0
*************************** 201. row ***************************
Variable_name: Innodb_os_log_written
Value: 22528
*************************** 202. row ***************************
Variable_name: Innodb_page_size
Value: 16384
*************************** 203. row ***************************
Variable_name: Innodb_pages_created
Value: 0
*************************** 204. row ***************************
Variable_name: Innodb_pages_read
Value: 841
*************************** 205.

Posto ne moze sve da stane u jednu poruku evo u 3 dela

kahm, zanimljivo ... no . u jednom upitu vadis datu iz tabele keywords a u drugom iz category_kwgroupkw

spori upit prolazi full table sken kroz 44774871 slogova tabele keywords ... jedini moguci key tu je groupid ali je beskoristan. on ga koristi pri joinu sa groups i to je to .. tako da realno tih 44M full table scan je to sto ti je problem ... nemas nikakav filter nad tom tabelom ..

sad druge strane, za brzi upit ti vadis datu iz category_kwgroupkw i tu picis full table scan kroz 380k slogova (znacajno manje) tabele groups

prvi upit finalno obradjuje 44774871*1*3*1 a drugi 380553*3*1*231 .. znacajno manje (143G vs 263M) slogova .. zato je i brzi ..

e sad da li je u slucaju prvog upita optimizer mogao da bude bolji, mozda jeste ali ckk.* ne sadrzi uid .. ti iz ckk vadis samo 3 sloga (u oba upita i u oba upita po primarnom kljucu) i to je to ..

da ne bi ja dalje tupio, probaj da forsiras u prvom (sporom) upitu da koristi groupid kljuc za keywords tabelu moguce da ce da resi problem

Hm, zapravo imao sam jednu gresku u logici, trebalo je citati podatke iz druge tabele, interakcija sa keywords ce izgleda biti svedena samo na update manjeg broja redova. Hvala u svakom slucaju na pojasnjenju, znam gde cu da kukam u buduce