Do you have innodb_file_per_table turned on ???
If this is off, then all your InnoDB data is going in /var/lib/mysql/ibdata1
You actually need to the following to recover all free space from all InnoDB
tables
I commented on this in
http://stackoverflow.com/questions/3927690/howto-clean-a-mysql
Dear all,
Today I performed the below commands on a 553 GB InnoDb table .
truncate table page_crawled;
optimize table page_crawled;
But I couldn't find the free space available after truncation. The
below structure is same as before truncation
/dev/sda2 29G 9.5G 18G 36%
Maybe some sort of logarithmic expression?
select no_of_jobs, 10 * log(10, no_of_jobs) as job_weight
from data;
Of course, you'd have to tweak your coefficients to match the weighting
system you want to use.
-Travis
-Original Message-
From: Richard Reina [mailto:gatorre...@gmail.com]
S
Is there a function that can limit the value of an integer in a MySQL
query? I am trying to write a query that scores someones experience.
However, number of jobs can become overweighted in the the query below. If
someone has done 10 jobs vs. 1 that's a big difference in experience. But
someone w
Thank you for your answers.
They are all in the same schema, the file system is ext3.
I cannot modify the app so it uses a table of table names, instead of show
tables.
I'll try a renice on the mysql process, so it doesn't kill the server.
Santiago Soares
Fone: (41) 8488-0537
On Thu, Feb 10, 201
FWIW, I've found MySQL information_schema related features to be quite useless
when you're dealing with that many tables. Not only do they take long, they
also activate a lot of locks (or so it seems). So I created a script that runs
every minute on each db server that basically does an "ls" i
By the way, the 'show tables' commands get stuck in the 'checking
permissions' state.
Santiago Soares
Fone: (41) 8488-0537
On Thu, Feb 10, 2011 at 4:48 PM, Santiago Soares
wrote:
> Hello, thanks for your answers.
> All of my tables are MyISAM.
> I found out that the application runs a lot of 's
Hello, thanks for your answers.
All of my tables are MyISAM.
I found out that the application runs a lot of 'show tables' commands.
These commands take a lot of time to run, due to the high number of tables
(~160k).
Is there anything I can do to make 'show tables' run faster?
Santiago Soares
Fone:
If you are brand new to mysql, you do not want to start with the
cluster. Try the community server distro instead:
here is a link to the 64-bit generic linux version:
http://dev.mysql.com/downloads/mirror.php?id=401067#mirrors
On Thu, Feb 10, 2011 at 10:33 AM, rohit bishnoi wrote:
> *hello ev
*hello everyone on list*
*i am a student of MCA and want to learn mysql. i have installed
"mysql-cluster-gpl-7.1.4b-linux-i686-glibc23" binary distribution on my
fedora 14 system. the installation process have gone OK according to steps
listed in distribution's installation file.*
*
*
*But when i
On Thu, Feb 10, 2011 at 2:15 PM, Santiago Soares
wrote:
> With a show global status I see a strange behavior:
> | Open_files| 286 |
> | Opened_files | 1050743 |
>
> At this time the database has just started (about 10 minutes).
>
That's quite a
Do you queries stay stuck in any particular status? (Writing to net,
Opening/Closing tables, Copying to temp table?)
What kind of disk sub system do you have? What other hardware do you have?
What is the primary engine type?
JW
On Thu, Feb 10, 2011 at 7:39 AM, Santiago Soares
wrote:
> I'm not su
I'm not sure I made myself clear:
The problem is not disk usage, but CPU time waiting for I/O, which is very
high.
Any ideas?
Santiago Soares
Fone: (41) 8488-0537
On Thu, Feb 10, 2011 at 11:15 AM, Santiago Soares
wrote:
> Hello,
>
> We have a database with about 160k tables. This database is c
Hello,
We have a database with about 160k tables. This database is causing very
high disk usage.
I'd like to know if there is anything we can do to optimize the database, in
order to reduce disk usage.
With a show global status I see a strange behavior:
| Open_files| 286
Hi,
I have a situation where I need clients to connect to a proxy server and to
then determine which MySQL server to forward their connection to based on
the username supplied. Does anyone know if this is possible using
mysql-proxy with Lua? Or by any other means?
Thanks.
REW
Hmm, I haven't seen the mail from Singer, yet.
On Thu, Feb 10, 2011 at 9:33 AM, Ananda Kumar wrote:
> On Thu, Feb 10, 2011 at 1:58 PM, Singer X.J. Wang wrote:
>
>> mysqldump -u[user] -p[pass] --where="db=`whatyouwant` and
>> name=`whatyouwant`" mysql proc
>>
>
Yes, I thought of that, too; but th
sorry, my bad.
Its -R and not -p.
regards
anandkl
On Thu, Feb 10, 2011 at 1:58 PM, Singer X.J. Wang wrote:
> Remember that procedure is defined per database,
>
> mysqldump -u[user] -p[pass] --where="db=`whatyouwant` and
> name=`whatyouwant`" mysql proc
>
>
> On Thu, Feb 10, 2011 at 02:55, Anand
17 matches
Mail list logo
