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 it
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, apache2.
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 , myphpa
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
www.the-infoshop.c
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 compl
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
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 Gener
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 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: h
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
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 arc
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 se
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
tog
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
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:
http://forge.mysql.com/wiki/Interaction_Between_Optimizer_and
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...
>
> http://www.mysql.com/news-and-e
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 a
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
goo
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 p
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 trou
21 matches
Mail list logo
