Re: Doubts tuning MySQL Percona Server 5.5

tence! Thanks in advance. Regards, Antonio.​

Doubts tuning MySQL Percona Server 5.5

is 627; table_open_cache is 1024 --> Maybe the next best value could be 2048? Key buffer hit rate is 93.7%; I have some queries that not using indexes .. join_buffer_size is 4M --> Next best value? Maybe 8M and then check it again? That's all. I hope your advices. Regards, Antonio.

Re: Optimizing InnoDB tables

​Hi Johan, Thanks for your reply. Theorically the fragmented tables not offer the best performance to the InnoDB engine, that's correct or not? I don't know if is a problem or not, is a doubt/question for me. I'm not sure if is an atypical behaviour. Thanks in advance. Regards, Antonio.​

Re: Optimizing InnoDB tables

after execute an analyze table command on some fragmented table, after that, appears fragmented again. Regards, Antonio.​

Re: Optimizing InnoDB tables

​Hi Andre, Thanks for your reply. I have checked the link and my configuration. Innodb_file_per_table is enabled and in data directory appears a set of files by each table. Any ideas? Thanks in advance. Regards, Antonio.​

Problem with INSERT INTO and UPDATE queries

| Extra | ++-+-+--+---+--+-+---+--+-+ | 1 | SIMPLE | radacct | ref | user_start,nasip_starttime,acctsesid_user_nasip,user_stop | acctsesid_user_nasip | 339 | const,const,const |1 | Using where | ++-+-+--+---+--+-+---+--+-+ 1 row in set (0.10 sec) ​### Any ideas? I have checked indexes, query's execution time ... All seems work fine ... ​ ​Thanks in advance. Regards, Antonio.​

Re: Optimizing InnoDB tables

​Hi again, I have enabled innodb_file_per_table (Its value is on). I don't have clear what I should to do ... Thanks in advance. Regards, Antonio. ​

Re: Optimizing InnoDB tables

​Hi Wagner, I'm running ​ ​MySQL Percona Server 5.5.30 64Bits. No, I don't have tried to execute ALTER TABLE (Analyze with InnoDB tables do that, or not?). Thanks in advance. Regards, Antonio.​

Optimizing InnoDB tables

seen that there are 49 fragmented tables. With one table, I have executed "optimize table table_name;" and "analyze table table_name;". The result is the same, the table continuos fragmented. Any ideas? I have followed the mysqltuner recomendations ... Thanks in advance. Regards, Antonio.

Re: Order column in the second table

s some time sorting the result set. Also, create a temporary table with the rows prevously. This is the reason. Regards, Antonio. ​

Re: Big innodb tables, how can I work with them?

service. For example, SUMs, COUNTS, nomal SELECTs ... Always with a where condition. Excuse me, what is the meaning of IMO? Thanks. Regards, Antonio.​

Advices for work with big tables

lmost all data. Another solution is increase the server resources. Any ideas? Thanks in advance. Regards, Antonio.

Big innodb tables, how can I work with them?

x27;t. For the other hand, maybe de only possible solution is increase the resources (RAM). Any ideas? Thanks in advance. Regards, Antonio.​

Re: DBA: please review my.cnf [for Java Hibernate application] and give suggestions

#x27;InnoDB' ) AA ) A; Good luck! Regards, Antonio.

Re: DBA: please review my.cnf [for Java Hibernate application] and give suggestions

timal. Regards, Antonio.

Re: LOAD DATA in replication

If I don't mistake, there are some parameters to make that you are saying. Check statement-based-replication and row-based-replication. I think that this could help you. Regards, Antonio.

Doubt with sored procedures - II

I have discovered that in MySQL client program I can define "definer" and "sql security". This is the detail. Thanks everybody. Best regards, Antonio.

Re: Doubt with stored procedures

49 on Debian 6. This normal user has CREATE PROCEDURE privilege and EXECUTE privilege. Thanks. Best regards, Antonio.

Doubt with stored procedures

everybody. Best regards, Antonio.

Re: Defragmentation of MySQL tables, how many times have I to do it?

Hello Manuel, Exactly. My objective doing performance MySQL it isn't to free disk space (it isn't the problem). I would like to get a good performance using cache and setting good values to configuration variables. I will defrag tables once per month. Best regards, Antonio.

Re: Defragmentation of MySQL tables, how many times have I to do it?

Ok. Thank you very much. Best regards, Antonio.

Re: Defragmentation of MySQL tables, how many times have I to do it?

