Re: MySQL optimization for testing purpose

On 04/03/2018 06:15 PM, Sebastien FLAESCH wrote: On 04/03/2018 05:59 PM, Sebastien FLAESCH wrote: Hi all, Looking for some configuration tips to speed execution of our non-regression tests with MySQL. We do pure functional testing, data persistence is not critical. Our tests are not using a

Re: MySQL optimization for testing purpose

On 04/03/2018 05:59 PM, Sebastien FLAESCH wrote: Hi all, Looking for some configuration tips to speed execution of our non-regression tests with MySQL. We do pure functional testing, data persistence is not critical. Our tests are not using a lot of data, but we create and drop a lot of test

MySQL optimization for testing purpose

Hi all, Looking for some configuration tips to speed execution of our non-regression tests with MySQL. We do pure functional testing, data persistence is not critical. Our tests are not using a lot of data, but we create and drop a lot of test tables. We have concurrency tests (processes loc

Re: MySQL Community Server 8.0.3-rc has been released (part 1/2)

Can you please stop using C++ comments in header files designed for C programming? /opt3/dbs/mys/8.0/include/mysql.h:36:1: error: C++ style comments are not allowed in ISO C90 [-Werror] // Small extra definitions to avoid pulling in my_inttypes.h in client code. ^ /opt3/dbs/mys/8.0/include/my

Re: kill query and prepared statements

Sorry for the spam, and thanks for you suggestion Johan! http://bugs.mysql.com/bug.php?id=84470 Seb On 01/11/2017 11:21 AM, Johan De Meersman wrote: Seb, You should log a bug at http://bugs.mysql.com - this is not a developer list. /Johan - Original Message - From: "Seba

Re: kill query and prepared statements

Just to be clear: This is a hint, to find the real problem, this is NOT A WORKAROUND for us! Seb On 01/10/2017 03:53 PM, Sebastien FLAESCH wrote: Investigating different API calls, to see if it makes a difference... Seems that the problem is related to the read-only cursor type option! If

Re: kill query and prepared statements

*) &ct); Then it works ... Seb On 01/10/2017 02:55 PM, Sebastien FLAESCH wrote: Hi all, I have reported this problem before, but I raise it again, since I still get this problem with 5.7.17 See attached code: I want to interrupt a long running statement with CTRL-C by starting a new con

kill query and prepared statements

Hi all, I have reported this problem before, but I raise it again, since I still get this problem with 5.7.17 See attached code: I want to interrupt a long running statement with CTRL-C by starting a new connect to make a KILL QUERY. I am using the same technique as the mysql client code. T

Re: Query interruption with MySQL 5.7 using KILL QUERY in signal handler does no more work

I did the following test: My program still uses MySQL 5.7 libmysqlclient.so, but I connect now to a 5.6.16 server. And the SQL interrupt works fine... so I suspect there is a MySQL server issue in 5.7. Seb On 07/12/2016 01:01 PM, Sebastien FLAESCH wrote: About: > B) For some reason,

Re: Query interruption with MySQL 5.7 using KILL QUERY in signal handler does no more work

hangs in recvfrom(): recvfrom(3, On 07/03/2016 06:55 PM, Sebastien FLAESCH wrote: Hi all, I use the following technique to cancel a long running query: In the SIGINT signal handler, I restart a connection and I perform a KILL QUERY mysql-process-id-of-running-query This was working f

Query interruption with MySQL 5.7 using KILL QUERY in signal handler does no more work

Hi all, I use the following technique to cancel a long running query: In the SIGINT signal handler, I restart a connection and I perform a KILL QUERY mysql-process-id-of-running-query This was working find with MySQL 5.6. But with 5.7 (5.7.11), we get now a different result: A) The query

Re: signal handling in mysql cli

ULL | ++-+-+---+-+--+--+--+ Why it is in "Sleep" state?!? Seb On 06/21/2016 06:27 PM, Sebastien FLAESCH wrote: FYI, I get the same problem with MySQL 5.7.13. Seb On 06/21/2016 04:59 PM, Sebastien FLAESCH wrote: Seems that after KILL QUERY mysql-thread-id, a call to mysql_stmt_clos

