meta user
network profile
| bio | website | myxplain.net |
|---|---|---|
| location | Paris | |
| age | 23 | |
| visits | member for | 5 months |
| seen | yesterday | |
| stats | profile views | 19 |
DBA MySQL - Co-Founder of MyXplain.net
|
1d |
awarded | Caucus |
|
1d |
awarded | Constituent |
|
Mar 14 |
awarded | Critic |
|
Mar 2 |
answered | Need logic to collate data |
|
Mar 1 |
awarded | Student |
|
Mar 1 |
comment |
Replication issue - CREATE SELECT alternative? Yes but, it'll by the INSERT statement, it's an DML, so i'll have the same issue |
|
Mar 1 |
comment |
Replication issue - CREATE SELECT alternative? I think so (pretty sure), i don't have a sample query, we have some MyISAM tables but i think the problem came from the CREATE statement that create a transaction and blocks rows until it'is done. |
|
Mar 1 |
comment |
Replication issue - CREATE SELECT alternative? Complex joins (8-10 tables it's not a particular query) |
|
Mar 1 |
revised |
Replication issue - CREATE SELECT alternative? edited title |
|
Mar 1 |
asked | Replication issue - CREATE SELECT alternative? |
|
Mar 1 |
comment |
How to take a database dump for selective set of values in few tables? Note that if you use subquery (i didn't saw on my first read, sorry) you should LOCK your tables with option -x (mysqldump <your options> <your database> foo -x --where 'user_id = 1') |
|
Mar 1 |
answered | How to take a database dump for selective set of values in few tables? |
|
Feb 27 |
answered | How to get non repeat results |
|
Jan 22 |
comment |
How often does the slow_log table get updated in MySQL? The question was "How often does slow_log table gets updated in MySQL?"... |
|
Jan 15 |
answered | tuning feed item's table query with multiple condition |
|
Jan 15 |
comment |
tuning feed item's table query with multiple condition Ok, can you paste an "SHOW CREATE TABLE rss_item" ? |
|
Jan 15 |
comment |
tuning feed item's table query with multiple condition Yes, can you paste here your explain plan (EXPLAIN SELECT * FROM `rss_item...) we'll can see if MySQL use your index or not. I suspect MySQL take time on the "order by" clause. |
|
Jan 7 |
answered | MySQL Dump/Import progress on Windows |
|
Jan 7 |
comment |
Delete and archive old data from several related tables What's your engine ? MyISAM or InnoDB? In MyISAM you can directly backup the file corresponding to your partition. With InnoDB you should make a mysqldump before removing partition. |
|
Jan 7 |
comment |
Database space doesn't match ibdata1 size Try the following request, it detects table which freespaces that can be removed with OPTIMIZE TABLE order : SELECT s.schema_name, table_name, IFNULL(ROUND(SUM(data_free)/1024,2),0.00) data_free FROM INFORMATION_SCHEMA.SCHEMATA s, INFORMATION_SCHEMA.TABLES t WHERE s.schema_name = t.table_schema GROUP BY s.schema_name, table_name HAVING data_free > 100 ORDER BY data_free DESC |
