Reputation
Top tag
Next privilege 125 Rep.
Vote down
Badges
5
Impact
~1k people reached

  • 0 posts edited
  • 0 helpful flags
  • 2 votes cast
Sep
24
awarded  Autobiographer
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