361 reputation
111
bio website noneatthemoment.de
location Germany
age 33
visits member for 2 years, 6 months
seen 4 hours ago

MySQL DBA currently working in the business intelligence field


6h
comment how to sync local mysql database and live server database?
Please merge your two answers. This is no forum, it's a Q&A site. Thanks.
22h
awarded  Explainer
Sep
26
answered MySQL Case problem
Sep
15
comment Very Slow MySql Stored Procedure
As your procedure does nothing special like using cursors or something like that, it comes down to query optimizing. Run the select queries, that insert data and put the keyword explain in front of it. Post the result and the table structures. Oh, and don't use variable/parameter names that can be confused with column or table names.
Sep
15
revised Very Slow MySql Stored Procedure
code formatting
Sep
15
suggested suggested edit on Very Slow MySql Stored Procedure
Sep
8
answered How to select different format of the date in mysql
Jul
24
revised Extracting the maximum of several subsets and join all maximums in a new table
Removed unnecessary text.
Jul
24
comment Why is my Mysql Query verry slow when selecting a text field
Absolutely the same, okay. Please have a look at this post and follow the instructions for the longer query: stackoverflow.com/a/11275107/447489 Then we can see with what the query is spending its time. As of now, I'd suspect, that it simply takes time to transport the query result over the network.
Jul
24
comment Why is my Mysql Query verry slow when selecting a text field
Please put the keyword EXPLAIN in front of your queries and post the results.
Jul
24
suggested suggested edit on Extracting the maximum of several subsets and join all maximums in a new table
Jul
24
answered Extracting the maximum of several subsets and join all maximums in a new table
Jun
30
revised MyISAM InnoDB performance
improved formatting
Jun
30
suggested suggested edit on MyISAM InnoDB performance
May
21
comment ibdata1 corrupted, recover from ib_logfile?
Agreeing to hidden_4003. Your best bet is a backup and binary log (if enabled).
Mar
28
comment Import data from a CSV file without creating a table first in MySQL
Second that. You have to issue a create table... somehow, so that the .frm file gets created. I'm not sure though, if the load data... really is necessary. If you specify engine=csv in your create table... statement, you can just put the csv file next to the frm file (same name of course), if I remember correctly. Better check that again here: dev.mysql.com/doc/refman/5.1/en/csv-storage-engine.html
Mar
26
comment MySQL 5.1.x: Performance improvement in Enterprise edition Vs community edition
If I'm not mistaken, the only difference between enterprise and community edition is, that the first includes support while the other doesn't.
Mar
18
comment Find the second highest value from a subquery or derived table
@user2493976 Updated my answer.
Mar
18
revised Find the second highest value from a subquery or derived table
added 575 characters in body
Mar
18
answered Find the second highest value from a subquery or derived table