meta user
network profile
| bio | website | logicworks.net/products |
|---|---|---|
| location | New York, NY (USA) | |
| age | 48 | |
| visits | member for | 2 years, 4 months |
| seen | 1 min ago | |
| stats | profile views | 4,831 |
One of JEHOVAH's Witnesses (Ex 6:2,3; 9:16; Isa 12:2,4,5)
Senior MySQL DBA (SCMDBA since 2007-08-11) with LogicWorks, provider of The Cloud Your Way (LinkedIn,Twitter,FaceBook). I currently support various MySQL Replication Topologies (Master/Slave, Master/Master, DRBD, Percona XtraDB Cluster) for Clients of Managed DB Services (Hardware and High Availability) in DB/Web/Cloud Hosting Environments (60+ MySQL Clients) since November 12, 2007.
|
5h |
comment |
CSV File Into MYSQL Merging - LOAD DATA on Duplicate Key? I updated my answer, dropping the Primary Key, and adding an index on userID. Give that a Try !!! |
|
5h |
comment |
CSV File Into MYSQL Merging - LOAD DATA on Duplicate Key? That's right. Add a regular index on userid in Table1Loader. |
|
5h |
comment |
CSV File Into MYSQL Merging - LOAD DATA on Duplicate Key? I gotcha. Try removing the PRIMARY KEY from Table1Loader before the LOAD DATA INFILE. |
|
6h |
comment |
CSV File Into MYSQL Merging - LOAD DATA on Duplicate Key? I know there are dups in the CSV. Table1 will have only unique keys. Table1Loader has everything. The UPDATE JOIN simply updates all the columns in Table1. When the UPDATE JOIN is done, Table1 will only have the 4411 rows in it with all the TINYINTs merged. |
|
7h |
comment |
CSV File Into MYSQL Merging - LOAD DATA on Duplicate Key? Another Question: Does Table1 already have data in it ? |
|
7h |
comment |
CSV File Into MYSQL Merging - LOAD DATA on Duplicate Key? Question to help me understand: Are you saying the merge of the first lines should look like this: 2323232,2333222,1,0,0,1,1... ? |
|
7h |
comment |
CSV File Into MYSQL Merging - LOAD DATA on Duplicate Key? Please show the table structure of the table you want to load. Please also show a sample of row/columns that will be inserted into the table. |
|
8h |
comment |
How to safely change MySQL innodb variable 'innodb_log_file_size'? This is a good answer as an update to this question. +1 !!! |
|
12h |
comment |
How to safely change MySQL innodb variable 'innodb_log_file_size'? @PeeyushKushwaha I am sorry, you are using sftp. The main point is still to remove the ib_logfile[01] file. Perhaps your logs are located in a different folder from /var/lib/mysql. In any event, I am glad you got the ball rolling again... :-) |
|
12h |
comment |
How to safely change MySQL innodb variable 'innodb_log_file_size'? @PeeyushKushwaha Please look at my answer again. Step 3 is rm -f /var/lib/mysql/ib_logfile[01]. That's the manual step to delete the logs before restarting mysql. |
|
20h |
comment |
MYSQL Timezone support If my answer was really helpful, please mark it accepted by clicking the checkmark. |
|
23h |
comment |
MySQL, optimize and replication @Michael-sqlbot Thanks, it's been awhile since seeing that syntax. Taken for granted and overlooked too long. Thanks again. |
|
1d |
comment |
MyISAM key buffer The book <a href=amazon.com/Database-Design-Tuning-Robert-Schneider/dp/… Database and Tuning</a> has a good tuning and monitoring guide for InnoDB on pages 265-279, naming all the status variables you need to monitor. |
|
1d |
comment |
Optimizing disk space for MyISAM tables: what is the benefit of ALTER and ANALYZE if you already do OPTIMIZE? Thank you for catching the typo in my ServerFault post. +1 !!! |
|
1d |
comment |
About changing data path by database This applies only a person is running two instances of mysqld on different ports. |
|
1d |
comment |
reset mysql root password on ubuntu I updated my answer on what to do next... |
|
2d |
comment |
What is the best way to transport database fields from one database to another? Are all the tables MyISAM ??? |
|
2d |
comment |
Fast way of delete MySQL record My answer dba.stackexchange.com/a/44637/877 is the implementation of your answer. You get a +1 for coming up with the idea first. |
|
Jun 15 |
comment |
Does the size of the primary key contribute to table size? This was an excellent question because the PRIMARY KEY is tied into the Clustered Index (as I mentioned in my answer). +1 !!! |
|
Jun 14 |
comment |
Does the size of the primary key contribute to table size? Do you have innodb_file_per_table enabled ??? |
