| Bug #39253 | Large query cache still freezes server after fix for bug #21074 | ||
|---|---|---|---|
| Submitted: | 4 Sep 2008 18:47 | Modified: | 12 Mar 2010 17:49 |
| Reporter: | Sveta Smirnova | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Server: Query Cache | Severity: | S2 (Serious) |
| Version: | 5.1 bzr | OS: | Any |
| Assigned to: | Kristofer Pettersson | CPU Architecture: | Any |
| Tags: | performance | ||
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
[28 Apr 2009 10:24]
Kristofer Pettersson
[28 Apr 2009 10:25]
Kristofer Pettersson
SELECT intensity
Attachment: SELECT-intensity-qcache.png (image/png, text), 27.31 KiB.
[7 Jul 2009 6:05]
Sveta Smirnova
tests used
Attachment: sources.tar (application/x-tar, text), 70.00 KiB.
[7 Jul 2009 6:51]
Sveta Smirnova
test result with 50mb query cache
Attachment: out_witqc2g.tar.gz (application/x-gzip, text), 161.76 KiB.
[7 Jul 2009 7:47]
Kristofer Pettersson
Locked select threads
Attachment: bild.png (image/png, text), 21.04 KiB.
[7 Jul 2009 7:49]
Kristofer Pettersson
Non-linear invalidation graph
Attachment: bild(2).png (image/png, text), 13.28 KiB.
[7 Jul 2009 8:26]
Kristofer Pettersson
Query cache free memory graph with spikes
Attachment: bild(3).png (image/png, text), 15.39 KiB.
[7 Jul 2009 8:48]
Kristofer Pettersson
select intesity in corralation to free cache memory
Attachment: bild(5).png (image/png, text), 30.64 KiB.
[14 Jul 2009 16:26]
Sveta Smirnova
results for 1G qc with 5.1-bugteam
Attachment: 20090714_log_1GB.txt (text/plain), 288.21 KiB.
[14 Jul 2009 16:26]
Sveta Smirnova
results for 500MB qc with 5.1-bugteam
Attachment: 20090714_log_500MB.txt (text/plain), 287.99 KiB.
[15 Jul 2009 7:39]
Sveta Smirnova
chart with inserts and qc=500 MB
Attachment: inserts_500MB.png (image/png, text), 14.25 KiB.
[15 Jul 2009 7:40]
Sveta Smirnova
chart with updates and qc=500 MB
Attachment: updates_500MB.png (image/png, text), 14.74 KiB.
[15 Jul 2009 7:41]
Sveta Smirnova
chart with inserts and qc=1 GB
Attachment: inserts_1GB.png (image/png, text), 14.22 KiB.
[15 Jul 2009 7:42]
Sveta Smirnova
chart with updates and qc=1 GB
Attachment: updates_1GB.png (image/png, text), 14.25 KiB.
[15 Jul 2009 7:55]
Sveta Smirnova
chart with updates and qc=500 MB - better format
Attachment: updates_500MB.png (image/png, text), 19.98 KiB.
[15 Jul 2009 7:56]
Sveta Smirnova
chart with updates and qc=1 GB - better format
Attachment: updates_1GB.png (image/png, text), 19.72 KiB.
[15 Jul 2009 7:59]
Sveta Smirnova
chart with inserts and qc=500 MB - better format
Attachment: inserts_500MB.png (image/png, text), 20.32 KiB.
[15 Jul 2009 8:00]
Sveta Smirnova
chart with inserts and qc=1 GB - better format
Attachment: inserts_1GB.png (image/png, text), 19.65 KiB.
[29 Jul 2009 21:46]
Sveta Smirnova
opcontrol output for 500MB query cache
Attachment: 20090729_opgrof_500MB.out.txt (text/plain), 153.42 KiB.
[29 Jul 2009 21:46]
Sveta Smirnova
opcontrol output for 1G query cache (+500MB I think)
Attachment: 20090729_opgrof_1G.out.txt (text/plain), 157.95 KiB.
[29 Jul 2009 22:00]
Sveta Smirnova
results
Attachment: 20090729.results.tar.gz (application/x-gzip, text), 175.80 KiB.
[29 Jul 2009 22:01]
Sveta Smirnova
chart with inserts and qc=1 GB
Attachment: 20090729_1G.inserts.png (image/png, text), 19.75 KiB.
[29 Jul 2009 22:02]
Sveta Smirnova
chart with updates and qc=1 GB
Attachment: 20090729_1G.updates.png (image/png, text), 20.49 KiB.
[29 Jul 2009 22:02]
Sveta Smirnova
chart with inserts and qc=500 MB
Attachment: 20090729_500MB.inserts.png (image/png, text), 20.01 KiB.
[29 Jul 2009 22:03]
Sveta Smirnova
chart with updates and qc=500 MB
Attachment: 20090729_500MB.updates.png (image/png, text), 20.06 KiB.
[14 Aug 2009 15:28]
Kristofer Pettersson
google-perftool-on-hash-test
Attachment: my_hash_delete-profile-release-build.pdf (application/pdf, text), 22.79 KiB.
