Jump to content
View in the app

A better way to browse. Learn more.
The Uniform Server Community

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Neon

Member

  • Joined

  • Last visited

View Profile Find content
  1. Neon

    Optimising MySQL

    Neon posted a topic in MySQL
    I am running the standard 3.2a version of Uniform server on a Win XP 64 box with dual 2.2GHz Opterons (i.e. 4 cores), 6Gb ram and a 15k rpm scsi drive. The system is running a very large database (approx 276 million records at present) and is working pretty well. I would really like some advice on optimising the MySQL settings to improve query times as most queries now take well over an hour to run. The system doesn't appear to be making very much use of the 6GB of ram that is installed so hopefully someone can tell me how to remedy that little problem to keep more table information cached in memory. Any other optimisation tips for large databases (in terms of records as the physical file is under 30Gb) would also be appreciated.

Account

Navigation

Search

Configure browser push notifications
Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.