cassandra write performance tuning

, Running-------------------+-----------------+-------+------------- +--------------------Maxscale> list SerUnknown or missing option for the list command. Valid Sub-commands is:Clients List all clientsDcbs List All DcbsFilters List All FiltersListeners List all listenersModules List all currently loaded modulesMonitors List all monitorsServices List all the servicesServers List all serversSessions List all sessionsThreads List Polling ThreadsCommands List Registered commandsMaxscale> quit 4 tes

A, sub-tableHorizontal DivisionVertical DivisionSecond, read and write separationThird, choose a reasonable data type, especially the primary keyIv. files, pictures and other large files using file system storageFive, database parameter configurationNote: The maximum number of max_connections connections is usually set at around 1000 to 2000 to the limit.Query_cache_size Query Cache SizeSix, reasonable hardware resources and operating systemMySQL Data

more information: Open source distributed database middleware mycat:http://blog.oldboyedu.com/mysql-mycat/Mycat: Open Source distributed database middleware: http://www.csdn.net/article/2015-07-16/2825228 Mongodb I've heard about it a few years ago, just know it's a nosql database, knowing that the storage format is JSON and is a file database. MongoDB supports sharding: Concrete implementation: http://my.oschina.net/ydsakyclguozi/blog/268377 PostgreSQL

fact, all operations will have similar problems over time, and reading and deleting rows across SStable will lead to dead nodes. All problems can be attributed to access mode and pattern design errors, which are usually related to data. If you write data to the same row for a long time (several months), this row will spread to many sstables. Reading this row of data will become slow, but accessing more "new" rows (located in the same SSTable) will be

; set [global] Variable name = value;Permanently definedVim/etc/my.cnf[Mysqld]Variable name = value....: Wq#systemctl Restart MysqldMySQL architecture?Connection poolSQL interfaceAnalyzerOptimizerQuery cacheStorage EngineFile systemManagement toolsHow does the MySQL service process query requests?4 The SQL query command of the query database written by the program is unreasonable, resulting in slow database processingEnable slow query log on the database server: Records SQL commands that display

about twice the I/O ratio of size-tiered compation. For the write-dominated load, this extra io will not bring a lot of benefits because there are not many lines of old versions involved. Settings: Leveled compaction ignores the concurrent_compactors setting. concurrent compaction is designed to avoid tiered compaction's problem of a backlog of small compaction sets becoming blocked temporarily while the compaction system is busy with a large set. l

Reprint: http://www.dbthink.com /? P = 420 We have started to use Cassandra in onespot as our next-generation storage engine (replacing a very large PostgreSQL machine with an EC2 machine cluster). Therefore, I have been using Cassandra for the past few weeks. as I am an infrastructure nerd and firmly believe that I need to understand all aspects of the system stack, I have read some information about how

can only mechanically, Most of the time it's not going to work out, and it's probably worse. Of course, I am not saying that those cases are useless, after mastering the basic theory, to study and analyze some cases, it is also very valuable. Just like a magic doctor gave us a secret recipe, can we read it? Can not understand, because we do not know medical knowledge, useful? Estimated not much use, we can not see the patient to use that prescription, SQL t