Reputation
824
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
4 15 26
Newest
 Yearling
Impact
~270k people reached

May
10
comment Single query sending and retreiving duplicate data on MS SQL Server?
IT looks like this problem is bigger than my knowledge (for now). Have you tried to execute: mysql> show full processlists; when the system is slow??, probably you can find something there, and if you do, you can kill it (don't know if it's good idea) with: mysql> kill query id
May
10
revised Why is MySQL is creating so many temporary tables on disk?
more readable
May
10
suggested approved edit on Why is MySQL is creating so many temporary tables on disk?
May
9
answered What is the best database design for this situation?
May
9
revised In MySQL, how to manually edit values of a BLOB column in few tuples?
added 7 characters in body
May
9
revised In MySQL, how to manually edit values of a BLOB column in few tuples?
added 374 characters in body
May
8
comment In MySQL, how to manually edit values of a BLOB column in few tuples?
I tried it and I think you are right, just use varchar(length) to create text index.
May
8
comment In MySQL, how to manually edit values of a BLOB column in few tuples?
change the storage engine, probably you are using innodb, with Myisam you can use text as primary key, please take a loot to this forum where someone have something like that stackoverflow.com/questions/10180762/…
May
8
answered In MySQL, how to manually edit values of a BLOB column in few tuples?
May
8
comment Single query sending and retreiving duplicate data on MS SQL Server?
please check the programmers code.... the 70% of the speed it's up how developer create the query, probably they are doing some crazies queries that can be improve or check how it's the DB design(tables, relations, index, PK, FK). 25% it's up the DBMS, how the DB is configure, 15% it's the hardware (someone tell me if I'm wrong...)
May
8
comment USING construct in JOIN clause can introduce optimization barriers in certain cases?
It looks like "using" make the code a little bit readable but I guess that both fields need the same name. I don't think that using will have a better performance than a "on", because the DB need to make the match anyway, it's like a select have the same performance than a join (correct me if I'm wrong), the difference is that Join is cleaner and easier to maintain.
May
8
awarded  Teacher
May
8
revised What does COUNT(1) actually count?
added 17 characters in body
May
8
comment In MySQL, how to manually edit values of a BLOB column in few tuples?
I'm not sure 100% what you mean, but BLOB is used a lot to store files, like images. how to edit that? I think if you make a select of that field the only think that you'll see is BINARY code, so probably edit it wont be easy...
May
8
revised What does COUNT(1) actually count?
added 1098 characters in body
May
8
revised What does COUNT(1) actually count?
added 1144 characters in body
May
8
answered What does COUNT(1) actually count?
May
4
accepted Which is faster, InnoDB or MyISAM?
May
3
asked Which is faster, InnoDB or MyISAM?
May
3
accepted Which mysql storage engine to choose?