DevHeads.net

Help

Bug in BETWEEN same DATETIME

By Daevid Vincent at 05/23/2013 - 16:55

I just noticed what I consider to be a bug; and related, has this been fixed
in later versions of MySQL?

We are using:
mysql Ver 14.12 Distrib 5.0.92, for portbld-freebsd8.1 (amd64) using 5.2

If you use BETWEEN and the same date for both parts (i.e.

The new versions of Devart dbExpress drivers with support for Rad Studio XE4

By Oksana Voloshuk at 05/23/2013 - 08:33

The new versions of Devart dbExpress drivers with support for Rad Studio XE4

Devart Team is proud to introduce the new versions of dbExpress drivers with support for the latest version of Embarcadero's RAD Studio - RAD Studio XE4. This considerable upgrade gives users an opportunity to develop their applications using the cutting-edge IDE for all the supported target-platforms: Win32, Win64 and Mac OS.

Version 5.6.2-m5 Boolean Datatype

By Tompkins Neil at 05/22/2013 - 12:55

Hi,

I've just created some tables that I designed using the MySQL Workbench
Model. However, the database type BOOLEAN which was in my models has been
converted to TINYINT(1); I'm currently running MySQL Version 5.6.2-m5 on
Windows 2008 server.

Any ideas why this has been removed ?

Neil

Mysql server - which filesystem to choose? Is it really that important nowadays?

By =?ISO-8859-2?Q?... at 05/22/2013 - 02:55

Hi All.

I use mysql/perconna/maria on my production CentOS 6 Linux servers. I
currently try to choose the default filesystem for partitions with mysql
data.

fragmentation in innodb tables

By =?ISO-8859-1?Q?... at 05/21/2013 - 17:03

Dear all,

I'm a newbie in MySQL so bare my questions.

I have run mysqltuner.pl and It says I have fragmentation in my
tables.

Visual Studio 2012 Supported in Devart's dbForge Fusion for MySQL, v.6.0

By Oksana Voloshuk at 05/21/2013 - 08:41

Visual Studio 2012 Supported in dbForge Fusion for MySQL, v.6.0

Devart Team is glad to present the release of dbForge Fusion for MySQL v.6.0 - powerful Visual Studio plugin designed to simplify MySQL database development and enhance data management capabilities. Now includes support for Visual Studio 2012! All users can now benefit from the Devart add-in in the latest version of the IDE.

THANKS

By Last Hacker Alw... at 05/18/2013 - 11:56

Hey sir thanks for adding me to the list but if I want to send a
question where do i send it to? <a href="mailto:mysql- ... at lists dot mysql.com">mysql- ... at lists dot mysql.com</a> or
<a href="mailto: ... at lists dot mysql.com"> ... at lists dot mysql.com</a>

,企,业,个,税 (发#票) ,13534102640 ,陈,

By wdakooojq at 05/16/2013 - 13:03

尊敬的 先生/女士： 您好;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp; 本公司有正规发嘌代开，普通,增值,建筑，銷售，工程，
苗木，广告,咨詢,住宿,餐饮等各類嘌據。
驗证 后 付 款，
联 系 人；135-3410-2640
Q Q;131-8225-801
聯 系 人：陳 經 理&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

COM_EXECUTE_STMT fails and I don't know why

By =?ISO-8859-1?Q?... at 05/16/2013 - 09:40

Hello everyone,

I'm sending a COM_EXECUTE_STMT message and the server returns an:

Error 1048 - #23000 - Column 'number_tinyint' cannot be null

The query is like this:

insert into numbers (
number_tinyint,
number_smallint,
number_mediumint,
number_int,
number_bigint,
number_decimal,
number_float,
number_double
) values
(
?, 679, 778, 875468, 100007654, 198.657809, 432.8, ?)

And what I send in is:

0: 18 00 00 00 17 01 00 00 . . . . . . . .
1: 00 00 01 00 00 00 00 00 . . . . . . . .
2: 01 01 05 0a 29 5c 8f c2 . . . . ) \ . .
3: f5 b0 58 40 . .

RE: Innodb innodb_buffer_pool_size?

By Vikas Shukla at 05/16/2013 - 05:24

Sorry I failed to specify ghatna is only applicable when the database is quiet large.

Vikas

Am 16.05.2013 11:01, schrieb Vikas Shukla:
hwo would a innodb_buffer_pool larger than the whole database
make anything better?

RE: Innodb innodb_buffer_pool_size?

By Vikas Shukla at 05/16/2013 - 05:01

Hi claudio,

The best value for innodb buffer pool size is considered to be 60 to 70 percent of ram.
So in your case, this must be around 4 gb.
That would work better.

Regards.

Vikas

Cc: " ... at lists dot mysql.com" < ... at lists dot mysql.com>

Hi Rafal,

Innodb innodb_buffer_pool_size?

By =?ISO-8859-2?Q?... at 05/16/2013 - 04:11

Hi All.

I am trying to set the best value for innodb_buffer_pool_size.

Dropping column/index from MyISAM table increases disk space without calling "optimize"

By Michael Finch at 05/14/2013 - 15:56

Hey,

We have a table with a column and index that we don't need anymore, so we are trying to find the best way to get rid of them

Path 1) Create a new table with the updated schema (excluding that column and index), and insert from the old table into the new table
Path 2) Alter the original table to drop the column and index

