Units
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/phpmyadmin/5-1/fi/units/?format=api&page=4
{ "count": 3385, "next": "https://hosted.weblate.org/api/translations/phpmyadmin/5-1/fi/units/?format=api&page=5", "previous": "https://hosted.weblate.org/api/translations/phpmyadmin/5-1/fi/units/?format=api&page=3", "results": [ { "translation": "https://hosted.weblate.org/api/translations/phpmyadmin/5-1/fi/?format=api", "source": [ "You do not have InnoDB enabled." ], "previous_source": "Cannot load or save configuration", "target": [ "Asetuksia ei voi ladata tai tallentaa" ], "id_hash": -7792045669304116983, "content_hash": -7792045669304116983, "location": "libraries/advisory_rules_generic.php:608", "context": "", "note": "", "flags": "", "labels": [], "state": 10, "fuzzy": true, "translated": false, "approved": false, "position": 151, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 6, "source_unit": "https://hosted.weblate.org/api/units/25066668/?format=api", "priority": 100, "id": 25158656, "web_url": "https://hosted.weblate.org/translate/phpmyadmin/5-1/fi/?checksum=13dd17bf6f81d909", "url": "https://hosted.weblate.org/api/units/25158656/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2020-12-19T00:31:52.424048+01:00", "last_updated": "2023-05-23T12:28:47.723593+02:00" }, { "translation": "https://hosted.weblate.org/api/translations/phpmyadmin/5-1/fi/?format=api", "source": [ "InnoDB is usually the better choice for table engines." ], "previous_source": "", "target": [ "" ], "id_hash": 2985798428342346939, "content_hash": 2985798428342346939, "location": "libraries/advisory_rules_generic.php:609", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 152, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://hosted.weblate.org/api/units/25066669/?format=api", "priority": 100, "id": 25158657, "web_url": "https://hosted.weblate.org/translate/phpmyadmin/5-1/fi/?checksum=a96fafd9e443e4bb", "url": "https://hosted.weblate.org/api/units/25158657/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2020-12-19T00:31:52.505592+01:00", "last_updated": "2023-05-23T12:28:47.723593+02:00" }, { "translation": "https://hosted.weblate.org/api/translations/phpmyadmin/5-1/fi/?format=api", "source": [ "have_innodb is set to 'value'" ], "previous_source": "", "target": [ "" ], "id_hash": -1751721549222413510, "content_hash": -1751721549222413510, "location": "libraries/advisory_rules_generic.php:610", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 153, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://hosted.weblate.org/api/units/25066670/?format=api", "priority": 100, "id": 25158658, "web_url": "https://hosted.weblate.org/translate/phpmyadmin/5-1/fi/?checksum=67b0a28831337b3a", "url": "https://hosted.weblate.org/api/units/25158658/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2020-12-19T00:31:52.582572+01:00", "last_updated": "2023-05-23T12:28:47.723593+02:00" }, { "translation": "https://hosted.weblate.org/api/translations/phpmyadmin/5-1/fi/?format=api", "source": [ "InnoDB log size" ], "previous_source": "Buffer pool size", "target": [ "Puskurivarannon koko" ], "id_hash": 4265045571470438559, "content_hash": 4265045571470438559, "location": "libraries/advisory_rules_generic.php:614, libraries/advisory_rules_generic.php:640", "context": "", "note": "", "flags": "", "labels": [], "state": 10, "fuzzy": true, "translated": false, "approved": false, "position": 154, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://hosted.weblate.org/api/units/25066671/?format=api", "priority": 100, "id": 25158659, "web_url": "https://hosted.weblate.org/translate/phpmyadmin/5-1/fi/?checksum=bb307c599e59309f", "url": "https://hosted.weblate.org/api/units/25158659/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2020-12-19T00:31:52.662217+01:00", "last_updated": "2023-05-23T12:28:47.723593+02:00" }, { "translation": "https://hosted.weblate.org/api/translations/phpmyadmin/5-1/fi/?format=api", "source": [ "The InnoDB log file size is not an appropriate size, in relation to the InnoDB buffer pool." ], "previous_source": "The number writes done to the InnoDB buffer pool.", "target": [ "InnoDB:n puskurivarannon kirjoituspyyntöjen määrä." ], "id_hash": 5947034177423711337, "content_hash": 5947034177423711337, "location": "libraries/advisory_rules_generic.php:619, libraries/advisory_rules_generic.php:648", "context": "", "note": "", "flags": "", "labels": [], "state": 10, "fuzzy": true, "translated": false, "approved": false, "position": 155, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 17, "source_unit": "https://hosted.weblate.org/api/units/25066672/?format=api", "priority": 100, "id": 25158660, "web_url": "https://hosted.weblate.org/translate/phpmyadmin/5-1/fi/?checksum=d2881c135c729c69", "url": "https://hosted.weblate.org/api/units/25158660/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2020-12-19T00:31:52.731425+01:00", "last_updated": "2023-05-23T12:28:47.723593+02:00" }, { "translation": "https://hosted.weblate.org/api/translations/phpmyadmin/5-1/fi/?format=api", "source": [ "Especially on a system with a lot of writes to InnoDB tables you should set {innodb_log_file_size} to 25% of {innodb_buffer_pool_size}. However the bigger this value, the longer the recovery time will be when database crashes, so this value should not be set much higher than 256 MiB. Please note however that you cannot simply change the value of this variable. You need to shutdown the server, remove the InnoDB log files, set the new value in my.cnf, start the server, then check the error logs if everything went fine. See also <a href=\"https://mysqldatabaseadministration.blogspot.com/2007/01/increase-innodblogfilesize-proper-way.html\">this blog entry</a>" ], "previous_source": "", "target": [ "" ], "id_hash": -7446755646582377938, "content_hash": -7446755646582377938, "location": "libraries/advisory_rules_generic.php:622, libraries/advisory_rules_generic.php:651", "context": "", "note": "", "flags": "no-php-format", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 156, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 95, "source_unit": "https://hosted.weblate.org/api/units/25066673/?format=api", "priority": 100, "id": 25158661, "web_url": "https://hosted.weblate.org/translate/phpmyadmin/5-1/fi/?checksum=18a7cf31ac52b22e", "url": "https://hosted.weblate.org/api/units/25158661/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2020-12-19T00:31:52.797610+01:00", "last_updated": "2023-05-23T12:28:47.723593+02:00" }, { "translation": "https://hosted.weblate.org/api/translations/phpmyadmin/5-1/fi/?format=api", "source": [ "Your InnoDB log size is at %s%% in relation to the InnoDB buffer pool size, it should not be below 20%%" ], "previous_source": "The number writes done to the InnoDB buffer pool.", "target": [ "InnoDB:n puskurivarannon kirjoituspyyntöjen määrä." ], "id_hash": 8321261154008284309, "content_hash": 8321261154008284309, "location": "libraries/advisory_rules_generic.php:633, libraries/advisory_rules_generic.php:662", "context": "", "note": "", "flags": "php-format", "labels": [], "state": 10, "fuzzy": true, "translated": false, "approved": false, "position": 157, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 21, "source_unit": "https://hosted.weblate.org/api/units/25066674/?format=api", "priority": 100, "id": 25158662, "web_url": "https://hosted.weblate.org/translate/phpmyadmin/5-1/fi/?checksum=f37b0eee7febbc95", "url": "https://hosted.weblate.org/api/units/25158662/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2020-12-19T00:31:52.874783+01:00", "last_updated": "2023-05-23T12:28:47.723593+02:00" }, { "translation": "https://hosted.weblate.org/api/translations/phpmyadmin/5-1/fi/?format=api", "source": [ "Max InnoDB log size" ], "previous_source": "Buffer pool size", "target": [ "Puskurivarannon koko" ], "id_hash": 3327805708159914918, "content_hash": 3327805708159914918, "location": "libraries/advisory_rules_generic.php:669", "context": "", "note": "", "flags": "", "labels": [], "state": 10, "fuzzy": true, "translated": false, "approved": false, "position": 158, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://hosted.weblate.org/api/units/25066675/?format=api", "priority": 100, "id": 25158663, "web_url": "https://hosted.weblate.org/translate/phpmyadmin/5-1/fi/?checksum=ae2ebda8fc6393a6", "url": "https://hosted.weblate.org/api/units/25158663/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2020-12-19T00:31:52.949821+01:00", "last_updated": "2023-05-23T12:28:47.723593+02:00" }, { "translation": "https://hosted.weblate.org/api/translations/phpmyadmin/5-1/fi/?format=api", "source": [ "The InnoDB log file size is inadequately large." ], "previous_source": "", "target": [ "" ], "id_hash": -656915490823033930, "content_hash": -656915490823033930, "location": "libraries/advisory_rules_generic.php:673", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 159, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://hosted.weblate.org/api/units/25066676/?format=api", "priority": 100, "id": 25158664, "web_url": "https://hosted.weblate.org/translate/phpmyadmin/5-1/fi/?checksum=76e22ad7720aabb6", "url": "https://hosted.weblate.org/api/units/25158664/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2020-12-19T00:31:53.025460+01:00", "last_updated": "2023-05-23T12:28:47.723593+02:00" }, { "translation": "https://hosted.weblate.org/api/translations/phpmyadmin/5-1/fi/?format=api", "source": [ "It is usually sufficient to set {innodb_log_file_size} to 25% of the size of {innodb_buffer_pool_size}. A very big {innodb_log_file_size} slows down the recovery time after a database crash considerably. See also <a href=\"https://www.percona.com/blog/2006/07/03/choosing-proper-innodb_log_file_size/\">this Article</a>. You need to shutdown the server, remove the InnoDB log files, set the new value in my.cnf, start the server, then check the error logs if everything went fine. See also <a href=\"https://mysqldatabaseadministration.blogspot.com/2007/01/increase-innodblogfilesize-proper-way.html\">this blog entry</a>" ], "previous_source": "", "target": [ "" ], "id_hash": 1622387663284191854, "content_hash": 1622387663284191854, "location": "libraries/advisory_rules_generic.php:675", "context": "", "note": "", "flags": "no-php-format", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 160, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 68, "source_unit": "https://hosted.weblate.org/api/units/25066677/?format=api", "priority": 100, "id": 25158665, "web_url": "https://hosted.weblate.org/translate/phpmyadmin/5-1/fi/?checksum=9683e0fbe607c26e", "url": "https://hosted.weblate.org/api/units/25158665/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2020-12-19T00:31:53.099794+01:00", "last_updated": "2023-05-23T12:28:47.723593+02:00" }, { "translation": "https://hosted.weblate.org/api/translations/phpmyadmin/5-1/fi/?format=api", "source": [ "Your absolute InnoDB log size is %s MiB" ], "previous_source": "", "target": [ "" ], "id_hash": -3474786389709624210, "content_hash": -3474786389709624210, "location": "libraries/advisory_rules_generic.php:685", "context": "", "note": "", "flags": "php-format", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 161, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://hosted.weblate.org/api/units/25066678/?format=api", "priority": 100, "id": 25158666, "web_url": "https://hosted.weblate.org/translate/phpmyadmin/5-1/fi/?checksum=4fc7143052feec6e", "url": "https://hosted.weblate.org/api/units/25158666/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2020-12-19T00:31:53.161189+01:00", "last_updated": "2023-05-23T12:28:47.723593+02:00" }, { "translation": "https://hosted.weblate.org/api/translations/phpmyadmin/5-1/fi/?format=api", "source": [ "InnoDB buffer pool size" ], "previous_source": "Buffer pool size", "target": [ "InnoDB-puskurivarannon koko" ], "id_hash": 5607716124151153934, "content_hash": 5607716124151153934, "location": "libraries/advisory_rules_generic.php:690", "context": "", "note": "", "flags": "", "labels": [], "state": 10, "fuzzy": true, "translated": false, "approved": false, "position": 162, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://hosted.weblate.org/api/units/25066679/?format=api", "priority": 100, "id": 25158667, "web_url": "https://hosted.weblate.org/translate/phpmyadmin/5-1/fi/?checksum=cdd29c1a9d42850e", "url": "https://hosted.weblate.org/api/units/25158667/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2020-12-19T00:31:53.243579+01:00", "last_updated": "2023-05-23T12:28:47.723593+02:00" }, { "translation": "https://hosted.weblate.org/api/translations/phpmyadmin/5-1/fi/?format=api", "source": [ "Your InnoDB buffer pool is fairly small." ], "previous_source": "Buffer pool size", "target": [ "Puskurivarannon koko" ], "id_hash": -814533747192378754, "content_hash": -814533747192378754, "location": "libraries/advisory_rules_generic.php:694", "context": "", "note": "", "flags": "", "labels": [], "state": 10, "fuzzy": true, "translated": false, "approved": false, "position": 163, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 7, "source_unit": "https://hosted.weblate.org/api/units/25066680/?format=api", "priority": 100, "id": 25158668, "web_url": "https://hosted.weblate.org/translate/phpmyadmin/5-1/fi/?checksum=74b231df5d07ca7e", "url": "https://hosted.weblate.org/api/units/25158668/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2020-12-19T00:31:53.320943+01:00", "last_updated": "2023-05-23T12:28:47.723593+02:00" }, { "translation": "https://hosted.weblate.org/api/translations/phpmyadmin/5-1/fi/?format=api", "source": [ "The InnoDB buffer pool has a profound impact on performance for InnoDB tables. Assign all your remaining memory to this buffer. For database servers that use solely InnoDB as storage engine and have no other services (e.g. a web server) running, you may set this as high as 80% of your available memory. If that is not the case, you need to carefully assess the memory consumption of your other services and non-InnoDB-Tables and set this variable accordingly. If it is set too high, your system will start swapping, which decreases performance significantly. See also <a href=\"https://www.percona.com/blog/2007/11/03/choosing-innodb_buffer_pool_size/\">this article</a>" ], "previous_source": "", "target": [ "" ], "id_hash": -4931413361302587528, "content_hash": -4931413361302587528, "location": "libraries/advisory_rules_generic.php:696", "context": "", "note": "", "flags": "no-php-format", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 164, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 98, "source_unit": "https://hosted.weblate.org/api/units/25066681/?format=api", "priority": 100, "id": 25158669, "web_url": "https://hosted.weblate.org/translate/phpmyadmin/5-1/fi/?checksum=3b9019acf6f1b778", "url": "https://hosted.weblate.org/api/units/25158669/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2020-12-19T00:31:53.405138+01:00", "last_updated": "2023-05-23T12:28:47.723593+02:00" }, { "translation": "https://hosted.weblate.org/api/translations/phpmyadmin/5-1/fi/?format=api", "source": [ "You are currently using %s%% of your memory for the InnoDB buffer pool. This rule fires if you are assigning less than 60%%, however this might be perfectly adequate for your system if you don't have much InnoDB tables or other services running on the same machine." ], "previous_source": "", "target": [ "" ], "id_hash": -8144552089193915127, "content_hash": -8144552089193915127, "location": "libraries/advisory_rules_generic.php:706", "context": "", "note": "", "flags": "php-format", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 165, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 47, "source_unit": "https://hosted.weblate.org/api/units/25066682/?format=api", "priority": 100, "id": 25158670, "web_url": "https://hosted.weblate.org/translate/phpmyadmin/5-1/fi/?checksum=0ef8bd06ccee5d09", "url": "https://hosted.weblate.org/api/units/25158670/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2020-12-19T00:31:53.479715+01:00", "last_updated": "2023-05-23T12:28:47.723593+02:00" }, { "translation": "https://hosted.weblate.org/api/translations/phpmyadmin/5-1/fi/?format=api", "source": [ "MyISAM concurrent inserts" ], "previous_source": "max. concurrent connections", "target": [ "Enim. yhtäaikaisia yhteyksiä" ], "id_hash": -1307048903805215507, "content_hash": -1307048903805215507, "location": "libraries/advisory_rules_generic.php:716", "context": "", "note": "", "flags": "", "labels": [], "state": 10, "fuzzy": true, "translated": false, "approved": false, "position": 166, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://hosted.weblate.org/api/units/25066683/?format=api", "priority": 100, "id": 25158671, "web_url": "https://hosted.weblate.org/translate/phpmyadmin/5-1/fi/?checksum=6ddc6df270a05ced", "url": "https://hosted.weblate.org/api/units/25158671/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2020-12-19T00:31:53.549536+01:00", "last_updated": "2023-05-23T12:28:47.723593+02:00" }, { "translation": "https://hosted.weblate.org/api/translations/phpmyadmin/5-1/fi/?format=api", "source": [ "Enable {concurrent_insert} by setting it to 1" ], "previous_source": "max. concurrent connections", "target": [ "Enim. yhtäaikaisia yhteyksiä" ], "id_hash": -1813167217436238577, "content_hash": -1813167217436238577, "location": "libraries/advisory_rules_generic.php:719", "context": "", "note": "", "flags": "", "labels": [], "state": 10, "fuzzy": true, "translated": false, "approved": false, "position": 167, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://hosted.weblate.org/api/units/25066684/?format=api", "priority": 100, "id": 25158672, "web_url": "https://hosted.weblate.org/translate/phpmyadmin/5-1/fi/?checksum=66d65605b6545d0f", "url": "https://hosted.weblate.org/api/units/25158672/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2020-12-19T00:31:53.623533+01:00", "last_updated": "2023-05-23T12:28:47.723593+02:00" }, { "translation": "https://hosted.weblate.org/api/translations/phpmyadmin/5-1/fi/?format=api", "source": [ "Setting {concurrent_insert} to 1 reduces contention between readers and writers for a given table. See also <a href=\"https://dev.mysql.com/doc/refman/5.5/en/concurrent-inserts.html\">MySQL Documentation</a>" ], "previous_source": "", "target": [ "" ], "id_hash": -6582711230832838417, "content_hash": -6582711230832838417, "location": "libraries/advisory_rules_generic.php:721", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 168, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://hosted.weblate.org/api/units/25066685/?format=api", "priority": 100, "id": 25158673, "web_url": "https://hosted.weblate.org/translate/phpmyadmin/5-1/fi/?checksum=24a58303233bf8ef", "url": "https://hosted.weblate.org/api/units/25158673/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2020-12-19T00:31:53.678960+01:00", "last_updated": "2023-05-23T12:28:47.723593+02:00" }, { "translation": "https://hosted.weblate.org/api/translations/phpmyadmin/5-1/fi/?format=api", "source": [ "concurrent_insert is set to 0" ], "previous_source": "", "target": [ "concurrent_insert on asetettu arvoon 0" ], "id_hash": -9039457302435132513, "content_hash": -9039457302435132513, "location": "libraries/advisory_rules_generic.php:725", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 169, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://hosted.weblate.org/api/units/25066686/?format=api", "priority": 100, "id": 25158674, "web_url": "https://hosted.weblate.org/translate/phpmyadmin/5-1/fi/?checksum=028d6579fe0b0b9f", "url": "https://hosted.weblate.org/api/units/25158674/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2020-12-19T00:31:53.730825+01:00", "last_updated": "2023-05-23T12:28:47.723593+02:00" }, { "translation": "https://hosted.weblate.org/api/translations/phpmyadmin/5-1/fi/?format=api", "source": [ "Query cache disabled" ], "previous_source": "Query cache", "target": [ "Kyselyvälimuisti" ], "id_hash": 780780921188910632, "content_hash": 780780921188910632, "location": "libraries/advisory_rules_mysql_before80003.php:9", "context": "", "note": "", "flags": "", "labels": [], "state": 10, "fuzzy": true, "translated": false, "approved": false, "position": 170, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://hosted.weblate.org/api/units/25066687/?format=api", "priority": 100, "id": 25158675, "web_url": "https://hosted.weblate.org/translate/phpmyadmin/5-1/fi/?checksum=8ad5e41c6ede0628", "url": "https://hosted.weblate.org/api/units/25158675/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2020-12-19T00:31:53.785097+01:00", "last_updated": "2023-05-23T12:28:47.723593+02:00" }, { "translation": "https://hosted.weblate.org/api/translations/phpmyadmin/5-1/fi/?format=api", "source": [ "The query cache is not enabled." ], "previous_source": "The server is not responding", "target": [ "Palvelin ei vastaa" ], "id_hash": -6998980727850103528, "content_hash": -6998980727850103528, "location": "libraries/advisory_rules_mysql_before80003.php:12", "context": "", "note": "", "flags": "", "labels": [], "state": 10, "fuzzy": true, "translated": false, "approved": false, "position": 171, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 6, "source_unit": "https://hosted.weblate.org/api/units/25066688/?format=api", "priority": 100, "id": 25158676, "web_url": "https://hosted.weblate.org/translate/phpmyadmin/5-1/fi/?checksum=1edea01c36b08d18", "url": "https://hosted.weblate.org/api/units/25158676/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2020-12-19T00:31:53.863734+01:00", "last_updated": "2023-05-23T12:28:47.723593+02:00" }, { "translation": "https://hosted.weblate.org/api/translations/phpmyadmin/5-1/fi/?format=api", "source": [ "The query cache is known to greatly improve performance if configured correctly. Enable it by setting {query_cache_size} to a 2 digit MiB value and setting {query_cache_type} to 'ON'. <b>Note:</b> If you are using memcached, ignore this recommendation." ], "previous_source": "", "target": [ "" ], "id_hash": 4743974800061591649, "content_hash": 4743974800061591649, "location": "libraries/advisory_rules_mysql_before80003.php:14", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 172, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 37, "source_unit": "https://hosted.weblate.org/api/units/25066689/?format=api", "priority": 100, "id": 25158677, "web_url": "https://hosted.weblate.org/translate/phpmyadmin/5-1/fi/?checksum=c1d5fbf22d137061", "url": "https://hosted.weblate.org/api/units/25158677/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2020-12-19T00:31:53.939343+01:00", "last_updated": "2023-05-23T12:28:47.723593+02:00" }, { "translation": "https://hosted.weblate.org/api/translations/phpmyadmin/5-1/fi/?format=api", "source": [ "query_cache_size is set to 0 or query_cache_type is set to 'OFF'" ], "previous_source": "", "target": [ "" ], "id_hash": -6015604335550750142, "content_hash": -6015604335550750142, "location": "libraries/advisory_rules_mysql_before80003.php:18", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 173, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://hosted.weblate.org/api/units/25066690/?format=api", "priority": 100, "id": 25158678, "web_url": "https://hosted.weblate.org/translate/phpmyadmin/5-1/fi/?checksum=2c8447ba9632a242", "url": "https://hosted.weblate.org/api/units/25158678/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2020-12-19T00:31:54.015111+01:00", "last_updated": "2023-05-23T12:28:47.723593+02:00" }, { "translation": "https://hosted.weblate.org/api/translations/phpmyadmin/5-1/fi/?format=api", "source": [ "Query cache efficiency (%)" ], "previous_source": "Query cache", "target": [ "Kyselyvälimuisti" ], "id_hash": -121717304183924752, "content_hash": -121717304183924752, "location": "libraries/advisory_rules_mysql_before80003.php:23", "context": "", "note": "", "flags": "no-php-format", "labels": [], "state": 10, "fuzzy": true, "translated": false, "approved": false, "position": 174, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://hosted.weblate.org/api/units/25066691/?format=api", "priority": 100, "id": 25158679, "web_url": "https://hosted.weblate.org/translate/phpmyadmin/5-1/fi/?checksum=7e4f92c1b91957f0", "url": "https://hosted.weblate.org/api/units/25158679/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2020-12-19T00:31:54.097141+01:00", "last_updated": "2023-05-23T12:28:47.723593+02:00" }, { "translation": "https://hosted.weblate.org/api/translations/phpmyadmin/5-1/fi/?format=api", "source": [ "Query cache not running efficiently, it has a low hit rate." ], "previous_source": "", "target": [ "" ], "id_hash": -8879575726243049618, "content_hash": -8879575726243049618, "location": "libraries/advisory_rules_mysql_before80003.php:27", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 175, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://hosted.weblate.org/api/units/25066692/?format=api", "priority": 100, "id": 25158680, "web_url": "https://hosted.weblate.org/translate/phpmyadmin/5-1/fi/?checksum=04c568ec491a0f6e", "url": "https://hosted.weblate.org/api/units/25158680/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2020-12-19T00:31:54.157106+01:00", "last_updated": "2023-05-23T12:28:47.723593+02:00" }, { "translation": "https://hosted.weblate.org/api/translations/phpmyadmin/5-1/fi/?format=api", "source": [ "Consider increasing {query_cache_limit}." ], "previous_source": "", "target": [ "" ], "id_hash": 4582812680569656883, "content_hash": 4582812680569656883, "location": "libraries/advisory_rules_mysql_before80003.php:28", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 176, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://hosted.weblate.org/api/units/25066693/?format=api", "priority": 100, "id": 25158681, "web_url": "https://hosted.weblate.org/translate/phpmyadmin/5-1/fi/?checksum=bf996bda29829633", "url": "https://hosted.weblate.org/api/units/25158681/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2020-12-19T00:31:54.233730+01:00", "last_updated": "2023-05-23T12:28:47.723593+02:00" }, { "translation": "https://hosted.weblate.org/api/translations/phpmyadmin/5-1/fi/?format=api", "source": [ "The current query cache hit rate of %s%% is below 20%%" ], "previous_source": "Sort buffer size", "target": [ "Lajittelupuskurin koko" ], "id_hash": 5254115885047098944, "content_hash": 5254115885047098944, "location": "libraries/advisory_rules_mysql_before80003.php:29", "context": "", "note": "", "flags": "php-format", "labels": [], "state": 10, "fuzzy": true, "translated": false, "approved": false, "position": 177, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 11, "source_unit": "https://hosted.weblate.org/api/units/25066694/?format=api", "priority": 100, "id": 25158682, "web_url": "https://hosted.weblate.org/translate/phpmyadmin/5-1/fi/?checksum=c8ea5e8f58f82e40", "url": "https://hosted.weblate.org/api/units/25158682/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2020-12-19T00:31:54.305390+01:00", "last_updated": "2023-05-23T12:28:47.723593+02:00" }, { "translation": "https://hosted.weblate.org/api/translations/phpmyadmin/5-1/fi/?format=api", "source": [ "Query Cache usage" ], "previous_source": "", "target": [ "Kyselyvälimuisti" ], "id_hash": -4297993275094140597, "content_hash": -4297993275094140597, "location": "libraries/advisory_rules_mysql_before80003.php:34", "context": "", "note": "", "flags": "", "labels": [], "state": 10, "fuzzy": true, "translated": false, "approved": false, "position": 178, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://hosted.weblate.org/api/units/25066695/?format=api", "priority": 100, "id": 25158683, "web_url": "https://hosted.weblate.org/translate/phpmyadmin/5-1/fi/?checksum=445a75e356fef94b", "url": "https://hosted.weblate.org/api/units/25158683/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2020-12-19T00:31:54.382931+01:00", "last_updated": "2023-05-23T12:28:47.723593+02:00" }, { "translation": "https://hosted.weblate.org/api/translations/phpmyadmin/5-1/fi/?format=api", "source": [ "Less than 80% of the query cache is being utilized." ], "previous_source": "", "target": [ "" ], "id_hash": -2789124072789726511, "content_hash": -2789124072789726511, "location": "libraries/advisory_rules_mysql_before80003.php:39", "context": "", "note": "", "flags": "no-php-format", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 179, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://hosted.weblate.org/api/units/25066696/?format=api", "priority": 100, "id": 25158684, "web_url": "https://hosted.weblate.org/translate/phpmyadmin/5-1/fi/?checksum=594b0a6ee6e0aad1", "url": "https://hosted.weblate.org/api/units/25158684/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2020-12-19T00:31:54.464526+01:00", "last_updated": "2023-05-23T12:28:47.723593+02:00" }, { "translation": "https://hosted.weblate.org/api/translations/phpmyadmin/5-1/fi/?format=api", "source": [ "This might be caused by {query_cache_limit} being too low. Flushing the query cache might help as well." ], "previous_source": "", "target": [ "" ], "id_hash": -825004783099880216, "content_hash": -825004783099880216, "location": "libraries/advisory_rules_mysql_before80003.php:41", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 180, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 17, "source_unit": "https://hosted.weblate.org/api/units/25066697/?format=api", "priority": 100, "id": 25158685, "web_url": "https://hosted.weblate.org/translate/phpmyadmin/5-1/fi/?checksum=748cfe8555555ce8", "url": "https://hosted.weblate.org/api/units/25158685/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2020-12-19T00:31:54.531619+01:00", "last_updated": "2023-05-23T12:28:47.723593+02:00" }, { "translation": "https://hosted.weblate.org/api/translations/phpmyadmin/5-1/fi/?format=api", "source": [ "The current ratio of free query cache memory to total query cache size is %s%%. It should be above 80%%" ], "previous_source": "", "target": [ "" ], "id_hash": -9210250421704062961, "content_hash": -9210250421704062961, "location": "libraries/advisory_rules_mysql_before80003.php:45", "context": "", "note": "", "flags": "php-format", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 181, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 20, "source_unit": "https://hosted.weblate.org/api/units/25066698/?format=api", "priority": 100, "id": 25158686, "web_url": "https://hosted.weblate.org/translate/phpmyadmin/5-1/fi/?checksum=002e9e0a19f0080f", "url": "https://hosted.weblate.org/api/units/25158686/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2020-12-19T00:31:54.596423+01:00", "last_updated": "2023-05-23T12:28:47.723593+02:00" }, { "translation": "https://hosted.weblate.org/api/translations/phpmyadmin/5-1/fi/?format=api", "source": [ "Query cache fragmentation" ], "previous_source": "Query cache", "target": [ "Kyselyvälimuisti" ], "id_hash": 7556711897767158730, "content_hash": 7556711897767158730, "location": "libraries/advisory_rules_mysql_before80003.php:52", "context": "", "note": "", "flags": "", "labels": [], "state": 10, "fuzzy": true, "translated": false, "approved": false, "position": 182, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://hosted.weblate.org/api/units/25066699/?format=api", "priority": 100, "id": 25158687, "web_url": "https://hosted.weblate.org/translate/phpmyadmin/5-1/fi/?checksum=e8ded56f106123ca", "url": "https://hosted.weblate.org/api/units/25158687/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2020-12-19T00:31:54.659138+01:00", "last_updated": "2023-05-23T12:28:47.723593+02:00" }, { "translation": "https://hosted.weblate.org/api/translations/phpmyadmin/5-1/fi/?format=api", "source": [ "The query cache is considerably fragmented." ], "previous_source": "The server is not responding", "target": [ "Palvelin ei vastaa" ], "id_hash": -5817382821655695672, "content_hash": -5817382821655695672, "location": "libraries/advisory_rules_mysql_before80003.php:56", "context": "", "note": "", "flags": "", "labels": [], "state": 10, "fuzzy": true, "translated": false, "approved": false, "position": 183, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 6, "source_unit": "https://hosted.weblate.org/api/units/25066700/?format=api", "priority": 100, "id": 25158688, "web_url": "https://hosted.weblate.org/translate/phpmyadmin/5-1/fi/?checksum=2f44812540c0aec8", "url": "https://hosted.weblate.org/api/units/25158688/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2020-12-19T00:31:54.734869+01:00", "last_updated": "2023-05-23T12:28:47.723593+02:00" }, { "translation": "https://hosted.weblate.org/api/translations/phpmyadmin/5-1/fi/?format=api", "source": [ "Severe fragmentation is likely to (further) increase Qcache_lowmem_prunes. This might be caused by many Query cache low memory prunes due to {query_cache_size} being too small. For a immediate but short lived fix you can flush the query cache (might lock the query cache for a long time). Carefully adjusting {query_cache_min_res_unit} to a lower value might help too, e.g. you can set it to the average size of your queries in the cache using this formula: (query_cache_size - qcache_free_memory) / qcache_queries_in_cache" ], "previous_source": "", "target": [ "" ], "id_hash": 1639363532280697608, "content_hash": 1639363532280697608, "location": "libraries/advisory_rules_mysql_before80003.php:58", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 184, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 80, "source_unit": "https://hosted.weblate.org/api/units/25066701/?format=api", "priority": 100, "id": 25158689, "web_url": "https://hosted.weblate.org/translate/phpmyadmin/5-1/fi/?checksum=96c0307267521308", "url": "https://hosted.weblate.org/api/units/25158689/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2020-12-19T00:31:54.827242+01:00", "last_updated": "2023-05-23T12:28:47.723593+02:00" }, { "translation": "https://hosted.weblate.org/api/translations/phpmyadmin/5-1/fi/?format=api", "source": [ "The cache is currently fragmented by %s%% , with 100%% fragmentation meaning that the query cache is an alternating pattern of free and used blocks. This value should be below 20%%." ], "previous_source": "", "target": [ "" ], "id_hash": -7444959872721853799, "content_hash": -7444959872721853799, "location": "libraries/advisory_rules_mysql_before80003.php:66", "context": "", "note": "", "flags": "php-format", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 185, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 31, "source_unit": "https://hosted.weblate.org/api/units/25066702/?format=api", "priority": 100, "id": 25158690, "web_url": "https://hosted.weblate.org/translate/phpmyadmin/5-1/fi/?checksum=18ae3070db606299", "url": "https://hosted.weblate.org/api/units/25158690/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2020-12-19T00:31:54.898632+01:00", "last_updated": "2023-05-23T12:28:47.723593+02:00" }, { "translation": "https://hosted.weblate.org/api/translations/phpmyadmin/5-1/fi/?format=api", "source": [ "Query cache low memory prunes" ], "previous_source": "Query cache used", "target": [ "Kyselyvälimuistia käytetty" ], "id_hash": 3973565737929948149, "content_hash": 3973565737929948149, "location": "libraries/advisory_rules_mysql_before80003.php:73", "context": "", "note": "", "flags": "", "labels": [], "state": 10, "fuzzy": true, "translated": false, "approved": false, "position": 186, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://hosted.weblate.org/api/units/25066703/?format=api", "priority": 100, "id": 25158691, "web_url": "https://hosted.weblate.org/translate/phpmyadmin/5-1/fi/?checksum=b724f0fc5cfa3bf5", "url": "https://hosted.weblate.org/api/units/25158691/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2020-12-19T00:31:54.973148+01:00", "last_updated": "2023-05-23T12:28:47.723593+02:00" }, { "translation": "https://hosted.weblate.org/api/translations/phpmyadmin/5-1/fi/?format=api", "source": [ "Cached queries are removed due to low query cache memory from the query cache." ], "previous_source": "The amount of free memory for query cache.", "target": [ "Kyselyvälimuistin vapaan muistin määrä." ], "id_hash": 8621316311984335685, "content_hash": 8621316311984335685, "location": "libraries/advisory_rules_mysql_before80003.php:77", "context": "", "note": "", "flags": "", "labels": [], "state": 10, "fuzzy": true, "translated": false, "approved": false, "position": 187, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://hosted.weblate.org/api/units/25066704/?format=api", "priority": 100, "id": 25158692, "web_url": "https://hosted.weblate.org/translate/phpmyadmin/5-1/fi/?checksum=f7a51182101b6b45", "url": "https://hosted.weblate.org/api/units/25158692/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2020-12-19T00:31:55.037515+01:00", "last_updated": "2023-05-23T12:28:47.723593+02:00" }, { "translation": "https://hosted.weblate.org/api/translations/phpmyadmin/5-1/fi/?format=api", "source": [ "You might want to increase {query_cache_size}, however keep in mind that the overhead of maintaining the cache is likely to increase with its size, so do this in small increments and monitor the results." ], "previous_source": "", "target": [ "" ], "id_hash": 5551576867638159110, "content_hash": 5551576867638159110, "location": "libraries/advisory_rules_mysql_before80003.php:79", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 188, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 34, "source_unit": "https://hosted.weblate.org/api/units/25066705/?format=api", "priority": 100, "id": 25158693, "web_url": "https://hosted.weblate.org/translate/phpmyadmin/5-1/fi/?checksum=cd0b29bf62d92706", "url": "https://hosted.weblate.org/api/units/25158693/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2020-12-19T00:31:55.114163+01:00", "last_updated": "2023-05-23T12:28:47.723593+02:00" }, { "translation": "https://hosted.weblate.org/api/translations/phpmyadmin/5-1/fi/?format=api", "source": [ "The ratio of removed queries to inserted queries is %s%%. The lower this value is, the better (This rules firing limit: 0.1%%)" ], "previous_source": "", "target": [ "" ], "id_hash": 9141023327280151722, "content_hash": 9141023327280151722, "location": "libraries/advisory_rules_mysql_before80003.php:84", "context": "", "note": "", "flags": "php-format", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 189, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 22, "source_unit": "https://hosted.weblate.org/api/units/25066706/?format=api", "priority": 100, "id": 25158694, "web_url": "https://hosted.weblate.org/translate/phpmyadmin/5-1/fi/?checksum=fedb7048f217bcaa", "url": "https://hosted.weblate.org/api/units/25158694/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2020-12-19T00:31:55.184849+01:00", "last_updated": "2023-05-23T12:28:47.723593+02:00" }, { "translation": "https://hosted.weblate.org/api/translations/phpmyadmin/5-1/fi/?format=api", "source": [ "Query cache max size" ], "previous_source": "Query cache", "target": [ "Kyselyvälimuisti" ], "id_hash": 9202577211627872784, "content_hash": 9202577211627872784, "location": "libraries/advisory_rules_mysql_before80003.php:91", "context": "", "note": "", "flags": "", "labels": [], "state": 10, "fuzzy": true, "translated": false, "approved": false, "position": 190, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://hosted.weblate.org/api/units/25066707/?format=api", "priority": 100, "id": 25158695, "web_url": "https://hosted.weblate.org/translate/phpmyadmin/5-1/fi/?checksum=ffb61f37752f2210", "url": "https://hosted.weblate.org/api/units/25158695/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2020-12-19T00:31:55.260165+01:00", "last_updated": "2023-05-23T12:28:47.723593+02:00" }, { "translation": "https://hosted.weblate.org/api/translations/phpmyadmin/5-1/fi/?format=api", "source": [ "The query cache size is above 128 MiB. Big query caches may cause significant overhead that is required to maintain the cache." ], "previous_source": "", "target": [ "" ], "id_hash": 3750191555732394639, "content_hash": 3750191555732394639, "location": "libraries/advisory_rules_mysql_before80003.php:96", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 191, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 22, "source_unit": "https://hosted.weblate.org/api/units/25066708/?format=api", "priority": 100, "id": 25158696, "web_url": "https://hosted.weblate.org/translate/phpmyadmin/5-1/fi/?checksum=b40b5b59bf19528f", "url": "https://hosted.weblate.org/api/units/25158696/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2020-12-19T00:31:55.350348+01:00", "last_updated": "2023-05-23T12:28:47.723593+02:00" }, { "translation": "https://hosted.weblate.org/api/translations/phpmyadmin/5-1/fi/?format=api", "source": [ "Depending on your environment, it might be performance increasing to reduce this value." ], "previous_source": "", "target": [ "" ], "id_hash": 5758135552864589410, "content_hash": 5758135552864589410, "location": "libraries/advisory_rules_mysql_before80003.php:100", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 192, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://hosted.weblate.org/api/units/25066709/?format=api", "priority": 100, "id": 25158697, "web_url": "https://hosted.weblate.org/translate/phpmyadmin/5-1/fi/?checksum=cfe901c7050a9662", "url": "https://hosted.weblate.org/api/units/25158697/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2020-12-19T00:31:55.417866+01:00", "last_updated": "2023-05-23T12:28:47.723593+02:00" }, { "translation": "https://hosted.weblate.org/api/translations/phpmyadmin/5-1/fi/?format=api", "source": [ "Current query cache size: %s" ], "previous_source": "Create version", "target": [ "Luo versio" ], "id_hash": -525648293207265140, "content_hash": -525648293207265140, "location": "libraries/advisory_rules_mysql_before80003.php:102", "context": "", "note": "", "flags": "php-format", "labels": [], "state": 10, "fuzzy": true, "translated": false, "approved": false, "position": 193, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 5, "source_unit": "https://hosted.weblate.org/api/units/25066710/?format=api", "priority": 100, "id": 25158698, "web_url": "https://hosted.weblate.org/translate/phpmyadmin/5-1/fi/?checksum=78b485a98e97308c", "url": "https://hosted.weblate.org/api/units/25158698/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2020-12-19T00:31:55.487182+01:00", "last_updated": "2023-05-23T12:28:47.723593+02:00" }, { "translation": "https://hosted.weblate.org/api/translations/phpmyadmin/5-1/fi/?format=api", "source": [ "Query cache min result size" ], "previous_source": "Query results", "target": [ "Kyselyn tulokset" ], "id_hash": -6784620470406014463, "content_hash": -6784620470406014463, "location": "libraries/advisory_rules_mysql_before80003.php:107", "context": "", "note": "", "flags": "", "labels": [], "state": 10, "fuzzy": true, "translated": false, "approved": false, "position": 194, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://hosted.weblate.org/api/units/25066711/?format=api", "priority": 100, "id": 25158699, "web_url": "https://hosted.weblate.org/translate/phpmyadmin/5-1/fi/?checksum=21d82fa0ed9b1a01", "url": "https://hosted.weblate.org/api/units/25158699/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2020-12-19T00:31:55.557329+01:00", "last_updated": "2023-05-23T12:28:47.723593+02:00" }, { "translation": "https://hosted.weblate.org/api/translations/phpmyadmin/5-1/fi/?format=api", "source": [ "The max size of the result set in the query cache is the default of 1 MiB." ], "previous_source": "", "target": [ "" ], "id_hash": -4377314260018373048, "content_hash": -4377314260018373048, "location": "libraries/advisory_rules_mysql_before80003.php:111", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 195, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 17, "source_unit": "https://hosted.weblate.org/api/units/25066712/?format=api", "priority": 100, "id": 25158700, "web_url": "https://hosted.weblate.org/translate/phpmyadmin/5-1/fi/?checksum=4340a7df5d5a5e48", "url": "https://hosted.weblate.org/api/units/25158700/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2020-12-19T00:31:55.629555+01:00", "last_updated": "2023-05-23T12:28:47.723593+02:00" }, { "translation": "https://hosted.weblate.org/api/translations/phpmyadmin/5-1/fi/?format=api", "source": [ "Changing {query_cache_limit} (usually by increasing) may increase efficiency. This variable determines the maximum size a query result may have to be inserted into the query cache. If there are many query results above 1 MiB that are well cacheable (many reads, little writes) then increasing {query_cache_limit} will increase efficiency. Whereas in the case of many query results being above 1 MiB that are not very well cacheable (often invalidated due to table updates) increasing {query_cache_limit} might reduce efficiency." ], "previous_source": "", "target": [ "" ], "id_hash": 8548320854426764960, "content_hash": 8548320854426764960, "location": "libraries/advisory_rules_mysql_before80003.php:113", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 196, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 78, "source_unit": "https://hosted.weblate.org/api/units/25066713/?format=api", "priority": 100, "id": 25158701, "web_url": "https://hosted.weblate.org/translate/phpmyadmin/5-1/fi/?checksum=f6a1bc86b22bc6a0", "url": "https://hosted.weblate.org/api/units/25158701/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2020-12-19T00:31:55.681575+01:00", "last_updated": "2023-05-23T12:28:47.723593+02:00" }, { "translation": "https://hosted.weblate.org/api/translations/phpmyadmin/5-1/fi/?format=api", "source": [ "query_cache_limit is set to 1 MiB" ], "previous_source": "", "target": [ "" ], "id_hash": -1841083069116352525, "content_hash": -1841083069116352525, "location": "libraries/advisory_rules_mysql_before80003.php:120", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 197, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://hosted.weblate.org/api/units/25066714/?format=api", "priority": 100, "id": 25158702, "web_url": "https://hosted.weblate.org/translate/phpmyadmin/5-1/fi/?checksum=667328b3ff5577f3", "url": "https://hosted.weblate.org/api/units/25158702/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2020-12-19T00:31:55.748213+01:00", "last_updated": "2023-05-23T12:28:47.723593+02:00" }, { "translation": "https://hosted.weblate.org/api/translations/phpmyadmin/5-1/fi/?format=api", "source": [ "Error when evaluating: %s" ], "previous_source": "Error while creating PDF:", "target": [ "Virhe luotaessa PDF-tiedostoa:" ], "id_hash": 5978761825569085902, "content_hash": 5978761825569085902, "location": "libraries/classes/Advisor.php:233", "context": "", "note": "", "flags": "php-format", "labels": [], "state": 10, "fuzzy": true, "translated": false, "approved": false, "position": 198, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 4, "source_unit": "https://hosted.weblate.org/api/units/25066715/?format=api", "priority": 100, "id": 25158703, "web_url": "https://hosted.weblate.org/translate/phpmyadmin/5-1/fi/?checksum=d2f8d43419b619ce", "url": "https://hosted.weblate.org/api/units/25158703/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2020-12-19T00:31:55.811635+01:00", "last_updated": "2023-05-23T12:28:47.723593+02:00" }, { "translation": "https://hosted.weblate.org/api/translations/phpmyadmin/5-1/fi/?format=api", "source": [ "Failed evaluating precondition for rule '%s'." ], "previous_source": "", "target": [ "Säännön '%s' esiehdon arviointi epäonnistui." ], "id_hash": 9018742113214974451, "content_hash": 9018742113214974451, "location": "libraries/classes/Advisor.php:260", "context": "", "note": "", "flags": "php-format", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 199, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://hosted.weblate.org/api/units/25066716/?format=api", "priority": 100, "id": 25158704, "web_url": "https://hosted.weblate.org/translate/phpmyadmin/5-1/fi/?checksum=fd29022b2b08c9f3", "url": "https://hosted.weblate.org/api/units/25158704/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2020-12-19T00:31:55.890927+01:00", "last_updated": "2023-05-23T12:28:47.723593+02:00" }, { "translation": "https://hosted.weblate.org/api/translations/phpmyadmin/5-1/fi/?format=api", "source": [ "Failed calculating value for rule '%s'." ], "previous_source": "", "target": [ "Arvon laskenta säännölle '%s' epäonnistui." ], "id_hash": -8102636862000801367, "content_hash": -8102636862000801367, "location": "libraries/classes/Advisor.php:280", "context": "", "note": "", "flags": "php-format", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 200, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://hosted.weblate.org/api/units/25066717/?format=api", "priority": 100, "id": 25158705, "web_url": "https://hosted.weblate.org/translate/phpmyadmin/5-1/fi/?checksum=0f8da6b42074d9a9", "url": "https://hosted.weblate.org/api/units/25158705/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2020-12-19T00:31:55.959258+01:00", "last_updated": "2023-05-23T12:28:47.723593+02:00" } ] }