319 reputation
110
bio website noneatthemoment.de
location Germany
age 33
visits member for 2 years, 4 months
seen Aug 8 at 10:34

MySQL DBA currently working in the business intelligence field


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
Mar
18
comment How to autoincrement Prod_id based on Product_Name using trigger in mysql
Is it or can it be a MyISAM table?
Jan
29
awarded  Critic
Jan
21
comment How can i update two tables
Why should he have no choice for rollback? Trigger events do get rolled back, too.
Jan
15
comment MySQL: How to drop all tables starting with a prefix?
No, this works on all versions. And I just tried, it also works for views.
Jan
15
comment MySQL: How to drop all tables starting with a prefix?
Well, I tried it on my machine and it works. Conclusion: Are you sure you actually have tables named "_elggwhatever" in your database? May that be views instead by any chance?
Jan
15
comment MySQL: How to drop all tables starting with a prefix?
Have you actually replaced your_database_name?
Jan
15
revised MySQL: How to drop all tables starting with a prefix?
added 18 characters in body