The problem with either of these is that when we are done, the table size has grown significantly (~15%).

size of orig table: 2026.5G
size of new table after inserting all of the data or running the alter: 2473.5M
~~flush the table~~
size of orig table: 2026.5G
size of

ANN: DAC for MySQL 2.9.0 Beta is out!

By Aleksander Andreev at 05/14/2013 - 08:32

DAC for MySQL is direct access components for MySQL, EnterpriseDB.

mysql binding for LuaJIT

By Cosmin Apreutesei at 05/14/2013 - 06:06

Hi,

I made a new mysql binding for LuaJIT, here it is:

<a href="https://code.google.com/p/lua-files/wiki/mysql" title="https://code.google.com/p/lua-files/wiki/mysql">https://code.google.com/p/lua-files/wiki/mysql</a>

Features:

- covers all of the functionality provided by the mysql Connector/C 6.1 API
- all data types are supported with multiple options for conversion
- prepared statements, avoiding dynamic allocation and type
conversions when fetching rows
- all C calls are checked for errors and Lua errors are raised
- all C objects are tied to Lua's garbage collector
- lightweight OOP-style API via ffi.metatype
- no external dependencies

Only tested with Windows for now but more tests

problems with relationships created by mysql

By rounak jain at 05/13/2013 - 00:07

I have connected MySql to Base. I created some relationships in MySql. They
are properly visible in the Relationships chart in Base. See image.
<a href="http://imgur.com/qtM8fVN,jwvJpen" title="http://imgur.com/qtM8fVN,jwvJpen">http://imgur.com/qtM8fVN,jwvJpen</a>

Other than that, they are non-existent. For example, while I try to create
a sub-form, I see that the option to create subform via existing
relationship is disabled. See image.
<a href="http://imgur.com/qtM8fVN,jwvJpen#1" title="http://imgur.com/qtM8fVN,jwvJpen#1">http://imgur.com/qtM8fVN,jwvJpen#1</a>

Kindly guide me.

auto-increment more than one field

By rounak jain at 05/12/2013 - 09:39

I have a table which needs two fields with auto-increment.
I have the found the answer here:
<a href="http://stackoverflow.com/questions/13642915/mysql-table-with-more-than-one-auto-incremented-" title="http://stackoverflow.com/questions/13642915/mysql-table-with-more-than-one-auto-incremented-">http://stackoverflow.com/questions/13642915/mysql-table-with-more-than-o...</a>
coloumn?rq=1

I am using MySqlWorkbench. I can see "Triggers" section below the table. I
don't know how to use the trigger script suggested in the link. Thanks.

NET START MYSQL QUESTION?