Re: signal handling in mysql cli

FYI, I get the same problem with MySQL 5.7.13. Seb On 06/21/2016 04:59 PM, Sebastien FLAESCH wrote: Seems that after KILL QUERY mysql-thread-id, a call to mysql_stmt_close(stmt-handle) hangs... This did not happen in 5.6 ... Will try 5.7.13 ... Seb On 06/21/2016 04:03 PM, Sebastien

Re: signal handling in mysql cli

Seems that after KILL QUERY mysql-thread-id, a call to mysql_stmt_close(stmt-handle) hangs... This did not happen in 5.6 ... Will try 5.7.13 ... Seb On 06/21/2016 04:03 PM, Sebastien FLAESCH wrote: Hi all, The technique described in this thread is working fine with MySQL 5.6

Re: signal handling in mysql cli

ysql> \q Bye Thanks! Seb On 12/03/2014 05:25 PM, Sebastien FLAESCH wrote: Hi all, I have a similar question regarding KILL QUERY usage: We have a C client program using libmysqlclient.so, it is a single-threaded program. When running a long query, how can I send the KILL QUERY command wh

C++ comment in binary_log_types.h header

Hi all, In version 5.7.10, I found a C++ comment in the .h headers: #endif // __cplusplus Should be: #endif /* __cplusplus */ To avoid: cc -g -fsanitize=address -fno-omit-frame-pointer -W -Wall -pedantic -Wmissing-prototypes \ -Wno-long-long -Werror -fPIC \ -I/opt3/dbs/mys/5.7/include

Re: signal handling in mysql cli

do the job... Thanks. Seb On 12/12/2014 12:12 PM, rafal somla wrote: Hello Sebastein, On 2014-12-03 17:25, Sebastien FLAESCH wrote: Hi all, I have a similar question regarding KILL QUERY usage: We have a C client program using libmysqlclient.so, it is a single-threaded program. When running a

Re: signal handling in mysql cli

Nobody concerned by this case? Simple question: is it safe or not to do a KILL QUERY in a SIGINT signal handler? S. On 12/03/2014 05:25 PM, Sebastien FLAESCH wrote: Hi all, I have a similar question regarding KILL QUERY usage: We have a C client program using libmysqlclient.so, it is a

Re: signal handling in mysql cli

