clickstefan

78 reputation

bio	website	clickstefan.wordpress.com
	location	Constanta, Romania
	age	23
visits	member for	3 months
	seen	Apr 22 at 8:59
stats	profile views	6

Pasionate about Web Design/Development & Open Source (php, mysql, apache, linux, android etc.)

	78 reputation	bio	website	clickstefan.wordpress.com	visits	member for	3 months
7 badges		location	Constanta, Romania		seen	Apr 22 at 8:59

summary answers questions tags badges favorites bounties reputation activity

25 Actions

suggestions reviews revisions comments badges posts accepts all

Mar 7	revised	How to improve INSERT speed in large table that has unique constraint added 1215 characters in body
Mar 7	answered	How to improve INSERT speed in large table that has unique constraint
Mar 4	comment	MySQL: Improve performance for one row insert into table with unique constraint check you have `key_buffer_size` bigger than the index size( you can see that using show table status ), other than that there could be many wrongs, ask a question and give details.
Feb 20	comment	MySQL: Improve performance for one row insert into table with unique constraint for these tests I've used a different machine as client, but the main application will be on server. I needed about 10x speed, so I didn't think the networking would matter as most operations are on server. For my data usage I've found that MyISAM is faster, as I don't need high reads as I need inserts. Even with table locks from 500 connections/s it still is faster than InnoDB. Anyway I found that using `LOAD INDEX INTO CACHE url_unique` did the trick, speed is now at ~ 0.001 (1k/s) from remote.
Feb 20	comment	MySQL: Improve performance for one row insert into table with unique constraint now it's at about .015 (~60/s) with nothing else running on the server, is there anything else I could do to speed it up, I see that the selects I did last night still run fast now, even after I've restarted the MySQL server, probably some Linux read cache. How much data can it cache? could I do some warm-up process?
Feb 20	comment	MySQL: Improve performance for one row insert into table with unique constraint oups, I've messed with the .cfg some time before and forgot that there :), should 1000 suffice?
Feb 19	asked	MySQL: Improve performance for one row insert into table with unique constraint
Feb 19	awarded	Supporter
Feb 19	comment	Query is not using indexes on third table in left join great, glad that it helped.
Feb 19	comment	Query is not using indexes on third table in left join could you please update the `mysql> show create table promotion_coupon_images\G` Also did you create an index on the new collumn, an use that column in the join ?
Feb 19	revised	Query is not using indexes on third table in left join corected username
Feb 19	awarded	Teacher
Feb 19	revised	Query is not using indexes on third table in left join corected username
Feb 19	answered	Query is not using indexes on third table in left join
Feb 18	revised	Unique insert performance: Primary Key vs Unique Index added 281 characters in body
Feb 18	awarded	Scholar
Feb 18	accepted	Unique insert performance: Primary Key vs Unique Index
Feb 15	comment	Unique insert performance: Primary Key vs Unique Index would an ssd or partitions help? I know they usually help reads, but would it make any difference in my case?
Feb 15	awarded	Editor
Feb 15	comment	Unique insert performance: Primary Key vs Unique Index from what I've tested the varchar Primary Key seems a little slow after a few million inserts. Is there a better storage engine/method for this table?