Navigacija
Lista poslednjih: 16, 32, 64, 128 poruka.

Velika tabela i joinovi

[es] :: MySQL :: Velika tabela i joinovi

[ Pregleda: 1898 | Odgovora: 10 ] > FB > Twit

Postavi temu Odgovori

Autor

Pretraga teme: Traži
Markiranje Štampanje RSS

Demonic_Alliance
Robert Osswald
Beograd

Član broj: 13777
Poruke: 40
*.static.sbb.rs.

Jabber: r.osswald@default.co.yu
ICQ: 25691421


Profil

icon Velika tabela i joinovi01.09.2014. u 16:23 - pre 116 meseci
Elem, tabela keywords ima preko 44 miliona entryja,
tabela category_kwgroupkw ima par stotina.
Ima indekse na svemu zivom itd.
Prvi kveri se izvrsava skoro minut, drugi za 0.13 sec. Razlika je samo u listi polja. Ima li leka? Zar je moguce da samo 44M redova toliko gnjavi?! Radio sam na bazama koje su imale na stotine miliona redova, doduse jest ono bio klaster ali opet, umeo je i tamo kveri da zabode ali se znalo zasto

Code:


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

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


 
Odgovor na temu

bogdan.kecman
Bogdan Kecman
"specialist"
Oracle
srbistan

Član broj: 201406
Poruke: 15887
*.dynamic.sbb.rs.

Sajt: mysql.rs


+2377 Profil

icon Re: Velika tabela i joinovi01.09.2014. u 16:41 - pre 116 meseci
daj create od ovih tabela
daj explain extended od ta dva upita
koja verzija mysql servera?
 
Odgovor na temu

bogdan.kecman
Bogdan Kecman
"specialist"
Oracle
srbistan

Član broj: 201406
Poruke: 15887
*.dynamic.sbb.rs.

Sajt: mysql.rs


+2377 Profil

icon Re: Velika tabela i joinovi01.09.2014. u 16:45 - pre 116 meseci
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
 
Odgovor na temu

Demonic_Alliance
Robert Osswald
Beograd

Član broj: 13777
Poruke: 40
*.static.sbb.rs.

Jabber: r.osswald@default.co.yu
ICQ: 25691421


Profil

icon Re: Velika tabela i joinovi01.09.2014. u 16:56 - pre 116 meseci
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!
 
Odgovor na temu

bogdan.kecman
Bogdan Kecman
"specialist"
Oracle
srbistan

Član broj: 201406
Poruke: 15887
*.dynamic.sbb.rs.

Sajt: mysql.rs


+2377 Profil

icon Re: Velika tabela i joinovi01.09.2014. u 19:13 - pre 116 meseci
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
 
Odgovor na temu

Demonic_Alliance
Robert Osswald
Beograd

Član broj: 13777
Poruke: 40
*.static.sbb.rs.

Jabber: r.osswald@default.co.yu
ICQ: 25691421


Profil

icon Re: Velika tabela i joinovi02.09.2014. u 10:01 - pre 116 meseci
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.
 
Odgovor na temu

Demonic_Alliance
Robert Osswald
Beograd

Član broj: 13777
Poruke: 40
*.static.sbb.rs.

Jabber: r.osswald@default.co.yu
ICQ: 25691421


Profil

icon Re: Velika tabela i joinovi02.09.2014. u 10:06 - pre 116 meseci
Posto ne moze sve da stane u jednu poruku evo u 3 dela

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




 
Odgovor na temu

Demonic_Alliance
Robert Osswald
Beograd

Član broj: 13777
Poruke: 40
*.static.sbb.rs.

Jabber: r.osswald@default.co.yu
ICQ: 25691421


Profil

icon Re: Velika tabela i joinovi02.09.2014. u 10:07 - pre 116 meseci
Code:


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)


 
Odgovor na temu

Demonic_Alliance
Robert Osswald
Beograd

Član broj: 13777
Poruke: 40
*.static.sbb.rs.

Jabber: r.osswald@default.co.yu
ICQ: 25691421


Profil

icon Re: Velika tabela i joinovi02.09.2014. u 10:08 - pre 116 meseci
Code:


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. row ***************************
Variable_name: Innodb_pages_written
        Value: 98
*************************** 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: 824556
*************************** 214. row ***************************
Variable_name: Innodb_rows_updated
        Value: 11
*************************** 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: 16541292
*************************** 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: 58
*************************** 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: 2161
*************************** 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: 4698
*************************** 242. row ***************************
Variable_name: Questions
        Value: 106
*************************** 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: 4
*************************** 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: 2
*************************** 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: 5679
*************************** 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: 20733
*************************** 291. row ***************************
Variable_name: Uptime_since_flush_status
        Value: 20733
291 rows in set (0.00 sec)


 
Odgovor na temu

bogdan.kecman
Bogdan Kecman
"specialist"
Oracle
srbistan

Član broj: 201406
Poruke: 15887
*.dynamic.sbb.rs.

Sajt: mysql.rs


+2377 Profil

icon Re: Velika tabela i joinovi02.09.2014. u 10:22 - pre 116 meseci
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
 
Odgovor na temu

Demonic_Alliance
Robert Osswald
Beograd

Član broj: 13777
Poruke: 40
*.static.sbb.rs.

Jabber: r.osswald@default.co.yu
ICQ: 25691421


Profil

icon Re: Velika tabela i joinovi02.09.2014. u 14:57 - pre 116 meseci
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
 
Odgovor na temu

[es] :: MySQL :: Velika tabela i joinovi

[ Pregleda: 1898 | Odgovora: 10 ] > FB > Twit

Postavi temu Odgovori

Navigacija
Lista poslednjih: 16, 32, 64, 128 poruka.