Devam Ediyor

optimizing mysql

We have two tables in mysql database([url removed, login to view]). One table has 300 records another table (myisam) has 50 millions records. We will provide you three queries with seven filter condition and 5 order by. We like to optimize those three queries, so that when we add different combination of filter conditions or all filter conditions and different order by, we need to expect the result by 250 msec. Our server has 4 cpu and 4 GB RAM. We also provide you the conf file. When we provide the data, we will provide for 8millions records and you need to make it into 50 millions records.

Deliveries: 50 million records table, different combination of three queries, filters and order by with performance timing. We will also test that and ensure we meet the performance.

Beceriler: MySQL

Daha fazlasını görün: optimize mysql, mysql optimizing , mysql server performance, mysql performance test, database optimizing, mysql optimize, optimize cpu, performance order cpu, cpu performance, optimize database mysql, order cpu performance, mysql gb ram, gb database, cpu mysql, order cpu, 2013 mysql, mysql need optimize, database queries mysql, mysql queries file, optimize mysql performance, mysql 2013, add result mysql, cpu performance order, mysql optimize cpu, mysql million records

İşveren Hakkında:
( 0 değerlendirme ) United States

Proje NO: #4398556

Seçilen:

boygiandi

Hi. I'm expert in mysql. I can do this project for you very fast and quality.

0 gün içinde 100$ USD
(29 Değerlendirme)
5.2

9 freelancer bu iş için ortalamada 314$ teklif veriyor

gopalvora

Hi ready to start Thanks

in 5 gün içinde267$ USD
(66 Değerlendirme)
6.1
meet2amitvw

Hello I will implement the mysql query you will release milestone after you satisfied with the results. I am ready to start work immediately. Please see my work portfolio for the technical expertise. I would a Daha fazlası

in 3 gün içinde350$ USD
(32 Değerlendirme)
5.1
GandalfTheGrey

I am experienced Linux system and database administrator. I can try to optimize your queries but with current project description it is not possible to guarantee results that you require. What I can guarantee is querie Daha fazlası

in 3 gün içinde1050$ USD
(6 Değerlendirme)
4.1
Ivan83

Hi, I am an expert for database optimization. Could you please send me schema for both tables, along with indexes created on them and of course the queries you need to run? How fast are the queries now? Regards Daha fazlası

in 3 gün içinde165$ USD
(6 Değerlendirme)
3.2
visualcreativnes

Hi, we are the team of professional designers, developers and SEO experts. We will provide you work with high quality and professional build themes. Please check private message for further details.

in 3 gün içinde275$ USD
(1 Değerlendirme)
1.4
anonymed

interested, with heigh experience in mysql and data administration, i guarantee you the best results; pm me

in 3 gün içinde200$ USD
(0 Değerlendirme)
0.0
oobretenov

send me the schema of tables and query to see them

in 3 gün içinde220$ USD
(0 Değerlendirme)
0.0
datonil

Datonil is an IT consulting 24*7 Onsite and Remote MySQL DBA services firm helping corporations,apply and use technology for successful and profitable business growth for their databases. [url removed, login to view]

in 3 gün içinde220$ USD
(0 Değerlendirme)
0.0
santap2013

I have worked on database internals on many databases. I have solid experience in MySQL. I was a part of SUN team for mysql. I am confident I can do this. Pay after the job is 100% done and you are 100% sure that you Daha fazlası

in 15 gün içinde250$ USD
(0 Değerlendirme)
0.0