Re: Estimate mysqldump size

however there will always be an edge case table which will be greater still.. Regards Ronan McGlue MySQL Support Thanks in advance, Olivier -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Re: Automated SQL checker?

eries which are candidates for improvement ) in a running DB. eg *|mysqldumpslow -s c -t 5 |* https://dev.mysql.com/doc/refman/5.7/en/mysqldumpslow.html https://dev.mysql.com/doc/refman/5.7/en/slow-query-log.html Regards Ronan McGlue MySQL Support On 13/04/2017 01:06, SSC_perl wrote:

Re: rescue Inno tables from an abandoned data directory?

can I rescue data from them? I’ll be grateful for help -- Regards Ronan McGlue MySQL Support

Re: Error on MySQL-5.0

EPAIR TABLE `/var/tmp/#sql_fc2a_0`" to fix it! | +-+---+--+----+ Thank you, Ronan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

MySQL Cluster

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 Mailin

Error on MySQL-5.0

--+ | information_schema.COLUMNS | check | error| Table upgrade required. Please do "REPAIR TABLE `/var/tmp/#sql_43b6_0`" to fix it! | ++---+--++ Any help would be appreciate. Thanks, Ronan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

JDBC Compatibility

ked for an alias. Is it right? I can't change the queries of my whole application to be compliant with JDBC 5.1.7. It's thousands+ queries. Thank you, Ronan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

auto incrementing fields

structure then restart. Is this the reccommended action. Ronan -- Regards Ronan McGlue === Analyst / Programmer Queens University Belfast -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: mysqldump on Freebsd 5 -- out of memory error

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 unsub

Re: mysqldump on Freebsd 5 -- out of memory error

realy don´t know if it will solve your problem, but, if MySQL is tring to use more RAM memory than the permited, it seems to be the case. Ronan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

How to generate efficient backups?

problem happened in a InnoDB table. Any help would be appreciated, Thanks, Ronan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: duplicate entry (same time every day)

[EMAIL PROTECTED] wrote: Ronan McGlue <[EMAIL PROTECTED]> wrote on 03/09/2006 05:05:15 AM: > i have a little quirck with my current Mysql setup. I log all messages > from my mtas into Mysql and then use a simple query to generate stats > from them... as below: > > my

duplicate entry (same time every day)

ON DUPLICATE KEY UPDATE count = count + 1\ }{0}{0}} anythoughts on the matter? thanks Ronan -- Ronan McGlue Analyst / Programmer CMC Systems Group Queens University Belfast -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

simple addition in a query?

tly shove me in the right direction on how I might take a sum of the 3 fields on the hourly field so I can hae a total count per hour? I could do it in perl easily but I want to know if its possible in MySQL... thanks Ronan -- Ronan McGlue Analyst / Programmer CMC Systems Group Queens University

primary key

ULL default '0', PRIMARY KEY (`date`,`hour`), ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='exim realtime stats'; thanks Ronan -- Ronan McGlue Analyst / Programmer CMC Systems Group Queens University Belfast -- MySQL General Mailing List For list archives: http://lists.mysql.c

Re: How to compose index?

what group of indexes should i use to gain maximum performance out of this query? Table users index_id: id Table accounts == index_id: assigned_user_id, deleted index_phone: phone_office After that, do an EXPLAIN in the query. I´m not sure about index_phone will help y

Re: Tips for better performance

do some more tweaks? I guess so. The bellow documentation has helped me a lot, although it´s for 3.23 version: http://www.tnt.uni-hannover.de/print/plain/soft/database/MySQL/Docs/manual_Performance.html Ronan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

Re: Tips for better performance

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 Li

Re: Tips for better performance

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

Re: Tips for better performance

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]

UDF

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

Re: general question

If you use query cache in server side (on database or on your programing language), yes. It should works. If you use cache base on proxy or in the client browser. Once the result was ignored, there is no page to cache. I hope this help you, Ronan -- MySQL General Mailing List For list arch

Re: Doubt about query optimization

etter understand the trouble. I think found what´s happening. A SELECT WHERE city = 1 returns more rows thant a full table scan in the table "front" (the real states that appear in the front page). So, it seems MySQL choose the second option, once it has less rows to optimize. Thanks, Rona

Doubt about query optimization

ppreciated, thank you, Ronan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: mysql_init

Philippe Poelvoorde wrote: i've googled and the only answer to problems like this has been to reinstall the DB perl module. Ive tried this but still get same error. any clues??? thanks in advance. Ronan Is libmysqlclient.so available in one of your LD_LIBRARY_PATH directory ? t

mysql_init

64-slackware-linux/lib /usr/lib /usr/lib64 /usr/local/lib64 /lib /lib64 /usr/X11R6/lib64 i've googled and the only answer to problems like this has been to reinstall the DB perl module. Ive tried this but still get same error. any clues??? thanks in advance. Ronan -- MySQL General Mail

Re: Help with query

