Demonic_Alliance Robert Osswald Beograd
Član broj: 13777 Poruke: 40 *.static.sbb.rs.
Jabber: r.osswald@default.co.yu ICQ: 25691421
|
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.
|