# SingleStore Tools

**URL:** https://www.singlestore.com/forum/c/toolbox/17.md?page=1

[Latest](https://www.singlestore.com/forum/latest.md) · [Categories](https://www.singlestore.com/forum/categories.md) · [Tags](https://www.singlestore.com/forum/tags.md)

**Page:** 2

---

## [New to SingleStore - What is using all my memory? (5.5.58 MemSQL source distribution)](https://www.singlestore.com/forum/t/new-to-singlestore-what-is-using-all-my-memory-5-5-58-memsql-source-distribution/2586)

<div class="topic-metadata">

**Author:** [@ctaylor](https://www.singlestore.com/forum/u/ctaylor)\
**Replies:** 2\
**Last updated:** [October 12, 2021, 11:11pm UTC](https://www.singlestore.com/forum/t/new-to-singlestore-what-is-using-all-my-memory-5-5-58-memsql-source-distribution/2586 "2021-10-12T23:11:58Z")

</div>

Ok, I’ve inherited some memSQL/SingleStore support and I’m a newbie with it. (Sr. Oracle DBA/Linux guy though) I had a user create support ticket with the following: \[Informatica\]\[ODBC 20101 driver\]\[20101\]Leaf Error …

---

## [Toolbox 1.12.1 updating OS settings by default](https://www.singlestore.com/forum/t/toolbox-1-12-1-updating-os-settings-by-default/3317)

<div class="topic-metadata">

**Author:** [@celer-tech](https://www.singlestore.com/forum/u/celer-tech)\
**Replies:** 3\
**Last updated:** [September 20, 2021, 7:14am UTC](https://www.singlestore.com/forum/t/toolbox-1-12-1-updating-os-settings-by-default/3317 "2021-09-20T07:14:36Z")

</div>

Hi, I can read the following in the release notes of toolbox 1.12.1: " By default, the sdb-toolbox-config register-host command now configures the host’s operating system per SingleStore’s recommendations. To disable …

---

## [Returning \>300 rows in MemSQL Studio](https://www.singlestore.com/forum/t/returning-300-rows-in-memsql-studio/1663)

<div class="topic-metadata">

**Author:** [@dhenry](https://www.singlestore.com/forum/u/dhenry)\
**Replies:** 9\
**Last updated:** [September 8, 2021, 12:04am UTC](https://www.singlestore.com/forum/t/returning-300-rows-in-memsql-studio/1663 "2021-09-08T00:04:50Z")

</div>

Is it possible to return more than 300 rows in the MemSQL Studio query editor? Also it looks like the “Save CSV” button only saves the 300 rows shown, can it return all results?

---

## [User to manage memsql ops web UI](https://www.singlestore.com/forum/t/user-to-manage-memsql-ops-web-ui/70)

<div class="topic-metadata">

**Author:** [@memsqlpubs](https://www.singlestore.com/forum/u/memsqlpubs)\
**Replies:** 0\
**Last updated:** [October 2, 2018, 7:34pm UTC](https://www.singlestore.com/forum/t/user-to-manage-memsql-ops-web-ui/70 "2018-10-02T19:34:50Z")

</div>

(Ported from memsql-public-chat Slack channel) mubi \[11:52 AM\] how to create a user and allow memsql ops web UI alec \[1:53 PM\] @mubi see the commands at SingleStoreDB Cloud · SingleStore Documentation (edited)

---

## [Error - invalid HCL: At 1:8: illegal char while deploying cluster](https://www.singlestore.com/forum/t/error-invalid-hcl-at-1-illegal-char-while-deploying-cluster/3246)

<div class="topic-metadata">

**Author:** [@e.soden](https://www.singlestore.com/forum/u/e.soden)\
**Replies:** 2\
**Last updated:** [August 20, 2021, 3:36pm UTC](https://www.singlestore.com/forum/t/error-invalid-hcl-at-1-illegal-char-while-deploying-cluster/3246 "2021-08-20T15:36:15Z")

</div>

Dears, I’m new to memsql. I have succeed to install memsql using cluster-in-a-box parameters. But now I would like to create a cluster over two hosts. I have generated the Yaml file using UI setup but when I try to depl…

---

## [Failed to find host with master: no master aggregator found in this cluster](https://www.singlestore.com/forum/t/failed-to-find-host-with-master-no-master-aggregator-found-in-this-cluster/3217)

<div class="topic-metadata">

**Author:** [@adriant](https://www.singlestore.com/forum/u/adriant)\
**Replies:** 2\
**Last updated:** [August 5, 2021, 9:01am UTC](https://www.singlestore.com/forum/t/failed-to-find-host-with-master-no-master-aggregator-found-in-this-cluster/3217 "2021-08-05T09:01:52Z")

</div>

Hi everyone, I’m following the SingleStore integration with Prometheus and Grafana tutorial, and I’m running into some issues on registering the master aggregator on the cluster. I’m using the Docker version of the CIA…

---

## [SingleStore Studio date format changed since v3.2.2](https://www.singlestore.com/forum/t/singlestore-studio-date-format-changed-since-v3-2-2/2783)

<div class="topic-metadata">

**Author:** [@prerak](https://www.singlestore.com/forum/u/prerak)\
**Replies:** 4\
**Last updated:** [July 26, 2021, 5:43am UTC](https://www.singlestore.com/forum/t/singlestore-studio-date-format-changed-since-v3-2-2/2783 "2021-07-26T05:43:34Z")

</div>

Is there a setting for the default date format displayed in SingleStore Studio? Upon query, TIMESTAMP(6) columns used to be displayed in ISO format, but now they are displayed as “Thu Feb 18 2021 07:55:54 GMT-0500 (East…

---

## [Backup to S3 Object ACL Issues](https://www.singlestore.com/forum/t/backup-to-s3-object-acl-issues/176)

<div class="topic-metadata">

**Author:** [@aaron.lee](https://www.singlestore.com/forum/u/aaron.lee)\
**Replies:** 2\
**Last updated:** [November 30, 2018, 5:06pm UTC](https://www.singlestore.com/forum/t/backup-to-s3-object-acl-issues/176 "2018-11-30T17:06:11Z")

</div>

Hey All, I was wondering if anyone has ever done backups to an s3 bucket that exists in a different AWS account? I’m running into issues with S3 Object ACLs. The files that are being uploaded from AWS Account A to the S…

---

## [Docker-compose: License unable to pick from variable, it is looking from different location](https://www.singlestore.com/forum/t/docker-compose-license-unable-to-pick-from-variable-it-is-looking-from-different-location/3041)

<div class="topic-metadata">

**Author:** [@gurramvinaychandra](https://www.singlestore.com/forum/u/gurramvinaychandra)\
**Replies:** 3\
**Last updated:** [June 7, 2021, 8:17pm UTC](https://www.singlestore.com/forum/t/docker-compose-license-unable-to-pick-from-variable-it-is-looking-from-different-location/3041 "2021-06-07T20:17:25Z")

</div>

Hello folks, A trying to install memSql inside a docker and added license with variable but am facing error for license since it is trying to fetch license from different location, have added there as well but still sam…

---

## [Memsql upgrade to version 7.1.11 making master node down](https://www.singlestore.com/forum/t/memsql-upgrade-to-version-7-1-11-making-master-node-down/2430)

<div class="topic-metadata">

**Author:** [@shishir.kumar](https://www.singlestore.com/forum/u/shishir.kumar)\
**Replies:** 1\
**Last updated:** [November 20, 2020, 8:16pm UTC](https://www.singlestore.com/forum/t/memsql-upgrade-to-version-7-1-11-making-master-node-down/2430 "2020-11-20T20:16:47Z")

</div>

Hi All, I am looking a help to up my master node. I upgraded memsql version from 6.5.12 to 6.8.22 every thing was fine. Once upgrade from 6.8.22 to version 7.1.11 then upgrade throw error on last “Currently on state Of…

---

## [Can't upgrade MemSQL Studio to 1.9.8](https://www.singlestore.com/forum/t/cant-upgrade-memsql-studio-to-1-9-8/2280)

<div class="topic-metadata">

**Author:** [@cuong.nguyen](https://www.singlestore.com/forum/u/cuong.nguyen)\
**Replies:** 8\
**Last updated:** [September 3, 2020, 10:23am UTC](https://www.singlestore.com/forum/t/cant-upgrade-memsql-studio-to-1-9-8/2280 "2020-09-03T10:23:37Z")

</div>

Dear support team Currently my MemSQL studio installed version 1.9.6 and I want to upgrade the latest version 1.9.8.Base on the guide line. I have run syntax: “sudo yum update memsql-studio” Run completed but nothing …

---

## [Is there a easy way to import data from Kdb to memsql?](https://www.singlestore.com/forum/t/is-there-a-easy-way-to-import-data-from-kdb-to-memsql/2217)

<div class="topic-metadata">

**Author:** [@ravisr](https://www.singlestore.com/forum/u/ravisr)\
**Replies:** 2\
**Last updated:** [August 3, 2020, 8:28pm UTC](https://www.singlestore.com/forum/t/is-there-a-easy-way-to-import-data-from-kdb-to-memsql/2217 "2020-08-03T20:28:04Z")

</div>

I would like to see if there are any tools to import directly from Kdb to memSql.

---

## [MemSQL Studio Docker Image](https://www.singlestore.com/forum/t/memsql-studio-docker-image/2079)

<div class="topic-metadata">

**Author:** [@Artum](https://www.singlestore.com/forum/u/Artum)\
**Replies:** 2\
**Last updated:** [June 22, 2020, 6:27pm UTC](https://www.singlestore.com/forum/t/memsql-studio-docker-image/2079 "2020-06-22T18:27:16Z")

</div>

I’ve create a simple docker image that you can use to run MemSQL Studio as Docker container. You can find it here: https://hub.docker.com/r/artum/memsql-studio Have fun, Artum.

---

## [Feature idea: MemSQL user management](https://www.singlestore.com/forum/t/feature-idea-memsql-user-management/1399)

<div class="topic-metadata">

**Author:** [@christoph](https://www.singlestore.com/forum/u/christoph)\
**Replies:** 2\
**Last updated:** [May 31, 2020, 11:15am UTC](https://www.singlestore.com/forum/t/feature-idea-memsql-user-management/1399 "2020-05-31T11:15:06Z")

</div>

Dear team, I am a big fan of MemSQL Studio, especially since it keeps improving at a very fast pace! I understand that Studio is a SQL frontend to MemSQL, so it can manage everything MemSQL related that can be done via…

---

## [What is causing high Waiting for network I/O](https://www.singlestore.com/forum/t/what-is-causing-high-waiting-for-network-i-o/1954)

<div class="topic-metadata">

**Author:** [@moralez.rodrigo](https://www.singlestore.com/forum/u/moralez.rodrigo)\
**Replies:** 2\
**Last updated:** [May 20, 2020, 6:23pm UTC](https://www.singlestore.com/forum/t/what-is-causing-high-waiting-for-network-i-o/1954 "2020-05-20T18:23:55Z")

</div>

What might be cause hight Waiting for network I/O I took 30 seconds with the Resource Usage and the waiting is taking 50% of the time. I tried several times of the day. What can be causing this? Memsql ver: 7.0.16

---

## [Upgrade Errors =\> Provide some meaningful documentation when releasing new versions](https://www.singlestore.com/forum/t/upgrade-errors-provide-some-meaningful-documentation-when-releasing-new-versions/1951)

<div class="topic-metadata">

**Author:** [@phanikrishna111](https://www.singlestore.com/forum/u/phanikrishna111)\
**Replies:** 27\
**Last updated:** [May 18, 2020, 1:13pm UTC](https://www.singlestore.com/forum/t/upgrade-errors-provide-some-meaningful-documentation-when-releasing-new-versions/1951 "2020-05-18T13:13:03Z")

</div>

Trying to upgrade memsql using the below link https://docs.memsql.com/v7.0/guides/cluster-management/operations/upgrading-to-70/ Memsql upgrade to V7 is failing in all methods Getting the following errors when used bo…

---

## [Memsql studio showing incorrect disk size](https://www.singlestore.com/forum/t/memsql-studio-showing-incorrect-disk-size/1937)

<div class="topic-metadata">

**Author:** [@elad](https://www.singlestore.com/forum/u/elad)\
**Replies:** 2\
**Last updated:** [May 11, 2020, 9:58pm UTC](https://www.singlestore.com/forum/t/memsql-studio-showing-incorrect-disk-size/1937 "2020-05-11T21:58:31Z")

</div>

Hi, I see in memsql studio in the hosts screen 273gb/1tb on both leaves (we only have 2 leaves). The disk though of that server is 1.5tb. Any reason I dont see all the size ? is there a limit or something ? Thx !

---

## [Partition status of replicated database in MemSQL studio](https://www.singlestore.com/forum/t/partition-status-of-replicated-database-in-memsql-studio/1878)

<div class="topic-metadata">

**Author:** [@mnagy](https://www.singlestore.com/forum/u/mnagy)\
**Replies:** 4\
**Last updated:** [May 7, 2020, 6:59pm UTC](https://www.singlestore.com/forum/t/partition-status-of-replicated-database-in-memsql-studio/1878 "2020-05-07T18:59:29Z")

</div>

Hello, I’ve set up REPLICATION of a few database in my DEV cluster to my DR DEV cluster. When I look at the database status on the DR MemSQL Studio page, I’m seeing ONLINE - IMPACTED Is this expected behavior from st…

---

## [Memsql-ops report not running in memsql-ops 5.8.2](https://www.singlestore.com/forum/t/memsql-ops-report-not-running-in-memsql-ops-5-8-2/1644)

<div class="topic-metadata">

**Author:** [@dumpy85](https://www.singlestore.com/forum/u/dumpy85)\
**Replies:** 0\
**Last updated:** [February 19, 2020, 2:36pm UTC](https://www.singlestore.com/forum/t/memsql-ops-report-not-running-in-memsql-ops-5-8-2/1644 "2020-02-19T14:36:03Z")

</div>

when we run memsql-ops report from our primary agent it is showing below message . Building diagnostic report took longer than 360 seconds.please suggest.

---

## [Feature request: GUI for pipelines](https://www.singlestore.com/forum/t/feature-request-gui-for-pipelines/1343)

<div class="topic-metadata">

**Author:** [@christoph](https://www.singlestore.com/forum/u/christoph)\
**Replies:** 2\
**Last updated:** [November 7, 2019, 6:34pm UTC](https://www.singlestore.com/forum/t/feature-request-gui-for-pipelines/1343 "2019-11-07T18:34:52Z")

</div>

Dear MemSQL, we are getting more and more into pipelines and are pretty amazed by the performance! In order to ease our development and management, I would like to propose improvements to Studio: GUI to create / upda…

---

## [How do I configure MemSql Studio for HTTPS?](https://www.singlestore.com/forum/t/how-do-i-configure-memsql-studio-for-https/573)

<div class="topic-metadata">

**Author:** [@ian.lewis](https://www.singlestore.com/forum/u/ian.lewis)\
**Replies:** 4\
**Last updated:** [November 6, 2019, 2:51pm UTC](https://www.singlestore.com/forum/t/how-do-i-configure-memsql-studio-for-https/573 "2019-11-06T14:51:38Z")

</div>

By default MemSql Studio is available over port 80. This is not really desirable so can someone please give me an idea of the preferred approach to setting up HTTPS for Studio. Many thanks.

---

## [User un hung state](https://www.singlestore.com/forum/t/user-un-hung-state/1295)

<div class="topic-metadata">

**Author:** [@arshakfm](https://www.singlestore.com/forum/u/arshakfm)\
**Replies:** 2\
**Last updated:** [October 21, 2019, 10:51pm UTC](https://www.singlestore.com/forum/t/user-un-hung-state/1295 "2019-10-21T22:51:01Z")

</div>

Hello, We are frequently facing the user hung issue. We are using one user for Grafana and another user to login to the memsql studio. Due to the frequent issue, Both applications stopped working. When we tried to log i…

---

## [Memsql studio upgradation](https://www.singlestore.com/forum/t/memsql-studio-upgradation/1257)

<div class="topic-metadata">

**Author:** [@arshakfm](https://www.singlestore.com/forum/u/arshakfm)\
**Replies:** 1\
**Last updated:** [September 23, 2019, 10:16am UTC](https://www.singlestore.com/forum/t/memsql-studio-upgradation/1257 "2019-09-23T10:16:13Z")

</div>

Hello, We have installed Memsql studio on our production system (Ubuntu) using “apt install memsql-studio” command. The current version is 1.8.0 and we want to upgrade it to 1.9.0. Can someone suggest the steps to upg…

---

## [User unable to run memsql-ops tool](https://www.singlestore.com/forum/t/user-unable-to-run-memsql-ops-tool/1246)

<div class="topic-metadata">

**Author:** [@derogers](https://www.singlestore.com/forum/u/derogers)\
**Replies:** 0\
**Last updated:** [September 18, 2019, 12:13am UTC](https://www.singlestore.com/forum/t/user-unable-to-run-memsql-ops-tool/1246 "2019-09-18T00:13:39Z")

</div>

I have a linux user that is unable to use the memsql-ops tool. Whenever I try to run the command, I get the following python error. Traceback (most recent call last): File “/usr/local/updated-openssl/lib/python3.4/sit…

---

## [A look back on MemSQL Studio, Year 1](https://www.singlestore.com/forum/t/a-look-back-on-memsql-studio-year-1/1229)

<div class="topic-metadata">

**Author:** [@fsmith](https://www.singlestore.com/forum/u/fsmith)\
**Replies:** 0\
**Last updated:** [September 11, 2019, 11:18pm UTC](https://www.singlestore.com/forum/t/a-look-back-on-memsql-studio-year-1/1229 "2019-09-11T23:18:49Z")

</div>

David Gomes, leader of the team that develops MemSQL Studio, has a new blog post up. At the 1-year anniversary of Studio’s launch, he goes through the launch features (such as the SQL Editor and the Resource Usage Profil…

---

## [Schedule database backups](https://www.singlestore.com/forum/t/schedule-database-backups/1167)

<div class="topic-metadata">

**Author:** [@geet](https://www.singlestore.com/forum/u/geet)\
**Replies:** 2\
**Last updated:** [September 9, 2019, 3:50pm UTC](https://www.singlestore.com/forum/t/schedule-database-backups/1167 "2019-09-09T15:50:20Z")

</div>

Hello, We are on version 6.8.\* and with the memsql-ops deprecated… We are trying to figure what the best way is to schedule full database backups (preferably to s3) on a recurring basis. Is there a way to configure sn…

---

## [Show table size by its storage type](https://www.singlestore.com/forum/t/show-table-size-by-its-storage-type/1124)

<div class="topic-metadata">

**Author:** [@diemontufar](https://www.singlestore.com/forum/u/diemontufar)\
**Replies:** 1\
**Last updated:** [August 13, 2019, 11:41pm UTC](https://www.singlestore.com/forum/t/show-table-size-by-its-storage-type/1124 "2019-08-13T23:41:17Z")

</div>

Hi guys, does anybody knows the query to show the information showed in the image?

---

## [Pipline get all catch errors](https://www.singlestore.com/forum/t/pipline-get-all-catch-errors/996)

<div class="topic-metadata">

**Author:** [@baruch.machluf](https://www.singlestore.com/forum/u/baruch.machluf)\
**Replies:** 1\
**Last updated:** [July 22, 2019, 8:00pm UTC](https://www.singlestore.com/forum/t/pipline-get-all-catch-errors/996 "2019-07-22T20:00:53Z")

</div>

Hi, I’m loading GZIP files from S3 into memsql cluster using the pipline. At first I got many ERROR 1262 ER\_WARN\_TOO\_MANY\_RECORDS errors so I added the IGNORE ALL ERRORS to the pipline and rerun it. Now, after it load…

---

## [Stats in old memsql-ops's web dashboard](https://www.singlestore.com/forum/t/stats-in-old-memsql-opss-web-dashboard/552)

<div class="topic-metadata">

**Author:** [@alexis.fernandez](https://www.singlestore.com/forum/u/alexis.fernandez)\
**Replies:** 3\
**Last updated:** [April 22, 2019, 9:01am UTC](https://www.singlestore.com/forum/t/stats-in-old-memsql-opss-web-dashboard/552 "2019-04-22T09:01:23Z")

</div>

I loved the old memsql-ops’s web dashboard with all the dynamic stats of every node about CPU, Paging, Disk Capacity, Disk Utilization and Network Usage. Now there isn’t any way to see this useful stats fast. This has be…

---

## [Memsql-ops vs memsql tools Permissions](https://www.singlestore.com/forum/t/memsql-ops-vs-memsql-tools-permissions/751)

<div class="topic-metadata">

**Author:** [@Kishore](https://www.singlestore.com/forum/u/Kishore)\
**Replies:** 1\
**Last updated:** [June 17, 2019, 10:18pm UTC](https://www.singlestore.com/forum/t/memsql-ops-vs-memsql-tools-permissions/751 "2019-06-17T22:18:42Z")

</div>

Hi, I have created a user called memsql with sudo privilages and with this user I am able to see the nodes and manage the cluster where as with the vagrant I want not able to see the nodes nor manage. However with the m…

[Previous page](https://www.singlestore.com/forum/c/toolbox/17.md)

[Next page](https://www.singlestore.com/forum/c/toolbox/17.md?page=2)