005 | 5 | 15 | 192.168.0.3 | 1 | +--+---+--+---++ 3 rows in set (0.00 sec) Thank you very much for your attention. It also answer my question, but I think the Shawn´s tip is more optimized. Any way, I appreciate your help. Thank you,

Re: Help with query

-day-ip be counted as 1. And I need this total per day. Thank you, Ronan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Help with query

BY year, month, day, ip ORDER BY year, month, day but it returns me several lines of the same day and the amount of access per IP, and I need the amount of access from different IPs. Could anybody help me? Ronan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

Re: Doubt about Performance

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

Re: Doubt about Performance

able should have about a million records, but WHERE clause should filter it to up to 5,000 and such query should be in the site´s home. I don´t know if it can put the site in performance troubles or if it´s paranoia of mine. Thanks, Ronan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Doubt about Performance

eavy such query is for the database and how viable such query is. Thanks in advance, Ronan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Doubt about Performance

query? I need to put these two queries in the first page of our site. So, I´ve been worried if it can slow down our site in the pics. Thanks, Ronan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Function

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

Doubt about query optimization

of it. Thanks, Ronan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Increasing the InnoDB log file size

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:

Re: Increasing the InnoDB log file size

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 Fo

Increasing the InnoDB log file size

file 0 134217728 bytes! 041210 13:27:40 [ERROR] Can't init databases 041210 13:27:40 [ERROR] Aborting 041210 13:27:40 [Note] /usr/local/libexec/mysqld: Shutdown complete 041210 13:27:40 mysqld ended Does anybody knows how can I do it? Thanks, Ronan -- MySQL Ge

Re: 4.0 vs 4.1

le tablename always > fixes the problem. I agree with you, but my worry is in cases that IÂm not accessible. Ronan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: 4.0 vs 4.1

sql/en/Table_maintenance.html). Once I dealing with hangs problems with MySQL + FreeBSD-4.x, I´m afraid that the table could crashs when MySQL hangs... :-/ Ronan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: 4.0 vs 4.1

in InnoDB to avoid corruption issues. Ronan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: 4.0 vs 4.1

max_timemin_timeq_per_s > select_index60 2 0 13201.30 > > -- > > It seems 4.0.22 is faster in each benchmark. Around a 20% increase. I > wonder why this is? --- Once I plan to run FreeBSD-5.3 + MySQL-4.1.7 in my server, it can affect me. Ronan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Opinions: notes field ideal length?

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 s

Re: MySQL 4.1.7 Network slowdown

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]

Re: MySQL 4.1.7 Network slowdown

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]

Re: MySQL 4.1.7 Network slowdown

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]

Re: mysqldump from 4.1 to 4.0 - It´s solved

, but can be disabled with --skip-opt. " So, I got to import the data with the following mysqldump line: mysqldump --skip-opt --add-drop-table --default-character-set=latin1 dbname > dbname.sql thanks, Ronan -- MySQL General Mailing List For list archives: http://lists.mysql

mysqldump from 4.1 to 4.0

the dump file successfully but now we having accentuation problems. It seems that the words were recorded with a wrong accentuation character. Any help would be appreciated. thanks, Ronan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mys

4.0 vs 4.1

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

Re: MySql Hangs

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]

Re: Tunning Problem

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 th

Tunning Problem

r_size + sort_buffer_size)*max_connections = 515615 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. ------ Thanks, Ronan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Innodb corrpution. Very Urgent

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

Re: Innodb corrpution. Very Urgent

he swap file of ulimits > innodb: of your operating system > innodb: On freeBSD check you have compiled the OS with > innodb:a big enough maximum process size It seems a tunning problem. Perhaps if you make some changes in your my.cnf file MySQL could run again. Ronan -- MySQL Gener

Re: Mysql Performance

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

Subqueries X Joins

before (I didn´t found it in the archives), please tell me the thread subject or the link for the documentation. Thanks, Ronan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Fw: Strange error in DELETE query

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

Re: Strange error in DELETE query

that I didn´t see, yet. thanks, Ronan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Strange error in DELETE query

t I forgot to say is I run a SELECT with the same where clause: SELECT * FROM table WHERE client_id = 1 AND row_id IN (2,5,7) and it returns me three rows, thanks, Ronan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Strange error in DELETE query

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

Re: UPDATE LOW PRIORITY

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:h

Re: UPDATE LOW PRIORITY

ion: Before the that be commited (until no other clients are reading from the table) the results for SELECTs will be either the data on disk or the date on the cache? Thanks, Ronan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.

Re: UPDATE LOW PRIORITY

ble1 Will it return BBB? Thanks, Ronan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

UPDATE LOW PRIORITY

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

Re: Help with query

Shawn, Thank you very for your answer. Actually, I thought that a main SELECT couldn´t be filtered by the WHERE clause refered to a field in a LEFT JOIN. Now, looking better in the JOIN documentation I see this issue. Thank´s, Ronan This is a very FAQ: SELECT t1.* FROM TABLE_1 t1

Help with query

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

JOIN in the same table

-4.0.18. Any help would be appreciated. Thanks, Ronan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Join and Performance Question

