ابدأ بالتواصل مع الأشخاص وتبادل معارفك المهنية

أنشئ حسابًا أو سجّل الدخول للانضمام إلى مجتمعك المهني.

متابعة

Why not mysql database contains more data like as oracle database?

user-image
تم إضافة السؤال من قبل Jahirul Jahir , software company , promiti computers and network
تاريخ النشر: 2014/11/03
Sheikh Faisal Izhar
من قبل Sheikh Faisal Izhar , Sr. Manager IT , Gourmet Foods Pakistan

An Oracle database consists of one or more tablespaces. Tablespaces provide logical storage space that link a database to the physical disks that hold the data. A tablespace is created from one or more data files. Data files are files in the file system or an area of disk space specified by a raw device. A tablespace can be enlarged by adding more data files

Kamran Saeed Kamran
من قبل Kamran Saeed Kamran , Oracle Apps DBA , DHA Lahore

Hi Dear,

 Limits on Table Size The effective maximum table size for MySQL databases is usually determined by operating system constraints on file sizes, not by MySQL internal limits. The following table lists some examples of operating system file-size limits. This is only a rough guide and is not intended to be definitive. For the most up-todate information, be sure to check the documentation specific to your operating system. Operating System File-size Limit Win32 w/ FAT/FAT322GB/4GB Win32 w/ NTFS2TB (possibly larger) Linux2.2-Intel32-bit2GB (LFS:4GB) Linux2.4+ (using ext3 file system)4TB Solaris9/1016TB OS X w/ HFS+2TB NetWare w/NSS file system8TB Windows users, please note that FAT and VFAT (FAT32) are not considered suitable for production use with MySQL. Use NTFS instead.

 

You can read this blog you will see the difference in many aspects.

 

http://www.xaprb.com/blog/2009/03/13/50-things-to-know-before-migrating-oracle-to-mysql/

 

Thank you 

Regards,

Kamran Saeed

المزيد من الأسئلة المماثلة

هل تحتاج لمساعدة في كتابة سيرة ذاتية تحتوي على الكلمات الدلالية التي يبحث عنها أصحاب العمل؟