Закрыт

MySQL DB and Tomcat tuning

I have an existing web site hosted by [url removed, login to view] that needs to run faster. I'd like someone to focus on tuning the database portion of the application. Currently the site gets about 3 million page views a month. To give you a better idea of the scope of the project, the MySQL database has 10 tables. The number of records in these tables are:

28362407

1087676

527549

215603

31207

29996

25883

4852

107

40

New rows are frequently added to the largest tables, but data is rarely deleted.

There are probably only about a dozen JSP pages that account for 95 percent of the sites activity. All of these JSP pages access the database by calling methods in a single java class. This java class has about 2400 lines of code and uses JDBC PreparedStatements to access the database.

My plan would be to setup a copy of the site on another server and have you use some program to simulate users accessing the application. You'd need to measure the site's performance under this simulated user load. Then gradually increase the number of users and monitor the site's performance. Then you could make whatever changes you think are necessary and retest how the application responds.

Навыки: Apache, Java, JSP, Linux, MySQL

Показать больше: tomcat mysql tuning, mysql tomcat tuning, mysql java tuning, mysql db, mysql data access, largest number, jdbc in jsp, java jsp mysql tuning, tuning mysql tomcat, mysql tuning java, TUNING, tomcat, simulate, s+db, performance tuning, mysql copy, java tomcat, java performance tuning, java monitor, java jdbc

О работодателе:
( 5 отзыв(-а, -ов) ) Mustang, United States

ID проекта: #886151

38 фрилансеров(-а) готовы выполнить эту работу в среднем за $1006

AshwinSen

Hello, Please view PMB. Ashwin

$1200 USD за 15 дней(-я)
(41 отзывов(-а))
5.7
techstyle

Please see my message in PMB.

$1200 USD за 30 дней(-я)
(9 отзывов(-а))
5.1
amendatech

Please see PMB

$1500 USD за 25 дней(-я)
(1 отзыв)
4.5
schipowski

Hi Plz check private message

$750 USD за 7 дней(-я)
(2 отзывов(-а))
3.2
marscoders

Please check post message box.

$750 USD за 10 дней(-я)
(1 отзыв)
1.8
kasimsaeed

Please Check PMB

$1300 USD за 35 дней(-я)
(1 отзыв)
1.4
javaj3d1

Hello I can do this for you. Check your PM.

$750 USD за 45 дней(-я)
(1 отзыв)
1.0
linusworld

Hi, I am most suited with your requirement, pl. check PM why i am. Pl check PM and my profile also.

$750 USD за 2 дней(-я)
(1 отзыв)
1.0
frondoso

Hello, we are a highly professional team with 6 years experience on Java technologies, working on enterprise-level projects on 4 different countries (Chile, UK, Turkey & US). We are highly skilled on DB optimization Больше

$2500 USD за 90 дней(-я)
(0 отзывов(-а))
0.0
softashu

Dear sir i am very intrested in this project. The project highly matched with my regular work. Please have look on PM for more details Thanks Ashutosh

$900 USD за 20 дней(-я)
(0 отзывов(-а))
0.0
piampri

Hi there, I am a graduated Computer Engineer working out of Toronto , Canada in the telecommunications / mobile marketing industries. I have 6 yrs of experience in the area of Enterprise Java Development and use it Больше

$1000 USD за 20 дней(-я)
(0 отзывов(-а))
0.0
bheemsinh

I'd love to code your project requirement, with a bug free shape.

$750 USD за 25 дней(-я)
(0 отзывов(-а))
0.0
sandeepbpatip

dear sir i have my own hosting server with private JVM service and 128 heap size If you need i can offer the [login to view URL] give me chance to work with you. thanking you sandeep

$1000 USD за 10 дней(-я)
(0 отзывов(-а))
0.0
larryzhou

standard issue.

$1200 USD за 17 дней(-я)
(0 отзывов(-а))
0.0
pankajrastogi

I have good experience over Java, Hibernate, Spring, JSP and MySQL tuning. Just try me I will give you more than your expectation. [login to view URL]

$750 USD за 30 дней(-я)
(0 отзывов(-а))
0.0
kkdhanesh

Please see the PM

$900 USD за 20 дней(-я)
(0 отзывов(-а))
0.0
KamalChandarana

I'll be able to do this very effectively as i have very much experience of this kind of application. I'll surely complete in 30 days . Thanks

$1000 USD за 30 дней(-я)
(0 отзывов(-а))
0.0
chauhanprakash

Hello Sir, I am SUN Certified Java Developer having an experience of 2 years in developing web application using J2EE and related technologies. Please check Private Message Board.

$1500 USD за 30 дней(-я)
(0 отзывов(-а))
0.0
javafreelancer03

I have 6.6 years experience in developing Java, J2EE based web applications. I would be definitely able to deliver quality deliverable on time. Please check your PMB for more details.

$1500 USD за 45 дней(-я)
(0 отзывов(-а))
0.0
freetedsky

I am an J2EE expert, I want to help

$750 USD за 2 дней(-я)
(0 отзывов(-а))
0.0