, test_name FROM City, Teacher, TestLocal WHERE city_id = Student.city_id AND teac_id = Student.teac_id AND test_id = Student.test_id AND Student.stud_id = $cod_student Or is it better to make 3 distinct SELECT? What should be better for the application and DB? Thanks, Ronan

Re: Help with query

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 Fo

Help with query

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

Re: moving data

rom the old table. > > Could someone help me out with the SQL for this please? Or tell me if > there's a better way of doing this? CREATE TABLE new_able SELECT * FROM old_table; Ronan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Server hanging

could make MySQL hangs? And where can I find error messages that could tell me what happend? Thanks, Ronan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: huge innodb data files

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:

Query Help

AND cod != 15 AND cod != 20 AND cod != 25 AND cod != 30 AND cod != 31 ORDER BY descr Is there a SQL command to make this query cleaner? I find something like: WHERE cod NOT IN (7,10,13,14,15,20,25,30,31) Thanks, Ronan -- MySQL General Mailing List For list

Re: inserting works fine but I cant update.

27;' at line 1 Is the column 1 string type? If it´s numec type. You should use SET 1=1 instead of SET 1='1' Ronan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: inserting works fine but I cant update.

What are the version of MySQL you are using? 4) Do you have GRANT privileges to UPDATE data in such table? Ronan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Table types

with the same type (InnoDB)? Thanks, Ronan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Inserting in a auto-inremental column

ID is an auto-incremental column, but if I leave MySQL set the client ID, it´s supposed to be different from the off-line software. Thanks, Ronan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Simple questions!!

an>". How do > I get out of this > shell? Forexample: When one is in mysql shell, QUIT takes out of the mysql > shwll. It seems you´re still in the CPAN interactive shell. Ronan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Database structure

how can I deal with it? I´m thinking to use InnoDB tables. Thanks, Ronan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Primary Key

t;CliCar_CarsID", the will be my index keys. Even thus do I need to create a Primary Key Column "CliCar_ID"? Thanks, Ronan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Innodb + full text searching

KE '%word%' Ronan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Standard of Column Names

Harald, > I don't see the necessity of the latter naming scheme since > > SELECT cod, name, description FROM car > > can also be written as > > SELECT car.cod, car.name, car.description FROM car Do you know how it would be about portability? Thanks, Ronan --

Re: Doubt about TINYINT type

5. OK, I understood it, but I didn´t understand why is there an option TINYINT(n) Thanks, Ronan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Standard of Column Names

27;s pain. Thank you your answer. Do you know where can I find a documentation about ANSI SQL Standards and what is the ANSI SQL standard implemented by MySQL? I ask it because I´ll prefer to work with column types that are in the ANSI SQL Stantard like INTEGER instead of MEDIUMINT. Thanks, Ronan

Doubt about TINYINT type

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

Standard of Column Names

, car_name, car_description)? Thanks, Ronan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Process Monitoring

e server and going in to the application server. Running a top in the application server, it show just the coldfusion process using the CPU and in the database server, just the mysql using de CPU. Ronan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To un

Re: Process Monitoring

the > symptoms that lead you to believe that it is a slow running query? Actually, I don´t know if the problem´s origem is a slow query. I´d like to know what query was running in such moment to see if exist a query receiving too many data. Thanks, Ronan -- MySQL General Mailing List F

Re: Process Monitoring

OK. I´m thinking that MySQL can be losting itself in the memory usage. Is it possible? But, I can´t understand what can made so many traffic going out from the server... :-/ Thanks, Ronan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:h

Process Monitoring

it? Thanks, Ronan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Search in Longtext fields

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]

InnoDB and searchs

search for a word in a LONGTEXT column? Will it be fast? Any help would be appreciated, Thanks, Ronan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: mysqldump

_priv and db databases and after restore I gain all fuctionalities and performance from MySQL-4.0.x? Thanks, Ronan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: starting mysql daemon.... help me !!!

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 exac

mysqldump

mysql -u root --password=littlesohh < ./dump-database-bh.txt ERROR 1136 at line 7: Column count doesn't match value count at row 1 It is happening in the db table. OK, the table (db) struct is different from the 3.23 version, but, how is the better way to do it? Thanks, Ronan

Re: MySQL on Linux

an InnoDB dbase with Mysql on a linux > system and the file is over 60 GIGS in size! Great!!! So, I don´t need to worry about it... :-) Thanks Dan, Ronan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

MySQL on Linux

when the database get major then 2 Mb? Or such situation won´t happen? thanks Ronan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

my.cnf in MySQL-Server-4.0.17

/etc/my.cnf file the MySQL works fine, except in some moments that it get slow. Does anyone knows what could be wrong? Any help would be Appreciated. Thank´s Ronan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

my.cnf on MySQL-Server-4.0.17

/etc/my.cnf file the MySQL works fine, except in some moments that it get slow. Does anyone knows what could be wrong? Any help would be Appreciated. Thank´s Ronan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

  1   2   >