Lahlouh's thoughts on MySQL's Image

Lahlouh's thoughts on MySQL

http://mohammadlahlouh.blogspot.com/
More about this blog
Latest Post
31 Mar 2010
Total Posts
29
Readers
354
Liked
0
Disliked
0
Views-Per-Post
12.21
vote up
0
vote down

vBulletin session table and Hash index in MEMORY Engine

In vBulletin Board System there is session table contains online user information and tracking, in which forum now, what the current URL now, So it is have huge concurrent update statement, By default this table is MEMORY engine because its data not
 
Mohammad Lahlouh
Mar 31 2010 03:04 PM
vote up
0
vote down

Can I use latin1 to store utf8 data?

I've table contains text column and its charset is latin1, and i can store Arabic text ( and non English character) in this column and retrieve it, i don't know how is it?So how is that? and why I need utf8?CREATE TABLE `post` ( `postid` int(10) unsigned
 
Mohammad Lahlouh
tags: tuning
Feb 23 2010 03:45 PM
vote up
0
vote down

Pass application user id to MySQL database??

In all our application we connect to MySQL database as single db user, and we need to pass the end user id to the mysql database?So how can we pass it?I've idea to create plugin to add mysql variables ex. "app_userid" and set it when user login??!!but i
 
Mohammad Lahlouh
Jan 10 2010 06:32 PM
vote up
0
vote down

First look to Chromium, Google Chrome OS

I download the binary version of Chrome OS from here, and plug it to VMware.New thing:the OS login is attach with Google account, so you cannot login if you havn't Google account or no internet connection, and i don't know how you can configure the
 
Mohammad Lahlouh
tags: chromium
Jan 06 2010 01:55 PM
vote up
0
vote down

Help MySQL to still free

There's a campaign started by Monty Widenius to save MySQL from the evil clutches of Oracle. You can read about it here.http://helpmysql.org
 
Mohammad Lahlouh
Jan 03 2010 03:52 PM
vote up
0
vote down

Palestinians storm foiled by Jews of the Far East after violent confrontations on the eve of Eid «forgiveness»

Translated via Google Translate from herePalestinians storm foiled by Jews of the Far East after violent confrontations on the eve of Eid «forgiveness» 9 injured members of the Israeli police... And 40 Palestinians Palestinian flying victory sign to a
 
Mohammad Lahlouh
tags: israel
Dec 22 2009 08:30 AM
vote up
0
vote down

Find Query Per certain Seconds

Do you need to find qps for peak hours not avg qps through mysql life.The MySQL 5.1 offers new GLOBAL_STATUS information schema tables. These can be used to report certain performance metrics, such as the number of queries processed per certain seconds,
 
Mohammad Lahlouh
Oct 01 2009 01:51 PM
vote up
0
vote down

Why does Google have two L's today?

Why does Google have two Ls today? If you happen to be also one of the many internet users that are wondering why Google decided to have their logo, or as they call it, "doodle" spelt with 2 l's, then you've come to the right place.Actually the 2L's are
 
Mohammad Lahlouh
tags: 11th
Sep 28 2009 03:27 PM
vote up
0
vote down

Yahoo! Acquires Maktoob The Largest Arab Portal!

Yesterday Yahoo! announced to Acquires Maktoob.Maktoob.com is a leading Web community portal offering online communications tools and information services that empower Arab Internet users. With a diverse audience covering the whole Arabicspeaking region
 
Mohammad Lahlouh
tags: maktoob
Aug 26 2009 05:31 PM
vote up
0
vote down

Threads with "freeing items", "Sending data" and "Locked" never finish

In one of the servers we have an issue that happens to one of the servers that some itemsthat have the status of "freeing items" and "Sending data" are just stuck there, causing alot of locks on the server, and the load of the server drops to almost
 
Mohammad Lahlouh
tags: database
Aug 05 2009 07:27 PM
vote up
0
vote down

Warning Aborted connection, log_warnings and wait_timeout

In my server error log i see090415 10:55:57 [Warning] Aborted connection 481 to db: 'db' user: 'user' host: 'localhost' (Got timeout reading communication packets)090415 10:56:16 [Warning] Aborted connection 582 to db: 'db' user: 'user' host: 'localhost'
 
Mohammad Lahlouh
tags: database
Aug 05 2009 07:27 PM
vote up
0
vote down

How to play Real audio and video files (*.rm) with Windows Media player!?

How to play Real audio and video files (*.rm) with Windows Media player!? Because of competition between Microsoft and Real Networks, Windows Media Player does not support Real audio and video files, and real networks does not release any patch for WMP.
 
Mohammad Lahlouh
tags: database
Aug 05 2009 07:27 PM
vote up
0
vote down

Convert Flash Video (.flv) to AVI (.avi) or MPEG (.mpg) - lifehack.org

Convert Flash Video (.flv) to AVI (.avi) or MPEG (.mpg) - lifehack.org: "Convert Flash Video (.flv) to AVI (.avi) or MPEG (.mpg)Hitrec at VideoHelp forum introduces a software called RivaFLVencoder which able you to convert .flv files (Flash Video) into
 
Mohammad Lahlouh
tags: database
Aug 05 2009 07:27 PM
vote up
0
vote down

How to Download Google Video - lifehack.org

How to Download Google Video Okay, it is just not fun to play video online with slow Internet connection - to have smooth video playback, the best way it is still downloading the whole clip locally and playback. However Google Video does not provide a
 
Mohammad Lahlouh
tags: database
Aug 05 2009 07:27 PM
vote up
0
vote down

How to plug JInitiator to Firefox...

I can run Oracle Forms on Mozilla Firefox.1- Install JInitiator.2- C:\Program Files\Oracle\JInitiator 1.1.8.19\bin\NPJinitXXXX.dll --XXXX = Version.3- Paste it under this directory of Firefox(C:\Program Files\Mozilla Firefox\plugins).4- Restart Firefox.
 
Mohammad Lahlouh
tags: database
Aug 05 2009 07:27 PM
vote up
0
vote down

How to Disable Windows Login Screensaver

How to Disable Windows Login Screensaver Have you ever been annoyed by the computer going into a screensaver before you've even logged in to it? This is a step-by-step guide to disabling this feature. Steps Login to your computer as an amdinistrator
 
Mohammad Lahlouh
tags: database
Aug 05 2009 07:27 PM
vote up
0
vote down

How to Use Windows XP Built in Remote Desktop Utility

How to Use Windows XP Built in Remote Desktop Utility This explains how to connect to another computer on your local network through Windows XP's built-in remote desktop utility. Steps Remote Desktop must be enabled on all the computers to which you wish
 
Mohammad Lahlouh
tags: database
Aug 05 2009 07:27 PM
vote up
0
vote down

How to Convert Measurements Easily in Microsoft Excel

How to Convert Measurements Easily in Microsoft Excel We've all been in a situation where we need to convert one measurement to another. An objects mass was measured in ounces and not kilos, or the lumber you ordered was measured in metres instead of
 
Mohammad Lahlouh
tags: database
Aug 05 2009 07:27 PM
vote up
0
vote down

Google Books

Hello AllSearch the full text of books and discover new ones ---------> with Google Books Enjoy
 
Mohammad Lahlouh
tags: database
Aug 05 2009 07:27 PM
vote up
0
vote down

MICROSOFT IN EGYPT (CAIRO)

MICROSOFT IN EGYPT (CAIRO) Soon Microsoft will be in Egypt, interviewing interested and qualified candidates for software development positions here in the USA at our corporate headquarters working on our major products. If you know of anyone who might
 
Mohammad Lahlouh
tags: database
Aug 05 2009 07:27 PM
vote up
0
vote down

Download->Office 2003 == 1.47MB

Hi all You can download Microsoft Office 2003 in one minute, 1.47MB. new Archive Program, it compress All Office 2003 in 1.47MB. you can try it now Office @ http://www.sendspace.com/file/kwtmeh Program @ http://rapidshare.de/files/13693514/Office.kgb.htm
 
Mohammad Lahlouh
tags: database
Aug 05 2009 07:27 PM
vote up
0
vote down

How? Connect from ORACLE Developer to ORACLE Database????

Hi ALL H r u? Just I'll write how you can connect ORACLE database with ORACLE Developer? When u use SQL Plus and don't have any problem, and u wanna install developer(Forms & Reports), u cannot connect to the same Database. The first: You must have the
 
Mohammad Lahlouh
tags: database
Aug 05 2009 07:27 PM
vote up
0
vote down

LiveMessenger.net

LiveMessenger.net Welcome at LiveMessenger.net, the first website about Windows Live Messenger! The next version of the extremely popular instant messaging client MSN Messenger won't be called MSN Messenger 8, but Windows Live Messenger, or Windows Live
 
Mohammad Lahlouh
tags: database
Aug 05 2009 07:27 PM
vote up
0
vote down

vBulletin, session table is InnoDB

In large vBulletin forum we had strange problem in memory table "session", we've 25M post, 1.7M user, 20K online user.So we change engine of session table to InnoDB and set configuration of innoDB as follow (be careful this configuration is not proper
 
Mohammad Lahlouh
tags: innodb
Aug 05 2009 07:26 PM
vote up
0
vote down

Oracle to Buy Sun !!!

Sun and Oracle today announced a definitive agreement for Oracle to acquire Sun for $9.50 per share in cash. The Sun Board of Directors has unanimously approved the transaction. It is anticipated to close this summer.What will happened in MySQL, JAVA.I
 
Mohammad Lahlouh
tags: database
Aug 05 2009 07:26 PM
vote up
0
vote down

mysqlsla amazing tool

mysqlsla is interesting tool to analyze slow log query, aggregate same query in one and generate unique sql statement withCount, (max, min, avg) execute time, lock time, Rows sent, Rows examined for each unique one.you can use it to review indexes and
 
Mohammad Lahlouh
tags: database
Aug 05 2009 07:26 PM
vote up
0
vote down

A Brief Introduction to MySQL Performance Tuning

Here are some common performance tuning concepts that I frequently run into. Please note that this really is only a basic introduction to performance tuning. For more in-depth tuning, it strongly depends on your systems, data and usage. Server Variables
 
Mohammad Lahlouh
Aug 05 2009 07:26 PM
vote up
0
vote down

InnoDB tablespace, single Vs. multiple, and InnoDB defragment

The ibdata file is too big 10GB, and actually we've only about 2GB (data+index) in innodb storage engine.How we can defragment this file and reduce it?How is this happened?By default the ibdata file created initially by (innodb_data_file_path =
 
Mohammad Lahlouh
tags: innodb
Jun 16 2009 05:20 PM
vote up
0
vote down

Upgrading MySQL with minimal downtime through Replication

Problem With the release of MySQL 5.1, many DBAs are going to be scheduling downtime to upgrade their MySQL Server. As with all upgrades between major version numbers, it requires one of two upgrade paths: Dump/reload: The safest method of upgrading, but
 
Mohammad Lahlouh
tags: database
Apr 12 2009 03:52 PM