Login
[x]
Log in using an account from:
Fedora Account System
Red Hat Associate
Red Hat Customer
Or login using a Red Hat Bugzilla account
Forgot Password
Login:
Hide Forgot
Create an Account
Red Hat Bugzilla – Attachment 663010 Details for
Bug 877741
[Scalability] rhevm machine with 250 fake hosts and 250 vms consumes ~99% IO due to database r/w
[?]
New
Simple Search
Advanced Search
My Links
Browse
Requests
Reports
Current State
Search
Tabular reports
Graphical reports
Duplicates
Other Reports
User Changes
Plotly Reports
Bug Status
Bug Severity
Non-Defaults
|
Product Dashboard
Help
Page Help!
Bug Writing Guidelines
What's new
Browser Support Policy
5.0.4.rh83 Release notes
FAQ
Guides index
User guide
Web Services
Contact
Legal
This site requires JavaScript to be enabled to function correctly, please enable it.
sorted queries
queriesSorted.txt (text/plain), 4.32 KB, created by
Alissa
on 2012-12-13 15:02:41 UTC
(
hide
)
Description:
sorted queries
Filename:
MIME Type:
Creator:
Alissa
Created:
2012-12-13 15:02:41 UTC
Size:
4.32 KB
patch
obsolete
> 15784 select * from getvdsbyvdsid($1, $2, $3) > 12783 select * from getvmsrunningonvds($1) > 8346 select * from getdisksvmguid($1, $2, $3) > 2455 select * from getvdsgroupbyvdsgroupid($1, $2, $3) > 1771 select 1 > 1487 select * from getinterface_viewbyvds_id($1, $2, $3) > 1369 select * from getvm_interfacebyvm_id($1, $2, $3) > 498 select * from updatevds_interface_statistics($1, $2, $3, $4, $5, $6, $7) as result > 288 select * from getstorage_poolbyid($1, $2, $3) > 214 select * from getallnetworkbyclusterid($1, $2, $3) > 179 select * from getstorage_domains_by_id_and_by_storage_pool_id($1, $2) > 114 select * from updatevdsdynamic($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38) as result > 93 select * from getstorage_domains_by_storagepoolid($1, $2, $3) > 87 select * from updatevdsstatistics($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15) as result > 83 select * from getstoragedomainidsbystoragepoolidandstatus($1, $2) > 35 select * from updatevmdynamic($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32) as result > 23 select * from updatevmstatistics($1, $2, $3, $4, $5, $6, $7, $8) as result > 21 select * from updatedisk_image_dynamic($1, $2, $3, $4, $5, $6, $7) as result > 20 select * from updatevm_interface_statistics($1, $2, $3, $4, $5, $6, $7) as result > 16 SELECT * FROM (SELECT * FROM vds WHERE ( vds_id IN (SELECT vds_with_tags.vds_id FROM vds_with_tags )) ORDER BY vds_name ASC ) as T1 OFFSET (201 -1) LIMIT 100 > 15 SELECT * FROM (SELECT * FROM audit_log WHERE ( audit_log_id > 108750 and audit_log_id IN (SELECT audit_log.audit_log_id FROM audit_log )) ORDER BY audit_log_id DESC ) as T1 OFFSET (1 -1) LIMIT 100 > 13 SELECT * FROM (SELECT * FROM audit_log WHERE ( audit_log_id > 108749 and audit_log_id IN (SELECT audit_log.audit_log_id FROM audit_log )) ORDER BY audit_log_id DESC ) as T1 OFFSET (1 -1) LIMIT 100 > 12 SELECT * FROM (SELECT * FROM audit_log WHERE ( audit_log_id > 108747 and audit_log_id IN (SELECT audit_log.audit_log_id FROM audit_log )) ORDER BY audit_log_id DESC ) as T1 OFFSET (1 -1) LIMIT 100 > 12 SELECT * FROM (SELECT * FROM audit_log WHERE ( audit_log_id > 0 and audit_log_id IN (SELECT audit_log.audit_log_id FROM audit_log WHERE audit_log.severity = '10' )) ORDER BY audit_log_id DESC ) as T1 OFFSET (1 -1) LIMIT 100 > 10 select * from getpermissionsbyentityid($1, $2, $3) > 8 select * from getallfromvdsgroups($1, $2) > 6 select * from insertauditlog($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26) as result > 3 select * from getjobsbyoffsetandpagesize($1, $2) > 2 SELECT * FROM (SELECT * FROM vds WHERE ( vds_id IN (SELECT vds_with_tags.vds_id FROM vds_with_tags WHERE vds_with_tags.vds_group_name LIKE 'cl_fake' )) ORDER BY vds_name ASC ) as T1 OFFSET (1 -1) LIMIT 2147483647 > 2 SELECT * FROM (SELECT * FROM vds WHERE ( vds_id IN (SELECT vds_with_tags.vds_id FROM vds_with_tags WHERE ( vds_with_tags.status = '3' AND vds_with_tags.storage_pool_name LIKE 'dc_fake' ))) ORDER BY vds_name ASC ) as T1 OFFSET (1 -1) LIMIT 2147483647 > 2 SELECT * FROM (SELECT * FROM audit_log WHERE ( audit_log_id > 108752 and audit_log_id IN (SELECT audit_log.audit_log_id FROM audit_log )) ORDER BY audit_log_id DESC ) as T1 OFFSET (1 -1) LIMIT 100 > 2 select * from insertstep($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12) as result > 2 select * from getvmsdedicatedtopowerclientbyvdsid($1) > 2 select * from getstorage_domains_list_by_storagedomainid($1) > 2 select * from getallfromvm_pools() > 1 select * from updatevds_interface($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18) as result > 1 select * from insertjobsubjectentity($1, $2, $3) as result > 1 select * from getvdsstaticbyvdsid($1) > 1 select * from getstorage_server_connectionsbystoragepoolid($1) > 1 select * from getfailingvdss() > 1 select * from getallfromrole() > 1 select * from deletecompletedjobsolderthandate($1, $2) as result
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Raw
Actions:
View
Attachments on
bug 877741
:
658812
| 663010 |
671557