4,662 reputation
21428
bio website stackoverflow.com/users/…
location France
age 37
visits member for 3 years, 2 months
seen 1 hour 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.


3h
comment Benchmarking MyISAM vs InnoDB using Sysbench on MariaDB-10.0.14
The TPS score for MyISAM (232 "transactions" per second) is better than that for InnoDB (130).
6h
revised What is fragmenting my index on a table with stable traffic?
added 10 characters in body
7h
revised PostgreSQL procedural languages overhead (plpython / plsql / pllua…)
edited tags
1d
comment What are the dangers of non-IT managers using improper database terminology
This question appears to be off-topic because it is not about database administration. The Workplace might take this sort of question, be sure to search their site and look at their help center first.
2d
reviewed No Action Needed MySQL slave stuck at 'System lock' most of the time, high CPU usage
2d
reviewed Close SQL Server stuck in single_user with auto_update_statistics_async on
2d
reviewed Close How to use SQLite3 in VB.Net 2013
2d
reviewed Leave Open One field with multiple values?
2d
reviewed Close Disk space Report for CMS
2d
reviewed Close The most important oracle database performance metrics
Oct
22
comment I cannot add oracle listener with windows server 2008 r2
Please edit your post with the "details of error". Nothing we can do for you without that.
Oct
22
comment Oracle PLSQL code recovery
TNS-12514 isn't usually a big problem. Can't you connect "/ as sysdba" from the server? Looks like you're trying to solve the wrong problem, your database probably isn't dead (unless there are thing you haven't mentioned).
Oct
21
awarded  Nice Answer
Oct
21
comment When is mariadb creating tmp tables?
I'm not familiar enough with MySQL, but I'd try the random limited select on pics in an inner query, and join on users outside - looks like it is materializing that "where-less" join.
Oct
20
revised Using transactions in sqlplus
added 39 characters in body
Oct
20
comment increasing disk space for mysql data volume
You can't have zero downtime and zero risk with a structural change to your database (even if there's a way to move the logs online - no idea if MySQL can do that - it's still a "risk" insofar as it deviates from standard operational conditions). If you're not in a hurry, use this time to prepare/plan a downtime properly, or thoroughly test alternatives.
Oct
20
answered Using transactions in sqlplus
Oct
20
comment increasing disk space for mysql data volume
Yes, I know, just haven't seen anyone use that filesystem in a while. What's your exact problem then, if you know you can resize your FS without downtime? Can't take the risk?
Oct
20
comment increasing disk space for mysql data volume
LVs and filesystems can be resized online. (Although I haven't seen reiserfs in ages.)
Oct
20
comment ASM configuration in linux
Oracle provides documentation for their install & upgrade procedures, as well as for migrating to ASM. Follow those. If you're stuck at some point, describe your exact problem.