Plesk Expand Optimizations

Discussion in 'Plesk Expand 2.3 Troubleshooting Issues' started by DimiterN, Nov 1, 2010.

  1. DimiterN

    DimiterN New Member

    Hello all,
    I'm trying to implement some database optimizations for mysqld (which is used by Expand) and I have noticed some facts:
    - We (in our company) haves two Expand servers : on first all Expand's tables uses MyISAM storage engine (SE), but on second - a lot of tables uses InnoDB SE. Is this normal? Or is caused by some database optimizations by Expand itself?
    - Both machines where Expand is installed haves a high load (1.70 - 2.10 for InnoDB's Expand and 1.10 - 1.20 for MyISAM's). Is this normal for mysqld to take 100% CPU load of one core/process all the time?
    - It is normal that expandom causes high load time to time (I think this is derived by 30 seconds update checks of expandom) and could be this period adjusted?
    - It is possible some SQL queries to be optimized. E.g. queries like this:
    Is there some optimization tutorial/manual or something like this?
    Where I can find more detailed information about Expand's database structure like EER diagrams and so on?

    Every help in Expand optimization will be very appreciated.

    Sincerely yours: Nikov, Dimiter

    P.S. Excuse me for my bad English
  2. DimiterN

    DimiterN New Member

    Seems that nobody in Paralles Team is not concerned about optimizing their crappy software.
    Shame on you guys...

Share This Page