# Mautic with 1M records

**URL:** <https://forum.mautic.org/t/mautic-with-1m-records/8196>\
**Category:** Product Support\
**Created:** [April 13, 2017, 5:02am UTC](https://forum.mautic.org/t/mautic-with-1m-records/8196 "2017-04-13T05:02:28Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![lvocella](https://avatars.discourse-cdn.com/v4/letter/l/839c29/32.png) [@lvocella](https://forum.mautic.org/u/lvocella)\
**Post date:** [April 13, 2017, 5:02am UTC](https://forum.mautic.org/t/mautic-with-1m-records/8196/1 "2017-04-13T05:02:28Z")

</div>

Hello,  
  
I’m testing mautic with a database containing about 1 million of leads and about 7 million of page hits.  
  
Have you got some things I could do to improve performance? I have a 4cpu 8gb ram vps.  
  
  
  
I know that there is a function for cleaning old data but we need to maintain them.  
  
  
  
Thanks in advamce

---

<div class="post-metadata">

**Author:** ![lvocella](https://avatars.discourse-cdn.com/v4/letter/l/839c29/32.png) [@lvocella](https://forum.mautic.org/u/lvocella)\
**Post date:** [April 13, 2017, 5:02am UTC](https://forum.mautic.org/t/mautic-with-1m-records/8196/2 "2017-04-13T05:02:28Z")

</div>

Hello,  
I’m testing mautic with a database containing about 1 million of leads and about 7 million of page hits.  
Have you got some things I could do to improve performance? I have a 4cpu 8gb ram vps.

I know that there is a function for cleaning old data but we need to maintain them.

Thanks in advamce

---

<div class="post-metadata">

**Author:** ![redneckbob](https://avatars.discourse-cdn.com/v4/letter/r/73ab20/32.png) [@redneckbob](https://forum.mautic.org/u/redneckbob)\
**Post date:** [April 14, 2017, 4:05am UTC](https://forum.mautic.org/t/mautic-with-1m-records/8196/3 "2017-04-14T04:05:32Z")

</div>

I know of at least one Mautic installation with 100M records, so it can scale. Don’t have a clue on what hardware, OS tweaks, web server configs, and database server magic was required for it to be usable at that scale. All depends on the workload.

Regardless:

- 8GB of RAM sounds really really small, do you have a typo?
- What are your hardware specifications?
- Why a VPS and not bare metal?
- What are you doing with those leads each day? What is the workload?
- Do you know the mix of page hits? A these landing pages pages or static images?
- Have you analyzed the server for bottlenecks? Check out this [chart for many useful tools](https://s-media-cache-ak0.pinimg.com/originals/99/56/4b/99564bbed9a2c64c7ba6ca2f7511a4c3.png).

---

<div class="post-metadata">

**Author:** ![redneckbob](https://avatars.discourse-cdn.com/v4/letter/r/73ab20/32.png) [@redneckbob](https://forum.mautic.org/u/redneckbob)\
**Post date:** [April 16, 2017, 2:36am UTC](https://forum.mautic.org/t/mautic-with-1m-records/8196/4 "2017-04-16T02:36:22Z")

</div>

I need to make a very serious point of clarification here, that would be “couple million emails sent out per day” not 100M records.

I should not post on the internet when it’s past my bedtime.

---

<div class="post-metadata">

**Author:** ![JoPitts](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/jopitts/32/636_2.png) [@JoPitts](https://forum.mautic.org/u/JoPitts)\
**Post date:** [April 19, 2017, 2:33am UTC](https://forum.mautic.org/t/mautic-with-1m-records/8196/5 "2017-04-19T02:33:30Z")

</div>

@lvocella,  
what performance issues are you having? If you define the problem a little more clearly, people will be better able to help you out.

BTW - I’m with @redneckbob, for a DB with well over 8 million records, 8gb sounds low. I presume you are running the DB on the webserver? Maybe separating the two might be a good start?

Cheers  
Jo

---

<div class="post-metadata">

**Author:** ![Yosu\_Cadilla](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/yosu_cadilla/32/6206_2.png) [@Yosu\_Cadilla](https://forum.mautic.org/u/Yosu_Cadilla)\
**Post date:** [October 17, 2019, 11:24am UTC](https://forum.mautic.org/t/mautic-with-1m-records/8196/6 "2019-10-17T11:24:00Z")

</div>

Hello @lvocella,

Check this guide about Mautic requirements that I’ve just published:

> **[Mautic Installation: Mautic Hardware Requirements | mauteam.org](https://mauteam.org/infrastructure/mautic-installation-mautic-hardware-requirements/)**
>
> The adequate amount of hardware resources you will need for your Mautic installation will depend on the Mautic features you will be using. Find out how to accurately define the Mautic Requirements for…