Author Topic: ANN: MySQL 4.1.17  (Read 2569 times)

pmf

  • Jr. Member
  • **
  • Posts: 64
    • View Profile
ANN: MySQL 4.1.17
« on: November 06, 2004, 02:11:48 pm »
I have made my MySQL 4.1.17 packages available in the unstable-feed.

mysql-client
mysql-server

To start the server: /etc/rc.d/init.d/mysqld start
To stop it: /etc/rc.d/init.d/mysqld stop

The default user is 'nobody'; the postinst script sets permissions accordingly.
If you decide to create a dedicated user/group, do a chown -R user:group /opt/mysql/var

Don't expect good performance, it is MySQL.

offroadgeek

  • Administrator
  • Hero Member
  • *****
  • Posts: 1419
    • View Profile
    • https://www.oesf.org
ANN: MySQL 4.1.17
« Reply #1 on: November 09, 2004, 01:51:58 pm »
Quote
Don't expect good performance, it is MySQL.
Is this what you mean by poor performance?

Someone please correct me if I'm wrong, but this looks like mysqld is taking up 12MB ram, which is 20% of the memory...  that's not good

When I had the cacko rom flashed on my 760, I had mysql running on it, and I don't remember seeing this kinda of performance (it was much less resource intensive)... granted the cacko rom doesn't have top to prove it.. but it didn't 'feel' this slow...
« Last Edit: November 09, 2004, 01:53:38 pm by offroadgeek »
Search the OESF Wiki
C1000 w/Cacko 1.23 beta (from Streamline) / 760 pdaxrom rc9 / 6000L (thanks Santa's elf!) / 5500 - OZ 3.3.5 / SIMpad SL4
1GB, 256mb SanDisk CF / 2x 1GB, 512mb, 256mb, 128mb SanDisk SD
Ambicom WL100C-CF wifi / Socket 56k CF modem / AmbiCom BT2000-CF (x2)
Pocketop keyboard, Piel Frama case (1000 & 5500), PDAir case (760 & 1000)
sip:536093@fwd.pulver.com
| OESF | ELSI | Zaurus User Group | ZaurusThemes |

dz

  • Administrator
  • Hero Member
  • *****
  • Posts: 589
    • View Profile
    • http://www.dangerz.net
ANN: MySQL 4.1.17
« Reply #2 on: November 09, 2004, 01:53:58 pm »
Mine is bad as well.  I think that's a mysql issue though.  Checking on my server and SQL is taking up 13mb's there as well.
« Last Edit: November 09, 2004, 02:21:12 pm by dz »
http://www.dangerz.net
c860 : Cacko
The greatest experience we can have is the mysterious.
- Albert Einstein

pmf

  • Jr. Member
  • **
  • Posts: 64
    • View Profile
ANN: MySQL 4.1.17
« Reply #3 on: November 09, 2004, 03:21:39 pm »
Quote
Quote
Don't expect good performance, it is MySQL.
Is this what you mean by poor performance?

Someone please correct me if I'm wrong, but this looks like mysqld is taking up 12MB ram, which is 20% of the memory...  that's not good
You can always play around with the values in /etc/my.cnf and decrease buffer/logfile sizes and/or the number of spawned child processes. Note that there is no way to decrease the memory-footprint below 4MB, since the mysqld-binary is of that size.

If you feel like trying it out, I recommend this page for further configuration of MySQL.
These options will have to be added to the /etc/rc.d/init.d/mysqld script.

If you find a configuration that both scales and is memory conservative, I will happily include it in the package instead of the current configuration (which is simply the "tiny" configuration of the source-distribution).

(If you really care about size and performance, use SQLite (as soon as they switch to PHP 5.0.x, this will become the default database for most hosting companies)).