123 reputation
4
bio website markandclick.com
location
age 32
visits member for 2 years
seen Nov 26 '13 at 14:27

I am researcher and a software engineer, working at BGU Deutsche Telekom Labs. I have BSc and MSc in Computer Science, Ben-Gurion University.

Currently my research (MSc & Phd-maybe) involves invention of new partially wait free algorithms (Multi-threaded queues / pools / stacks etc..).

My current work focuses on system design and anomaly detection using machine learning techniques.

My hobbies are python -> here is an interactive tutorial that i have created: www.markandclick.com/pythontutorial/.

If you are interested to get some advice or consultation on the following topics: System design, Database design (specially MySQL) or multithreading synchronization techniques/ algorithms.

You are welcome to write me an email to smgorelik@gmail.com


Jan
12
comment MySQL large databases, unique index effect on efficiency?
I would suggest you to post your insert query and the definition of your table here, so that we are able to see why it takes too long to insert 300k records (it is a small size even for 3 indexes)
Jan
12
comment MySQL large databases, unique index effect on efficiency?
Partitioning by it self may slower the queries, only in case where you specify the partition field in a query in a correct manner , it may boost the performance. partition by it self is not intend to improve performance.
Dec
25
awarded  Supporter
Dec
25
awarded  Tumbleweed
Dec
18
asked Dynamic MySQL partitioning based on UnixTime
Dec
18
asked MySQL Partitioning, Reorganize Max Value partition (Known Bug / Feature)
Jul
24
comment MySQL: reducing ibdata file size for MyISAM tables
Thanks for a good answer
Jul
24
awarded  Scholar
Jul
24
accepted MySQL: reducing ibdata file size for MyISAM tables
Jul
24
awarded  Student
Jul
24
comment MySQL: reducing ibdata file size for MyISAM tables
I will do so and update here as soon as i will return back to work tomorrow morning, thanks
Jul
24
comment MySQL: reducing ibdata file size for MyISAM tables
Maybe i am doing something wrong, and may be i have some bug, although my default engine is MyISAM and i do create all the tables as MyISAM tables and the ibdata is very high (~20G). I have also checked the actual data size in the DB and it is about 3-4G,
Jul
24
asked MySQL: reducing ibdata file size for MyISAM tables