Reputation
4,129
Top tag
Next privilege 5,000 Rep.
Approve tag wiki edits
Badges
1 7 13
Newest
 innodb
Impact
~542k people reached

13h
comment mysql command not restoring data
Something subtle is going on that I cannot see, nor can I imagine. Please show us the contents of Dump.sql down to (and including) the first INSERT. And show us some of the output from SELECT * from the table that should have those inserted rows.
1d
comment Why people often said nosql has better write performance than sql?
If you want high-speed writes, with indexing, and with ACID, look into TokuDB, which is now available in MariaDB.
1d
comment Why people often said nosql has better write performance than sql?
A few applications will run faster with a NoSQL than with a RDBMS. A few applications are easier to write in NoSQL than in SQL. RDBMS (and SQL) is more general purpose. If you have a specific application, we can debate which way to write it. Otherwise, your question is too broad.
1d
comment Mysql: binary log vs transaction log
Correct. Often, after a crash, MyISAM tables need a REPAIR.
1d
comment How to get line that causes error when loading from csv to MySQL
Let's see a couple of lines around #123545. Let's see the LOAD command. Let's see SHOW CREATE TABLE for what you are loading into. (Edit your question with this info)
1d
revised (VS Comm./VB6) How to Select from 2 different data sources/formats in one query?
wrap
1d
comment MySQL - Combining multiple rows as one in one table
Here's a Stored Procedure that will create the SELECT for you: Pivot
1d
comment MySQL InnoDB 5.6.23 cannot start segmentation fault 11
5.6.23 on both machines?
1d
comment how to boost range count query performace
PRIMARY KEY(id)
1d
answered longtext in select makes query extremely slow, even if not used in where clause and empty result set (MySQL)
1d
comment longtext in select makes query extremely slow, even if not used in where clause and empty result set (MySQL)
MyISAM might help. Big fields are stored with the record - usually. If there is a lot of 'churn' (deletes/updates, then more inserts) the rows become fragmented. That would lead to lots of I/O.
2d
comment Are certain environment variables required for mysql login-path?
cron runs as someone else, perhaps "nobody".
2d
comment Migrate MySQL 3.23 Data
Good. But JSON?? Nothing in MySQL (until 5.7) deals with JSON.
2d
answered Are certain environment variables required for mysql login-path?
2d
answered Migrate MySQL 3.23 Data
2d
comment how to splitt a mysql table file?
What benefit do you hope to gain by limiting pieces to 10GB? I ask because` PARTITION` does not automatically give any benefits.
2d
answered MySQL: Update table by closing existing record and inserting a new one?
2d
answered insert multiple depend on prev queries
2d
comment How to reduce connection usage,Traffic and No of mysql queries in a mysql server?
What client are you using? How many instances of it? What is max_connections?
2d
comment Performance hits with MySQL Left Joins and Order By
SHOW CREATE TABLE for both tables; there is too much handwaving about indexes.