Hi all, I have a similar question regarding KILL QUERY usage: We have a C client program using libmysqlclient.so, it is a single-threaded program. When running a long query, how can I send the KILL QUERY command when a SIGINT (CTRL-C) is caught? (of course we implement a signal handler, so we

Re: MySQL Community Server 5.6.13 has been released

Hello, On 07/31/2013 01:03 PM, Sunanda Menon wrote: > * The C API libmysqlclient shared-library .so files now have > version 18.1.0 (up from version 18.0.0 used in MySQL 5.5). > (Bug #16809055) What impact has this change regarding backward compatibility with existing C pro

Re: MySQL Client (libmysqlclient) compatibility policy

On 05/17/2013 03:07 PM, Reindl Harald wrote: Am 17.05.2013 14:53, schrieb Sebastien FLAESCH: On 05/17/2013 12:29 PM, Reindl Harald wrote: Am 17.05.2013 12:05, schrieb Sebastien FLAESCH: Beside the Oracle skills debate and the stupid mistakes with soname changes between 5.5.8 and 5.5.10 or

Re: MySQL Client (libmysqlclient) compatibility policy

On 05/17/2013 12:29 PM, Reindl Harald wrote: Am 17.05.2013 12:05, schrieb Sebastien FLAESCH: Beside the Oracle skills debate and the stupid mistakes with soname changes between 5.5.8 and 5.5.10 or 5.6.x, (imagine all of this did not happen): I have a VERY simple question that needs a VERY

Re: MySQL Client (libmysqlclient) compatibility policy

5.5.10 and earlier 5.5 versions, so client programs that use the 5.5 client library should be recompiled against the 5.5.10 client library. (Bug #60061, Bug #11827366) Am 17.05.2013 11:10, schrieb Sebastien FLAESCH: Could someone from the libmysqlclient contributors comment on this, and could someone

Re: MySQL Client (libmysqlclient) compatibility policy

Hi all, Could someone from the libmysqlclient contributors comment on this, and could someone complete the documentation regarding client compatiblity? Thanks! Seb On 02/20/2013 09:31 AM, Sebastien FLAESCH wrote: Hello, FYI, I found this statement in the doc, at the end of the C API main

Re: MySQL Client (libmysqlclient) compatibility policy

Hello, FYI, I found this statement in the doc, at the end of the C API main page: http://dev.mysql.com/doc/refman/5.6/en/c.html If, after an upgrade, you experience problems with compiled client programs, such as Commands out of sync or unexpected core dumps, you probably have used old header

Re: MySQL Client (libmysqlclient) compatibility policy

On 02/18/2013 12:14 PM, Noel Butler wrote: On Mon, 2013-02-18 at 10:57 +0100, Sebastien FLAESCH wrote: I have several versions of MySQL installed on my Linux, and it appears that the libmysqlclient versions have changed in the 5.x version line: /opt3/dbs/mys/4.1.24/lib/libmysqlclient.so.14

MySQL Client (libmysqlclient) compatibility policy

Hi all, What is the compatibility policy regarding the MySQL C API library? I could not find the rules in the documentation. I have several versions of MySQL installed on my Linux, and it appears that the libmysqlclient versions have changed in the 5.x version line: /opt3/dbs/mys/4.1.24/lib/li

Re: numeric types

Hi I have already tried DECIMAL type but I cannot get what I want. Maybe the simple way to get data out of MySQL and data inside MySQL the same, is to reproduce what MySQL does by default on my data out of MySQL. Check out the DECIMAL type. / Carsten Sebastien MORETTI skrev: Hello, I

numeric types

Hello, I have a row which is defined as double unsigned (MySQL 5.0.26-Max, OpenSuse). Values in this row can go from a single digit, like 1, to values like 0.0006872207 or 1.2513e-18. I want to store exact numbers. But I would like also this: 1 stored as 1.0 0.098

Re: innodb_file_per_table cost

Hi Sebastian, It depends. In general, no. In some filesystems and operating systems, it actually helps. I think you can base your decision on whether it makes server administration easier for you. Regards Baron Thanks It seems there are no clear thresholds between I/O access, the number of

Re: ibdata1 lost

Sebastien, On Wed, May 27, 2009 at 11:24 AM, Sebastien MORETTI wrote: Hi, Your data is gone (unless you can undelete it from whatever filesystems you're using). I think it's too late for this, because the MySQL server has been restarted. You may be able to recover from the file

Re: ibdata1 lost

Sebastien, On Wed, May 27, 2009 at 11:24 AM, Sebastien MORETTI wrote: Hi, Your data is gone (unless you can undelete it from whatever filesystems you're using). I think it's too late for this, because the MySQL server has been restarted. You may be able to recover from the file

Re: ibdata1 lost

mysqld and the tables should be replaced with the old ones but with no data. Thanks for the schema. But the main problem is the data. The generation process was near completion when we lost ibdata1 file. So, no dump. Andrew -Original Message- From: Sebastien MORETTI [mailto

innodb_file_per_table cost

Hi, Does the use of "innodb_file_per_table" option imply a performance cost ? Compared to default: all InnoDB indexes are in ibdataX file(s). Thanks -- Sébastien Moretti -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mys

ibdata1 lost

Hi, Is there a way to recover data and/or database schema when ibdata1 file has been removed (for InnoDB databases) ? (MySQL 5.0.26) Thanks -- Sébastien Moretti -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsu

Re: How to show highly frequent words in fulltext index ?

It looks perfect. Thanks Google for "myisam_ftdump", HTH Cor - Original Message ----- From: "Sebastien Moretti" To: Sent: Thursday, April 23, 2009 5:24 PM Subject: How to show highly frequent words in fulltext index ? Hi, Is there a command to see which words ar

How to show highly frequent words in fulltext index ?

Hi, Is there a command to see which words are highly frequent in a fulltext index ? Thanks -- Sébastien Moretti -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Performances between different filesystems

Hello, I look for updated performances between different file systems. I have only found performances computed between 2003 and 2005, and for x86. Do you have any updated performance tables for XFS, ReiserFS and Ext3 file systems, on linux x86 AND x86_64 ? And with or without raid ? Thanks -

Multiple connections not happenning

Hello, I run a PHP/MySQL environment. This may be more of a PHP question, but I'll take my chance here. I have 3 different servers: - 1 running apache2 + php4 - 1 running mysql 5.0 - 1 running mysql 4.1 On the web server, I run multiple php applications which all connect to the MySQL databa

RE: database corruption ? how to fix ?

Sorry it is */*.MYI instead of */*.MYD > -Original Message- > From: Gregory Machin [mailto:[EMAIL PROTECTED] > Sent: Thursday, March 22, 2007 12:02 PM > To: Jean-Sebastien Pilon > Cc: mysql@lists.mysql.com > Subject: Re: database corruption ? how to fix ? > >

RE: database corruption ? how to fix ?

- Stop you mysql server - change working directory to $MYSQL_DATA_DIR - run myisamchck with */*.MYD This will run a check on all your table files > -Original Message- > From: Gregory Machin [mailto:[EMAIL PROTECTED] > Sent: Thursday, March 22, 2007 8:41 AM > To: mysql@lists.mysql.com

Innodb corruption help needed!

See below for mysql startup log What should I do next ? Please let me know if you need any additionnal information, such as log files etc... Thanks, Jean-Sebastien Pilon *** LOG *** Mar 10 17:57:21 db01-mtl mysqld_safe[3579]: started Mar 10 17:57:21 db01-mtl mysqld

RE: Does MySQL require patch for Daylight Savings Time 2007 change

You ran your zdump -v against this file ? > -Original Message- > From: Jerry Schwartz [mailto:[EMAIL PROTECTED] > Sent: Wednesday, February 28, 2007 1:41 PM > To: Jean-Sebastien Pilon; mysql@lists.mysql.com > Subject: RE: Does MySQL require patch for Daylight Savings >

RE: Does MySQL require patch for Daylight Savings Time 2007 change

on Systems Administrator Penson Financial Services Canada Inc. % Tel.: 514.841.9724 #269 % Cell: 514.771.0365 > -Original Message- > From: Jerry Schwartz [mailto:[EMAIL PROTECTED] > Sent: Wednesday, February 28, 2007 12:13 PM > To: Jean-Sebastien Pilon; 'Causevic, Dze

RE: Does MySQL require patch for Daylight Savings Time 2007 change

I don't believe so, since the version of MySQL you are using relies on the system's time. I am using 4.1 and I am setup to use system's time and my timezone tables in the mysql schema are empty. I would take a look at those on your installation. You can also run the 2nd command below to see if the

RE: Does MySQL require patch for Daylight Savings Time 2007 change

Version < 4.1.3 -> relies on the O/S for DST Quote from http://dev.mysql.com/doc/refman/4.1/en/time-zone-support.html "For versions of MySQL older than 4.1.3 that do not have time zone support, the server always tracks the operating system time (much like a time zone setting of SYSTEM in 4.1.3 a

RE: Growing innodb size

From: Jean-Sebastien Pilon [mailto:[EMAIL PROTECTED] > Sent: Wednesday, February 21, 2007 12:53 PM > To: Nils Meyer; mysql@lists.mysql.com > Subject: RE: Growing innodb size > > +---++ > |

Mysql on linux - choosing the right filesystem

Hello, I would like to get some of your input on file systems to use with mysql. Should I use a journaling filesystem ? Should I choose a different one based on what I store (log files, myisam dbs, innodb datafiles, etc ) ? Is there any file system tweaks you recommend ? TIA NOTICE: This email

RE: Growing innodb size

[EMAIL PROTECTED] > Sent: Wednesday, February 21, 2007 11:33 AM > To: mysql@lists.mysql.com > Subject: Re: Growing innodb size > > Hi, > > Jean-Sebastien Pilon wrote: > > I would like to grow my innodb table space, the only > problem that I have > > is that I did not

Growing innodb size

Hello list, I would like to grow my innodb table space, the only problem that I have is that I did not declare any size in the config file since we were not using it to start with. If I modify the config file, will this override the current innodb file or will it grow it ? Or should dump all the

Performance

Hey guys, In my last email I was talking about 5 daemon on the same box. We change that to use only one daemon and we upgrade to 5.0.xx-64bit instead of 4.1.xx-64bits. The machine itself it's a 12 CPU running AIX 5.3 ML03 with 4 Gig of RAM. The machine it's big web server running Apache/

Performance tuning...

Hey guys, I'm trying to optimize our database server machine. Currently we have 5 mysql daemon running that serves between 5-20 DB each. Is it better for me to have only one mysql daemon running with all the DB ? And I will need some tips to fine tune the server it self also. It's running und

relay-bin file missing

I am missing my *-relay-bin file on my slave so I got an error on my show slave status; . The slave is stopped, now I want to resync but whenever I do a change master_log_pos and master_log_file it outputs a ERROR 1105 (HY000): Failed purging old relay logs: Failed during log reset what should I

Upgrade glitches

Hi, I am about to upgrade from mysql-standard-4.0.14 to mysql-standard-4.1.7 on two Red Hat ES 3 server (master/slave circular relationship). I would like to know about any glitches I might face while doing so... Has anyone had any problems or bugs with any incompatible directives. Here is the co

RE: selected records retrieve

Hi, you can use mysqldump command line utility with the '--where=' switch. See the man page for more details. Regards, Sebastien sql query > -Message d'origine- > De : Nixarlidis Aris [mailto:[EMAIL PROTECTED]] > Envoye : jeudi 4 juillet 2002 09:46 > A

insert french accent with java

Hi, I want to insert into the Mysql db some text containing French Accent. If I do this using the console (mysql), it work fine. But if I try the same query via Java and JDBC, I loose the French accent. They are replaced by '?'. Any idea ??? Thank a lot --

Equivalent for 'prompt'.

Hi, Is there any MySQL equivalent command for the Oracle 'prompt' command (which writes out some text). Thanks in advance, -- Sebastien Guillemin - Before posting, please check: http://www.mysql.com/manual.

MySQL and Physical strorage

Hello my name is Sebastien and i am french student in database administration. I'm searching for vues or tables in MySQL like dba_ or dbms_ in Oracle db soft. How are stored data in the files etc... Are they tablespaces, segments, extents or blocs. If exists, what is the structu

lost connection to mysql!

Hi, I'm running 2 websites in PHP 4.0.6 with Mysql 3.23.42 on OpenBSD 2.7. If the client machine browse the 2 websites at the same time in get the following error: Warning: Lost connection to MySQL server during query in /usr/local/apache/vhdocs/tech/includes/database.inc on line 4

Re: question about mysql under FreeBSD

Yes, I try to use with softupdates or async but results is the same. DD are SCSI U3W Disks. Have an idea ? spe. -- [EMAIL PROTECTED] - Original Message - From: "Andrey Nepomnyaschih" <[EMAIL PROTECTED]> To: "Sebastien Petit" <[EMAIL PROTECTED]>; <[EM

question about mysql under FreeBSD

Hi, I have test two systems with mysql Linux Slackware 7.1 kernel 2.2.16 and FreeBSD-4.2-STABLE. I have mysql 3.23.36 only running on this two hosts and hosts are the same (PIII 800 Mhz Ami MegaRaid RAID 1 18.2 Go 1 Go RAM). I copy the database from FreeBSD to Linux and I launch a same select o

MySQL unicode

I want to create a text field who support Unicode. Is there any link, example to do it. Sebastien