Hello,
I´m using MySQL-4.1.7, and I have a query that seems,
even using where clause, an specific table isn´t being optimized
properly:
I have four tables:
real_state: cod, name, city, ag_cod, sell
agency: cod, name, ag_status
front: cod, rs_cod, ag_cod
photo: cod, rs_cod
These table have the
Eric,
Can you send us the actual show indexes from table and explain output that
isn't shortend?
Thank you for answer my question.
Actually, the real query and tables are much more complex than
the data in the previous message.
A just tryed to optimize the information for you better understan
Octavian,
I am using a MySQL database on a web site, and I would like to know what
happends if someone searches in the database using a form, but after a few
seconds MySQL starts the query, that user hit the "Stop" button of the
browser.
Will MySQL continue its searching and also create the cach
Hello,
I´m using MySQL-4.1.7 and I need to create a UDF.
For all I have understood, I need to create it in C/C++ sintaxe.
My doubt is: Is it the only way to have UDF server-side in MySQL(4.1.x)?
Do I need to learn C/C++ to have a UDF?
Thanks,
Ronan
--
MySQL General Mailing List
For list ar
Marko,
I have a table with 5,000,000 records that takes about 1 second
to show the results.
Perhaps your queries aren´t optimized properly.
Ronan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Martijn,
I have a table with 5,000,000 records that takes about 1 second
to show the results.
All rows?
No. The queries return an average of 30 rows.
I just wanted to say that the problem isn´t the table size, but the
query X indexes used.
Ronan
--
MySQL General Mailing List
For list ar
Marko,
Do you have an index "deleted + name" on the accounts table?
How many rows have "deleted=0"?
Can you apply any more filter in the users table (like date)?
You are requesting all rows.
How many rows do you have in the users table?
Ronan
--
MySQL General Mailing List
For list archives:
that depends because SugarCRM doesn't delete anything from DB just marks
item as deleted using this field.
Do you have an index for deleted column?
It should help.
Can you apply any more filter in the users table (like date)?
You are requesting all rows.
no, because purpose of this query is
I have following query:
SELECT SQL_NO_CACHE users.user_name assigned_user_name, accounts.* FROM
accounts LEFT JOIN users ON accounts.assigned_user_id=users.id where
(accounts.assigned_user_id='1') AND accounts.deleted=0 ORDER BY
phone_office asc LIMIT 620300,20
In your opinion, what group
Hi,
Suppose a simple query:
SELECT
client_name as name
FROM
clients
WHERE
client_id = $client_id
Using JDBC 5.0.8 it returns column name as "name", that it's the
expected for me.
Using JDBC 5.1.7 it returns column name as "client_name", although I
have asked for an alias.
Is it ri
Hi,
I installed MySQL-5.0.67_1.
When I execute "CHECK TABLE information_schema.COLUMNS FOR UPGRADE" I
get the message:
++---+--++
| Table | Op| M
Hi,
Does anybody has a tip to install a MySQL Cluster in a Linux CentOS-5?
Is it better from source or can it be from yum?
I do prefer yum because it's easier for upgrades, but I don't know if
the available package was compiled for that.
Thank you,
Ronan
--
MySQL General Mailing List
For list
Moon's
Moon's Father escreveu:
You may execute mysql_fix_privileges_table script to upgrade all of your
mysqld.
I did it, but the problem persists... :-/
+-+---+--++
Hi,
Yesterday I had a problem in a InnoDB table that I needed
to DROP and reimport the table.
When I tryed to reimport the table, most of the data was lost.
So, I´ve tryed to reimport the data from the backups (created via
mysqldump) and these datas were still corrupted.
So, it brings to my min
Graham,
/usr/local/bin/mysqldump: Error 5: Out of memory (Needed 14154840 bytes)
when dumping table `Attachments` at row: 24285
Did you changed the values of MAXDSIZ in the kernel file?
I use this:
options MAXDSIZ=(1536UL*1024*1024)
for MySLQ can you up to 1,5 Gb of RAM memory.
I r
Graham,
I was under the impression that in FreeBSD 5, you didn't need to change
the kernel, just the entry in /boot/loader.conf...
Even if you use kern_securelevel="1"?
Ronan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.c
Hello,
I have a table where is saved all site´s access:
access
id
year
month
day
weekday
hour
minute
ip
Any column has multiple lines, and I have the follow query
that returns the amount of access per day of month:
SELECT year, month, day, COUNT(*) AS access
FROM access
WHERE year = 2005
AND
Mathias,
Hi,
look at group by ... with rollup at :
http://dev.mysql.com/doc/mysql/en/group-by-modifiers.html
Thank you very much for your help.
My needs aren´t this, exactly.
GROUP BY WITH ROLLUP, returns me several lines of the
same day (one per IP), plus the total.
I need that every year-month-da
Mathias,
To drop multiple IP, you can use distinct :
mysql> SELECT year, month, day, group_concat(distinct ip),count(*) AS
access
-> FROM access
-> WHERE year = 2005
-> AND month = 5
-> GROUP BY year, month,day
-> ORDER BY year, month, day;
+--+---+--+---
Hi,
I´m having a serious performance problem with my MySQL.
The CPU is most of time with a load of 60%-95%.
I´m using MySQL-4.0.14 on a FreeBSD-5.1 box.
It´s a Celeron-2.0 Ghz - 512 Mb RAM - 40 Gb of Hard Disk.
I think the main problem the queries struct wrongly build,
but at this time I need to
Mike,
> Ronan,
> You haven't given us much to go on.
I´m sorry.
> Is this application running on a web server?
Yes, but in a diferent machine connecting via TCP/IP.
> 1) How many rows are your queries returning? (on average) and how long
does
> it take?
Hmmm... Most of the queries are l
Mike,
> Ronan,
> If your queries are only returning fewer than a hundred rows, and
> if every join is indexed, I would have expected it to take only a second
or
> two at most.
I´m sorry, but I´m not so good in SQL queries, rather joins.
If my queries are taking about 15 seconds instead
Hello,
We have an MySQL-4.0.14 Server installed and sometimes the
it takes 90% from CPU.
So, my question is:
Is there a way to know what is taking so many CPU process?
What query is causing such problem?
Thanks
Ronan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mys
Hello,
I tried to migrate a database from a MySQL-4.0.14 to another
one hardware with MySQL-4.0.17 installed.
The database has InnoDB tables and I just executed a:
# mysqldump -A --user root --password=my_password > dump_db.txt
in the old server (MySQL-4.0.14) and
# mysql -u root -p < dump_db.
> Hi,
Hi,
> Can anyone help me that i want to view all the record from a table,
but in mysql control centre, i only can view the first 1000 records, can
anybody teach me how to make it can view for all the rest of the records?
Click with the right button in the table´s name -> "Open table" -
Hi All,
A short question:
If I have a slave MySQL Server (updating via logs).
Supposing the master MySQL (for any reason) goes down.
The users start using (and updating) the slave database.
When the master MySQL goes up. Does it will update it´s data
from the slave database?
Thank´s
Ronan
--
Hi All,
I executed a SHOW PROCCESSLIST command and
it returned me 39 rows which 21 of than show "Sleep"
in the column "Command".
What does this tell me?
Thank´s,
Ronan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMA
Jeremy,
> On Wed, Feb 18, 2004 at 04:01:57PM -0300, Ronan Lucio wrote:
> > Hi All,
> >
> > I executed a SHOW PROCCESSLIST command and
> > it returned me 39 rows which 21 of than show "Sleep"
> > in the column "Command".
> >
> >
Martijn,
> > > 21 threads are idle.
> >
> > But, what could make so many threads get idle?
>
> Connecting, but don't doing anything.
>
> > Shouldn´t the queries just be executed, return the results and
> > be closed?
>
> If you don't close your connection, what do you expect?
>
> > Does this mean
Hi All,
I´m trying to do some customization in a MySQL-Server-4.0.17
to gain a better performance.
We have a Intel P4-2.4 Ghz with 1 Gb RAM and 40 Gb HD
on a FreeBSD-5.2.1 box dedicated for MySQL.
My trouble is when I create the my.cnf file and start MySQL.
MySQL don´t stat.
the /usr/local/mysq
Hi All,
I´m trying to do some customization in a MySQL-Server-4.0.17
to gain a better performance.
We have a Intel P4-2.4 Ghz with 1 Gb RAM and 40 Gb HD
on a FreeBSD-5.2.1 box dedicated for MySQL.
My trouble is when I create the my.cnf file and start MySQL.
MySQL don´t stat.
the /usr/local/mysq
Hi All,
I created a user "dfn" and I granted access to only the
database "dfn".
Now, if I log as dfn user query for "SHOW DATABASES", mysql
returns me the error:
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)
Would anybody know what could be wrong?
Thank's
Ronan
Mike,
On Fri, 13 Jun 2003 08:38:32 -0600
"Mike Hillyer" <[EMAIL PROTECTED]> wrote:
> Did you GRANT SHOW DATABASES to the user? If not then they will not be
> able to use the command. The SHOW DATABASES GRANT clause is a new
> addition.
I'm sorry but I don't have experience with MySQL.
Actually,
Mike,
On Fri, 13 Jun 2003 08:59:09 -0600
"Mike Hillyer" <[EMAIL PROTECTED]> wrote:
> GRANT SHOW DATABASES will allow a user to see all databases, whether the
> user can access them or not.
How should I securely grant SHOW DATABASES to an user?
GRANT SHOW DATABASES ON mysql.db to [EMAIL PROTECTE
gt;
> I think the syntax is GRANT SHOW DATABASES TO dfn@"%";
>
> But I personally do not use it.
>
> Regards,
> Mike Hillyer
> www.vbmysql.com
>
>
> -Original Message-
> From: Ronan Lucio [mailto:[EMAIL PROTECTED]
> Sent: Friday, June 13
Hi,
I have a situation like this:
Table People
=
people_ID
people_name
people_friend_ID
people_friends_ID is the people_ID from another record.
Is there a way to make a SELECT that returns people_name
and people_friend_name?
Perhaps I´d get this with sub-selects but I´m using MySQL-4.0
Hi,
I have two tables:
TABLE_1
===
- id
- name
TABLE_2
===
- id
- table1_id
- name
How could I make a select on table_1 that returns me only the
rows that don´t have any reference in table_2?
Any help would be appreciated.
Thank´s,
Ronan
--
MySQL General Mailing List
For list arch
LEFT JOIN TABLE_2 t2
ON t1.id = t2.table1_id
WHERE t2.id is null
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
"Ronan Lucio" <[EMAIL PROTECTED]> wrote on 10/27/2004 10:12:42 AM:
> Hi,
>
> I have two tables:
>
&g
Hi All,
I have o little (I think) doubt:
If I use a query UPDATE LOW PRIORITY and right after
I execute a SELECT in the same table/column.
Will I receive the correct result or only after MySQL commit
the data?
Any help would be appreciated,
Thanks,
Ronan
--
MySQL General Mailing List
For li
> What is "the correct result"?
The correct result is the data in the updated column after commit.
For example, if I have:
Table1
=
- id
- name
INSERT INTO Table1 (id, name) VALUES (1, 'AAA')
UPDATE LOW PRIORITY Table1
SET name = 'BBB'
SELECT name
FROM Table1
Will it return BBB?
Thanks,
Jay,
> From TFM, "If you specify the LOW_PRIORITY keyword, execution of the
> UPDATE is delayed until no other clients are reading from the table."
Yes, I had alread read it, but it only specify when the data
will be commited, not what will be returned.
Let´s change the question:
Before the tha
Gleb,
> So, when it returns, all updates will be commited and select statement
will return the correct result.
It´s exactly what I´d wanted to know.
Thank you very much,
Ronan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.
Hi,
I have a MySQL-4.0.18 installed on a FreeBSD system.
When I run the follow query:
DELETE
FROM table
WHERE client_id = 1
AND row_id IN (2,5,7)
only the first record is deleted.
Am I doing something wrong or is it a MySQL bug?
Thanks
Ronan
--
MySQL General Mailing List
For list archives:
Jay,
> It is not a bug, just say it out loud
> "AND row_id is 2 OR 5 OR 7"
>
> Once the OR condition is satisfied once, the query will halt.
The problem is that if I use OR in the where clause, MySQL wont
use the indexes in the row_id column.
One important thing that I forgot to say is I ru
Michael,
> What are you talikng about? Queries don't halt on the first row matched.
> For example:
It´s my thought, too. But it isn´t happen in my MySQL Server.
Now, doing the same tests you did I got the same results of you.
Well, I´ll inspect my code again looking for some error that I
didn´t
Hi,
I think I found out what was wrong.
ColfFusion has a tag that prevents
SQL Injection.
Probably was removing anything after comma.
Without using the code works perfectly.
So, I had to create a UDF to remove everything except digits and commas.
Thanks in advance,
Ronan
--
MySQL Ge
Hello,
I wondering about Subqueries X Joins.
What is the fastest technic?
I´ve read the Manuals and I found some texts saying Joins are faster
and other saying Subqueries are faster.
Well, if both so. When Subqueries are faster and when Joins are faster?
If this question has been answered befor
Carlos,
Give us more details about our system:
What are the table types you´re using?
What are the configs in your my.cnf file?
Ronan
- Original Message -
From: "Carlos Augusto" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, November 23, 2004 3:41 PM
Subject: Mysql Performan
Carlos,
> 041124 14:13:18 Innodb: fatal error: cannot allocate 2147500032 bytes of
> innodb: memory with malloc! total allocated memory
> innodb: by inndodb 16975556 bytes. Operating system errno: 8
> innodb: Cannot continue operation!
> innodb: check if you should increase the swap file of ulimit
Calos,
> Well i didn´t change nothing at no config file. Any suggestions?
> thanks.
If you didn´t change anything, it´s supposed to be time to you
configure the my.cnf file.
A better tunning should solve your problem.
Ronan
--
MySQL General Mailing List
For list archives: http://lists.mysq
Hi All,
I´m having a trouble where my server is falling to it's knees
when a certain number of connections are match.
Well, in a short, I configured the my.cnf files to accept up to
120 connections. When the server receives about to 55
connections, it hangs the connections and I don´t get me
even
Sasha,
> Ronan:
>
> InnoDB complains it cannot allocate memory. With your configuration you
are
> likely to run out of memory:
>
> You are telling InnoDB to allocate at least 256 MB + 20 MB for the buffer
pool.
> On top of that, you are telling MyISAM to use 384 MB for the key buffer.
So this
> is
Ajay,
Could you send the error messages (.err file in the mysql dir)
and your my.cnf file?
Ronan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi,
Has anyone any benchmark between 4.0 and 4.1?
MySQL website says that version 4.0 has some performance
improvements but I´ve heard that MySQL-4.0 is 20% faster
than MySQL-4.1.
Thanks,
Ronan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:h
Hi,
I need to import a dump from a mysql-4.1 to mysql-4.0.
I have already read the MySQL Manual page but I didn´t
find the answer, even importing the data with the option
--default-character-set=latin1.
When executed mysql < dump.sql, it happend an error
because mysql-4.1 generates the dump inclu
Hi,
Now I found this line the MySQL Manual:
"
If you run mysqldump without the --quick or --opt option, mysqldump will
load the whole result set into memory before dumping the result. This will
probably be a problem if you are dumping a big database. As of MySQL
4.1, --opt is on by default, but c
Frank,
If you provide more informations like the query and how
many rows it returns, it should be easier help you.
Ronan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hmmm...
The MySQL-client is 4.1.7, too?
I realy don´t know if it make some difference, but perhaps
it does.
Ronan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Frank,
Wouldn´t it because the client driver (ODBC version)?
Perhaps it´s faster in the local server because it uses a mysql-4.1.7
client.
Ronan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Chris,
> Quick question. What's a reasonable length for a notes-type field? I
> couldn't really find any guidelines on the web so I'm thinking of just
> setting it to 65,535. Or is that ridiculously long?
For performance reasons, the data type should be as short as possible.
Ronan
--
M
Jeff,
>> Has anyone any benchmark between 4.0 and 4.1?
>>
>> MySQL website says that version 4.0 has some performance
>> improvements but I´ve heard that MySQL-4.0 is 20% faster
>> than MySQL-4.1.
>
> As far as what? Thats a very general statement. How do you even know that
> affects you?
The fol
>> Once I plan to run FreeBSD-5.3 + MySQL-4.1.7 in my server, it can
>> affect me.
>
> I may have missed it, but myisam, or innodb?
Both, because I have tables that have few inserts and too few
updates/deletes,
like states, cities and so on, but I plan transform every table in InnoDB to
avoid corr
Jeff,
>> Both, because I have tables that have few inserts and too few
>> updates/deletes,
>> like states, cities and so on, but I plan transform every table in InnoDB
>> to avoid corruption issues.
>
> Nothing here has slowed down. A few innodb stuff I use, has, but thats
it.. I
> run linux on a
Greg,
> Never had table corruption, though I have had index corruption in myisam
> tables many times on sound hardware. Usually, this is due to an unclean
> shutdown, though I have seen it happen other times when the server is
> supposedly running with no problems. A repair table tablename alw
Hi,
I need to increase the innodeb_log_file_size parameter,
but when I set it higher, mysql don´t starts and give the
follow erro:
041210 13:27:40 mysqld started
InnoDB: Error: log file ./ib_logfile0 is of different size 0 100663296 bytes
InnoDB: than specified in the .cnf f
Anil,
> First shutdown the mysql cleanly.
>
> #mysqladmin shutdown
>
> then drop log files in data directory.
>
> restart mysql. it will create new log files.
Do you know if is there a risk of loosing any data?
Thanks,
Ronan
--
MySQL General Mailing List
For list archives: http://lists.mysql
Hello,
Is there a way to create my own function on MySQL (4.0.18)?
We have a site where a product can have it´s price in differents
currencies, so, I need to make a query that returns the correct
product´s price.
Thanks,
Ronan
--
MySQL General Mailing List
For list archives: http://lists.mys
Anil and Oropeza,
> if mysql shutdowns cleanly. then there is no chance of loosing data. for
> safe side take compleate database backup.
Ok, thank you very much for your help.
Ronan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.m
Hello,
Supposing I have 2 tables:
product
==
- id
- name
price
=
- id
- product_id
- sell_price
- rent_price
If I want to make a SELECT for the products having the
rent_price between 300,00 and 500,00, so I use the query:
SELECT rent_price
FROM product
LEFT JOIN price ON (product.id =
Hello,
Trying to keep the database and the application fast,
I´d like to clearify my mind about it.
1) Is a SELECT DISTINCT over 5,000 records a weight
query? (Supposing it has about 20 different option the the
DISTINCT key).
2) Is SELECT ORDER BY RAND() over 1,500 records
a weight q
Greg,
Thank you very much for your help.
> An index the full size of the distinct key is probably very quick
especially
> if it only has 20 distinct values. OTOH, if you already know you have a
> small number of distinct values, could you just store them normalized in a
> different table?
Actua
Sasha,
> I assume you mean "has serious performance impact" when you say "weight".
If
> this is not what you meant, please correct/clarify.
Yes, you´re right.
>>
>> 1) Is a SELECT DISTINCT over 5,000 records a weight
>> query? (Supposing it has about 20 different option the the
>> DISTIN
Shawn,
Thank you very much for your tips.
I´ll do that.
Ronan
- Original Message -
From: <[EMAIL PROTECTED]>
To: "Ronan Lucio" <[EMAIL PROTECTED]>
Cc:
Sent: Tuesday, January 18, 2005 6:36 PM
Subject: Re: Doubt about Performance
"Ronan Lucio" <[EMAIL
Hi,
I sorry for I neither didn´t find the information that I need in
the documentation nor found the correct words for a search
in the mailing archivers.
I have a query like this:
SELECT cod, descr
FROM table
WHERE AND cod != 7
AND cod != 10
AND cod != 13
AND cod != 14
Mayuran,
Well, I´m not a MySQL expert, but I think that a good
configuration in the my.cf file can make it better.
Ronan
- Original Message -
From: "Mayuran Yogarajah" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, August 26, 2004 5:37 PM
Subject: huge innodb data files
Ou
Hello,
I had a problem with our MySQL server-4.0.18 where
it suddenly stoped working.
Even a KILL command didn´t killed the mysqld process.
I looked for any error message in the file
/usr/local/mysql/hostname.err, but I couldn´t see any error
message about such time.
Does anyone knows what could
> I want to copy data from one table to another. However I need to do this
> carefully because I haven't got much of space left. I was thinking of
maybe
> selecting data from every 10 rows of the old table, inserting it into
> the new table, then deleting those rows from the old table.
>
> Coul
Hello,
A have two tables:
City:
CityID
CityName
Client:
ClientID
ClienteName
CityID
How can I make a SELECT that returns me only the cities
that have more than 30 (example) clients?
Thanks,
Ronan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/my
Shawn
> SELECT CityName, Count(ClientID) as ClientCount
> FROM City
> INNER JOIN Client
> on City.CityID = Client.CityID
> GROUP BY CityName
> HAVING ClientCount > 30;
Thank you very much,
It should solve by problem... :-)
Ronan
--
MySQL General Mailing List
For list archives: http:/
Hi,
Supposing we have for tables:
One master table (student) and three independent tables.
There is no relationship between them.
Each of the three table have a relationship with table student.
City | Teacher | TestLocal
| === | =
city_id | teac_id | test_id
cit
Hi All,
I always worked with MySQL on FreeBSD systems.
Now I need to install am MySQL with InnoDB and MyISAM
tables in ta Linux RH system.
So, do I need to care about the Linux file size limitation of 2 Mb?
Or MySQL deal this situation with Linux FS?
In other words, will my MySQL stop working w
> Uhm,
> what are you talking about?!?
When I put our site on a Linux system, apache stop working when
it´s logfile get major than 2 Gb.
I was afraid of it´d happen with MySQL, too.
> Linux has no such limitation.
> you can grow files as large as you like.
> right now I have an InnoDB dbase with
Hi All,
I have another question:
I have a .sql file from a mysqldump did in a mysql-3.23.x
Is there a way to restore it in a mysql-4.0.17?
I´m trying to do it but the mysql return some errors like:
# mysql -u root -p < ./dump-database.sql
Enter password:
ERROR 1050 at line 1923
The user that mysql run as, has permission to write
in the /var/run/mysql dir?
Ronan
> muhammad alqama wrote:
> > hi
> >
> > **(plz someone help me urgently)**
> >
> > i have tried the procedure mentioned below but of no avail.
> > this is the exact message in .err file
> >
> > "can not s
Patrick,
> >From your description, I assume you already have data in an existing
version
> 4 database that has existing table structures that are different from your
> 3.23 dump.
I didn´t have datas, but I had already run the mysql upgrade script.
Because the original version of the MySQL in Linu
Hi,
We have a FULLTEXT search in our site.
The is after we migrate the tables from MyISAM to InnoDB,
this search stop working.
Looking at the MySQL Documentation
(http://dev.mysql.com/doc/mysql/en/Fulltext_Search.html) I´ve seen
that it´s support for MyISAM tables online.
So, how can I make a se
Hi,
Is it possible to make a search for a word in a longtext column
from a InnoDB database?
Thanks,
Ronan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi,
We have a MySQL-Server-4.0.17 installed in our enterprise
working fine... :-)
Some times our application takes too bandwidth from the
database server.
So, I´m trying to figure out what (perhaps what select) is taking
so manu bandwidth.
SHOW FULL PROCESSLIST shows me the follow:
mysql> show
Victor,
> Are you logging slow queries? If so, have you looked in the slow query
log?
Yes, I am.
But, it shows many of them and no one at this time.
Or, it doesn´t show slow queries when the problem is occurring.
I restarted the server 1 hour ago and after I did it, the server seems
to be OK.
I
Victor,
> Do you have any around the approximate time?
I know the time that the problem occurred.
In the slow-log, it shows the line "Time".
Is it line the hour the query ran?
> The timestamp will be will the
> query was written to the slow log and how long it took. What are the
> symptoms that
> The timestamp is when the query was written to the log. You will have to
> subtract the query time to get when the query began. Unless you have
queries
> that are running for long durations the timestamp and actual time should
be
> close.
OK, so, slow query shouldn´t be my problem, because there
Kirti,
> (1) I am going to setup a MySQL Client machine on a different Server. I
> notice I can't install
> a Client MySQL from Binary MySQL distro. Is it correct?
I´m not sure, but I think you´ll have to install altmost the complet
MySQL package on the client machine. Perhaps because the librari
Hi,
I´m working in a project of a database that should be grow
to more than 25,000,000 of clients.
For all I´ve read in MySQL manual pages it´s too much records
to place in only one table.
So, my main doubt is how to divide it.
I divide the client table in few tables according with the different
Hi,
Can I insert specifying the data into a auto-incremental column?
Explain better:
We have a database (MySQL-4.0.17) that I need to syncronize
with a off-line software.
If a client was inserted in the off-line software, I´ll need to import
the client datas to the central database.
The client
> Hi there, I am aware this isnt possible. I would like the power of Innodb,
> but one of my applications also requires the boolean search within blocks
of
> text, how can i do this efficiently ?
I know it isn´t so efficient, but you can use:
SELECT *
FROM yourtable
WHERE text_column LIKE '%word%
Hi,
Is the Primary Key Column mandatory?
Supposing:
If I have two tables: Clients and Cars, and a third table Clients_R_Cars,
that is a relationship between Clients and Cars.
I only need to know what cars the clients have.
So, I just need to two columns "CliCar_ClientsID" and "CliCar_CarsID",
th
Hello,
I´m doing the planing for an application that will use
MySQL as database.
So, I´d like to know your opinions about the standard
for the column names.
Supposing that I should create a table named car.
Is it better to have either the column names (cod,
name, description) or (car_cod, car_na
Hi,
If I create a column with the type TINYINT(2) UNSIGNED.
Will the content can have the value minor than 510 (like a number 499),
or will the content can have two values minor than 255 (like 11)?
Thanks,
Ronan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
Ruslan,
> IMHO:
> 1) Table name as prefix is unnecessary for me. It's norwegian notation
> which I hate.
> 2) Also I recomend look into ANSI SQL standard for reserved keywords.
> I've got experience of porting DB from MySQL(allow some keywords) to
> another DB, it's pain.
Thank you your answer.
D
Paul,
> I don't know what "minor than" means
Sorry by my english.
I´d like to say "less than" (or something like this).
> , but TINYINT is a single-byte
> type. The range for TINYINT is -128 to 127, and the range for
> TINYTINT UNSIGNED in 0 to 255.
OK, I understood it, but I didn´t understand
1 - 100 of 104 matches
Mail list logo