By SIVASUTHAN NADARAJAH at 05/11/2013 - 10:50

I want to start the mysql from command prompt using "NET START MYSQL"BUT the server not started. It display an error message.
C:\Users\PC> NET START MySQLSystem error 5 has occurred.
Access is denied.
could you please help me, how to start the Mysql service FROM command prompt?
SIVASUTHAN- Consultant Trainer

Triggers

By Aastha at 05/10/2013 - 14:55

If triggers use complex business rules and large transaction.
What would we be recommendations?
I need three possible ways.

Thanks,

RE: Slow Response -- What Does This Sound Like to You?

By Vikas Shukla at 05/10/2013 - 00:06

Hi everybody,

I think we need to focus on three things:-

A) temp tables created on disk
B) table cache size
C) buffer sizes

If you find the number of temp tables created on disk is very large, please increase the temp_table_size.

Enable the slow query log And check if sort buffer size and join buffer size needss to be increased if multiple joins are used.

Also check whether the tables used in the slow queries do have index build on them or not. This heavily impacts the performance.

Slow Response -- What Does This Sound Like to You?

By Robinson, Eric at 05/09/2013 - 16:58

We have a situation where users complain that the system periodically freezes for 30-90 seconds. We check the slow query logs and find that one user issued a complex query that did indeed take 30-90 seconds to complete. However, NO slow queries are recorded for the other 50 users, before, during, or after the freeze.

MySQL Connector/ODBC 5.2.5 has been released

By Kent Boortz at 05/02/2013 - 16:08

Dear MySQL users,

MySQL Connector/ODBC 5.2.5, a new version of the ODBC driver for the
MySQL database management system, has been released.

The available downloads include both a Unicode driver and an ANSI
driver based on the same modern codebase. Please select driver type
you need based on the type of your application - Unicode or ANSI.
Server-side prepared statements are enabled by default.

MySQL Connector/C 6.1.0 has been released

By Kent Boortz at 05/02/2013 - 16:07

Dear MySQL users,

MySQL Connector/C 6.1.0, a new version of the C API for client/server
communication for the MySQL database management system, has been
released.

This version of Connector/C has the same feature set as the client
library shipped with latest MySQL server 5.6 and supports all
client/server protocol features present in the server.

Adding language support to tables

By Tompkins Neil at 05/01/2013 - 08:53

Hi,

I've the following database structure of 4 tables for geographical
information

CREATE TABLE IF NOT EXISTS `mydb`.`country` (

`country_id` INT NOT NULL ,

`country_code` CHAR(2) NOT NULL ,

`name` VARCHAR(255) NOT NULL ,

PRIMARY KEY (`country_id`) ,

UNIQUE INDEX `country_code_UNIQUE` (`country_code` ASC) )

ENGINE = ndbcluster

DEFAULT CHARACTER SET = utf8

COLLATE = utf8_unicode_ci;

