Reputation
4,007
Top tag
Next privilege 5,000 Rep.
Approve tag wiki edits
Badges
1 9 21
Newest
 Enlightened
Impact
~210k people reached

Jan
14
awarded  Enlightened
Jan
14
awarded  Nice Answer
Sep
24
comment Partitioning large mysql table
@shuron, I can't do that. You'll have to test it to be sure.
Sep
24
comment Partitioning large mysql table
@shuron, roughly the same as doing an OPTIMIZE TABLE or other ALTER TABLE that causes a table restructure. It's impossible for me to estimate the time for your table. How large is an entry? How fast is your server? How much other work is going on concurrently on the same server? You might want to look at percona.com/doc/percona-toolkit/2.2/… to help.
Aug
5
awarded  Yearling
Jun
9
comment Dynamically change schema to accommodate custom fields!
@ThaDafinser, thank you!
Feb
24
comment How are auto_increment keys handled in INSERT (SELECT * FROM…)
@Pacerier, the pivot/transpose functions I have seen do not make the column headers into a column. So your made-up syntax does not work. I don't know why you're trying to do acrobatics to avoid using select *. This problem has a straightforward solution.
Feb
24
comment How are auto_increment keys handled in INSERT (SELECT * FROM…)
@Pacerier, if I understand correctly, you're asking if select * can mean select * except for the first column. The answer is no. select * always requests all the columns from that table. If you want a subset, you must spell out the columns you want.
Nov
25
comment Increase performance WITHOUT adding indexes
@RolandoMySQLDBA, have you gotten improvement from putting tmpdir on a tmpfs? I have tried it and found little to no improvement. The overhead of creating temp tables seems to be the bottleneck. The savings by using tmpfs isn't enough to fix performance issues. I suspect temp tables on disk use the filesystem cache and end up living in system memory anyway.
Nov
25
comment Increase performance WITHOUT adding indexes
@TobiasBaumeister, tmp tables on "disk" (even if it's a RAM disk or tmpfs) uses the MyISAM storage engine by default. You can also put a limit on the size of the RAM disk. Whereas tmp tables in memory use the MEMORY (aka HEAP) storage engine, and can use up to tmp_table_size memory per thread. Also, MEMORY storage engine does not support TEXT/BLOB columns.
Oct
29
comment How can i make dump of big mysql table?
"Connection timed out" or "No route to host" when you try to connect usually indicates that you cannot reach the server from the host you're running the mysqldump client on. Sounds like you have no access to the server at all, possibly because of a firewall. You should talk to the network administrator to find out if you can get a VPN connection or access to another client host on the same network.
Oct
16
revised 1 query using OR operator in where clause vs multiple query equal condition where clause in mysql
added 565 characters in body
Oct
16
answered 1 query using OR operator in where clause vs multiple query equal condition where clause in mysql
Oct
10
comment Percona MySQL 5.5 Unique key is duplicated
@PrakashK, here's a link: dev.mysql.com/doc/refman/5.6/en/binary-log.html
Oct
2
answered Upgrading to new cPanel Server with mySQL on SSD — What should I change in my.cnf?
Oct
2
comment Upgrading to new cPanel Server with mySQL on SSD — What should I change in my.cnf?
@ceejayoz, we at Percona frequently see scaling problems that are fixed by disabling the query cache. I advise to disable it unless you see a very favorable ratio of QC hits/misses, perhaps 10:1 or more.
Sep
28
answered What is the cost of adding a foreign key in mysql?
Sep
26
revised Using an index for both asc and desc on a string column
added 498 characters in body
Sep
26
comment Using an index for both asc and desc on a string column
@ypercube, yeah, you're right, I think I created the collation naively by just reversing the order of all the bytes. It turns out that designing collations is more complex than can be done in a few minutes in a StackOverflow post! :-) Anyway, this answer at least serves as a demo of how to do it.
Sep
26
comment Using an index for both asc and desc on a string column
@ypercube, see example of CHAR above.