3,832 reputation
21123
bio website stackoverflow.com/users/…
location France
age 36
visits member for 2 years, 8 months
seen 29 mins ago

“Well!... That takes the biscuit!”

Joyce, James. The Dubliners

The best way to speed up something is to not do it in the first place.

Kyte, Thomas.


5h
revised ORA-12516 but max_utilization not reaching limit
added 30 characters in body
11h
comment MySQL - Out of memory: Kill process 3046 (mysqld)
Linux does not swap to random parts of your disk. You need to configure a swap device (or swap file) yourself.
11h
comment MySQL - Out of memory: Kill process 3046 (mysqld)
Apr 19 20:09:30 mysql1 kernel: Free swap = 0kB Apr 19 20:09:30 mysql1 kernel: Total swap = 0kB - the kernel can't swap if it doesn't have swap space...
1d
reviewed Approve suggested edit on Relational modeled design to store versioned files
1d
revised Optimizing indexes
added 1 character in body
2d
comment Will redirecting queries to dev/null warm up indexes?
mysql has essentially no clue that you're redirecting the output. Redirecting to a file or to /dev/null will have the same effects on the database as not redirecting at all. That being said, I have no clue if your query would warm the cache or not on MySQL. (e.g. for Oracle, some full scans can bypass the cache given the right set of circumstances.)
Apr
14
comment Impact of replication compression & encryption on performance, traffic?
For 2/, apart from the handshake, SSL essentially won't add size overhead. (Some CPU overhead though, see e.g. stackoverflow.com/questions/9436754/…). 3/ is rather vague.
Apr
14
revised Impact of replication compression & encryption on performance, traffic?
deleted 18 characters in body; edited title
Apr
11
comment Retrieve result set with proportion of some column value
Select X records with scoring rule 1 union all Y records with rule 2. But your problem isn't really clear. There is no such thing as "first 10 records" unless you specify sorting criteria. Are you looking for random sets of records?
Apr
8
comment How to improve the performance of this select query?
What indexes do you have? What's the explain plan?
Apr
8
revised Oracle becomes too slow after system crash
added 9 characters in body
Apr
8
revised Oracle becomes too slow after system crash
added 14 characters in body; edited title
Apr
7
comment Why does my table hold duplicate primary keys?
What's ID's datatype and how did you find those duplicates?
Apr
7
revised How does SQL*Plus connect to Oracle without a listener?
added 39 characters in body; edited title
Apr
7
revised Question on relation schema questions
added 27 characters in body
Apr
5
comment Large RAM use after import database - ubuntu server
You have 3.5G of cache - that's freeable if needed. Don't worry about it. It's normal and good. Completely free RAM is wasted RAM.
Apr
5
revised Oracle Database 12c and Kerberos Authentication
added 248 characters in body
Apr
3
comment Oracle 10g: same query, different plans on copies of the same DB
Compare all your parameters (including any hidden parameter you might have touched), and compare the stats on the affected tables.
Apr
2
revised netca failed during installation of Oracle 12c on Windows
deleted 3 characters in body; edited title
Mar
30
revised Using environment variables in data pump query
deleted 57 characters in body