Hi Reindl, Thanks for your reply. So, is it not necessary (not recommended) to defragment tables if I have a lot of write operations (writing or deleting)? Best regards, Antonio.

Defragmentation of MySQL tables, how many times have I to do it?

Hi everybody, Once I have done the defragmentation of MySQL tables, mysql-tunner.pl suggests me do it again. Is this correct? I think that the idea is that in the result of the script there are not fragmented tables ... Any ideas? Thank you very much. Best regards, Antonio.

Updating Sql Server DB from MySql

Hi all, I'm working for a company which has a administrative system under C# and SqlServer and they have a payment system under PHP + MySql. The want I create a trigger to update the SqlServer DB(Payments table) automatically when a record is inserted in the MySql DB. I've heard about LinkedServe

Re: What if the user closes the browser while INSERT INTO MySQL? (PHP/MySQL)

Well... just summarizing my thread here. I tested this today. As Carsten mentioned... Without the function 'ignore_user_abort(true);', when the browser is closed the script will stop at some point (if there's output ('echo etc') of certain number (1,000s) of characters remaining.). Many Thanks

What if the user closes the browser while INSERT INTO MySQL? (PHP/MySQL)

This maybe a newbie question. Consider the following concept, ~/index.php #1. Fetch data from an external webpage using PHP Curl; #2. Preg_match/Prepare Data to INSERT from local MySQL; - this may take a few secs #3. While Loop { INSERT data (from #2) into local MySQL } - this may take only mili

Re: Now() : SQL syntax error. But why?

rote: > > On Apr 29, 2009, at 11:29 AM, Antonio PHP wrote: > > This is MySQL data structure. - I underlined where it causes the error >> message. (datetime) >> `id_Company` smallint(6) unsigned NOT NULL AUTO_INCREMENT, >> `Name` varchar(50) CHARACTER SET utf8 COLLATE

Re: Now() : SQL syntax error. But why?

e query and the table structure. timestamp fields > can have options set to auto update them, where order matters, and only one > field can support that feature. > > Please supply more data. > > > On Apr 28, 2009, at 2:18 PM, Antonio PHP wrote: > > You have an error in your

Now() : SQL syntax error. But why?

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Created = NOW(), Updated = NOW()' at line 8 'Created' and 'Updated' are set to datetime (InnoDB). The same syntax works for some newly created tables... and gives

Besoin d'aide urgent

Je viens au pres de vous solliciter une aide en ce qui concerne le demarrage du serveur mysql. J'ai installe sur ma machine la version mysql suivant: mysql-4.0.20a-win Je constate qu'il n'y a pas un racourcie pour la source graphique. J'ai tente de demarrer le server en ligne de commande en me met

unix_timestamp + milliseconds support?

milliseconds. Have you already face this problem and come to a solution you are happy with? Thank you for taking the time to read this email & for your support. José Antonio

Spatial Extensions in MySQL: Multidimensional Points?

MySQL offers Spacial Extensions to operate with points in a 2 dimensional space. For a project I'm working on, I need to work with points in an N dimensional space and measure the distance among them. Is there a clever do to solve the following problem?: Let's say I have 4 3D point (X,Y,Z): (0,0

Datetime with milliseconds?

I'm working on a system that deals with data with second resolution. The data type we are using is not the MySQL DATETIME but the MySQL UNSIGNED INT and we save the datetime as UNIX_TIMESTAMP. By this way we managed to reduce by 4 bytes the storage needs of each record. We also reduce the index siz

Timestamp problem.

I have the following part in a schema describe feeds . | pubdate | timestamp| YES | | CURRENT_TIMESTAMP | | show create table feeds; `pubdate` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, when i make an INSERT INTO feeds(,

MySQL win32 and SSL

Dear all, I need SSL support for MySQL. I've checked the documentation and it seems that for windows there is no SSL support in the binaries. In addition the documentation in the examples is for Linux. Has anyone has used MySQL with SSL in windows? If so ... how? How easy is to set it up? What

Re: MySQL 4.1.8 & InnoDB: data unavailability among different connections

tions do not see your data. Jose Antonio wrote: Hi! I am experiencing something weird using MySQL 4.1.8 with InnoDB tables. I have an application, let's call it A, that is monitoring the data that is available in the database. The data is inserted in the database by a different application,

MySQL 4.1.8 & InnoDB: data unavailability among different connections

Hi! I am experiencing something weird using MySQL 4.1.8 with InnoDB tables. I have an application, let's call it A, that is monitoring the data that is available in the database. The data is inserted in the database by a different application, let's call it B. The problem is the following: A star

MatLab connector

Do you know if I can use MySQL data from MatLab? Does it exists a connector for MatLab in the same sense as JDBC for Java? Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

The better and more efficient way to store datetime data.

I need to store huge data series using MySQL with InnoDB as storage engine. The data type of the parameters can be double, float, int, smallint, mediumint, tinyint So, I've thought to store them in the following way: Table Parameter: Parameter ID - small int Parameter Name - varchar(8) Parame

help with dbf and dbt

Can someone help me, i have two files one dbf and one dbt thant i need to import it in mysql, can someone help me telling me how can i do this. Thanks. José Antonio Viadas O. Director de Desarrollo Denumeris Interactive <http://www.denumeris.com/> TEL. Oficina: 56.64.31.7

RE: InnoDB TableSpace Question

Oracle can shrink tablespaces, you can find how to do it searching Metalink for this article: "1029252.6 How to Resize a Datafile" Best regards, Antonio Delgado. -Original Message- From: David Griffiths [mailto:[EMAIL PROTECTED] Sent: martes, 03 de agosto de 2004 22:00

Re: loading dates

I've a second look to de csv file and the format of the date is 09/14/1988, so I think it's easier to load it to the mysql date format, could it be done using mysqlimport, or LOAD DATA INFILE ?? Thanks On Tuesday 13 January 2004 18:24, Antonio De Luna wrote: > Hi, I've

loading dates

Hi, I've got a csv archive with a date field 15/02/03, how can I load it to a date field with the mysql date format (ISO ? ) 2003-02-15 ? thank you -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Setting the timezone

Hi: Do you use version 4 or 3? I thought that I need to use "set-variable = timezone = CST" for it to work under MySQL 3. Also, does anybody know if "CST" is recognized? Or do I have to use GMT-6 or something like that? Thanks for your time and help. King reg

Setting the timezone

t then the timezone stays at MDT. Thanks for your time. Kind regards, Juan Antonio Ruiz Zwollo -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

URGENT : Benchmark

Help me ... Antonio Jose Rodrigues Neto <[EMAIL PROTECTED]> wrote:Hi All, I almost finish my MSC Thesis and my thesis is iSCSI Performance. I would like to make tests using Fibre Channel and iSCSI with MYSQL. Please I will need informations (cookbook) how does implement tunning on

Unicode (UTF-8) and full text searching

Hi List, This is my first mail in this list and thanks in advance. Does anyone know what version of Mysql has Unicode support for full text searching? I have a database with information in four languages (english, german, greek and spanish) in unicode and I would like to do full text searching. R

Error creating an udf

I read the indications in the MySQL manual about how to create an user defineable function and I implemented a dll (I am working in win2000). When I try to execute the query: CREATE FUNCTION cuadrado RETURNS REAL SONAME 'cuadrado.dll' it shows the message: 1105 - Unknown error I am working

Re: Privileges - Does Anybody knows how to answer to me?

> > Hi, I read the book, but there is not explain about it. > > I would like to know when I give privileges to the user, in the table > level, and after I give privileges in the database level. Do I replace > the privileges? Any time you execute a query, MySQL looks for the privileges needed for

I: Relation N-M

row the name of the book and the name of the 3 > authors? > Thanks > Antonio Bernabei > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the l

Bug

1. I' am using mysql-max-3.23.49 for Windows and y have a problem to insert a tuple with the char ñ. Anyone can tell me how solve this problem ? 2. I'm developing an aplication with Power Builder 7.0. What is the compatibily of MySQL with Power Builder 7.0 ? Thanks. --

replicate-wild-ignore under mutual master-slave relation

Hello, I have two servers under a mutual master-slave relationship. I need to ignore certain databases when replicating. I tried to use replicate-ignore-db but according to the MySQL manual this won't work for cross database updates. The manual suggests using replicate-wild-ignore-table instead.

Auto-starting mySQL on a Macintosh

Hello I need help to startup My SQL in my OS X Server 10.1 box.. Some idea of what can I do? Greetings Antonio - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

problem with count (*) max (*) min (*)

I'm trying to do select count (*) from table. but it doesn't work ERROR 1064: You have an error in your SQL syntax near '(*) from pendientes' at line 1 Same happens with max (column) and min (column). Do I have to install anything else or is something wrong. I'm using redhat 7.0 wi

RE: MySQL/PHP

Try with $db=mysql_connect ("localhost.localdomain","myname","mypassword"); use the test database that i think that is the least restrictive database. -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]En nombre de Adams, Bill TQO Enviado el: miercoles, 05 de septiem

Hi!

I am New at this Mailing List, `cause of it first of all lemme say Hi to everybody... I`m facing a problem with my Web Server, it`s a Conectiva Linux, running Apache We had a problem with it last night, all configuration files were lost and were forced to recover the backup. After this, trying to

Newbie with mysql

Hi, I've got a question that i'm sure that it is easy to solve. I've installed mysql in Redhat Linux 7.0 and it is working fine. I've also installed PHP module so i can make PHP pages. I've tried to do a small page that connects to mysql server but this error appears: Warning: Can't connect to

MySql++ Installation Problem

annot find mysql libraries in ' ' . What does it mean? What have i to do to install the APIs? Obviously I have installed the mysql server. Thanks in advice to everybody. Antonio Scotti - Before posting, please

undefined reference to `__cxa_pure_virtual'

>Fix: Can't know. Maybe's just some broken library or... whatever >Submitter-Id: Antonio Suárez >Originator: >Organization: Icosís, S. L. >MySQL support: none >Synopsis: Unable to build source tarball >Severity: critical >Priority:

RE: Urgent:MySql problem

any mysql command > > Can't connect to localMySql server through socket > 'var/lib/mysql/mysql.sock'(111) > > Please Help me. > > Thank You > Sachin Ate´ Antonio [ [EMAIL PROTECTED] | [EMAIL PROTECTED] | [EMAIL PROTECTED] ] [ http://floripa.zoing.net

insert a blob

how can in insert i.e. a tar-archive in a blob ? i want to do it with perl. i read allready about the quote function but i wount work #!/usr/bin/perl use DBI; # DB-Vars $host = "ux4"; $database = "db_webera"; $user = "webera"; $pass = "webera"; $port = 3306; $driver = "mysql"; $dsn = "DBI:$dr

Re: Full Text Search Question

-- > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL

Re: Can't recover a bad corrupeted table...

+--+ | Table | Op | Msg_type | Msg_text | +---+--+--+--+ | queries.keywordsn | optimize | status | OK | +---+--+--+--+ 1 row in set (11 min 26.70 sec) Antonio gulli wrote: Bob Hall wrote: >>

Re: How to have faster select?

m/manual.php (the manual) >>http://lists.mysql.com/ (the list archive) >> >> To request this thread, e-mail <[EMAIL PROTECTED]> >> To unsubscribe, e-mail <[EMAIL PROTECTED]> >> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.

Re: Can't recover a bad corrupeted table...

t looks like you only tried m >> > > > >>> with the -r -q option combination. Try it with just -r. If that >>> doesn't work, try it with -o. If that doesn't work, restore from >>> backup. >>> >>> Got backup? >>>

Re: Can't recover a bad corrupeted table...

low, and it > looks like you only tried myisamchk with the -r -q option combination. > Try it with just -r. If that doesn't work, try it with -o. If that > doesn't work, restore from backup. > > Got backup? > > Bob Hall > >> Antonio gul

Re: mysql over nfs on netapp filer

> > Hi, > > my problem is that now the second time the performance of my f740 > goes down every day. > i solved the prob with increasing maxfiles (no to the max for the > volume). > after that the cpu of the filer, which went up from > 25% peak to 90% peak in 5 days, goes down again. > > any i

Re: How to have faster select?

re posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: ht

Re: mysql over nfs on netapp filer

OTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > -- -- Antonio Gulli'Ideare S.p.a tel: (+39) 050 575300 [EMAIL PROTECTED] Lungarno Mediceo 56 fax: (+39) 050 575583 whois: AG2-ORG I-56126 Pisa, Italy http:

Can't recover a bad corrupeted table...

Antonio gulli wrote: > Any help is appreciated > > Welcome to the MySQL monitor. Commands end with ; or \g. > Your MySQL connection id is 158 to server version: 3.23.36-log > > myisamchk -V > myisamchk Ver 1.45 for pc-linux-gnu at i686 > > a) Trying a recove

Can't recover a bad corrupeted table...

Any help is appreciated Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 158 to server version: 3.23.36-log myisamchk -V myisamchk Ver 1.45 for pc-linux-gnu at i686 a) Trying a recovery. myisamchk -r -q -Osort_key_blocks=16 keywords - check key delete

VIRUS FOUND Re: escape character for # sign?

Attention, the original message of Funky Gao and following replies contain the virus W32.Navidad.16896 Antonio