473,388 Members | 1,355 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,388 software developers and data experts.

How to optimize a big database with slow writes?

I'd like to improve the speed of our database writes. They have slown down as our database has gotten larger.

What solutions are out there to improve performance of a growing database?
Apr 5 '12 #1
2 1784
Rabbit
12,516 Expert Mod 8TB
I don't know if mysql supports it but you could partition the tables. One thing you could do is upgrade the hardware but that will cost money. You should delete any unnecessary indexes. And if push comes to shove, archive some of the older data.
Apr 6 '12 #2
Luuk
1,047 Expert 1GB
I don't know if mysql supports it but you could partition the tables
see: http://dev.mysql.com/doc/refman/5.5/...titioning.html

so, it does support partitioning. ;)
Apr 6 '12 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

16
by: mamo74 | last post by:
Hello. I am administering a SQL Server (Enterprise Edition on Windows 2003) from some month and can't understand what is going on in the latest week (when the db grow a lot). The DB is around...
1
by: Tardus Merula | last post by:
We have just put a new samba server on the lab premises and upgradede all workstations to 100 MB/s, in order to avoid using 10-mile radio link, hoping that this would enable us to operae our...
1
by: dd_bdlm | last post by:
I have made some alterations to my company's database so that variable rates are calculated on postcode area. This is currently been expanded from a query which featured 12 IIf statements to one...
0
by: Wayne | last post by:
Original Post: The following problem started on my PC about a week ago and I can't link it to any specific change. I'm using Access XP. If I have any database open and try to open any other...
0
by: Wayne | last post by:
I experienced the following problem the last time I installed IE7 beta. Since then I have done a reformat of my hard disc and after using IE6 for a while I installed the latest version of IE7 and...
2
by: jl2886 | last post by:
I have three questions: I have a variable that is going to be input with a monetary amount and upon update of that variable i want another field in the form to be populated with the now date. I...
2
by: bravo | last post by:
hi everyone , i am trying to join two tables , the query is working fine when the records in the tables are less but when the records are in huge numbers say 1-2 million then the system hangs... i am...
8
by: rusdyrip | last post by:
hi all, i have problem on loading large database i am using Firebird Database and VB.NET 2005 it seems really slow to load 10.000+ row on DataGrid currently i use DataReader to open the...
6
by: DannielHS | last post by:
The computer is just one-year-old. Many problems: - Always run every program slowly; - Desktop always appears some strang files; I've used some antivirus product to clear virus. It says everthing...
14
by: Hembd | last post by:
Hello, I'm new to creating databases and coding in general. Through research I have created a DB that works. However, I have filled it with test data and find that a few queries which are used to...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.