| Bug #26442 | Adaptive Hash Index's CPU scalability is low. | ||
|---|---|---|---|
| Submitted: | 16 Feb 2007 6:57 | Modified: | 12 Aug 2009 17:18 |
| Reporter: | Yasufumi Kinoshita | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Server: InnoDB storage engine | Severity: | S4 (Feature request) |
| Version: | 5.0.54 | OS: | Any (All) |
| Assigned to: | Inaam Rana | CPU Architecture: | Any |
| Tags: | Contribution | ||
If the data you need to attach is more than 50MB, you should create a compressed archive of the data, split it to 50MB chunks, and upload each of them as a separate attachment.
To split a large file:
- On *nix platforms use the split command e.g.
split -b 50MB <my_large_archive> <my_split_archive_prefix> - On windows use WinZip or a similar utility to split the large file
[16 Feb 2007 7:03]
Yasufumi Kinoshita
[16 Feb 2007 7:04]
Yasufumi Kinoshita
Experimental patch
Attachment: mysql-5.0.30_yasufumi_20070209.patch.gz (application/x-gzip, text), 17.63 KiB.
[16 Feb 2007 9:02]
Yasufumi Kinoshita
Another benchmark example of the "low" utilization ratio of Adaptive Hash.
Attachment: TPC-C_20070209.png (image/png, text), 8.06 KiB.
[6 Apr 2007 1:25]
Yasufumi Kinoshita
Experimental patch (for also x86_64)
Attachment: mysql-5.0.30_yasufumi_20070405_x86_64.patch.gz (application/x-gzip, text), 17.50 KiB.
[29 May 2007 12:15]
Yasufumi Kinoshita
Patches for 5.0.41
Attachment: mysql-5.0.41_scale_patches.tar.gz (application/x-gzip, text), 15.42 KiB.
[4 Jun 2007 11:34]
Yasufumi Kinoshita
Results (Xeon E5310 x2 : openSUSE 10.2 (kernel-2.6.18))
Attachment: scale_patch_combination_test_5.0.41.pdf (application/pdf, text), 27.35 KiB.
[8 Jun 2007 11:38]
Yasufumi Kinoshita
fixed patch (page hash mutex)
Attachment: mysql-5.0.41_page_hash_cell_mutex_fixed.patch.gz (application/x-gzip, text), 3.20 KiB.
[22 Jun 2007 10:54]
Yasufumi Kinoshita
much more stable rwlock patch
Attachment: mysql-5.0.41_optimize_rwlock_stable.patch.gz (application/x-gzip, text), 7.10 KiB.
[13 Aug 2007 9:52]
Yasufumi Kinoshita
fixed a little
Attachment: mysql-5.0.41_optimize_rwlock_stable2.patch.gz (application/octet-stream, text), 7.08 KiB.
[3 Oct 2007 1:47]
Yasufumi Kinoshita
The effects of Bug#29560 fix.
Attachment: os_event_fix_effects.pdf (application/pdf, text), 30.75 KiB.
[26 Jan 2008 16:02]
Yasufumi Kinoshita
The new patch improves rw_lock without assembly (with Atomic Builtin of GCC,ICC)
Attachment: mysql-5.0.54_optimize_rwlock_atomic_builtin.patch (text/x-patch), 36.53 KiB.
[28 Jan 2008 7:54]
Yasufumi Kinoshita
Performance results
Attachment: extreme_workload_results.pdf (application/pdf, text), 20.86 KiB.
