Bernd Jagla wrote:
sar will give you some basic information about what happens on the
system... (see e.g.: http://linux.die.net/man/1/sar)...
Munin (http://munin.projects.linpro.no/) will generate graphs and stats
over time for system usage (cpu, mem load, disk usage etc) and includes
good
Hi Vanish,
redhat by default installs a old version of mysql.
execute this command and check if two version 's of mysql are there
rpm -qpl MySQL-server-VERSION
On 11/20/07, vc [EMAIL PROTECTED] wrote:
i install mysql 5.0.22 with php 5.2 on my redhat 9 installation.
after i first lunch
i install mysql 5.0.22 with php 5.2 on my redhat 9 installation.
after i first lunch phpmyadmin , it says
Your PHP MySQL library version 5.0.22 differs from your MySQL server version
3.23.32.
i am quite sure there is no mysql 3.23.32 installed in my system . anyone has
the same kind of
Hi all,
just a simple question :
Does the query ANALYZE position reads and/or writes locks ?
I read these two pages but I didn't find the answer...
http://www.mysql.com/news-and-events/newsletter/2003-04/a000155.html
http://dev.mysql.com/doc/refman/5.0/en/innodb-restrictions.html
Thanks
It locks the table for both.
regards
anandkl
On 11/20/07, Thomas Raso [EMAIL PROTECTED] wrote:
Hi all,
just a simple question :
Does the query ANALYZE position reads and/or writes locks ?
I read these two pages but I didn't find the answer...
Hi,
this Thursday, Sergey Petrunia will give a MySQL University session on:
Interaction Between Optimizer and Storage Engine
Please register for this session by filling in your name on the session
Wiki page that you can find here:
Mohammad wrk wrote:
Hi Eric,
In the case of a yes answer to the second question below, can't we
still use something like VPD (Virtual Private Database) in MySQL?
Thanks,
Mohammad
Hi,
I don't know much about Oracle, but I looked this up. MySQL can't do it,
that I know of. Here is the
No one probably wants to go through the trouble to code this solution but it
is possible to use MySQL Proxy to filter the SQL statements and results.
MySQL Proxy sits in between MySQL Server and the MySQL Client.
It can read queries, modify them, send queries to the server or deny them all
Russell E Glaue wrote:
No one probably wants to go through the trouble to code this solution but it
is possible to use MySQL Proxy to filter the SQL statements and results.
MySQL Proxy sits in between MySQL Server and the MySQL Client.
It can read queries, modify them, send queries to the
Afan, you'll need to have a date and time column in the database storing a
created at value, that is set on INSERT and then not changed.
Assuming you have such a column - let's call it created_at - you can run
queries like this:
/* to get count of records created on Mondays */
SELECT COUNT(*)
Hi,
I have to build a report - when (date and/or time) the records are
inserted. E.g., number of records inserted on Monday - doesn't matter
what month.
Or, number of records inserted on specific date between 8am and 4pm.
Thanks for any help.
-afan
--
MySQL General Mailing List
For list
Yup! That's it!
Thanks Dan.
;)
The link is really helpful. I was looking for it on mysql but was able
to find. Looks like I didn't try hard. :)
-afan
Dan Buettner wrote:
Afan, you'll need to have a date and time column in the database storing a
created at value, that is set on INSERT and
Hello to everybody!
I have read some messages about this topic but i haven´t resolved my problem
yet. I am using mySQL Query Browser to make de schema. And i have a table
(product) where there are some attributes (producto, precio,
nUds,tipo)(spanish). All are relationated with one product (ex:
Hi,
I have read some messages about this topic but i haven´t resolved my
problem
yet. I am using mySQL Query Browser to make de schema. And i have a table
(product) where there are some attributes (producto, precio,
nUds,tipo)(spanish). All are relationated with one product (ex: heineken
beer).
Hello!
I have read that. But i have not idea what i have to do. Because i´m amateur
in this topic.
Thank you
--
View this message in context:
http://www.nabble.com/IMAGES-PICTURES-MYSQL-tf4845682.html#a13865352
Sent from the MySQL - General mailing list archive at Nabble.com.
--
MySQL
It all comes down to what you are most comfortable with. What I have done is
to name each image file with a serial number (1.jpg, 2.gif, 3.png, ...) and
store the path along with the real name of the image in a table row. Doing
it this way means that you don't need to program logic to convert a
I have a merge table that is a union of 20 1 million row tables. Select
rows from it is quite fast. However if I want to delete all the rows as in:
delete from MyMergeTable;
it takes just over 3 minutes. I could execute 20 separate delete statements
for each of the 20 tables and it would
Does TRUNCATE work on a merge table? I honestly don't know, but it should be
faster than a DELETE for removing all of the records.
Regards,
Jerry Schwartz
The Infoshop by Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
Thanks Ananda ,
I tried , i tried to uninstall the maybe-preinstalled mysql, but rpm tells me
that there is no mysql installed in my system .
I listed all the rpm packages in my system . I am quite sure there is no rpm
mysql package .
I installed the php 5.2.0, mysql 5.0.22, apache2.2.6 ,
vc wrote:
Thanks Ananda ,
I tried , i tried to uninstall the maybe-preinstalled mysql, but rpm tells me
that there is no mysql installed in my system .
I listed all the rpm packages in my system . I am quite sure there is no rpm
mysql package .
I installed the php 5.2.0, mysql 5.0.22,
mos wrote:
I have a merge table that is a union of 20 1 million row tables. Select
rows from it is quite fast. However if I want to delete all the rows as in:
delete from MyMergeTable;
it takes just over 3 minutes. I could execute 20 separate delete
statements for each of the 20 tables and
21 matches
Mail list logo
