Skip to content
DbaFix
Just share answer and question for fixing database problem
MENU
  • HOME

Tag: cassandra

What is an efficient storage method to store Graph Data from GraphX (Spark)?

By adminPosted on August 16, 2023

Question : I generate graph data using Spark’s GraphX library and I need an efficient way to store graph data. […]

Cassandra change replication factor hive datastore

By adminPosted on July 16, 2023

Question : I am trying to change replication factor of HiveMetaStore but I receive this message: cassandra@cqlsh:system> alter KEYSPACE HiveMetaStore […]

Which database system can break me free?

By adminPosted on June 18, 2023

Question : I am currently running a MySQL Database for logging and analyzing those logs. My current table schema looks […]

Cassandra query response time degradation

By adminPosted on April 1, 2023

Question : I am experimenting with Cassandra on 4 sites with 2 nodes on each one. Have small network latency […]

Cassandra Table data modeling for a event system monitoring data

By adminPosted on March 3, 2023

Question : I have been working in a cassandra database to keep the real time data of an event/monitoring system […]

How can I generate Cassandra data model from a MySQL schema?

By adminPosted on February 20, 2023

Question : Is there a tool for generating a Cassandra model from a MySQL database? Answer : The whole point […]

Small startup: Cassandra + Hadoop or ElasticSearch

By adminPosted on November 28, 2022

Question : To give some context, I am from a small start up (4 team members) and we work in […]

Optimal database for large number of columns or rows

By adminPosted on November 26, 2022

Question : Problem 1: I have one file with 567 rows and 16,382 columns, most of which are floating point […]

Joining in NoSQL to get chat messages for a user

By adminPosted on November 19, 2022

Question : In my chat app i have private / group chats and I need to get messages for a […]

Filtering a large number of rows in Cassandra

By adminPosted on October 27, 2022

Question : Let’s assume we have a lot of potentially heavy rows (e.g. 500k) in a table that we want […]

  • 1
  • 2
  • 3

Recent Posts

  • Suggestions for type of DB to use (Elasticsearch vs MongoDB vs Hadoop)
  • Creating Indexes to optimize query
  • Does joining to the same table twice have a predictable performance impact
  • Can we prevent table from update directly but allow update using trigger from another table?
  • Querying ‘random’ Oracle data via openquery in SQL Server returning the same data for multiple runs
  • The implications of lack on indexes on supporting a large production database
  • How to limit work_mem on PostgreSQL
  • Select max(pk) instead of sequence.nextval
  • Query detailing differences between rows for a large amount of data
  • How to combine `delete` and `insert` operations in one statement?
  • Slow SQL Server database on a specific server [duplicate]
  • How to model the relationship between these three tables
  • Error when migrating MySQL 8 to SQL Server 2019
  • multiple MYSQL full text indexing for innodb and memory + disk efficiency
  • Many-To-Many relationship between Students and heights (Is it necessary?)
  • What is the ideal composite index for this query?
  • hosting images on own database or 3rd party
  • Can’t start mongodb server using ‘sudo service mongod start’
  • sqlcmd new login/user
  • Log Reader replication agents are constantly restarting

Categories

  • Database Backup
  • Database Design
  • Database Index
  • Database Optimization
  • InnoDB
  • Join
  • MariaDB
  • MongoDB
  • MySQL
  • Oracle
  • Performance
  • Permissions
  • Postgresql
  • Query Performance
  • Replication
  • Security
  • SQL Server
Proudly powered by WordPress / Support by: DizzyCoding