![]() For example on Ubuntu sudo du -h /var/lib/mysql. select datadir Once you know where the data is stored, you can check disk usage with du command. You can execute the query below to find the path where MySQL data is stored. If I already know what I'm looking for, I might use a combination of HTTPie and jq to get it. Assuming that your MySQL host is running on Linux. ![]() I can get a JSON blob of Python package details by hitting PyPI's /pypi//json endpoint. That makes my VisiData sense start to tingle. That answered my immediate question, and would have been a fine place to stop.īut I figured this would be a handy thing to check from the terminal. vdx, a simplified new cmdlog format add -N/-nothing command to disable loading. mysqlimultiquery () waits for the first query to complete before returning control to PHP. VisiData version history v2.10.2 (2022-10-XX) add. So I opened Firefox dev tools and found a usable CSS selector for a release label:Īnd checked how many times that class showed up on the page: Queries are sent asynchronously in a single call to the database, but the database processes them sequentially. If you are using InnoDB with innodbfilepertable set, then you can get an approximate answer using du -sh. Knowing a little bit of Python, however, will make VisiData even more powerful for you. Note You don’t need to be a programmer to use VisiData. If you are using MyISAM, it is easiest to just look at the filesystem and use du -sh /var/lib/mysql/database. VisiData is a free, open-source tool that lets you quickly open, explore, summarize, and analyze datasets in your computer’s terminal. I was already in the browser, and the data I needed was right there. 8 Answers Sorted by: 69 There are 3 scenarios. I noticed that the release history page listed all releases but didn't show a total count. Some contributors were discussing the total number of releases, and I was curious about the count from the PyPI side. You can use either to launch VisiData. I was looking at the Python Package Index recently to browse release history for the Cloud Custodian package. To install VisiData this way, open your terminal and run this command: pip3 install visidata To test that VisiData installed correctly, run this: vd -version You should see something like the following: vd -version /VisiData v2.8 (On the command line, vd and visidata are synonymous. Tour of a quick win - browsing Python package information VisiData is useful to me in so many situations that "just throw it to VisiData" has become an instinct. even some things you might not think of at first: like filesystem metadata and API results and packet captures. The anniversary post modestly describes VisiData as an interactive tabulator, but for me the real prize comes later when talking about its support for a wide variety of data sources: VisiData recently celebrated its five-year anniversary. Tour of a quick win - browsing Python package information.Use Windows Subsystem for Linux (WSL) or install via the Conda or Python method above. Run this command (install Anaconda first if necessary): conda install -channel conda-forge visidata Windows Run this command (install brew first if necessary): brew install saulpw/vd/visidata Conda ![]() Run this command (install Python first if necessary): pip3 install visidata MacOS Some formats will require additional dependencies. Some packages support additional formats. ![]() These packages at minimum support csv, tsv, fixed-width text, json, and sqlite. ![]()
0 Comments
Leave a Reply. |