[ Date Index ][
Thread Index ]
[ <= Previous by date / thread ] [ Next by date / thread => ]
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Thursday 25 September 2003 11:29 pm, Neil Williams wrote: > It's the performance that I was considering at 250,000 records - I know > MySQL is scalable but just how much will it take? LOTS AND LOTS! 250k is nothing for mysql, even on high-column-count tables ... Here's my stats i'll proudly shout about: :) On a dual p3 850, running a 23 col table, with 10 ints of various sizes, 4 floats, and 9 (var)chars ranging from 8 to 255 bytes: +-----------+ | COUNT(*) | +-----------+ | 223796453 | +-----------+ # df -h /dev/rd/c0d0p2 34G 33G 1.1G 97% /arse [1] # mysqladmin status Uptime: 2206247 Threads: 8 Questions: 80460219 Slow queries: 36995 Opens: 192 Flush tables: 1 Open tables: 185 Queries per second avg: 36.469 # uptime Unknown HZ value! (47) Assume 100. [2] 01:30:57 up 472 days, 9:15, 1 user, load average: 1.45, 1.43, 1.46 Only problem i had was memory requrments. After about 100 million records, it whined until i fed it another 2gb ram, but it's since chuntered along again nicly (on 4gb). i'm upgrading the hardware and having to make the application more scalable, as i expect there will be another 15 million rows a month at the current rate of growth (here's me wishing i'd RRD'ed the # records since the inception), possibly more. I've not yet braved it up to move to 4.0.x yet, so these stats are all based on 3.23.x. ~ Theo [1] - Associatednetworks Redundant Storage Erray ... honest ;) [2] does anyone know what causes this, i've not had time to look into it? - -- Theo Zourzouvillys <theo@xxxxxxxxxxxxxxxx> <http://theo.me.uk/> -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.2 (GNU/Linux) iD8DBQE/c46S448CrwpTn6YRAlgKAKCsC6evuUMzGfJ/28IuQA6LvVp3ugCfYQvN FBxg0UgDuXNt4W9UlGQUUBM= =mqT7 -----END PGP SIGNATURE----- -- The Mailing List for the Devon & Cornwall LUG Mail majordomo@xxxxxxxxxxxx with "unsubscribe list" in the message body to unsubscribe.