CREATE TABLE IF NOT EXISTS `mydb`.`region` (

`region_id` INT NOT NULL ,

`name` VARCHAR(255) NOT NULL ,

`country_code` CHAR(2) NOT NULL ,

PRIMARY KEY (`region_id`) ,

INDEX

Chain Replication QUestion

By Richard Reina at 04/30/2013 - 13:10

I have a few slaves set up on my local network that get updates from
my main mysql database master. I was hoping to turn one into a master
while keeping it a slave so that I can set up a chain. Does anyone
know where I can find a "how to" or other documentation for this
specific task?

Thanks,

Richard

Long integer constant problem in views

By Martin Koch at 04/30/2013 - 11:17

Hi List

I have a table with a primary key with type binary(16) and a few columns.
I'd trying to create a view that looks up all rows with a particular key,
i.e. something like

CREATE OR REPLACE VIEW foo AS
SELECT *
FROM mytable
WHERE id = X'36a461c81cab40169791f49ad65a3728';

I use the mysql command line client to create the view.

Rookie question

By Patrice Olivier... at 04/29/2013 - 13:29

Hi all:

I have a membership directory where folks can belong to more than one category. But all folks do not qualify for a category. So I want to list folks who have qualified in a category but not have them repeat. So if member 1 is in cat 3 and cat 5, I want their name only to show up once.

Performance of delete using in

By Larry Martell at 04/24/2013 - 20:19

I have a table that has 2.5 million rows and 9 columns that are all
int except for 2 varchar(255) - i.e. not that big of a table. I am
executing a delete from that table like this:

delete from cdsem_event_message_idx where event_id in (....)

The in clause has around 1,500 items in it. event_id is an int, and
there is an index on event_id. This statement is taking 1 hour and 5
minutes to run. There is nothing else hitting the database at that
time, and the machine it's running on is 97% idle and has plenty of
free memory. This seems extremely excessive to me.

how to list record in column (instead of a row)

By Rajeev Prasad at 04/24/2013 - 12:06

this table has many columns and only 1 record.

select * from table;

generates an unreadable list.

how can i list the record as in two columns? (column name and its value)?

i looked at UNPIVOT, but could not get it to work.

SQL> select * from table UNPIVOTE INCLUDE NULLS;                    
select * from table UNPIVOTE INCLUDE NULLS
                                  *
ERROR at line 1:
ORA-00933: SQL command not properly ended

Spatial changes in InnoDB - Details?

By Hartmut Holzgraefe at 04/24/2013 - 03:25

The "What's new in MySQL 5.7" manual page [1] says:

* InnoDB now supports spatial data types.

What is the difference to previous releases in this respect?
Spatial column types have been supported by InnoDB (and even
Cluster) for a long time already, and spatial indexes on
spatial columns still don't seem to be possible with 5.7.1 [2]

So what is the actual improvement in InnoDBs support of spatial
types supposed to be?

[1] <a href="http://dev.mysql.com/doc/refman/5.7/en/mysql-nutshell.html" title="http://dev.mysql.com/doc/refman/5.7/en/mysql-nutshell.html">http://dev.mysql.com/doc/refman/5.7/en/mysql-nutshell.html</a>
[2] <a href="http://pastebin.com/VnqZ6guG" title="http://pastebin.com/VnqZ6guG">http://pastebin.com/VnqZ6guG</a>

ANN: Database Workbench 4.4.0, the multi-DBMS IDE now available!

By Martijn Tonies at 04/24/2013 - 02:41

Ladies, gentlemen,

Upscene Productions is proud to announce the next version
of the popular Windows-based multi-DBMS development tool:

" Database Workbench 4.4.0 Pro "

This release includes new features and fixes several bugs as reported by the
users.

For more information, see <a href="http://www.upscene.com/go/?go=news&amp;id=20130423" title="http://www.upscene.com/go/?go=news&amp;id=20130423">http://www.upscene.com/go/?go=news&amp;id=20130423</a>

The FREE Lite Editions will follow later.

Database Workbench supports:
- Borland InterBase ( 6.x and up )
- Firebird ( 1.x and up )
- MS SQL Server/MSDE ( 7 and up )
- MySQL 4.x and up
- Oracle Database ( 8i and up )
- Sybase SQL Anywhere ( 9 and up )
- NexusDB (

MySQL Community Server 5.7.1 has been released (part 2)

By Bjorn Munch at 04/23/2013 - 15:00

This is part 2 of the MySQL 5.7.1 announcement

* Replication: In certain cases, the dump thread could send a
heartbeat out of synchronisation with format description
events. One of the effects of this issue what that, after
provisioning a new server from a backup data directory and
setting --gtid-mode=ON and enabling autopositioning (see
CHANGE MASTER TO Syntax
(<a href="http://dev.mysql.com/doc/refman/5.7/en/change-master-to.html" title="http://dev.mysql.com/doc/refman/5.7/en/change-master-to.html">http://dev.mysql.com/doc/refman/5.7/en/change-master-to.html</a>)
), replication failed to start, with the error Read invalid
event from master....

MySQL Community Server 5.7.1 has been released (part 1)

By Bjorn Munch at 04/23/2013 - 14:49

Dear MySQL users,

MySQL Server 5.7.1 (Milestone Release) is a new version of the world's
most popular open source database. This is the first milestone release
of MySQL 5.7.

<a href="http://dev.mysql.com/doc/mysql-development-cycle/en/development-milestone-releases.html" title="http://dev.mysql.com/doc/mysql-development-cycle/en/development-milestone-releases.html">http://dev.mysql.com/doc/mysql-development-cycle/en/development-mileston...</a>

The new features in these releases are of Beta quality.

Design help

By Tompkins Neil at 04/21/2013 - 02:47

Hi

I'm creating the following basic tables

COUNTRIES
countries_id
name

REGIONS
region_id
countries_id
name

CITIES
cities_id
region_id

Using joins I can obtain which country each city belongs too. However,
should I consider putting a foreign key in the CITIES table referencing the
countries_id ? Or is it sufficient to access using a join ?

Thanks
Neil

Troubleshoot excessive memory usage in InnoDB

By Denis Jedig at 04/19/2013 - 17:17

Hi all.

In a specific MySQL installation of 5.6.10 using InnoDB tables, I
am observing unusual memory consumption patterns. The memory
usage is growing constantly - even beyond the physical memory
limits.

ORDER ENQUIRY

By joy helen at 04/19/2013 - 16:35

Hello,
&nbsp; I want to place an order in your store,and i will like to know if you ship to Australia and my method of payment will be credit card.so please let me know if you can assist me with the order ,And please do not forget to include your web page in your replying back to my mail.I will await your prompt response as soon as you receive this mail,i will be be very glad if you treat this email with good concern
Warm Regards

Helen

Query Help

By Richard Reina at 04/19/2013 - 10:24

Hello All,

Happy Friday! I know how to do the following query:

But can someone tell me I can do a query that will give me:

the count(*) for each week of 2013 so that I end up with:

WEEK | COUNT
1 | 22
2 | 31
3 | 29
etc...

Thanks,

Richard

help with mysql db names

By Doug at 04/18/2013 - 23:44

Hello,

why these db names created fail but the last one gets success?

mysql> create database 3208e1c6aa32;
ERROR 1064 (42000): 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 '3208e1c6aa32' at line 1

mysql> create database 208e1c6aa32;
ERROR 1064 (42000): 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 '208e1c6aa32' at line 1

mysql> create database 08e1c6aa32;
ERROR 1064 (42000): You have an error in your SQL syntax; che

logging in using host alias not working

By Larry Martell at 04/18/2013 - 12:59

We use host aliases to connect to MySQL all the time, never had an
issue before.

Doubt with sored procedures - II

By =?ISO-8859-1?Q?... at 04/18/2013 - 05:22

I have discovered that in MySQL client program I can define "definer" and
"sql security". This is the detail.

Thanks everybody.

Best regards,

Antonio.

Doubt with stored procedures

By =?ISO-8859-1?Q?... at 04/17/2013 - 08:16

Hi everybody,

I have a doubt with stored procedures functionality. Is possible that a
stored procedure works with all databases form the server? I have created a
stored procedure on dataBaseA and also works with dataBaseB. Is that
correct? Independently of the user privileges defined.

Thanks everybody.

Best regards,

Antonio.

MySQL on Mac OS 10.8

By Larry Martell at 04/16/2013 - 12:34

I just set up mysql on Mac OS 10.8. Each time after the machine is
rebooted the server fails to start with:

2013-04-13 14:09:54 12222 [ERROR] /usr/local/mysql/bin/mysqld: Can't
create/write to file '/var/run/mysqld/mysqld.pid' (Errcode: 2 - No
such file or directory)

Because the /var/run/mysqld dir does not exist. I have to create it
manually then the server starts. But I have to do this after each
reboot, which is a pain. Anyone know why the /var/run/mysqld dir gets
deleted, or how to get around this?

Mesaure query speed and InnoDB pool

By Ilya Kazakevich at 04/16/2013 - 04:53

Hello,

I have 12Gb DB and 1Gb InnoDB pool. My query takes 50 seconds when it reads
data from disk and about 2 seconds when data already exists in pool. And it
may take 10 seconds when _some_ pages are on disk and some are in pool.
So, what is the best way to test query performance? I have several ideas:
* Count 'Innodb_rows_read' or 'Innodb_pages_read' instead of actual time
* Set pool as small as possible to reduce its effect on query speed
* Set pool larger than my db and run query to load all data into pool and
measure speed then

How do you measure your queries' speed?

Ilya Kazakevich

mysql 5.6.10 won't start

By Paul Nowosielski at 04/15/2013 - 09:20

Hi,

I'm running mysql 5.6.10 on Fedora.
when I try and boot mysql I get this:

# /etc/init.d/mysql start
Starting MySQL.The server quit without updating PID file
(/[FAILED]xt/mysql/veritian.pid).

Any ideas?

Thank you,

Paul

ERROR 1005 (HY000): Can't create table 'user_database.user_table' (errno: 157)

By Sai Kumar Ganji at 04/15/2013 - 03:34

Hello Guys,

I am trying to setup a mysql-cluster with two data nodes and one management
node.

The sequence of step I followed are:

Ran *'ndb_mgmd' *on management node
Ran '*ndbd --initial' *on both the data nodes
Ran '*mysqld' *on both the data nodes

Then the status of the cluster on management node is:

[ndbd(NDB)] 2 node(s)
id=2 @10.252.151. <http://10.252.151.67/>xx (Version: 5.1.68,
Nodegroup: 0, Master)
id=3 @10.253.4. <http://10.253.4.143/>xx (Version: 5.1.68,
Nodegroup: 0)

[ndb_mgmd(MGM)] 1 node(s)
id=1 @10.253.19.

Cannot connect to MySql Database

By Joe Kosinski at 04/09/2013 - 13:54

Hi,

I am trying to connect to a MySql database and I keep getting the following:

Cannot find (ping) database host Joseph-Kosinskis-MacBook on the network
Failed to connect to Unix socket '/var/run/lirc/lircd'
No such file or directory (2)

The database is located on a MacBook running OS X 10.8. The MySql Server is running.

Joe

Adding new disk (space) to mysql box

By a bv at 04/09/2013 - 02:36

Hi,

What is the best way and steps to add new disk or SAN to a LVM setuped
mysql/linux box?.

If there are slots is it better to add a physical one or a SAN space? How
would add that at linux /lvm. What to do at the current mysql database?
Kernel is 2.6.x.x , any storage size restriction for linux or mysql side?
Using LVM and adding a new disk will the current partion of the mysql
databases size will rise at the amount of the new added disk space, so
there wont be any issue releated to
mysql ?

Regards

Mysql Cluster Sync-UP

By Kevin Peterson at 04/08/2013 - 23:58

Hi,

I am running My-SQL in cluster mode with two machine. Want to know if mysql database get corrupted on one of the machine will it force the corruption on the other machine too or in this case sync between two mysql instances will stop after the corruption.

Thanks,
Kevin Peterson

Reg: MYSQL Mail Agent

By bharani kumar at 04/08/2013 - 04:33

How to enable mail agent service in MYSQL. and what are the necessary steps
to send mail.

How to tweek the max connections

By Yu Watanabe at 04/07/2013 - 21:01

Hi all!

I would like know if there are any calculatios for
specifying the maximum number of the 'max_connections' value.

I understand that max_connections should be decided by the remaining RAM size
of the system.

mysql_tzinfo_to_sql

By Joe Kosinski at 04/06/2013 - 21:26

I was finally able to load the time zone tables using the following:
sh-3.2# /usr/local/mysql-advanced-5.6.10-osx10.7-x86/bin/mysql_tzinfo_to_sql /usr/share/zoneinfo | /usr/local/mysql-advanced-5.6.10-osx10.7-x86/bin/mysql -u root mysql

My version of Mac OSX 10.8.3 did not have root user installed but I googled for the instructions and installed it.

I then located the paths for mysql_tzinfo_to sql and also mysql.

I ran queries and the time zones tables are now populated.

Please forgive me for all the confusion and wasted time I may have caused anyone.

remove me from the mailing

By =?koi8-r?B?883P... at 04/06/2013 - 12:02

remove me from the mailing
remove me from the mailing
remove me from the mailing
remove me from the mailing
remove me from the mailing
remove me from the mailing
remove me from the mailing
remove me from the mailing
remove me from the mailing
remove me from the mailing
remove me from the mailing
remove me from the mailing
remove me from the mailing
remove me from the mailing
remove me from the mailing
remove me from the mailing
remove me from the mailing
remove me from the mailing
remove me from the mailing
remove me from the mailing
remove me from the mailing
remove me from the mailing
remove

mysql_tzinfo_to_sql

By Joe Kosinski at 04/05/2013 - 13:26

I cannot find the path where mysql_tzinfo_to_sql is installed.

I have these instructions:
This program is installed to the same .../bin folder as your mysqld binary.

Cannot load time zone tables to MySQL

By Joe Kosinski at 04/05/2013 - 10:25

I have installed the community edition version 5.6 to my MacBook running OSX 10.8.3. I am trying to set up MythTV backend which requires the time zone tables to be loaded for the database I will be using.

I have not been able to load the tables using the syntax of version 5.6.

I have tried mysql> mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root but nothing happens and my prompt just goes to > instead of mysql>.

I have attached my terminal output.

Thanks

Joe Kosinski

Cannot load time zone tables

By Joe Kosinski at 04/05/2013 - 10:14

I have installed the community edition version 5.6 to my MacBook running OSX 10.8.3. I am trying to set up MythTV backend which requires the time zone tables to be loaded for the database I will be using.

I have not been able to load the tables using the syntax of version 5.6.

I have tried mysql> mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root but nothing happens and my prompt just goes to > instead of mysql>.

I have attached my terminal output.

Thanks

Joe Kosinski

MySQL on RHEL4

By Nitin Mehta at 04/05/2013 - 00:53

Hi,
 
We're trying to upgrade our existing MySQL 5.1.26 to MySQL 5.1.68 but the installation gives error:
 
libc.so.6(GLIBC_2.4) is needed by MySQL-server-community-5.1.68-1.rhel5.i386 rtld(GNU_HASH) is needed by MySQL-server-community-5.1.68-1.rhel5.i386
 
Now, GLIBS2.4 is not available for RHEL4 and MySQL 5.1 and 5.5 are supported on RHEL4 as per this: <a href="http://www.mysql.com/support/supportedplatforms/database.html" title="http://www.mysql.com/support/supportedplatforms/database.html">http://www.mysql.com/support/supportedplatforms/database.html</a>
 
Any ideas?
 
Regards,
Nitin

error-log aging

By hsv at 04/04/2013 - 17:08

Is there somewhere within MySQL means of aging the error log, that it not indefinitly grow big, or is that done through the OS and filesystem on which "mysqld" runs?

Determing number of queries

By Richard Reina at 04/04/2013 - 16:15

I am looking to spec out hardware for a new database server. I figured
a good starting point would be to find out how much usage my current
server is getting. It just a local machine that runs mysql and is
queried by a few users here in the office. Is there a way that mysql
can tell me info about it's workload?

Thanks

Richard

Update and lock question.

By =?ISO-8859-1?Q?... at 04/04/2013 - 12:08

I'm doing some tests, but have a questions about locking.

In a innodb table, if you issue an select for update lock for a row,
supposedly, it only locks that row, but if you don't issue a select for
update, and trow the update... does it locks the hole table?

The update goes over an indexed field, or the effect of locking the hole
table is due I'm updating an indexed field?

This is because I'm running into dead locks, but I know there is no select
for update to the row being updated.

Thanks.

Syndicate content