Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Forum Replies Created

Viewing 6 posts - 1 through 6 (of 6 total)
  • Author
    Posts
  • in reply to: Import From Sql Statements Slow #22235
    DARAB
    Member

    What is indizis?

    in reply to: Import From Sql Statements Slow #22232
    DARAB
    Member

    do the databases use different charsets?

    No.

    what happens if you set your my.ini settings to the same values as the slower machine has?

    No significant change.

    does the slower machine have a raid-disk-subsystem (or something like a cache-controller)?

    No.

    are the database engines on both machines the same? it looks like a bit like you would use INNO-DB for your laptop and myisam on the slower machine.

    INNO-DB for both.

    in reply to: Import From Sql Statements Slow #22229
    DARAB
    Member

    I have changed the “Max Packet Size (in K:cool: for BULK INSERT statements” on the General tab of Preferences in SQLyog to 10000. I ran the import again and it has ben running for over 12 hours and it looks like it has 4-6 hours to go. This same import took 35 minutes on a slower machine. I've compared the my.ini files between the 2 machines and if there are differences, my machine that is taking such a long time to import has higher settings. The version of MySQL on the machine that imports in 35 minutes is a slightly older version and is an alpha. Could there be a different MySQL file that has parameters I need to change?

    in reply to: Import From Sql Statements Slow #22227
    DARAB
    Member

    When you say “the BULK setting is an internal SQLyog setting” are you referring to the “Max Packet Size (in K:cool: for BULK INSERT statements” on the General tab of Preferences in SQLyog? If so, I have unchecked Get Server Default and set the Custom Size to 10000 but no performance improvement.

    in reply to: Import From Sql Statements Slow #22225
    DARAB
    Member

    Sorry about that one post.

    I meant to say:

    Yes, I created the SQL statement file with SQLyog where I used the Export Database as SQL Statements…

    I forgot to mention that I'm importing SQL statements to my laptop locally so there is no network involved and it is still running slowly.

    I'm assuming I need to make a change in the my.ini file of MySQL to alter the BULK setting. Do you know what the variable name is for BULK?

    in reply to: Import From Sql Statements Slow #22223
    DARAB
    Member

    Thanks for responding Peter.

    I forgot to mention that I'm importing SQL statements to my laptop locally so there is no network involved and it is still running slowly.

    I'm assuming I need to make a change in the my.ini file of MySQL to alter the BULK setting. Do you know what the variable name is for BULK?

Viewing 6 posts - 1 through 6 (of 6 total)