meta user
network profile
| bio | website | |
|---|---|---|
| location | Cincinnati, OH | |
| age | 42 | |
| visits | member for | 8 months |
| seen | 17 mins ago | |
| stats | profile views | 101 |
If you question the superiority of the relational model... you're doing it wrong.
|
Feb 21 |
answered | How to retrieve master log position and master log file in shell script |
|
Feb 20 |
comment |
Mysql optimization help dev.mysql.com/doc/refman/5.5/en/show-processlist.html ... however you normally talk to the server (the mysql command line client, MySQL workbench, phpmyadmin, etc.) just send SHOW FULL PROCESSLIST; while logged in a a user with the SUPER privilege. It shows all of the current connections and what they're doing, and how long they've been doing it, right at the moment you issue the statement. You're pretty much operating blind with out it. |
|
Feb 20 |
answered | How to apply patches in MySQL in any version |
|
Feb 20 |
comment |
Mysql optimization help Have you looked at MySQL's SHOW FULL PROCESSLIST while the spikes are occurring? |
|
Feb 20 |
comment |
mysqldump including deleted rows If my suggestion sent you in the right direction, I could post it as an answer that you could mark as the accepted answer. |
|
Feb 20 |
comment |
MySQL: Improve performance for one row insert into table with unique constraint Questions: Is the client running on the same machine as the server, or a different machine? Have you benchmarked with multiple concurrent clients? With an empty table with the same structure? Without the unique key? With an InnoDB table? If you slam the server with repeated inserts, what values peak up on the "Cpu(s)" row of top -- %us, %sy, %wa, %hi, %si, or %st? |
|
Feb 19 |
comment |
MySQL Scheduled Event and server offline? Are you asking whether the "missed" event will be "made up" when the server restarts, if the server isn't online when the event should have fired? |
|
Feb 19 |
comment |
MySQL: Improve performance for one row insert into table with unique constrainttable_open_cache = 1 seems like a potential performance killer. |
|
Feb 19 |
revised |
Create a VIEW that spans 3 tables clarify temptable algorithm |
|
Feb 19 |
revised |
Create a VIEW that spans 3 tables add "strengths vs" before "limitations" since wording seems too negative |
|
Feb 19 |
answered | Create a VIEW that spans 3 tables |
|
Feb 18 |
comment |
mysqldump including deleted rows What you're describing sounds impossible. The mysqldump utility creates the INSERTs by executing essentially SELECT * FROM table_name and transforms the results back into INSERT statements. One possibility is that you might have an index-related problem that's keeping you from finding the records on the old server using WHERE, but they're really there. The fact that COUNT(*) returns the same value seems to suggest that this might be the case. |
|
Feb 18 |
comment |
How to retrieve master log position and master log file in shell script This is not entirely correct, because the two parameters need to be retrieved in a single query to the database. Otherwise, there exists a narrow window of time, each time the binlog rotates, when you get an entirely invalid answer because the position returned by the 2nd query would be from the next file, not the filename you retrieved during the 1st query. |
|
Feb 17 |
comment |
Table that writes most of the time, and also read for autocomplete, which MySQL engine to use? Changing to MyISAM is rarely a good move. Fulltext indexes are supported for InnoDB in the still-new MySQL 5.6... but the biggest question is... if you have Sphinx, why are you not querying Sphinx for the autocomplete? |
|
Feb 17 |
comment |
index doesn't work properly Your GROUP BY in the first example is in the opposite order from the GROUP BY in the second example... so you likely need an index in the correct order (stage,user_id) for the second query... but you should post EXPLAIN SELECT as well as the table definition, because there's not enough information here for a definitive answer. It's also hard to tell what your 2nd query is trying to calculate and whether it's accurate for its intended purpose. The user_id you get from that query does not appear to be meaningful and total_players is the total of records in single. |
|
Feb 16 |
answered | Problem with (not) Locking Tables during Restore |
|
Feb 16 |
revised |
MySQL Reusing calculation in SELECT clause in a VIEW clarification, this answer is offered because I'm unaware of alternatives. |
|
Feb 16 |
comment |
MySQL Reusing calculation in SELECT clause in a VIEW The answer to "how do you do this?" is "you don't," ... or "no, you cannot reuse the calculation in a view, you have to repeat the expression." |
|
Feb 16 |
answered | MySQL Reusing calculation in SELECT clause in a VIEW |
|
Feb 15 |
comment |
Using multiple server databases Your "main data"...? |
