What is this?
Mysql query will become slow when table contains millions of rows. A simple way of solving this probolem is spliting the big table into small ones. We use some method to decide which table each row should be moved into. A widely used method is “modulus”, e.g. group rows by [ID mod 100]. This tool will help you to do this job easily.
Check home page for usage and more infomation.
Features
Move records from one table to another(or other) table(s) according to user specified rules.
Dynamically create new tables during moving.
Move records between different mysql servers.
Check data integrity of the new tables.
For records who have been moved to new tables, remove them from source table.
Using it as a python module which means dynamically changing the behavior.
1 maintainer
Release files for pymysql-split-tool 0.5.6
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | |
|---|---|---|---|
| pymysql_split_tool-0.5.6.tar.gz | 8.5 kB | Details |
Built distribution (wheel)
| File | Interpreter | ABI | Platform | Reset |
|---|---|---|---|---|
| pymysql_split_tool-0.5.6-py2.py3-none-any.whl | Python 2, Python 3 | none | any | Details |
Total release size: 20.8 kB
Release files / pymysql_split_tool-0.5.6.tar.gz
| Download URL | pymysql_split_tool-0.5.6.tar.gz |
|---|---|
| Size | 8.5 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
c7aa072c7b7c0bbfccc7aac80ad515f18c90d566a1081a5606dd3d924eb4cc5c
|
|
BLAKE2b-256 checksum How to use checksums |
02c46b480a640e79953bbacfdafafa662c4ae001678c26d75857591fe98fcff8
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/1.12.1 pkginfo/1.4.2 requests/2.20.1 setuptools/40.6.2 requests-toolbelt/0.8.0 tqdm/4.28.1 CPython/3.6.7
|
Release files / pymysql_split_tool-0.5.6-py2.py3-none-any.whl
| Download URL | pymysql_split_tool-0.5.6-py2.py3-none-any.whl |
|---|---|
| Size | 12.2 kB |
| Tags | Python 2 Python 3 |
|
SHA-256 checksum How to use checksums |
74d8d0fb3fae6beba54d93afa0c0b575ad4f4dfa9ef1656bf3c6241256ddbbea
|
|
BLAKE2b-256 checksum How to use checksums |
fecce0065c3d7b9af928acd83be075553fdc609247db2573d47e62e395d33ebd
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/1.12.1 pkginfo/1.4.2 requests/2.20.1 setuptools/40.6.2 requests-toolbelt/0.8.0 tqdm/4.28.1 CPython/3.6.7
|
