||...script which runs locally on my machine and uses MySQL. The script takes a long time to run (three hours)...CPU is used by MySQL.
I want someone to look at the MySQL statements, and optimize the system. I...be able to:
Change Memory Allocation
Change MySQL parameters
Create or change indexes
||PHP, Engineering, Software Architecture, Software Testing, MySQL
||Nov 3, 2005
||Nov 3, 2005Ended
||We need an optimization on a small MYSQL database structure with php code.
||PHP, ASP, .NET, Engineering, Software Architecture, Software Testing, MySQL
||Mar 2, 2006
||Mar 2, 2006Ended
||...one that I upgraded from. I believe its all in mysql, as basic queries that took less than 1 second before
||Jan 20, 2009
||Jan 20, 2009Ended
||I have a loarge mysql datbase with over 20,000 products in it.
It is very slow right now and it needs...coder's Seller Legal Agreement).
||MySQL, Anything Goes
||Mar 2, 2008
||Mar 2, 2008Ended
||I need only professional MySQL optimizer, I have dedicated server but my website is going very slow from
||Oct 27, 2014
||Oct 27, 2014Ended
|Optimize Lighttpd and MySQL
||...and SSD HDD.
We need help to optimize the lighttpd webserver and mysql for a high traffic website to
||Feb 27, 2013
||Feb 27, 2013Ended
|341274 Optimize apache and mysql
||...wordpress gets round 60 - 80k uniques a day httpd and mysql using too much cpu and crashing the server already...cache on my website so i need someone to Optimize apache and mysql so that it uses less cpu and can handle
||System Admin, Anything Goes
||Aug 9, 2009
||Aug 9, 2009Ended
|optimize mysql on server
||We are looking for person to optimize our server mysql. we have 64gb memory installed but still the site...slow due to mysql.
You will connect through teamviewer and do necessary adjustments so mysql works faster...faster.
Here is our output for mysql tuner.
>> MySQLTuner 1.3.0 - Major Hayden <>
||May 26, 2014
||May 26, 2014Ended
|URGENT: Optimize MySQL query
I urgently need the attached query optimized.
Please bid quickly and reasonably and I will select someone asap.
Use PMB for questions.
||May 11, 2011
||May 11, 2011Ended
|Optimize MySQL Queries
||We have a list of 9 MySQL slow queries that we would like a DB specialist to help us lower the query_time...should be easy to optimize for anyone who has extensive experience in writing MySQL queries.
We will...will provide to you:
1) a list of 9 MySQL slow queries along with query_time, lock_time, rows_sent, rows_examined
||Data Processing, Website Testing, MySQL
||Jun 17, 2013
||Jun 17, 2013Ended
|96310 Optimize mysql
||...site can be seen at: www pot space dot com
The mysql queries should be optimized and changed so that
||PHP, MySQL, Anything Goes
||Nov 10, 2006
||Nov 10, 2006Ended
|Optimize MySQL database and queries
||We have a web site with a MySQL database with some large tables, and other tables that will become large
||Nov 12, 2012
||Nov 12, 2012Ended
|Optimize MySQL Queries
||I have the following queries which needs to be optimized.
Sorting by a LEFT JOIN column is extremely slow even with index on vtb.v:
SELECT * FROM `content` LEFT JOIN `view` vtb ON vtb.id = content.id WHERE content.time>1234567 ORDER BY vtb.v DESC LIMIT 0, 10
Selecting row starting from a high row number is very slow even with proper indexes:
SELECT * FROM `content` ...
||Jul 10, 2014
||Jul 10, 2014Ended
|Optimize MySQL on dedicated server
||...and one 1 TB HDD, hosts one MySQL intensive site. Particularly the MySQL settings need optimization including...including reserving more memory (32 GB available) for MySQL.
||Nov 11, 2012
||Nov 11, 2012Ended
|Optimize MySQL Database
||...someone who is an expert in mysql & has lots of experience in optimizing mysql databases, so the site loads...iin my vps acct. My host, hostgator says, it is a mysql db problem, the db has to be optimized, too many...process:
mysql 0 131% 5.6 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --log-er
||Nov 22, 2012
||Nov 22, 2012Ended
||Dec 20, 2007
||Dec 20, 2007Ended
|Optimize Server & MySQL
||...portal/social network website. Our server including MySQL do need to be optimized and secured to handle thousands...as stable and secure as it can be, and also to optimize it according to our needs and according to our
||System Admin, Web Security, SQL
||Jun 8, 2009
||Jun 8, 2009Ended
|optimize MySQL query
||...if the queries are working, I need someone to optimize the whole proccess and make sure it is much much
||Jul 13, 2014
||Jul 13, 2014Ended
|519131 Optimize mysql database
||...very slow, using all my cpu. I need for you to optimize my database to make the site run faster. I need
||PHP, MySQL, Anything Goes, Database Administration
||Aug 23, 2011
||Aug 23, 2011Ended
|Help Optimize Mysql Queries
||...against my production database that I would like to optimize. I have slow.log enabled and it seems there are...seconds to run.
I.m running Your MySQL Server version: 5.1.61-log MySQL Community Server (GPL). The application...database server are on the same host.
The mysql tables are InnoDB type. There are roughly 70-80k
||Mar 15, 2012
||Mar 15, 2012Ended