80 reputation
9
bio website clickstefan.wordpress.com
location Constanta, Romania
age 24
visits member for 1 year, 2 months
seen Jan 28 at 8:00

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


Jan
28
awarded  Tumbleweed
Jan
21
revised How to change a table's data directory
added 473 characters in body
Jan
21
asked How to change a table's data directory
Oct
29
accepted Multibyte replace not working in SQL Server
Oct
29
comment Multibyte replace not working in SQL Server
@mark_s what is the difference between SQL Server and MSSQL? I usually use MSSQL notation when searching as SQL Server is too generic.
Oct
29
asked Multibyte replace not working in SQL Server
Jun
12
awarded  Custodian
Jun
12
reviewed Approve suggested edit on Query is not using indexes on third table in left join
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