« first day (2874 days earlier)      last day (1994 days later) » 

MDCCL
MDCCL
12:03 AM
Interesting SO Q & A:
1
A: What's the difference between DBMS, database engine and storage engine?

Erwin SmoutA DBMS must always include a storage engine to play their role. That's modulo the in-memory-only systems that are deliberately designed to lose all data once switched off (and of which it might for that reason be considered questionable to call them 'DBMS' in the first place). But a DBMS does m...

 
MDCCL
MDCCL
12:17 AM
@SpringLearner You seem to be involved in a work environment similar to the one dealt with in this Q & A. I share my take on those subjects and on some related points in that answer, in case you want to take a look.
 
 
3 hours later…
Max Vernon
Max Vernon
3:42 AM
Nice bounty for a canonical Oracle answer here:
0
Q: ORA-03113 when starting up an Oracle 11g database

vincent nguyenI have read "ORA-03113: end-of-file on communication channel" on startup and others from this site to solve my problem but I still have not solved it. All I get is the following: Microsoft Windows [Version 6.1.7601] Copyright (c) 2009 Microsoft Corporation. All rights reserved. C:\Windows\sy...

oracle oracle-11g startup
 
Max Vernon
Max Vernon
4:13 AM
→ 3 messages moved to Trash
 
Max Vernon
Max Vernon
4:24 AM
hmmm, you can edit the list of duplicate questions. I learn something new every day.
 
Paul White
Paul White
4:54 AM
315
Q: Gold tag-badge holders and moderators can now edit duplicate links

Shog9As of a few minutes ago, if you have a gold tag-badge for a tag associated with a question that's been closed as a duplicate, you can edit the duplicate links to replace, add, remove or re-arrange them: These changes are tracked in PostHistory to allow anyone to detect abuse, while the res...

discussion exact-duplicates moderator-tools dupehammer
March 2017 🙂
 
 
4 hours later…
Tom V
Tom V
8:26 AM
@MaxVernon no up vote on the question though
 
 
3 hours later…
Paul White
Paul White
11:42 AM
@TomV He did. It started at -2.
 
Paul White
Paul White
11:56 AM
in DROP QUESTION queue;, 8 hours ago, by Max Vernon
Oh, plus I un-downvoted, and then up-voted it :-)
 
 
2 hours later…
Tom V
Tom V
1:54 PM
Oh. I don't speak oracle but the question looks decent to me
@McNets I don't think that's feasible but if you can make it work I'll up vote your answer or even bounty it
Maybe javascript injection could work though
 
 
5 hours later…
McNets
McNets
6:35 PM
@TomV I don't know, maybe playing with cache and timeout options you can get something similar
 
 
2 hours later…
yasar
yasar
8:22 PM
is it possible to learn disc usage per index
I don't mean total disc usage of indexes on a table
but individial indexes
 
Tom V
Tom V
@yasar wich rdbms
 
yasar
yasar
@TomV sorry, forgot to mention. MySQL
 
Tom V
Tom V
It's a very broad question
 
yasar
yasar
@TomV I have 14G index on 12G table
I am thinking of deleting some indexes, but want to learn cardinality vs. disc usage
to make more informed decision
does it look excessive? It is a table that is rarely updated and heavily queried
I have 28G memory available for MySQL, but there also exists other tables so I was thinking freeing some space here
to decrease disc usage as much as possible
 
Tom V
Tom V
8:46 PM
I don't know
I consider myself lucky I don't have to deal with mysql
 
yasar
yasar
what do you use?
 
jadarnel27
jadarnel27
9:39 PM
@yasar I don't use MySQL either (I use SQL Server), but this came up in a Google search. Seems like exactly what you're looking for, if you're on that version:
12
A: Find out usage statistics of MySQL indices?

user1970667Yes, it is. You should query Performance Schema: select * from performance_schema.table_io_waits_summary_by_index_usage where object_schema = 'your_schema' The count_star column show how many times each index was used since MySQL was started. If you add the following, you got the never used in...

 

« first day (2874 days earlier)      last day (1994 days later) »