Problems Associated With Very Large Databases

Replies

• 

  PraveenKumar Purushothaman

  Problems in the sense, it depends on the server and hardware in which it is running. Database generally is encountered with indexing problem and accessing problem. It is also directly proportional to the performance of the hardware. No way redundancy or ambiguity occurs in any point of database. Due to heavy traffic and large number of connections, the DB Server may go down at the worst case. 😔
• 

  Kaustubh Katdare

  Well hardware troubles will always be there. Maybe we should only talk about the problems that arise only because of the size of the databases.
• 

  PraveenKumar Purushothaman

  Only performance issue and indexing issue will be occurring... 😀
• 

  slashfear

  Hey biggie,
  
  Yeah since we are dealing with Very large databases (VLDB) for sure the maintenance really matters and is not maintained properly it can lead to less performance and yeah as praveen said indexing is the solution but make sure that you index the tables which are not updated on regular basics because when using index the select statement will work fine but the update and insert will be really slow!! 😔 and to achieve performance we can go for partitioning the table which is the most effective way to solve the performance issue as it creates a logical split of the table and not a physical split but when you do so it will reduce the number of input and output device as well as the scan device used by the query 😉 which lead to performance 😁
  
  And yeah if you need to know how to partition a table in mysql (I have done partition in SYBASE only 😔 ) follow this link buddy: #-Link-Snipped-#
  
  
  Hope it helps!!
  
  -Arvind
• 

  PraveenKumar Purushothaman

  slashfear

  Hey biggie,
  
  Yeah since we are dealing with Very large databases (VLDB) for sure the maintenance really matters and is not maintained properly it can lead to less performance and yeah as praveen said indexing is the solution but make sure that you index the tables which are not updated on regular basics because when using index the select statement will work fine but the update and insert will be really slow!! 😔 and to achieve performance we can go for partitioning the table which is the most effective way to solve the performance issue as it creates a logical split of the table and physical split but when you do so it will reduce the number of input and output device as well as the scan device 😉
  
  And yeah if you need to know how to partition a table in mysql (I have done partition in SYBASE only 😔 ) follow this link buddy: #-Link-Snipped-#
  
  
  Hope it helps!!
  
  -Arvind

  MySQL partitioning in Portable Server is a mess. I tried once and ended up crashing the server files. All my frm files became corrupted. 😔But in the normal installation, the performance boosted upto 12% - 15%! 😀 Arvind, any idea to partition in Portable Servers?
• 

  slashfear

  praveenscience

  MySQL partitioning in Portable Server is a mess. I tried once and ended up crashing the server files. All my frm files became corrupted. 😔But in the normal installation, the performance boosted upto 12% - 15%! 😀 Arvind, any idea to partition in Portable Servers?

  Sorry dude I dont have any idea about portable server 😔
  
  -Arvind