Page 3 of 3 FirstFirst 123
Results 21 to 27 of 27

Thread: [MySQL] MySQL Database setup recommendation for best results.

  1. #21
    omarfilip's Avatar
    omarfilip is offline Nearly a Master Glow Jedi
    Join Date
    Jan 2008
    Location
    Dallas, TX
    Posts
    127

    Default

    Matt, Sergey's SCREEN solution did the trick. The DB is in and working.

    Any thoughts on the very long import time it required?

  2. #22
    Matt's Avatar
    Matt is offline GlowHost Administrator
    Join Date
    Jan 2005
    Location
    Behind your monitor
    Posts
    5,515

    Default

    It is a bad ISP, or a bad computer.

    130 MB should never take that long.

    Have you tried another ISp or another computer? I suggest you download a large file like that SQL and test it from:

    Different ISP
    Different Computer
    Different Computer on Different ISP
    Same Computer on Different ISP
    Same Computer on Same ISP

    Doing those tests will tell you where your problem is.
    Send your friends and site visitors to GlowHost and get $125 plus bonus!
    GlowHost Affiliate Program | Read our Blog | GlowHost's Facebook | Follow us on Twitter | GlowHost on Google+

  3. #23
    omarfilip's Avatar
    omarfilip is offline Nearly a Master Glow Jedi
    Join Date
    Jan 2008
    Location
    Dallas, TX
    Posts
    127

    Default

    No, this was a file already uploaded to my vps and already unzipped. All I had to do was issue the mysql command.

    It was all done on the glowhost vps (cpvps118-vern). Bad computer?

  4. #24
    Matt's Avatar
    Matt is offline GlowHost Administrator
    Join Date
    Jan 2005
    Location
    Behind your monitor
    Posts
    5,515

    Default

    Not sure why it took so long, perhaps because of MySQL or perhaps because of the VPS enviroment.

    Maybe we can get a DBA to post here and give us a normal import time for a DB of that size.
    Send your friends and site visitors to GlowHost and get $125 plus bonus!
    GlowHost Affiliate Program | Read our Blog | GlowHost's Facebook | Follow us on Twitter | GlowHost on Google+

  5. #25
    omarfilip's Avatar
    omarfilip is offline Nearly a Master Glow Jedi
    Join Date
    Jan 2008
    Location
    Dallas, TX
    Posts
    127

    Default

    For what it's worth, during the first few import tries (which timed out after 10 minutes) the rate of import was approximately 50MB/10min or 5MB/min. The successful import was 130MB/2.5hr or 0.9MB/min.

  6. #26
    jmarcv's Avatar
    jmarcv is offline Cranky Coder
    Join Date
    Jan 2005
    Posts
    354

    Default

    What was 130MB? The final data or the sql file?
    Also may be the format of the sql file
    I think possibly what could be an issue is that the redirect method reads the whole file into mem and depending on how mem is arranged, it could have been hitting the swap file pretty heavily. That would slow it down. I'll bet the disk IO was pretty high too with all that reading and writing. Theres no real answer on how long these things should take. I assume this was a one shot deal anyway? If not, I can take a look next time.

  7. #27
    omarfilip's Avatar
    omarfilip is offline Nearly a Master Glow Jedi
    Join Date
    Jan 2008
    Location
    Dallas, TX
    Posts
    127

    Default

    Yes John-Marc, it was a one shot deal and it's finished.

    The file size of the database.sql was ~130MB.

    Not sure what you mean by final data vs. sql file.

    Perhaps there was something else going on at the same time, maybe the nightly backup, because the first few attempts had a better rate of import than the one that ultimately succeeded.

    Omar
    Last edited by omarfilip; 02-01-2008 at 08:26 PM.

Page 3 of 3 FirstFirst 123

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16