Is writing server log files to a database a good idea?

by

Write locally to disk, then batch insert to the database periodically (e.g. at log rollover time). Do that in a separate, low-priority process. More efficient and more robust…

(Make sure that your database log table contains a column for “which machine the log event came from” by the way – very handy!)

More Related Contents:

  1. Log to a database using log4j
  2. What is the minimal proof that a database relation is not in BCNF?
  3. What is the best design for a database table that can be owned by two different resources, and therefore needs two different foreign keys? [closed]
  4. How do I backup a database file to the SD card on Android?
  5. Spring Security:password encoding in DB and in applicationContext
  6. ADO.Net EF – how to define foreign key relation in model first approach?
  7. How to retrieve the last autoincremented ID from a SQLite table?
  8. SQL Server Connection Strings – dot(“.”) or “(local)” or “(localdb)”
  9. Synchronous database queries with Node.js
  10. How can I avoid SQL injection attacks?
  11. What is the recommended way to delete a large number of items from DynamoDB?
  12. Logging ALL Queries on a SQL Server 2008 Express Database?
  13. Supertype-subtype database design
  14. Storing time-series data, relational or non?
  15. Why should I use document based database instead of relational database?
  16. Good Free Alternative To MS Access [closed]
  17. SQLite insert speed slows as number of records increases due to an index
  18. What’s wrong with nullable columns in composite primary keys?
  19. wikidata get all properties with labels and values of an item
  20. Convert String ISO-8601 date to oracle’s timestamp datatype
  21. Are Cloud Firestore queries still case sensitive?
  22. How should you build your database from source control?
  23. Strange behavior in PowerShell function returning DataSet/DataTable
  24. Populating Spinner From SQLite Database Android
  25. Adding a new value to an existing ENUM Type
  26. Does anyone know of a good library for mapping a person’s name to his or her gender? [closed]
  27. Minimum GRANTs needed by mysqldump for dumping a full schema? (TRIGGERs are missing!!)
  28. “Cannot drop database because it is currently in use”. How to fix?
  29. Predict next auto-inserted row id (SQLite)
  30. Best beginner resources for understanding the EAV database model? [closed]

Leave a Comment