180 reputation
11
bio website about.me/stefan.rogin
location Constanta, Romania
age 25
visits member for 1 year, 10 months
seen 2 days ago

Passionate about Web Software Development, either server or client side, & Open Source (php, mysql, apache, linux, android etc.)


Dec
17
comment Does Sql Server 2008 support Database Sharding
Scaling Out SQL Server : msdn.microsoft.com/en-us/library/aa479364.aspx
Jun
25
awarded  Commentator
Jun
25
comment Unique insert performance: Primary Key vs Unique Index
Correct @Antonis, just that I didn't know how mysql aranges the data on the hdd, and if it would arrange by the primary key, what overhead the varchar would have over int.
Apr
21
awarded  Popular Question
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 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